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 152 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
YES! Correct, THANKS for helping me on my review

Hdosisshsbshs

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

The medical assistant as receptionist in a medical office. The medical assistant as receptionist in a medical office.
Treatment for Shock in the Medical Office Treatment for Shock in the Medical Office
Every medical office should keep emergency supplies in a waterproof container. Every medical office should keep emergency supplies in a waterproof container.
Recommended childhood and adolescent immunization schedule, 2009. Recommended childhood and adolescent immunization schedule, 2009.
A piece of broken plate was dug up in an archeological site. It was put on top of the grid ... A piece of broken plate was dug up in an archeological site. It was put on top of the grid ...
question in cost accounting question in cost accounting
Video: Transmission Across a Synapse

For a complete list of videos, visit our video library