Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I cannot seem to find the excel formulas needed. I know what the amount of the depreciations should be but i cannot figure out the

image text in transcribed

I cannot seem to find the excel formulas needed. I know what the amount of the depreciations should be but i cannot figure out the formulas for the correct amount.

At the beginning of Year 1, Copeland Drugstore purchased a new computer system for $52,000. It is expected to have a five-year life and a $7,000 salvage value. $52,000 $ 7,000 5 Required: a-1. Compute the depreciation, assuming that the company uses straight-line depreciation. Straight-line depreciation 59,000 a-2. Compute the depreciation for each of the five years, assuming that the company uses double-declining-balance depreciation. Note: Leave no cells blank - be certain to enter " 0 " wherever required. You may enter the hardcoded number " 2 " when calculating the depreciation expense. Depreciation Expense Year 1 $20,800.00 Year 2 Year 3 Year 4 Year 5

At the beginning of Year 1, Copeland Drugstore purchased a new computer system for $52,000. It is expected to have a five-year life and a $7,000 salvage value. \begin{tabular}{|l|l|l|l|} \hline$52,000 & $7,000 & 5 \\ \hline \end{tabular} Required: a-1. Compute the depreciation, assuming that the company uses straight-line depreciation. Straight-line depreciation $9,000 a-2. Compute the depreciation for each of the five years, assuming that the company uses double-declining-balance depreciation. Note: Leave no cells blank - be certain to enter " 0 " wherever required. You may enter the hardcoded number " 2 " when calculating the depreciation expense

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions