Calculate reducing balance method percentage formula
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??