calculate and analyze depreciation under alternative methods 494509
On January 1, 2010, the super fast subs company purchased a delivery automobile for $31,000. The estimated useful life of the vehicle is five years, and the estimated salvage value is 1,000. The company expects the automobile to be driven 200,000 miles during its service life. Actual miles driven were:
Year Miles
Don't use plagiarized sources. Get Your Custom Essay on
calculate and analyze depreciation under alternative methods 494509
For $10/Page 0nly
2010 35,000
2011 40,000
2012 45,000
2013 39,000
2014 41,000
Requirements
1. Calculate the depreciation expense for each year of the five-year-life of the automobile using the following methods. (Round your answers to the nearest dollar.)
a, Straight-line method
b. Double-declining balance method
c. Activity method
2. How does the choice of depreciation methods affect net income in each of the years? How does the choice of depreciation methods affect the balance sheet in each of the years?
Document Preview:
Sheet3 Sheet2 Sheet1 A B C D E G H Name Section F End of Problem Data Input Section: Estimated residual value Estimated useful life Depreciation Expense Per Year Double Straight Declining Year Line Balance Helpful Hint: Use the following functions to calculate depreciation =SLN(cost,salvage,life) =DDB(cost,salvage,life,period) Activity Method Output Section: Problem 6-70A Super Fast Subs Company Cost of asset, January 1, 2010 Miles driven Total miles driven over life of equipment Cost per mile (cost-residual/units) Part 1. Part 2. Amount Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 Formula 7 Formula 8 Formula 9 Formula 10 Formula 11 Formula 12 Formula 13 Formula 14 Formula 15 Formula 16 Type answer starting here Reimers, Financial Accounting 3e 5.00 6.00 7.00 8.00 9.00 10.00 11.00 2010.00 12.00 2011.00 13.00 2012.00 14.00 2013.00 15.00 2014.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 2010.00 24.00 2011.00 25.00 2012.00 26.00 2013.00 27.00 2014.00 28.00 $0.00 $0.00 $0.00 29.00 30.00 31.00 32.00 33.00 34.00 35.00 36.00 37.00 38.00 39.00 40.00 41.00 42.00 CyberCoach: Enter the following formula: =(H7-H8)/H16 CyberCoach: Enter the following formula: =G11*$H$17 Then copy down CyberCoach: You have to enter this amount manually. Sheet3 Sheet2 Sheet1 A B C D E G H Name Section F End of Problem Data Input Section: Estimated residual value Estimated useful life Depreciation Expense Per Year Double Straight Declining Year Line Balance Helpful Hint: Use the following functions to calculate depreciation =SLN(cost,salvage,life) =DDB(cost,salvage,life,period) Activity Method Output Section: Problem 6-70A Super Fast Subs Company Cost of asset, January 1, 2010 Miles driven Total miles driven over life of equipment Cost per mile (cost-residual/units) Part 1. Part 2. Amount Formula 1 Formula 2 Formula…
Attachments:
p06-70a.xlsCalculator
Our features
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.