
Friends, readers of Chandoo.org, we are very glad to announce Financial Modeling School for your consideration. Please read this short page to understand the benefits of this program and how you can sign-up.
Click here if you want to skip the story and just get in to Financial Modeling School.
What is Financial Modeling School?
This is an online training program to teach you,
- How to develop financial models using MS Excel
- How to create project finance models using Excel
- 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. - 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. - 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. - 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. - Free Bonus – Excel Formula Lessons
For successful modeling, you need to know various excel formulas and their uses. So we have 15 video lessons on various excel formulas for you as a free bonus. - Free Bonus – List of Keyboard Shortcuts PDF
This one page PDF includes some really powerful and useful Excel Keyboard Shortcuts. - 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. - 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. - 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. - Should I be online or available at a specific time to enjoy the lessons?
No. You can learn at your convenience. - Can I upgrade to Download option later?
You can upgrade to download option once you sign-up. It costs $77. You will find the details inside Financial Modeling School.
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.
Who 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 Finace Module are,
| Financial Modeling School Topics: | |||
| FSS Nuances for Project finance | Components of Real Estate (RE) Financial Model | RE Investments: Key Metrics | Key Concepts in RE ModelDesigning 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 | |
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 School Now
We have special pricing for Existing Students of Financial Modeling School. Use the below form to select the option and make a payment.
How the Purchase Process Works?

Frequently Asked Questions
I have answered 3 most frequently asked questions here:
Please check out Financial Modeling School FAQ page for more.
Problems During Signup?
If you have any problem during sign-up process or still have some un-answered questions, write to me at chandoo.d @ gmail.com or call me at +91 814 262 1090 or +1 206 792 9480. I will be very glad to answer your questions.
We hope to see you in Financial Modeling School.
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 350 tutorials, articles and how-to guides and trained 900 students and made them awesome in Excel. I have received prestigious MVP award from Microsoft in years 2009, 2010 and 2011.
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] |
| Want to pay thru Bank Transfer? Indian Pricing & Account Details |
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 eveyday 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 specialised 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
Share this tip with your colleagues

Get FREE Excel + Power BI Tips
Simple, fun and useful emails, once per week.
Learn & be awesome.











11 Responses
Ciao Hui,
Collecting Excel tricks under the title “Notable Excel Websites (Non-MVP) Edition” is a brilliant idea…
Thank you in the name of all The FrankensTeam.
On our site there is a box with a picture and text highlighting:
This is a no-MVP site
we think ourselves “bad boys” a bit 🙂
For those who would like to know why our site is a no-MVP site, enough to click on the link:
http://goo.gl/lxDszY
Thank you again!
Thanks a lot
I really enjoyed this (newsletter). I must admit that I rarely read an Excel newsletter (and I subscribe to quite a few) all the way though, but this grabbed my attention and before I realized it, I was engrossed in it. I must also admit that most of this I don’t understand, yet. But, it excites me when I do learn something new in Excel. I can’t wait to see how much of this I can implement into my (constantly-evolving) ‘House Budget’ & ‘Family Medical’ worksheets that I have developed over the past few years! I sure hope to see more of these type of newsletters in the future! Thanks!
Thanks for doing this Hui! I appreciate being included.
I like Tom’s tip a lot. I posted about a tool I wrote to automate this at http://yoursumbuddy.com/tables-edit-query-dialog/
EXCELLENT !
Hui, This post is Superb! More over I have always been a fan of Roberto’s work and have learnt a lot from him.
Here are some of my recent contributions
1. Customising markers in a chart – http://www.goodly.co.in/customize-markers-in-a-chart/
2. Charting Hacks to work faster – http://www.goodly.co.in/5-charting-hacks-to-help-you-work-faster/
3. 7 Date formulas to make life easy – http://www.goodly.co.in/date-formulas-in-excel/
4. Customised scrollbar using VBA – http://www.goodly.co.in/customized-scroll-bar-in-excel/
5. Adding Direct Legends – http://www.goodly.co.in/customized-scroll-bar-in-excel/
Hope everyone enjoys!
I like the Excel Ninja Menus.
1. Select a cell or range then move till the 4-way cross appears. Right-Click and drag the selection to another place in the worksheet then, like a ninja, a menu full of skills and throwing stars pops up allowing me to do all kinds of awesomeness.
2. When you click the fill box on a Date and right click and drag it down, a lot of amazing Date options pop up.
I also brand my Excel to remind myself that I’m awesome. In my personal macro workbook I place the following code.
Private Sub Workbook_Open()
Application.Caption = “SuperKrishna’s Awesomeness”
End Sub
My favorite tip goes along with #17. If you try to copy subtotaled data (and in earlier Excel versions filtered data),when you paste it all the data displays instead of just the summarized data.
To get around this, select your summarized data, click on Find and Select tab and then select Go to Special. Click Visible cells Only and click OK. Now paste and you will see that only the summarized data has been copied.
You can also go CTRL+G and then click the Special icon at the bottom of the dialog box.
What a great idea, Chandoo! I’d love to be included in your next edition:) Perhaps a VBA exclusive version?
@Ryan
I will review this concept about 6 months out from the original post and be sure to keep your site in mind
Hui…
That sounds great, Hui:) I just realized I gave credit to Chandoo for the idea and I should have attributed it to you.
Sorry about that!