What is Financial Modeling School?
This is an online training program to teach you,
» How to do Financial Modeling using MS Excel
» How to do Project Finance Modeling using Excel
At the end of the program you will be able to develop an integrated financial model or project finance model. We will use a practical case study to understand various steps of modeling & build one by the end of the program.
Why should you join Financial Modeling School?
This program is suitable for people in investment banking, project management, equity research, business planning, strategy, private equity, funds or commercial banking. It is also ideal for people who want a career with any of the above activities.
The program assumes you have basic knowledge of MS Excel. We will teach you various features Excel as part of the course, it is advisable that you know how to use Excel.
What Topics are Covered?
We have 2 modules in the program. (1) Financial Modeling Module (2) Project Finance Module
The course contents for Financial Modeling are,
|Financial Modeling School Topics:|
|Designing an efficient layout||Inputting the historical statements||Analyzing the growth drivers||Forming growth assumptions|
|Projecting future P&L and B/S||Creating Asset & Dep. Schedule||Creating Debt schedule||Equity & Retained Earnings|
|Creating Cash Flow statement||Circular loop and Cash updation||Analyzing Ratios||Valuation by DCF|
|Valuation by Comps||Charting a football field|
The course contents for Project Finance Module are,
|Project Finance School Topics:|
|FSS Nuances for Project finance||Components of Real Estate (RE) Financial Model||RE Investments: Key Metrics||Key Concepts in RE Model – Designing an efficient layout|
|Understanding circular loops in Excel||Interest During Construction||Modeling Depreciation and Deferred Taxes||Deferred Tax and Loss Carried Forward|
|Cash Distribution and Tranches||Modeling Delays||Debt Servicing Reserve Account (DSRA)||Modeling Commercial Complex|
|Modeling Assumptions||Modeling Area parameters||Modeling EPC Cost and Phasing||Modeling financing Schedules|
|Modeling NOI and Expenditure||Building financial statements||Valuation and Analysis|
The course contents for Excel School are,
|Excel School Topics:|
|Formulas||Formatting||Conditional Formatting||Basic Charting|
|Advanced Charting||Excel Tables||Pivot Tables||Data Validation, Filters|
|Advanced. Formulas||Importing External Data||Shortcuts, Productivity||Basic Form Controls, Macros|
How does Financial Modeling School Work?
We have made a short video to tell you how it works. Please watch it below:
Financial Modeling School – Course Brochure
Please download our course brochure: Financial Modeling School Course Details & Methodology [PDF]
What do you get when you Join?
Join Financial Modeling Classes Now
If you wish to join our Financial Modeling Classes without the hassle of going thru PayPal, use below options.
How the Purchase Process Works?
Frequently Asked Questions
I have answered 3 most frequently asked questions here:
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
© 2020 All rights reserved