Last updated on October 23rd, 2024 at 03:39 pm
Download TEMPLATE and start with me.
Free Financial Modeling Course: Tutorial
Leaving aside the fascination of any finance student or professional on learning this skill, financial model is nothing but business. Having said that business’s take decisions and decisions making is financial modeling. I will take you through a very simple, three statement model, at the end of which we decide if we want to start this business or not.
- Download Template –here
- Assumptions & Objective Setting
- Create the Income Statement
- Balance Sheet
- Cash Flow Statement
- Return Calculation and Sensitivity
- Take Decisions- Basis NPV & IRR
Step by Step Tempalte- Easy to use
The template of this model is an easy one, just so that your basic concept of what is financial modeling and how it is applied is clear. Remember financial modeling is a decision making tool and hence template should help us in making decisions. It is not necessary for the template to be very complicated.
You could also check my video on “ History of Financial Modeling”
Assumptions & Objective Setting
Assumptions are the most critical part of a financial Model, primary because financial models are basically used for business and finance decision making.In this model we are making a financial model in excel to take decision whether the feasibility of a start up business in the travel industry. Hence the first step in any financial model you build is to first list down the assumptions we will need to take the decision and then think about the model template.
So to sum it up till here!
- Gather the assumptions
- Design the structure of the model template
Gathering Assumptions
Believe it or not, your financial model is as good as your assumptions. A lot of time has to be spent, on understanding the business details, which is not as easy as it may sound. You need to break down the business drivers and cost drivers. Business drivers means, its revenue sources in ( Price X Quantity) structure, and a similar structure for the business costs.
Create the Income Statement
The Income statement is given in the template and its not important for the income statement to be according to some accounting standard but logical.
- Calculate the revenue first by looking out at the assumptions of tariff, seating capacity and load factor (Calculate for 365 Days)
- Leave the other income part for now (other income can be calculated only after we have the cash)
- Calculate costs in a similar manner by Finding the total fuel required (Ill let you think that!)
- Calculate Gross profit in the model by reducing total cost of revenues from Revenue + Other Income
- Depreciation is basically the cost of the bus spread across years according to the matching principle of accounting- Remember bus is the asset here
- Create the amortization schedule of debt- If you don’t know how to do that you can watch the tutorial for it which I have linked above
- Finally arrive at Net Income
Balance Sheet
Balance Sheet tells the position of the business at a point in time and is one of the three statements we create in this financial model
- Remember the balance sheet starts from year 0, since your investment happens before your operations begin
- So in year 0 there will be gross fixed assets and on the liability side there will be the financing of that asset using debt and equity
- Populate all the years and give special attention to calculations you perform.
Cash Flow Statement
Cash flow statement is one of the most important statements and which helps us in valuing this business. Pay attention on the calculation methodlogy I cover in the tutorial to learn how to make the cash flow statement in the financial model easily.
This will also teach you how the other income in the form of interest income gets calculated
Return Calculation and Sensitivity
Once you have the entire model in place then perform a sensitivity analysis to calculate how your assumptions affect your financial Model. Also the return calculation method we used in this model is IRR and NPV.
Financial Modeling is a core skill for careers in investment banking . If you are confused on, how to make your careers in investment banking then watch this video on the same.
Related Articles
Detailed Free Financial Modeling Coruse Series on Titan company
How to Build a Financial Model: A Practical Step‑by‑Step Guide
Learning how to build a financial model isn’t just about entering numbers into Excel — it’s about structuring information so you can make better business and investment decisions.A financial model turns business drivers and assumptions into a logical framework that helps you forecast outcomes and evaluate choices. Whether you’re an investor, entrepreneur, or finance professional, this guide…
Top Investment Banking Skills for Aspiring Students & Professionals
Investment banking skills are the foundation of a successful career in one of the most competitive fields in finance. These skills decide how fast you grow, how well you perform under pressure, and how much value you bring to clients. They matter for students, fresh graduates, and even career switchers who want to break into…
Investment Banking Subjects: What You’ll Learn & Why It Matters
Last updated on January 16th, 2026 at 01:35 pmInvestment banking is a specialized field of finance that focuses on helping companies, governments, and institutions raise capital, make strategic decisions, and execute complex financial transactions. The subjects related to investment banking combine accounting, finance, economics, and business strategy to build a strong understanding of how companies…
What Is an Investment Banking Course? Syllabus, Skills & Career
Last updated on January 16th, 2026 at 01:13 pmInvestment banking is one of the most sought-after careers in finance, attracting both fresh graduates and professionals looking to switch into core finance roles. But where do you begin, and what skills or training actually matter?In this guide, we break down what an investment banking course really…
Top 5 high paying CFA level 1 Jobs in India – Guide
Cracked CFA Level 1 and wondering what’s next? You’re not alone. Thousands of finance students and professionals in India clear Level 1 of the CFA Program each year but the big question remains: “Can I get a good job after CFA Level 1?” The short answer? Yes, but with the right expectations. While Level 1…
Importance of corporate finance – Why it matters
In today’s dynamic business world, every financial decision big or small has a ripple effect. Whether it’s funding a new project, managing day-to-day cash flows, or planning for long-term growth, corporate finance lies at the heart of it all. It’s the engine that keeps businesses running efficiently, strategically, and profitably. But why exactly is corporate…
