Author Question: The depreciation schedule for a copier/printer is created in Excel. The cost of the asset is in Cell ... (Read 66 times)

savannahhooper

  • Hero Member
  • *****
  • Posts: 576
The depreciation schedule for a copier/printer 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, the depreciable amount is in Cell C7, and the sum of the years digits is in Cell C8. Column A contains the year, Column B contains the depreciable amount, Column C contains the fraction for the years remaining, Column D contains the annual depreciation, Column E contains the accumulated depreciation, and Column F contains the end-of-year book value. Using the sum of the year's digits method of depreciation, what formula should be keyed into Cell D11 to calculate the first-year annual depreciation?

Question 2

The depreciation schedule for a school bus 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 annual double-declining-balance rate is in Cell C7. Column A contains the year, Column B contains the depreciable amount, Column C contains the double-declining-balance rate, Column D contains the annual depreciation, Column E contains the accumulated depreciation, and Column F contains the end-of-year book value. Using the double-declining-balance method of depreciation, what formula should be keyed into Cell C10 to calculate the first-year end-of-year book value?



Ptupou85

  • Sr. Member
  • ****
  • Posts: 334
Answer to Question 1

#NAME?

Answer to Question 2

#REF!



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

For a complete list of videos, visit our video library