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

vickybb89

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

« previous next »
 

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Office Space Office Space
A Piece of Mars on Earth A Piece of Mars on Earth
HCPCs Modifiers Used for Medical Office Services Cont. HCPCs Modifiers Used for Medical Office Services Cont.
Shell-Tube CHE 413 Chemical Engineering Equipment Design Shell-Tube CHE 413 Chemical Engineering Equipment Design
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
A cowbird with its foster parent. A female cowbird minimizes her cost of parental care by laying her A cowbird with its foster parent. A female cowbird minimizes her cost of parental care by laying her
Video: Passive Smoke Exposure

For a complete list of videos, visit our video library