Reducing balance depreciation?

T

THD69

how do I set formula to calculate reducing balance depreciation? like below:

Cost Rate A = (Cost*Rate) B = (Cost - A)
45,000 0.0003 375 44,625
44,625 0.0003 372 44,253
44,253 0.0003 369 43,884
cumulative: 1.116

can i do it in a query by building expressing or i need to write
program....if, where? pls let me know?
 
P

Pendragon

go to the microsoft website and search for the excel template on
depreciation. you can look at the formulas in the workbook to help you
program accordingly in access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

This is a toughie | auto-calculate depreciation | populate unbound 4
Depreciation Table Formula 1
Reducing balance 3
Balance Depreciation - how many years? 2
SLN & Annual rate of Depreciation 1
Depreciation Spreadsheet 3
Excel Formula - Depreciation calculation for opening balance and additions 0
Depreciation function inconsistencies 1

Top