« previous next »

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

savannahhooper

  • Hero Member
  • *****
  • Posts: 576
on: Jun 24, 2018
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
Reply #1 on: Jun 24, 2018
Answer to Question 1

#NAME?

Answer to Question 2

#REF!


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

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?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Squamous cell carcinoma Squamous cell carcinoma
Local/long distance cell Signaling Local/long distance cell Signaling
cell component cell component
HIV cycle in an infected cell: (a) latent infection; (b) active infection. HIV cycle in an infected cell: (a) latent infection; (b) active infection.
Typical photovoltaic cell Typical photovoltaic cell
A diagram of a generalized human cell A diagram of a generalized human cell
Video: Splitting of Sugar, Oxidation/ Reduction & ATP Generation

For a complete list of videos, visit our video library