Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Penny and Daughter's construction business is considering purchasing a new Bobcat. The equipment will cost $150,000 and is expected to last 12 years. The Bobcat

Penny and Daughter's construction business is considering purchasing a new Bobcat. The equipment will cost $150,000 and is expected to last 12 years. The Bobcat has a salvage vale of $7,000. Calculate the depreciation AND book value for each year. You can create one table for a-d or you can create different tables for each. This problem will need to be done in excel. (30 points)

a.Use straight-line depreciation. (5 points)

b.Use declining-balance depreciation with a depreciation rate that ensures the book value equals the salvage vale in the last year of the life of the equipment. (5 points)

c.Use double declining balance depreciation. (5 points)

d.Use MACRS depreciation where the Bobcat is considered a 10 year property. (5 points)

e.Graph the Book values of each methods on a single graph. The graph should have points at each year for each BV and a line of each method. You will have 4 lines on your graph. You should include year 0 on your graph so that all four lines start at the same point. Each method should be a different color and you must label the graph, axes, and legend. (10 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

This problem involves calculating depreciation using four different methods and then graphing the book values over the life of the asset Lets break it down step by step 1 Overview of Depreciation Meth... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

7th Edition

978-0-538-4527, 0-538-45274-9, 978-1133161646

More Books

Students also viewed these Accounting questions

Question

2. It is the results achieved that are important.

Answered: 1 week ago

Question

7. One or other combination of 16.

Answered: 1 week ago