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

シンガポール

Financial Modeling in Excel | One Raffles Placeの情報やチケットをお探しですか？Trip.comにお任せください！Financial Modeling in Excel | One Raffles Placeへの参加に備えて、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

友人の考えを知りたい？自分の回答をシェアして、会話を始めましょう。

ラッフルズ シンガポール

シンガポール マーライオン公園周辺|マリーナ・ベイ

豪華なホテル

マリーナベイ・サンズ

インスタ映えホテル

ユニバーサル・スタジオ・シンガポール

明日分を予約可

遊園地

夜景

CJ7wonders

楽しくてコンパクト、そして1日で楽々回れます。ユニバーサル・スタジオの中では一番大きいパークではありませんが、よく整備されていて、トランスフォーマーとバトルスターが効率的に運営されています&hearts;️&hearts;️&hearts;️。残念ながら、ミイラは閉まっています🥲🥲。

ガーデンズ・バイ・ザ・ベイ

匿名ユーザー

花が好きな人には特におすすめです。それでも訪れる価値のある場所です。夜のライトショーは期待していたほどではありませんでした。

カペラ シンガポール

シンガポール ユニバーサル・スタジオ・シンガポール周辺|セントーサ

現地ならではの体験ができるホテル

ラッフルズ セントーサ シンガポール

シンガポール パラワン ビーチ周辺|セントーサ

ザ フラートン ベイ  ホテル

マンダイ・ワイルドライフ・リザーブ

チケットがプロモーション価格だったので、この旅は価値がありました。間違いなく体験する価値があり、公共交通機関での移動時間も節約できました。

ナイトサファリ

すぐに入場可

当日予約可

入場料は払う価値があります。トレイルを歩くと少し暗いので、夜間視力の弱い方は懐中電灯を持参した方が良いかもしれません。円形劇場のショーはまあまあでしたが、夜行性の動物たちを観察するには良い機会でした。ハイライトは列車の乗車です。どういうわけか、ほとんどの動物が活発に動き回り、列車から見える距離にいました。食べ物の値段はまあまあで、外より少し高い程度です。スタッフは温かく親切です。夜に楽しいアクティビティを探している方にはぜひお勧めします。

スカイライン リュージュ

家族向け観光スポット

ケーブルカー

_TI***so

とてもおすすめです！とても楽しかったので、KUルンプールにも遊びに行きました。年齢を問わず楽しくて夢中になれる場所です。

Time:	Oct 1, 2025（UTC+8） ENDED
所在地：	One Raffles Place

Financial Modeling in Excel | One Raffles Place

詳細

投票

Financial Modeling in Excelに興味がありますか？