Author Question: The depreciation schedule for a copier/printer is created in Excel. The cost of the asset is in Cell ... (Read 111 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?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

For a complete list of videos, visit our video library