1. Financial Modelling Overview
Unusual Method We are all living in an era of extraordinary uncertainty. Humanity has suffered greatly and is suffering greatly as a result of the second wave of COVID-19. I'm hoping for you.
2. Setting up an Excel workbook
Choosing a Business I never thought the previous chapter would have such a great reception. I feel like there are a lot of expectations from this, and I'm a little overwhelmed.
3. Past information
Report on the Year Continuing from the previous chapter, we will extract the data from the yearly report to our blank Excel sheet now that we have our sheet set up.
4. Premises (First Part)
Integrity of the model I want to discuss a rather essential idea at the beginning of this chapter. Even if I may have mentioned this before, I'd like to talk about it once more with some new images to emphasise.
5. Part 2: Assumptions
Postponed taxes In the previous chapter, a gentleman left a thought-provoking comment. The business he selected to model did not provide the gross block data in the manner that the business we are working with did.
6. Model of revenue
Using common sense We constructed the P&L and balance sheet assumptions in the previous chapter. We also addressed the company's revenue in the P&L projections. Indeed, we did take.
7. Part I of the Asset Schedule
Recap and next steps In the last chapter, we examined how a straightforward, common-sense method might help us create a basic revenue model for a business. With their assistance, we created the revenue model.
8. Part 2 of the Asset Schedule
Greetings, depreciation Our first prediction for the balance sheet, the gross block, brought the previous chapter to a close. The asset schedule will be finished in this chapter, and the figures will be plugged back into it.
9. Debt Schedule
Managing Debt In the previous chapter, fixed assets were covered. As you can see, the largest line item on the asset side of the balance sheet is fixed assets. This chapter contains full of finance system.
10. Schedule of Reserves (Part 1)
Share Capital (10.1) We have made a few schedules so far in this session to aid in our understanding of the financial statements' finer points. You will learn how to create an additional schedule in this chapter.
11. Schedule of Reserves (Part 2)
Transfer and Swap In the previous chapter, we learned how to create a reserve timetable for a specific company. While creating the reserve timetable for Bata India Limited, we also talked about.
12. Forecasts
A significant accomplishment There are two crucial checkpoints in the construction of a financial model. The first milestone will be reached in this chapter, and the second in the next. Prior to moving on, I'd like to.
13. Statement of cash flow
Cash Flow Indirectly We are in a pivotal phase of our financial modelling process. The cash flow statements will be derived in this chapter, and the balance sheet will be updated with that cash flow figure.
14. Overview of Valuation (Part 1)
Basics of Valuations We have reached the final phase of our financial modelling process. Building a valuation model, which will be incorporated into the integrated model we are building, is the final phase.
15. FCFF and FCFE in Part 2 of Valuation
Foundational elements We continued our discussion of relative and absolute valuation ideas from the previous chapter. The absolute valuations are fundamentally driven by three important inputs.
16. Part 3 of Valuation: Risk Premium and Tax Shield
Premium for market risk As we covered in the last chapter, equity holders anticipate a larger return than debt holders. We shall discount the fee using the higher return rate.
17. Terminal Growth and Weighted Average Capital Cost
Summarise We have nearly reached the conclusion of the theoretical concept of valuation. We will talk about two important topics in this chapter, and then in the following chapter, we will.
18. Analysis of Discounted Cash Flow (DCF)
Summarise Chapter 1 began with an overview of financial modelling. I did discuss how kids are always taught financial modelling in a classroom setting.
You must be logged in to post a comment.