Hwan wants to compare straight-line depreciation amounts with declining balance depreciation amounts to determine which method is more favorable for the company's balance sheet. In the range G4:G6, he estimates that the construction equipment will be worth $800,000 in tangible assets at the beginning of the loan, and that the useful life of these assets is 10 years with a salvage value of $128,000. Start by calculating the straight-line depreciation amounts as follows: In cell B23, enter a formula using the SLN function to calculate the straight-line depreciation for the construction equipment during the first year of operation. b. Use absolute references for the cost, salvage, and life arguments in the SLN formula. a. Fill the range C23:K23 with the formula in cell B23 to calculate the annual and cumulative straight-line depreciation in Years 2-10. B D G H 3 Loan Conditions 4 Loan amounts 5 Annual interest este 6 Monthly interest rate cate) 7 Loan period in an & Loan period in months Cape Month 10 Start date of loan E Depreciation Conditions Long-term sets (cost) Salvage she (salvago) Life of asset life Amounts $300,000 4.45% 0.37% 10 120 18.272 1/6/2022 $800,000 $128,000 10 S.999 1998 10 25 49 73 12 Anual Principal mod. Cumulativement Payments Yes 13 Months 15 12 34 16 Pripal Principal mining $300.000 $300,000 Retrating 100 97 37 48 8 85 96 61 72 36 109 120 60 34 108 $500,000 100 $800,000 100". $900,000 100%. $800.000 100% $800,000 10046 $300,000 100% $800,000 -1009 $500,000 100 21 Straighie Depreciation 22 3 10 An depucation Cumulative det Depreciated anser value 25 26 50 $500.000 30 3800,000 $0 1500,000 10 $300,000 SO $500,000 90 $500.000 $0 $900.000 $0 $800.000 50 $300,000 $0 $500.000