Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Accounting study guide help So iv mostly been getting stuck on making the functions work and doing the part were its saying don't use cell
Accounting study guide help
So iv mostly been getting stuck on making the functions work and doing the part were its saying don't use cell references to the values
Plant Assets, Natural Resources, and Intangibles Using Excel to prepare depreciation schedules The Fraser River Corporation has purchased a new piece of factory equipment on January 1, 2018, and wishes to compare three depreciation methods: straight-line, double-declining-balance, and units-of-production. The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 machine hours. At the end of four years, the equipment is estimated to have a residual value of $20,000. Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points. Requirements 1 Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. 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. 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? *For all requirements, enter all amounts as positive values. Do not use a minus sign or parentheses for any values. Excel Skills 1 Create formulas with absolute and relative cell references. 2 Format the cells as accounting number format. 3 Use the Excel function DDB to calculate double-declining-balance depreciation. Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add-solution-date to end of file name 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 B Requirement 1 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Requirement 3 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) **For calculations in each of the four tables below refer only to the values calculated in the same table or provided in the DATA table. DATA Cost $ 400,000.00 Residual Value $ 20,000.00 Useful Life (Years) Useful Life (Hours) 8,000 Gain End of Year 1 $ 6,000.00 Straight Line Year Depreciable Cost Rate Depreciation Expense 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? Double Declining Balance Book Value Year Beginning of Year Depreciation Expense Rate Accumulated Depreciation Double Declining Balance using DDB function Depreciation Accumulated Year Expense Depreciation Book Value End of Year 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? Depreciation Expense Accumulated Depreciation Book Value Units of Production Depreciation Machine Hours Year Per Unit 2,400 2 1,800 2,480 1,320 3 The minimum amount to sell the factory equipment in order to have a gain of $6,000 at the end of Year 1? HINTS Cell Hint: C24:D27 Use absolute cell references to the corresponding cells in the DATA table to calculate depreciable cost and depreciation rate values 56 for periods 1-4. (Absolute cell reference uses $, example $A$1) ALL Book Value columns Use absolute cell reference to the corresponding cell in the DATA table and the values obtained in the 57 Accumulated Depreciation column to calculate the book values for periods 1-4. 134:37 Use the function =DDB() to calculate the depreciation expense. Do not enter any value for the FACTOR argument of the DDB 58 function. 59 D37 Leave this cell blank. 60 G39 Do not use cell references to the values in the Double Declining Balance using DDB function table. 61 C44:047 Use absolute cell references to the corresponding cells in the DATA table to calculate depreciation per unit values for periods 1-4Step 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