15. Go to the Equipment Loan worksheet, which contains details about a loan the company used for computer network equipment. 16. The worksheet contains two errors. Make sure Excel is set to check all types of errors, and then resolve the ones on the Equipment Loan worksheet as follows: a. b. Display the possible errors and solutions for cell C2, and then select convert to number. Trace the precedents to the formula in cell 19, which should multiply the scheduled payment amount by the number of scheduled payments. Correct the error. Draw attention to the optional extra payments in the range C10:E10 by adding a thick outside border using the Orange, Accent 3 shape outline color. Aa Themes Colors A Fonts Effects Themes LoanAmo... Width: 1 page Height: Automatic Margins Orientation Size Print Breaks Background Print Area Titles Page Setup 5 Scale: 79% Scale to Fit 5 Gridlines Headings View View Bring Print Print Forward Send Backward Sheet Options 5 fx 15000 D E F G H Selection Align Group Rotate Pane Arrange 1 A B C Equipment Loan J K L 2 Year: 2020 3 Loan Details 4 Loan amount $15,000.00 5 Annual interest rate 4.15% Scheduled payment Scheduled number of payments 6 Loan period in years 1 Actual number of payments 7 Number of payments per year 12 Total early payments 8 Start date of loan 2/26/2020 Total interest 9 Total paid Loan Summary $1,278.28 12 12 $1,100.00 $316.23 #VALUE! 10 Optional extra payments $100.00 11 Pmt No Payment Date Beg Balance Payment Amt Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest 12 13 1 2/26/2020 $15,000.00 $1,278.28 $100.00 $1,378.28 $1,326.40 $51.88 $13,673.60 $51.88 14 2 3/26/2020 $13,673.60 $1,278.28 $100.00 $1,378.28 $1,330.99 $47.29 $12,342.61 $99.16 15 3 4/26/2020 $12,342.61 $1,278.28 $100.00 $1,378.28 $1,335.59 $42.68 $11,007.02 $141.85 16 4 5/26/2020 $11,007.02 $1,278.28 $100.00 $1,378.28 $1,340.21 $38.07 $9,666.81 $179.91 17 5 6/26/2020 $9,666.81 $1,278.28 $100.00 $1,378.28 $1,344.85 $33.43 $8,321.96 $213.34 18 6 7/26/2020 $8,321.96 $1,278.28 $100.00 $1,378.28 $1,349.50 $28.78 $6,972.46 $242.12 19 7 8/26/2020 $6,972.46 $1,278.28 $100.00 $1,378.28 $1,354.16 $24.11 $5,618.30 $266.24 20 8 9/26/2020 $5,618.30 $1,278.28 $100.00 $1,378.28 $1,358.85 $19.43 $4,259.45 $285.67 21 9 10/26/2020 $4,259.45 $1,278.28 $100.00 $1,378.28 $1,363.55 $14.73 $2,895.91 $300.40 22 10 11/26/2020 $2,895.91 $1,278.28 $100.00 $1,378.28 $1,368.26 $10.02 $1,527.65 $310.41 23 11 12/26/2020 $1,527.65 $1,278.28 $100.00 $1,378.28 $1,372.99 $5.28 $154.65 $315.70 24 12 1/26/2021 $154.65 $1,278.28 $0.00 $154.65 $154.12 $0.53 $0.00 $316.23 25 26 27 Ending Balance and Cumulative Interest 28 $16,000.00 $350.00 29 $14,000.00 30 31 $12,000.00 32 $10,000.00 33 34 $8,000.00 35 $6,000.00 36 $4,000.00 37 38 $2,000.00 $300.00 $250.00 $200.00 Ending Balance $150.00 -Cumulative Interest $100.00 $50.00 39 $0.00 $0.00 40 2/2020 3/2020 4/2020 5/2020 6/2020 7/2020 8/2020 9/2020 10/2020 11/2020 12/2020 1/2021 41 42 43 44 45 46 47 48 49