Answered step by step
Verified Expert Solution
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
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 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started