Free Financial Modeling Training Courses
Financial Modeling training courses are all around the web and there has been lot written about learning Financial Modeling, however, most of the financial modeling courses are exactly the same. This goes beyond the usual gibberish and explore practical Financial Modeling as used by Investment Bankers and Research Analysts.
In this Free Online Financial Modeling Training Course, I will take an example of Colgate Palmolive and will prepare a full integrated financial model from scratch.
This Financial Modeling Course Tutorial guide is over 6000 words and took me 3 weeks to complete. Save this page for future reference and don’t forget to share it
Financial Modeling Training — Read me First
Step 1 — Download Colgate Financial Model Template. You will be using this template for the tutorial
Step 2 — Please note you will get two templates — 1) Unsolved Colgate Palmolive Financial Model 2) Solved Colgate Palmolive Financial Model
Step 3- You will be working on the Unsolved Colgate Palmolive Financial Model Template. Follow the step by step Financial modeling Training instructions to prepare a fully integrated financial model.
Step 4 — Happy Learning!
In addition to financial modeling course, you can also take advantage of this Free Investment Banking Course.
I have made an easy to navigate table of contents for you.
· What is Financial Modeling?
· How to build a financial model?
· #1 — Colgate’s Financial Model — Historical
· # 2 — Ratio Analysis of Colgate Palmolive
· #3 — Projecting the Income Statement
· #4- Working Capital Schedule
· #5 — Depreciation Schedule
· #6 — Amortization Schedule
· #7 — Other Long Term Schedule
· #8 — Completing the Income Statement
· #9 — Shareholder’s Equity Schedule
· #10 — Shares Outstanding Schedule
· #11 — Completing the Cash Flow Statements
· #12- Debt and Interest Schedule Recommended
· Financial Modeling Course
· Free Financial Models
What is Financial Modeling?
Wikipedia defines “Financial Modeling” as follows –
Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment. Financial modeling is a general term that means different things to different users; the reference usually relates either to accounting and corporate finance applications, or to quantitative finance applications.
In simple terms, financial modeling means forecasting the future of the company or an asset by way of an Excel Model that is easy to understand and perform scenario analysis. In the context of our discussion here, we will discuss Financial Modeling with respect to the forecasting of the future financials of the company. This free financial modeling training course will help you forecast the financial statements of the company i.e. Income Statement, Balance Sheet and Cash Flows. The excel model is also known as an Integrated Financial Statements Model.
How to build a financial model?
Now that we know what Financial Modeling is, let us look at how a financial model is build from scrath. This detailed free financial modeling training course will provide you with a step by step guide to create a financial model. The primary approach taken in this financial modeling course isModular. Modular approach essentially means that we build core statements like Income Statement, Balance Sheet and Cash Flows using different modules/schedules. The key focus is to prepare each statement step by step and connect all the supporting schedules to the core statements on completion. I can understand that this may not be clear as of now, however, you will realize that this is very easy as we move forward. You can see below various Financial Modeling Schedules / Modules –