Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12 On the Depreciation worksheet, in cell B7, use the straight-line depreciation function to calculate the depreciation value of the equipment for year one. Use

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
12 On the Depreciation worksheet, in cell B7, use the straight-line depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references. Copy the function down through B13. 13 In cells C7:C13, calculate the accumulated depreciation value for each year. In cell C7, reference the current year's Depreciation Expense. In cell C8, add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through C13. 14 In cells D7:D13, calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied. Copy the formula down through D13 15 In cell G7, use the declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute references where appropriate. Copy the function down through G13. Step Instructions Possible 16 In cell G18, use the double declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references where appropriate. Copy the function down through G24. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Double Declining Balance Depreciation schedule } \\ \hline & YearlyDepreciationExpense & AccumulatedDepreciation & \\ \hline 1 & & $0.00 & $00k Value \\ \hline 2 & & $0.00 & $100,000 \\ \hline 3 & $0.00 & $100,000 \\ \hline 4 & $0.00 & $100,000 \\ \hline 5 & $0.00 & $100,000 \\ \hline 6 & & $0.00 & $100,000 \\ \hline 7 & & $100,000 \\ \hline \end{tabular} 12 On the Depreciation worksheet, in cell B7, use the straight-line depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references. Copy the function down through B13. 13 In cells C7:C13, calculate the accumulated depreciation value for each year. In cell C7, reference the current year's Depreciation Expense. In cell C8, add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through C13. 14 In cells D7:D13, calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied. Copy the formula down through D13 15 In cell G7, use the declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute references where appropriate. Copy the function down through G13. Step Instructions Possible 16 In cell G18, use the double declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references where appropriate. Copy the function down through G24. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Double Declining Balance Depreciation schedule } \\ \hline & YearlyDepreciationExpense & AccumulatedDepreciation & \\ \hline 1 & & $0.00 & $00k Value \\ \hline 2 & & $0.00 & $100,000 \\ \hline 3 & $0.00 & $100,000 \\ \hline 4 & $0.00 & $100,000 \\ \hline 5 & $0.00 & $100,000 \\ \hline 6 & & $0.00 & $100,000 \\ \hline 7 & & $100,000 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Guidelines For Laboratory Quality Auditing

Authors: Donald C. Singer, Ronald P. Upton

1st Edition

0824787846, 978-0824787844

More Books

Students also viewed these Accounting questions

Question

9. Describe the characteristics of power.

Answered: 1 week ago

Question

10. Describe the relationship between communication and power.

Answered: 1 week ago