MENTOR ME CAREERS

Free Financial Modeling Course with Template & Detailed Video Series

Last updated on June 13th, 2024 at 03:21 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.

  1. Download Template –here
  2. Assumptions & Objective Setting
  3. Create the Income Statement
  4. Balance Sheet
  5. Cash Flow Statement
  6. Return Calculation and Sensitivity
  7. 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!

  1. Gather the assumptions
  2. 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.

  1. Calculate the revenue first by looking out at the assumptions of tariff, seating capacity and load factor (Calculate for 365 Days)
  2. Leave the other income part for now (other income can be calculated only after we have the cash)
  3. Calculate costs in a similar manner by Finding the total fuel required (Ill let you think that!)
  4. Calculate Gross profit in the model by reducing total cost of revenues from Revenue + Other Income
  5. Depreciation is basically the cost of the bus spread across years according to the matching principle of accounting- Remember bus is the asset here
  6. 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
  7. 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

  1. Remember the balance sheet starts from year 0, since your investment happens before your operations begin
  2. 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
  3. 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.

Detailed Free Financial Modeling Coruse Series on Titan company

 

 

  • CFA Course Details in Hindi: हिंदी में: मेरी यात्रा और अनुभव

    क्या आपने कभी सोचा है कि सीएफए (CFA) क्या है और इसे कैसे किया जाता है? चलिए, मैं आपको अपनी कहानी और अनुभव के माध्यम से इस कोर्स के बारे में बताता हूँ, ताकि आप भी इस रोमांचक यात्रा को समझ सकें। CFA course details in Hindi सीएफए का फुल फॉर्म (CFA Full Form in…

  • Understand The XIRR meaning using XIRR calculator & Examples

    I remember when I first entered the investment industry, and for the very first time using the xirr calculator. And the truth be told it took me some good to comprehend the xirr meaning practically. So I will try my best to use my real live experiences with investments, in making you understand this concept.…

  • FRM Syllabus Detailed Walkthrough for 2024 exams

    Last updated on July 13th, 2024 at 01:29 pmFinancial risk management qualification from GARP, one of the fastest growing professional qualification. In this article, I will take you through the detailed FRM Syllabus and walkthrough for optimum preparation. FRM Syllabus Overview Below I have shown the broader classification of subjects across 4 areas. More or…

  • Appropriation Account in accounting & how is it prepared?

    Let’s take an example to nail the context right away. Let’s suppose you are running an IT Services company with 5 founders , 20 common shareholders. Now, at the end of the year after looking at the profit and loss account. I as a common shareholder would like to understand how the profits were divided.…

  • New Age Sources of Working Capital a Definitive study

    New Age Sources of Working Capital: A Definitive Study** discusses the new-age, rapidly growing startup fintechs focusing on providing working capital loans. Since the 2008 credit crisis, tight banking regulations have opened the way for alternative financing solutions that have made it easier for businesses to source much-needed funds.

  • 5 Critical Pitfalls of Target Costing

    Last updated on July 20th, 2024 at 01:45 pmSo there is enough literature out there which talks about target costing definition and the features of target costing. Hence in this article, you should expect less on what but the problems of target costing. Define Target Costing Target costing is a method of costing and a…

Summary
×