Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use excel formulas to fill out the blue areas B Requirement 1 c D o 1 2 3 4 5 6 7 8 9 10

image text in transcribed
use excel formulas to fill out the blue areas
image text in transcribed

B Requirement 1 c D o 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) Requirement 2 Prepare a second depreciation schedule for double-declining-balance method, using the Excel function DDB. The DDB function cannot be used in the last year of the asset's useful life. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) Requirement 3 At December 31, 2018, Fraser River is trying to determine if it should sell the factory equipment. Fraser River will only sell the factory equipment if the company earns a gain of at least $6,000. For each of the depreciation methods, what is the minimum amount that Fraser River will sell the factory equipment for in order to have a gain of $6,000? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) **For calculations in each ofthe four tables below refer only to the values calculated in the same table or provided in the DATA table. DATA Cost Residual Value Useful Life (Years) Useful Life (Hours) Gain End of Year 1 Straight Line Year 1 2 3 4 400,000.00 20,000.00 4 8,000 6,000.00 Depreciable Cost Rate Depreciation Expense Accumulated Depreciation The minimum amount to sell the factory equipment in order to have a gain of $6,000 at the end of Year 1? Double Declining Balance Book Value Book Value End of Year Double Declining Balance using DDB function Year 1 2 3 4 Book Value Beginning of Year Rate Depreciation Expense Accumulated Depreciation Depreciation Year Expense 1 2 3 4 Accumulated Depreciation Book Value The minimum amount to sell the factory equipment in order to have a gain of $6,000 at the end of Year 1? Instructions ENTERANSWERS Ready Accessibility: Investigate s 100%

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_2

Step: 3

blur-text-image_3

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

Performance Management

Authors: Herman Aguinis

3rd edition

132556383, 978-0132556385

More Books

Students also viewed these Accounting questions

Question

What does SMART stand for? (p. 86)

Answered: 1 week ago