fbpx
Search
Close this search box.

Welcome to Financial Modeling School - Online Training Program

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?

  1. 20 hours of Financial Modeling Online Training
    Each of the 14 topics in this program come with several videos discussing the process of constructing model in excel. There is a total of 20 hours of videos planned. All these lessons are neatly structured in to a lesson plan with links to view, download and discuss. You can follow the lesson plan and boost your modeling skills in a very short period of time.
  2. 20 hours of Project Finance Modeling Online Training
    Each of the 12 topics in this program come with several videos discussing project finance modeling in excel. There is a total of 20 hours of videos planned. All these lessons are neatly structured in to a lesson plan with links to view, download and discuss. You can follow the lesson plan and boost your modeling skills in a very short period of time.
  3. 24 hours of Microsoft Excel Training [Optional]
    You can sign-up for the optional Excel School and learn various concepts and practical uses of MS Excel. This course takes a practical approach and makes you a master of Excel. You can download all the course material and lesson videos for later reference. For details please refer to Excel School page.
  4. Example workbooks – both Empty & Completed ones
    At each step, we will provide you an example workbook so that you can immediately apply the knowledge gained in the class. You can verify your solution against ours using instructor version of same workbook. This will make your modeling skills rock-solid.
  5. 6 month Access to Online Classroom
    Online classroom is a blog-like area with secure userid and password for students. This is where you can ask questions related to lesson topics, discuss the lesson content or share your tips / ideas with other students. You can access the classroom for 6 months from data of joining.
  6. Free Bonus – List of Keyboard Shortcuts PDF
    This one page PDF includes some really powerful and useful Excel Keyboard Shortcuts.
  7. Free bonus – Chart Design E-book
    In this short 24 page e-book, we explain the process you should follow to format your charts to wow your audience. It also includes guidance on colors to use.
  8. 30 Day money back guarantee
    Each Financial Modeling School membership comes with a 30 day money back guarantee. If you don’t like what you see, just drop me an email and I will refund your money. No questions asked.

Join Financial Modeling Classes Now

Financial Modeling & Project Finance Classes - Signup Options
   
Financial Modeling & Project Finance Classes + Excel School - Signup Options
   

Accepted Payment Methods - Financial Modeling Classes

Alternative Payment Options Credit Card, Local Currency, Indian Rupee etc.

If you wish to join our Financial Modeling Classes without the hassle of going thru PayPal, use below options.

  • Payment Details for Bank Transfer / Check – Click here
  • Payment by Credit Card, Net Banking & Debit Cards – Coming Soon.

How the Purchase Process Works?

How the Purchase Process Works?

Frequently Asked Questions

I have answered 3 most frequently asked questions here:

  1. What payment methods are accepted?
    You can pay by credit card (VISA, Master, AMEX etc.) or with your PayPal Account. In some countries, you can also pay by electronic check. Use the most convenient option from Checkout page.
  2. What version of Excel is used in these Classes?
    We use Excel 2007 to conduct the classes. However, most lessons can be applied to Excel 2003 onwards.
  3. Can I upgrade to other options after joining the course?
    You can upgrade to any other option once you join the course. You will find the details inside the Financial Modeling School.

We hope to see you in Financial Modeling School.

Contact Details
Email: chandoo.d @ gmail.com
US: +1 206 792 9480
India: +91 814 262 1090

About Your Teachers:
Paramdeep

Welcome to Financial Modeling School.
My aim is to make you awesome in financial modeling. I have co-founded Pristine Education and till date taught Financial Modeling to 100s of individuals in investment banks, equity research firms etc.

Chandoo

At Chandoo,org, I have one goal – “to make you awesome in Excel”. I have started writing about Excel in year 2007. To date, I have authored more than 450 tutorials, articles and how-to guides and trained 4,500 students and made them awesome in Excel. I have received prestigious MVP award from Microsoft in years 2009, 2010, 2011 & 2012.

We hope to see you in Financial Modeling School.
Links & Downloads

Financial Modeling School FAQs
Course Contents & Methodology [PDF]
Example Lesson – Overview of Integrated Financial Model [ZIP]
Payment Options for Indians [Bank Transfer, Credit Card etc.]

Testimonials from Past Students

Love building the integrated model from the ground up.

It has been helpful to see and hear another person’s perspective on how they approach an integrated model and has served as a good good refresher on some areas that I may not use every day. It is also very helpful knowing that I can reach out to Paramdeep at any time if I encounter material I need additional help following / understanding.

– Sabrina

This is Best Financial Modeling training for small Scale to Large Scale Industries irrespective of Product, services,Builders, Dealers, Franchises e.t.c..

– Gangadhara Rao

Well done!, I owe you my respect and best regards for transmitting so much knowledge within such a short period of time. I am looking forward to more of such online school rooms. Thanks a lot so far for having you both, Chandoo and Paramdeep sharing your time and knowledge.

– Uwe Karrenberg

I find a the approach and the models very practical to my everyday work. I enjoy the fact that I can work at my own pace.

– Jim Moran

What I appreciated the most is that it started from the start. Although I am not a newcomer to financial modeling I guess someone with a less specialized background would be able to follow through and become proficient with practice.

I’d like to thank you for the course. I enjoyed it a lot.

– Marie-Helene Leopold



View Cart and Checkout