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.
 
Top