This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: The depreciation schedule for a piece of office equipment is created in Excel. The cost of the asset ... (Read 136 times)

jayhills49

  • Hero Member
  • *****
  • Posts: 559
on: Jun 24, 2018
The depreciation schedule for a piece of office equipment 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?

Question 2

Miguel bought a boat at the beginning of the year for 48,000. The boat has an estimated life of 16 years and a salvage value of 19,000 at the end of the 16-year period. What is the book value after the first year?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Awesome

  • Sr. Member
  • ****
  • Posts: 280
Reply #1 on: Jun 24, 2018
Answer to Question 1

#REF!

Answer to Question 2

46,187.50;
48,000 - 19,000 = 29,000
29,000  16 = 1,812.50
48,000 - 1,812.50 = 46,187.50


jayhills49

  • Member
  • Posts: 559
Reply 2 on: Jun 24, 2018
Great answer, keep it coming :)

kjohnson

  • Member
  • Posts: 330
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

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?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Boundaries within landscapes created by human activity (background) and natural environmental gradie Boundaries within landscapes created by human activity (background) and natural environmental gradie
Contents of Office Policies and Procedures Manual Contents of Office Policies and Procedures Manual
Body Part, Method of Examination, and Equipment Used During the General Physical Examination Body Part, Method of Examination, and Equipment Used During the General Physical Examination
Crucible Lab Equipment Crucible Lab Equipment
When operating your own business, it is wise to know your cost of capital and that of the ... When operating your own business, it is wise to know your cost of capital and that of the ...
Tickets for the school play were $3 for students and $5 for all others. The box office sold 750 ... Tickets for the school play were $3 for students and $5 for all others. The box office sold 750 ...
Video: Alzheimer's Disease

For a complete list of videos, visit our video library