Let us utilize the proportion approach.
The company reported depreciation of 41.71Cr for the total asset worth of 538.76Cr.
41.71/538.76
= 7.74%
What is the depreciation for Year 6 when its gross block value is 588.77 Cr?
7.74% * 588.77
= 45.58Cr
This estimation suggests that depreciation for the next year will be 45.58Cr, which should be reflected in the Profit and Loss statement.
The depreciation value is fixed at 7.74%.
Rather than take the proportion used in the previous year and expect it to apply for the following one, try computing the depreciation to gross block ratio for all past years, then taking an average of those last five years to forecast future estimates.
It will look something like this –
Y6 = Average of Y1 to Y5
Y7 = Average of Y2 to Y6
Y8 = Average of Y3 to Y7
Etcetera.
I’ll opt for the first approach since it seems to be the simplest.
If you possess a sound background in accounting, then exploring deeper into the net-block to get to the bottom of the depreciation figures may be an option.
By using the first method, I can quickly enter the formula in the P&L.
In cell J16, I divided the Depreciation expense stated in the P&L for Year 5 by the gross block stated in the Balance Sheet for the same year; thus generating the depreciation proportion. This figure is then used to calculate the Depreciation Expense for Year 6 by multiplying it with the projected gross block.
The resulting value is the depreciation amount for Year 6, which is projected. This same math can be applied to all future years in order to calculate the depreciation expense for each year.
We also took a small step forward with our financial modelling, since we created a P&L projection.
At this juncture, my profit and loss account appears like this –
Now that this is done, let’s review the asset list.
– Accumulated depreciation
Some of you may have already guessed what we will do next. It’s quite straightforward: we update the asset schedule sheet with the current year depreciation figure from the P&L and use the base rule to work out the total accumulated depreciation.
I have calculated the P&L numbers and used them as part of my computation.
The closing balance for Y5 is 223.68Cr and this serves as the opening balance for Y6. To work out the closing balance for Y6, add current year depreciation – although we don’t have any visibility on this line item so can only assume a value of zero for all future years.
I’ve employed the basic rule to work out the concluding balance of accrued depreciation. The net block is composed of the initial block minus the accrued depreciation, which I have approximated for coming years.
You can get the amount of accumulated depreciation from the asset schedule and then use that figure to do the net block calculation on the balance sheet.
We have now incorporated the Fixed assets section into the balance sheet.
© 2021 BP Equities Pvt. Ltd.
All Rights Reserved
By signing up, you agree to receive transactional messages on WhatsApp. You may also receive a call from a BP Wealth representative to help you with the account opening process
Disclosures and Disclaimer: Investment in securities markets are subject to market risks; please read all the related documents carefully before investing. The securities quoted are exemplary and are not recommendatory. Past performance is not indicative of future results. Details provided in the above newsletter are for educational purposes and should not be construed as investment advice by BP Equities Pvt. Ltd. Investors should consult their investment advisor before making any investment decision. BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), IN-DP-CDSL-183-2002 (CDSL), INH000000974 (Research Analyst), CIN: U45200MH1994PTC081564. Please ensure you carefully read the Risk Disclosure Document as prescribed by SEBI | ICF
Attention Investors
Issued in the interest of Investors
Communications: When You use the Website or send emails or other data, information or communication to us, You agree and understand that You are communicating with Us through electronic records and You consent to receive communications via electronic records from Us periodically and as and when required. We may communicate with you by email or by such other mode of communication, electronic or otherwise.
Investor Alert:
BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), INZ000030431 (MCX/NCDEX), IN-DP-CDSL-183-2002 (CDSL),
INH000000974 (Research Analyst) CIN: U45200MH1994PTC081564
BP Comtrade Pvt Ltd – SEBI Regn No: INZ000030431 CIN: U45200MH1994PTC081564
For complaints, send email on investor@bpwealth.com
