Calculate reducing balance method percentage formula

Posted by Anthony.Evans82 PM | on Thu, 14/06/2012 - 13:04 5440 7 comments | report

Hi All,

I trust you are all well. I was really hoping someone would be able to help me with a query that I have for the reducing the balance method of depreciation in Excel.

1. How would I calculate the percentage to use based on say an asset NBV of £25,000, salvage value of £5,000 and a useful life of 5 years,

2. How on earth do I go about putting that into an Excel formula.

Maybe someone would be kind enough to assist??

Thanks

Ant

Comments

There are 7 comments. Login or register to view them.

Is this close enough?

ElliottRoss | Thu, 14/06/2012 - 13:51

Try DB

Steve Kesby | Thu, 14/06/2012 - 14:08

Hi Steve & Elliott,

Anthony.Evans82 | Thu, 14/06/2012 - 19:51

Actually, before you waste

Anthony.Evans82 | Thu, 14/06/2012 - 19:56

I just did...

Steve Kesby | Thu, 14/06/2012 - 20:12

Ah yes, the formula

Anthony.Evans82 | Thu, 14/06/2012 - 20:14

The Formula

edhy | Mon, 18/06/2012 - 08:41