Accumulated depreciation in Excel
Some clients have had old computers for years, and it is time to write off old ones from the accounts. We have date of purchase, current year date year end, and cost. 25% reducing balance method is used. We need accumulated depreciation from date of purchase to current year end date in one formula. Trouble with Excel is that their formulas always ask for useful life of the asset, which we do not have and there seems no formula to calculate what must be a common requirement. Am I missing something, or does someone have the golden formula? Any help appreciated.
- Is Dropbox right for your client comms? Webinar 15 May 306
- Set up a company pension 259
- 2011 FHL loss & ITA 2007 s74a 227
- RTI Fees 216
- HMRC Lost PAYE Clients 201
- Where's our 10%? 199
- Driving sales growth 193
- EIS 187
- UK Property Purchase by an overseas individual in own name 185
- Regiatration of a Trust 183
- Cost of converting property - who pays? 182
- CIS late registration 167
- Best structure 164
- Accounting for gift vouchers - paid for and donated 164
- Inorporation using S165 gift relief 160
- Break up basis accounting 160
- Mortgage application for intending director. 153
- Property owned privately 153
- Membership of trade association - tax deductible? 141
- Companies in administration - Bad debt and VAT 133




DEPRECIATION