Author Question: The depreciation schedule for a dump truck is created in Excel. The cost of the asset is in Cell C4, ... (Read 54 times)

tiffannnnyyyyyy · **on:** Jun 24, 2018

The depreciation schedule for a dump truck is created in Excel. The cost of the asset is in Cell C4, the salvage value is in Cell C5, the length of service is in Cell C6, and the depreciable base is in Cell C7 . Using the straight-line method of depreciation, what formula should be keyed into Cell C8 to calculate annual depreciation?
a. =C5/C6

b. =C4/C6

c. =C7/C6

d. =C7/C4

Question 2

A primary difference between standard spreadsheet models and simulation models is that at least one of the input variable cells in a simulation model contains random numbers.
a. True
b. False
Indicate whether the statement is true or false