please help
Depreciation Methods Scenario -Saved to my Mac Tell me View References A A A Mallings Review A E. E. . . + . tu AaBbt tyd e , and improvements, choose Check for Updates Scenario: A machine is purchased for $21,000. The machine is expected to last for five years and has an expected salvage value is $4,000. The expense associated will be allocated to periods over the life of the asset. Goal: Prepare a depreciation schedule in Excel for a five year period using straight-line, double-declining balance, and sum-of-the-year's digit depreciation methods. Procedure: 1. Enter the appropriate factual data in cells B3:B5. 2. In cell B8, enter a function formula that determines the straight-line depreciation for one year (ESLN(cost salvage, life)]. Use absolute references (for example, B$65) within the function formula so that the formula may be copied without losing the original references. Copy the formula in BB to B9:B12. In cell CB, enter a function formula that determines the double declining balance depreciation for one year (=DDB(cost salvage life period factor) Use absolute references within the function formula for the cost, salvage, and life so that the formula may be copied without losing the original references. The period should be a relative cell reference for the value in Tell me we 2 Depreciation Methods Scenario -Saved to my Mac References Mailings Review View A A A A E L AMC AaBb C A S A E == ::.._. Enpress Lemon The Normal arity updates, fees, and improvements, choose check for Updates 1. Enter the appropriate factual data in cells B3:35. Sung CBT 2304 AaBbc 2. In cell B8, enter a function formula that determines the straight-line depreciation for one year (=SLN(cost salvage, life)]. Use absolute references (for example, B$6$) within the function formula so that the formula may be copied without losing the original references. Copy the formula in B8 to B9:B12. 4. In cell C8, enter a function formula that determines the double declining balance depreciation for one year (=DDB(cost salvage,life period, factor)]. Use absolute references within the function formula for the cost, salvage, and life so that the formula may be copied without losing the original references. The period should be a relative cell reference for the value in A8. The factor should be the default. Copy the formula in C8 to C9:C12. In cell D8, enter a function formula that determines the sum-of-the-year's digit depreciation for one year (=SYD(cost salvage,life period)). Use absolute references within the function formula for the cost, salvage, and life so that the formula may be copied without losing the original references. The period should be a relative cell reference for the value in A8. 7. Copy the formula in D8 to D9:012. wish (United States AutoSave D Home Insert . X cut Copy o = Page Layout Formulas Data Review View Arial 12 - An A = = = d. BIUS A. E 33 - Paste Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Upx SUM * fx = A DEPRECIATION METHODS + 3 Original Cost 4 Salvage Value 5 Asset Life $21,000.00 $4,000.00 5 yrs Double Declining Straight line Sum-of-the- Year's Digit 2 Tota
