Reducing balance depreciation?

  • Thread starter Thread starter THD69
  • Start date Start date
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?
 
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.
 
Back
Top