Learn financial modelling Balance Sheets, P&L, and Assumptions Know About

  1. Financial Modelling
    1. Financial Modelling Introduction
    2. Financial Modelling Tools & steps
    3. How to Make a Financial Model and choose the best Company and Excel Workbook Setup?
    4. How to build a financial model Step-by-Step Guide to Excel Sheet Setup?
    5. Financial Statements: A Step-by-Step Guide to Extracting Historical Data
    6. Financial modelling excel
    7. Learn financial modelling Balance Sheets, P&L, and Assumptions Know About
    8. What is financial modelling Assumptions and Projections?
    9. Financial modelling and valuation
    10. Investment decision calculation
    11. The balance sheet’s asset side reveals the company’s line items.
    12. Revenue Model & Growth Rate in in P&L Assumptions
    13. Basics of financial modelling CAPEX and Asset Schedule
    14. Financial Analysis: Gross Block and CAPEX
    15. Gross block & Capex: Constructing the Asset Schedule
    16. Depreciation : Connecting P&L and Balance Sheet for Accurate Asset Forecasting
    17. depreciation expense : Exploring Different Methods in Financial Modeling
    18. Debt Management: Connecting P&L and Balance Sheet for Accurate Liability Projection
    19. Interest Rate Calculation & Debt Schedule
    20. Share Capital & Reserves
    21. IPOs and Under subscription : Bata’s Share Capital Dynamics
    22. Reserves & Surplus understanding Bata schedule
    23. Reserves and surplus schedule How to Build on Excel
    24. Financial modelling projections
    25. Balance Sheet Projections and Completing Reserves Schedule
    26. Cash Flow Statements Analysing Operations, Investments, and Financing Activities
    27. What Is Valuation for Investor
    28. Free Cash Flow Key Components, Formulas and How to Calculate?
    29. FCFF and FCFE uses in Mastering Free Cash Flow Calculation
    30. WACC Weighted Average Cost of Capital Analysis
    31. Market Risk Premium analysis
    32. Tax Shield and its Impact on Equity Holder Returns
    33. Weighted Average Cost of Capital and Terminal Growth in Valuation
    34. Terminal Value Understanding Perpetual Cash Flow Projections in DCF Model
    35. Learn Financial Modelling
    36. Free Cash Flow to the Firm (FCFF) Calculation with examples
    37. Stock Valuation DCF Model & Stock Market Value
Marketopedia / Financial Modelling / Learn financial modelling Balance Sheets, P&L, and Assumptions Know About

Assumptions Part 1

– Model integrity

I want to begin this chapter by stressing a pivotal concept. I may have mentioned it earlier, but I would like to elaborate on it further with visuals to emphasise its significance.

Previously, we created a balance sheet and P&L for the helper model. This is an overview –

P&L –

And the balance sheet

The model design ensures that the numbers are identified quickly, and links between cells are accurate by assigning FY16 data to column E, FY17 to column F and so on.

For example, if I’m trying to determine the ratio of Property, plant and equipment to Total revenue for FY18, crisscrossing between sheets is necessary. However, it’s very easy to mistakenly link up incorrect cells without even realising it.

Let us go ahead and do this. I can use the cells of Column G in the formula bar to easily calculate the result.

Examine a case wherein you mis-linked the years when calculating the ratio. It is effortless to identify the error –

In this instance, I am aware that column G in the balance sheet should be correlated with column G in the P&L. When I observe the amalgamation of columns G and F, I realise something isn’t right.

This example may seem basic, yet as the model becomes increasingly intricate, you will recognise the importance of preserving its accuracy.

– Main model

It’s time to introduce you to the main concept. Undoubtedly, many of you would anticipate me to disclose the organisation we’re focusing on and name the timeframe we’re evaluating. But I have different ideas.

I am consciously avoiding mentioning a specific company to avoid potential biases. This way, it is clear that the model template can be applied to any organisation (except banking and NBFCs) without singling out any sector in particular.

It is expected that by omitting the date references, this module will remain relevant for readers looking to undertake a financial modelling exercise regardless of when they decide to learn about it. The core principles and structure would still be applicable even many years down the line.

In this illustration, we will take into account the records of a basic manufacturing company.

I followed all the instructions in the preceding chapter and got Balance Sheet and P&L data together. Below is a screenshot of it –

Balance sheet

I’ve reduced the size of my Excel sheet to 70%, so I can get a complete picture of the balance sheet, with numbers and formatting that may look a bit different.

This is a snapshot of the P&L.

A couple of things here –

For the purposes of this study, Year 1 up to Year 5 are being taken into account. This captures the most recent five years’ worth of information, so the data will still be relevant in the future no matter how far removed from this present moment.

The data presented in the Annual Report reflects the financial position as of the fiscal year’s conclusion, which is March 31st.

Year 1A and 6P signify the actual and anticipated data of Year 1 and 6, respectively. The projected information is based on March 31st. In other words, this allows us to contemplate what the financial statement might appear like in future annual reports.

At the conclusion of this chapter, you can download an excel sheet that features the raw P&L and Balance sheet data. I believe it’d be beneficial for you to utilise this information and create a format as we discussed. It’ll serve as a great way for you to practice.