Depreciation : Connecting P&L and Balance Sheet for Accurate Asset Forecasting

  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 / Depreciation : Connecting P&L and Balance Sheet for Accurate Asset Forecasting

Understanding depreciation

We ended the prior chapter with the initial balance sheet calculation, referred to as the gross block. This one will finalize the asset schedule and connect the information back to both the P&L and Balance sheet

Currently, this is what the asset list looks like –

The gross block appears to be neat and orderly. We must now move on to determining the deprecation. The greatest difficulty with forecasting the total depreciation is calculating the current year’s number, as you are aware of, which comes from the P&L statement.

A look at this year’s depreciation, per the Profit & Loss report, reveals…

Investors commonly have difficulty understanding the difference between the accumulated depreciation shown on a balance sheet and the current year’s depreciation that appears in a P&L (in the expense section).

The depreciation value reported in the P&L for the current fiscal year is only relevant to that fiscal period. The finance team at the company reviews all existing assets (gross block) when determining the figure for the current year’s depreciation. Each new financial year brings with it a revised depreciation amount dependent on any updates to the gross block.

The balance sheet’s accumulated depreciation is cumulative in nature, meaning that the current year depreciation (from the Profit & Loss report) is simply added to the next year’s number, which produce the total for this year.

Don’t fret if this seems befuddling; you’ll soon comprehend it, but for the present I want you to consider the path we are taking.

We have already estimated the Gross block number. By projecting the current year depreciation figure to the P&L, we can then apply the base rule in the asset schedule and forecast its Accumulated Depreciation amount.

After forecasting the accumulated depreciation, we can compute the company’s netblock. This netblock figure will then be reflected in the balance sheet.

We make the process simpler and easier, and we save time.

Forecast the depreciation expense in the current year’s profit and loss statement.

Retrieve the forecasted netblock amount from the asset record and feed it back into the balance sheet.

Predicting this year’s depreciation relies heavily on methods and techniques used.

We’ll take a brief detour before continuing, which is relevant to our conversation.

Imagine yourself in the shoes of a freelance photographer with an unpredictable monthly income. You are responsible for handling your own finances, and you must be prepared to adjust according to the amount of work that comes your way.

Your October income amounted to 25K, and you shelled out 3K for leisure.

In November, how much do you reckon you should put aside for entertainment, given that your income is 30K?

The best approach is to stick with the same expenditure pattern as you did in October.

In October –


= 12%

Hence for September,

12% * 30000

= 3600

By applying the method of proportions, I am hoping to forecast depreciation for the current year.

For Year 5, the P&L showed Depreciation and Amortization of 41.71 Cr, while the balance sheet reported a Gross Block of 538.76Cr. This is estimated to reach 588.77 Cr in Year 6; what would you expect depreciation in that year to be?