8. Asset Schedule (Part 2)
8.1 – Hello depreciation We closed the previous chapter with our first balance sheet projection, i.e. the gross block. This chapter will complete the asset...
7. Asset Schedule (Part 1)
7.1 – Recap and way forward In the previous chapter, we looked at how a basic common sense approach can lead us to build a...
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...
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...
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,...
3. Historical Data
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...
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...
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...
32. Personal finance review (Part 2)
32.1 – Investments This is the sexiest part of the personal finance journey and one that most people focus on. The amount of time people...
31. Personal finance review (Part 1)
31.1 – Overview It’s a new year, and that means it’s time to review your personal finances. Most tips about reviewing personal finances tend to...