Question

In: Accounting

Using Excel create depreciation schedule for the Straight-Line and Double-Declining-Methods for the following Long-Term assets: Asset...

Using Excel create depreciation schedule for the Straight-Line and Double-Declining-Methods for the following Long-Term assets:

Asset 1 – Office Furniture

Acquisition cost $30,000

Residual value $5,000

Useful life 7 years--------

Asset 2 – Delivery Truck

Acquisition cost $40,000

Residual value $5,000

Useful life 5 years-------

Asset 3 – Computer

Acquisition cost $2000

Residual value $0

Useful life 4 years

For each asset create its own Tab (Sheet) in the Excel worksheet and name the corresponding sheet by the asset.

At the top of each sheet create the input cells with the initial parameters of the asset (Name, Acquisition Cost, Residual Value, and Useful Life)

Below create Depreciation schedule for the (a) Straight-Line and (b) Double-Declining-Methods using formulas and cell references.

Use the in class excel example as a template for your answers.

Expert Solution

ekkarill92 answered 2 years ago

Explain in detail how to compute each of the following depreciation methods: straight-line, units-of-production, and double-declining-balance.

1) A change from straight line depreciation to double declining balance depreciation is an example of...

1) A change from straight line depreciation to double declining balance depreciation is an example of a change in an accounting principle. (answer True or False) 2) When preparing a statement of cash flows (indirect method), a sale of equity securities is an investing activity. (answer True or False)

1. Briefly identify each of the three major methods of calculating depreciation (Straight-Line, Double Declining Balance,...

1. Briefly identify each of the three major methods of calculating depreciation (Straight-Line, Double Declining Balance, Units of Production). Why would that company choose one method over another? 2. Define: "cost of goods sold", "gross profit", and "net income"

1. ) Prepare a depreciation schedule for the assets in the following transactions using the straight...

1. ) Prepare a depreciation schedule for the assets in the following transactions using the straight line method of depreciation: A. Flash Enterprises purchased 3 new delivery trucks at a cost of $45,000 each. Each truck has an estimated useful life of 5 years. B. Flash needed a new forklift to be used in warehouse operations at a cost of $12,500. The old forklift was traded in for $1,500. The new forklift has an estimated useful life of 4 years....

Question 1 (1 point) Straight-Line depreciation and Double-Declining-Balance depreciation result in the same Accumulated Depreciation at...

Question 1 (1 point) Straight-Line depreciation and Double-Declining-Balance depreciation result in the same Accumulated Depreciation at the end of the asset's useful life. Question 1 options: True False Question 2 (1 point) If a company makes a journal entry to record a PP&E Impairment, the entry will cause: Question 2 options: Total Assets to Decrease Net Income to Increase Total Assets to Increase Total Liabilities to Increase Question 3 (1 point) We depreciate Land unless it contains natural resources. Question...

Different depreciation methodologies: straight line depreciation, declining balance, units of production depreciation methods; should be able...

Different depreciation methodologies: straight line depreciation, declining balance, units of production depreciation methods; should be able to compute the depreciation amount and journal entries using each of those methods.

The method of depreciation was changed from the double-declining-balance method to the straight-line method in fiscal...

The method of depreciation was changed from the double-declining-balance method to the straight-line method in fiscal 2015. A machine was purchased on January 1, 2014 at a cost of $150,000. The machine has an estimated useful life of 10 years and a residual value of $9,000. What should have been booked as depreciation expense in fiscal 2015?

ABC Company has the following asset on its books: Using the double declining balance depreciation method,...

ABC Company has the following asset on its books: Using the double declining balance depreciation method, what is the depreciation expense in years 1 through 4. Truck cost 31,000 Salvage value 1,000 Estimated life in years 4 Estimated life in miles 100,000 Miles driven in years 1 = 25,000, year 2 = 20,000, year 3 = 33,000, year 4 = 24,000 Question 9 options: a) year 1 = 7,500, year 2 =...

Calculate depreciation (create schedule - excel is fine) of an asset costing $5,000,000, depreciating at a...

Calculate depreciation (create schedule - excel is fine) of an asset costing $5,000,000, depreciating at a rate of 10% per annum (diminishing value), having a life of 12 years and salvage value of $900,000 at the end of life. Please show working out / formulas used.

Complete the following depreciation table using the declining-balance method (twice straight-line rate). Auto: $26,000 &nbsp

Complete the following depreciation table using the declining-balance method (twice straight-line rate). Auto: $26,000 Estimated life: 10 years Residual value: $600 End of Cost of Acc. depr. Book value Annual Depr. Acc. depr. Book value Year asset B.O.Y B.O.Y. Expense E.O.Y. E.O.Y. 1 2 3 4 5 6 7 8 9 10 11