Using the attached excel file compute and label each type


Question -

1. Iverson Company purchased a delivery truck for $45,000 on January 1, 2015. The truck was assigned an estimated useful life of 5 years and has a residual value of $10,000 and the truck was assigned an estimated useful life of 100,000 miles. Using the attached Excel File, compute and label each type of depreciation expense under following independent methods

2. Straight line method for years 2015 and 2016. Assume you disposed of the asset on July 1, 2017 and no cash was received. Calculate the gain or loss for this disposal as of that date.

3. Double Declining Balance method for years 2015, 2016, and 2017. What is the book value of the truck as of December 31, 2017?

4. The truck was driven 18,000 miles in 2015 and 22,000 miles in 2016. Compute depreciation expense using the units-of-activity method for the years 2015 and 2016.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Using the attached excel file compute and label each type
Reference No:- TGS02529819

Now Priced at $25 (50% Discount)

Recommended (97%)

Rated (4.9/5)