Excel formula to calculate previous depreciation

**sunboy** · 08-08-2021, 12:59 PM

Hi

I'm kindly asking for the formula to calculate Previous depreciation (past 5 years) column K as shown in the desired solution.

Thank you.

Regards,

Sunboy

**Bo_Ry** · 08-08-2021, 02:14 PM

Maybe try

=SLN(D6,E6,F6)*(H6-1)

=SUM(SYD(D7,E7,F7,SEQUENCE(H7-1)))

=SUM(DB(D8,E8,F8,SEQUENCE(H8-1)))

=SUM(DDB(D9,E9,F9,SEQUENCE(H9-1)))

=VDB(D10,E10,F10,0,H10-1)

**sunboy** · 08-08-2021, 02:57 PM

Hi

Thank you so much.

Regards,

Sunboy

Excel formula to calculate previous depreciation

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Excel formula to calculate previous depreciation

Re: Excel formula to calculate previous depreciation

Re: Excel formula to calculate previous depreciation

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel formula to calculate year to date depreciation based on today's date

Calculate Previous 3 months (DAX Formula)

Calculate declining bal Depreciation

Calculate new depreciation rate for an exisitng asset

Excel formula or function for Depreciation schedule.

[SOLVED] Formulas to show all previous depreciation combined, and also current depreciation.

Can we calculate depreciation using exponential function

Bookmarks

Bookmarks

Posting Permissions