Module 13

Integrated Financial Modelling

  • 1. Introduction to Financial Modelling

    1.1 – Unusual approach We are all living in a very uncertain and unprecedented time. Covid 2nd wave has been brutally devastating and has caused a lot of pain and misery to humanity. I hope you ..

  • 2. Excel workbook setup

    2.1 – Selecting a company I never expected such a tremendously positive response for the previous chapter. I’m a bit overwhelmed, and I also get a sense that there are many expectations from this ..

  • 3. Historical Data

    3.1 – Annual Report recce Picking up from the previous chapter, now that we have our excel sheet set up, we will extract the data from the annual report to our blank excel sheet. The excel sheet at ..

  • 4. Assumptions (Part 1)

    4.1 – Model integrity I want to start this chapter by talking about a super important concept. I may have touched upon this topic earlier, but I would like to discuss it again with snapshots to emph ..

  • 5. Assumptions (Part 2)

    5.1 – Deferred tax   A gentleman posted an interesting comment in the previous chapter. The company he chooses to model did not present the gross block data in the way the company we are dealing wi ..

  • 6. Revenue model

    6.1 – Common sense approach In the previous chapter, we built the Balance Sheet and P&L assumption. Within the P&L assumptions, we dealt with the revenue of the company as well. We did take ..