Accounting Excel, accounting homework help

Todd Service Company purchased a copier on January 1, 20xx. The following information applies to the copier purchased:

Purchase price –$25,000
Delivery cost –$ 500
Estimated life –4 years
Estimated copies produced1,000,000
Salvage value$ 1,500

The copies produced as follows:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
Year 1250,000 copies
Year 2270,000 copies
Year 3320,000 copies
Year 4160,000 copies

Using Excel, determine the amount of depreciation expense and the net book value for each of the four years (6 years for MACRS) using each of the following methods:

Straight-line
Double-declining balance
Units of production
MACRS, assuming the machine is classified as five-year property

 
"Looking for a Similar Assignment? Order now and Get 15% Discount! Use Code "FIRST15"
[promo3]