Calculate the declining balance depreciation amounts for the medical van as follows:
a) In cell C18, enter a formula using the DB function to calculate the declining balance depreciation for the medical van during its first year of operation.
b) Use year 1 (cell C17) as the current period.
c) Use absolute references only for the cost, salvage, and life arguments in the DB formula.
d) Fill the range D18:I18 with the formula in cell C18 to calculate the annual and cumulative declining balance depreciation in years 2–7.



Answer :

Other Questions