The balance sheet’s asset side reveals the company’s line items.

  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 / The balance sheet’s asset side reveals the company’s line items.

We have already taken care of the inventories.

We will create a schedule for gross block, similar to the liabilities side, and address Cash and Bank balance in the current assets extensively in the cash flow statement.

Let us assume the remaining items on the asset side, and I’ll quickly explain our approach before we head over to excel.

Balance Sheet Assets

I will look at sundry debtors as a proportion of Gross block; however, there is an option of converting to days and back.

This line item is linked to the organisation’s working capital, and so can be seen as a ratio of net sales.

The figure for Year 1 is minuscule and omitted in the subsequent years, hence it can be disregarded.

Capital work in progress – As a percentage of net sales

Investments – As a percentage of Gross block

Having worked out the historical percentages, I can then estimate the rolling average for the years ahead. From what I mentioned before, it is practicable to adjust the denominator depending on your analysis of the company’s financial records. Assumptions in financial modelling are derived from creative judgement – you are welcome to try something different as long as it isn’t too exaggerative.

Balance Sheet Assets

I’ll go ahead and implement what I’ve discussed into the excel sheet and post a sequence of screenshots. With any luck, they’ll make everything clear.

Balance Sheet Assets

I’ve worked on the assumption sheet, putting the line items in the same arrangement as they are on the balance sheet. I’m starting my calculations with Year 2 to keep them consistent with the other assumptions.

I’ve identified the Year 2 percentages and highlighted the loans, advances and deposits compared to net sales. You can view the equation bar and F16 cell, both of which I’ve featured in order to emphasise the P&L line item in the denominator.

I trust you’ll find this a simple, achievable goal. If you experience any trouble with carrying out this task, feel free to leave a comment.

For the following steps, I will move the rows to the right until year 5. Then, starting with year 6, I’ll take the averages.

I’ve emphasized the average calculation to make it easier for you to understand. Instead of averaging out the figures of Y6 to Y10 for the last entry on balance sheet, Investment as a percentage of Gross Block, I will set it as a fixed value at 3.5%.

Why not opt for an average as with the other elements? Why settle on 3.5%? Could 4% or 3% be better? All these queries are legitimate.

The number fluctuates from 3% to 11%, which is not ideal. To ensure consistency, I would prefer it to remain at a steady 3.5%.

Financial models bring a lot of convenience; it means I don’t have to commit to one figure from the start. I can adjust this number according to what I believe is most sensible, so there’s no need for pressure on this particular parameter – 3.5% it is!

This completes the balance sheet side of assumptions. The remaining items will be addressed using schedules.

Now, let’s proceed to the P&L assumptions; this should be straightforward.


    Get the App Now