The objective of this program is to provide knowledge and practical experience about the creation of comprehensive and flexible financial models used in financial planning and fundraising purposes. 


The participants will gain insights into the step-by-step process of creating financial models using Microsoft Excel, putting checks and audits and finally analyzing the same.


Overview


This course will equip all participants with various tools to aid in complex business decision making by incorporating multiple factors operating in the dynamic business environment. At the end of the course, each participant will be able to create a financial model independently and carry out analysis to take the best decision for their company.


Who should attend
                          
 




All individuals who want to improve their financial modeling skills should attend this course


Middle to senior managers from different industries 


All professionals who want to deal or currently deal with financial modeling in their company


Consultants, advisors and other professionals who wish to improve their modeling skills 




Methodology 
      
                                          


The non-theoretical methodology which includes interactive discussions, case studies, and assignments to understand the concepts and their applicability. As a policy, we limit the class size to 15 participants so that we can provide attention to each participant and ensure their objective is achieved. 


We request you to please bring your laptop with Microsoft Excel installed to the class.


Trainer


All our trainers are carefully chosen by us and possess a rich and vast experience in the financial sector. This course conducted by an experienced training consultant having more than 16 years of industry experience with some of the world’s leading business institutions, specializing in corporate finance, investment banking, and private equity.


Course Content
 


Module – 1


Setting up a financial model and building projections




Overview of best industry practices for financial modeling


Importance of historical information 


Analysis of company and industry information


Steps for creating financial models


Proper presentation of various sheets and setting up the model input dashboard




Module – 2


Preparation of Income statement, cash flow statements and balance sheet




Analysis of industry assumptions and their rationale for revenues & costs, assets and liabilities’ assumptions - operating cost, capex, leverage, modeling of historical ratios and trends


Shortlisting assumptions and applying adjustments


Applying various forecasting tools, etc




Module – 3


Importance of key schedules and their application




Working capital schedule  


Fixed assets and depreciation 


Schedule of amortization of intangible assets


Preparation of debt and interest 


Taxation


Equity fundraising


Equity gap and funding




Module – 4


How to create working capital schedule




Components of cash and non-cash working capital


Working capital ratios and their interpretation


Forecasting working capital requirements 




Module – 5


How to create Capex and funding schedules including multiple debts




Equity and debt fund raising and repayment structure 


Debt waterfall mechanism


Checking debt repayment ratios, leverage, and covenants




Module – 6


Integration of income statement, balance sheet, and cash flow statement




Industry practices on handling exceptions




integration of Cash Flows, Income Statement and Balance Sheet




How to handle Circular References in financial modeling




Module – 7


Establish scenario and sensitivity analysis




Use of data for sensitivity analysis


Importance of scenario manager


Identifying suitable scenarios and sensitivities and their impact on financial analysis 


Managing critical pitfalls in the analysis




Module – 8


How to analyze the data




Data sorting and Data filtering


Creating, customizing Pivots Tables, advanced pivot tables, and analysis


V-LOOK UP and H-LOOK UP, Macros, and other analysis




Module – 9


How to apply different financial analysis techniques on the model




Importance of PV, NPV, and IRR and their link with company valuation


How to analysis various capital budgeting decisions 


Calculation of multiple ratios


Calculate the weighted average cost of capital using capital asset pricing model (CAPM) 


Calculation of WACC


Investment and exit analysis - equity IRR, project IRR etc




Module – 10


Approaches to applying different valuation techniques in the model




Various methods of valuation - DCF, Multiples, comparables, etc 


Discounted Cash Flow valuation and different multiples based methodologies


Importance of terminal valuation 


Current industry practices followed in company valuation using single or multiple methods 


Incorporate various adjustments to the publicly available versions of Company valuation






If you need further information, please visit www.riverstonetraining.com.sg or send mail at info@riverstonetraining.com.sg


Riverstone – Corporate Training https://www.riverstonetraining.com.sg


Information Source: Riverstone Training Pte Ltd | eventbrite

新加坡

正在搜尋Oct 1, 2025（UTC+8）在新加坡舉辦的Financial Modeling in Excel | One Raffles Place的資料和門票？ Trip.com 幫助您。 立即查看Financial Modeling in Excel | One Raffles Place的日期、行程和其他資訊！ Trip.com 更有其他類似的精彩活動。 立即起程！

Financial Modeling in Excel | One Raffles Place: 日期及行程 | Trip.com

Financial Modeling in Excel | One Raffles Place

Financial Modeling in Excel | Trip.com

探索更多關於新加坡的內容

null | Trip.com

分享你的結果，看看朋友們怎麼說！

新加坡萊佛士酒店

新加坡, 鄰近魚尾獅公園|濱海灣

奢華酒店

新加坡濱海灣金沙酒店

Instagram打卡酒店

新加坡環球影城

明日可用

人氣景點

主題樂園

夜景

CJ7wonders

有趣、緊湊，一天就能玩遍。雖然它不是最大的環球影城，但維護得很好，運作也很高效，變形金剛和太空堡壘卡拉狄加都很棒&hearts;️&hearts;️&hearts;️。可惜木乃伊工程關閉了🥲🥲。

新加坡濱海灣花園

Stella_s

建議下午3,4點入園 這樣可以連同夜景 燈光秀一起看喔本來免費看的燈光秀遇上聖誕節限定活動 燈光秀要收費了😂

新加坡嘉佩樂酒店

新加坡, 鄰近新加坡環球影城|聖淘沙島

當地風情酒店

新加坡聖淘沙萊佛士酒店

新加坡, 鄰近巴拉灣海灘|聖淘沙島

新加坡富麗敦海灣酒店

萬態野生動物世界

zhang_ja

常說的新加坡動物園，其實分4個單獨的園區▫️新加坡動物園：老虎獅子大象啥的🐯🦁▫️夜間野生動物園：世界上首個夜間動物園🎑▫️新加坡飛禽公園：各種飛鳥為主🦜🦤🦩🦚▫️河川生態園：世界上最大淡水水族館🐟🐠🐡

夜間野生動物園

隨買隨用

即日可用

匿名用戶

門票物有所值，步道有點黑，所以夜視能力不好的人可能需要帶手電筒。露天劇場的表演一般，但可以算是對一些夜行動物的初步了解。亮點是火車之旅&mdash;&mdash;幾乎所有動物都很活躍，而且都在火車的視線範圍內。食物價格還可以，但比外面略貴一些。工作人員熱情友善。我會推薦給任何想在晚上體驗健康活動的人。

新加坡天際線斜坡滑車

親子景點

纜車

雖然今天去玩碰到了下雨，但是下了一會兒就停了，還是很好玩的，小朋友直呼再來幾圈，買了4圈還不夠玩，山上景色也不錯，也很好上手玩，不排隊，很幸運的一天

時間：	Oct 1, 2025（UTC+8）結束
地點：	One Raffles Place

Financial Modeling in Excel | One Raffles Place

詳情

投票

你對Financial Modeling in Excel感興趣嗎？