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 186 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

Alyson.hiatt@yahoo.com

  • Member
  • Posts: 354
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Choose the telephone unit that offers the features needed in your office. Choose the telephone unit that offers the features needed in your office.
The puppet, created for the Tbilisi Marionette Theatre, is controlled by forces hidden from public ... The puppet, created for the Tbilisi Marionette Theatre, is controlled by forces hidden from public ...
Display piece, Yoruba culture. Display piece, Yoruba culture.
CPT Modifiers Used for Medical Office Services Cont. CPT Modifiers Used for Medical Office Services Cont.
Medical assistant working in a front office area of a medical office. Medical assistant working in a front office area of a medical office.
Infant formula is available in several forms and varies in cost and ingredients Infant formula is available in several forms and varies in cost and ingredients
Video: Cell mediated immune response to a viral infection Animation

For a complete list of videos, visit our video library