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 123 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
:D TYSM

billybob123

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Elle and associates investigated the cost to Datura wrightii of producing sticky leaf trichomes. Elle and associates investigated the cost to Datura wrightii of producing sticky leaf trichomes.
Chemical Laboratory Equipment Chemical Laboratory Equipment
CPT Modifiers Used for Medical Office Services Cont. CPT Modifiers Used for Medical Office Services Cont.
Does It Cost More to Eat Healthy? Does It Cost More to Eat Healthy?
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 ...
Cost = $99.49; Rate of markup based on cost = 32%. Find the markup and selling price. Cost = $99.49; Rate of markup based on cost = 32%. Find the markup and selling price.
Video: Double Stranded DNA Molecule Animation

For a complete list of videos, visit our video library