1. Pranjali wants to compare straight-line depreciation amounts with declining balance depreciation amounts to determine which method is more favorable for the hospital's balance sheet. In the range D5:D7, she estimates that the Neighborhood Nurse program will have $234,000 in tangible assets at startup, and that the useful life of these assets is seven years with a salvage value of $37,440. Start by calculating the straight-line depreciation amounts as follows:
   1. In cell C11, enter a formula using the SLN function to calculate the straight-line depreciation for the medical van during its first year of operation.
   2. Use absolute references for the cost, salvage, and life arguments in the SLN formula.
   3. Fill the range D11:I11 with the formula in cell C11 to calculate the annual and cumulative straight-line depreciation in Years 27.

Mount Moreland Hospial - Neighborhood Nurse Van Depreciation Van with Medical Eauioment Declinina Balance Deoreciation