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 199 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
Excellent

gcook

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

« previous next »
 

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

The lipid bilayer is made of phospholipids. They are arranged in a double layer because one of their ends is attracted to water while the other is repelled by water.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

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
The vast majority of older adults live in their own homes, even when they need special equipment or ... The vast majority of older adults live in their own homes, even when they need special equipment or ...
A medical office requires teamwork. A medical office requires teamwork.
Typical Examination Room Equipment and Supplies Cont. Typical Examination Room Equipment and Supplies Cont.
Portable tabletop equipment that provides support for recipients receiving massage. Portable tabletop equipment that provides support for recipients receiving massage.
Close-up of a newly created enzyme degrading PET plastic Close-up of a newly created enzyme degrading PET plastic
Video: Interpreting a cladogram Animation

For a complete list of videos, visit our video library