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 106 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
Wow, this really help

rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Excellent

« previous next »
 

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?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Booker T. Washington in his office at Tuskegee Institute, 1900. Washington chose a policy of accommo Booker T. Washington in his office at Tuskegee Institute, 1900. Washington chose a policy of accommo
Demonstrating the use of venipuncture equipment. Holding a butterfly needle in place with a ... Demonstrating the use of venipuncture equipment. Holding a butterfly needle in place with a ...
The disaccharides sucrose, maltose, and lactose are created from the monosaccharides The disaccharides sucrose, maltose, and lactose are created from the monosaccharides
Basic Marketing Research: Using Microsoft Excel Data Analysis Basic Marketing Research: Using Microsoft Excel Data Analysis
Created Equal: A Social and Political History of the United States, Brief Edition Created Equal: A Social and Political History of the United States, Brief Edition
Present Value Formula: Amortization Schedule Present Value Formula: Amortization Schedule
Video: Replication of DNA and Chromosomes/ How do cells replicate their DNA? (Animation) no Audio

For a complete list of videos, visit our video library