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
Is ACCA hard? Truth Be told
So I recently asked a colleague name Rahul Tyagi: Is ACCA hard? His answer was Yes it is hard for me. but when I asked a student who was a fresher, the answer was the opposite. How could that be? So in this article I shall give you the first hand answer on this question.…
Best Extra Courses for Commerce Students
Last updated on October 23rd, 2024 at 02:28 pmSo, you have limited time? May be you have a semester break or may be you are waiting for the placements week to start. And you are confused as to what are the best 3 months extra courses for commerce students? So, I have some good news…
Advanced Excel Course Syllabus-Designed For Industry
Last updated on November 22nd, 2024 at 03:10 pmAccording to a 2023 survey conducted more than 80% of the job postings in data analysis, financial modeling, project management require high proficiency in Microsoft excel. However, excel is so wide and so is its application that having a clearly defined advanced excel course syllabus is important.…
Gumbel Copula in Financial Modeling
Last updated on October 23rd, 2024 at 03:39 pmThe Gumbel copula is a popular tool for modeling dependencies between variables, particularly in the context of financial modeling where extreme events (tail dependencies) are of interest. This copula belongs to the Archimedean family and is characterized by its ability to capture asymmetric tail dependence, especially for…
Example of A/D Analysis (Accumulation/Distribution Analysis)
Last updated on October 23rd, 2024 at 02:55 pmAccumulation/Distribution (A/D) Analysis is a technical indicator used in financial markets to assess the relationship between stock prices and trading volume. It helps determine whether a stock is being accumulated (bought) or distributed (sold). The indicator calculates the “money flow” based on the price movement and volume.…
Prototyping Stage in Financial Models Development
Last updated on October 23rd, 2024 at 02:58 pmThe prototyping stage forms an integral component of the financial modeler’s approach and is even more apparent in sophisticated environments like mergers, acquisitions or even capital budgeting. The focus of this stage is on the preparation of a first basic outline of the financial model, in order…
