14. Hide the Properties worksheet, which contains data Liam wants to keep private. 15. Go to the Equipment Loan worksheet, which contains details about a loan the company used for computer network equipment. 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: Display the possible errors and solutions for cell C2, and then select convert to number. b. 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. 16. 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. nal Figure 1: Loan Calculator Worksheet Date 5. S. LO Loan Am Amate Interest Rate La Priyan Loan ere the Startete Future 13.000 0.000 New Office Building Loan Calculator 9/15/2021 Rate Property Charles Street Temahe $1,650,000 Monthly Payment 2014. > Down Payment 5 230,000 Total $ 0.1 Lanmount 5 220.000 Total Com $1.601.23 10 vary tem 11 Rate 7,014 130 11 11 2.5 4.7.10 14 4.00 MOS 6.12.20 5.50 15 4.15 10 S. 90435 5 6.220.63 3. 17 4,75 515 8.35 TOSOS 4.59 9.9.25 7.14 5.1.23 20 2015 7.10 $ WS 7,165 . 9.00 TIS 7.2016 5,995.00 9,73956 7.2305 20 5.09 2.780.93 7.29.295 . 5.11 22 2. L WAT 5 cos 5 5 CWS W V nal Figure 2: Equipment Loan Worksheet Equipment Loan med Ware Number of www Most Wantes et tar S. SU S S St. UMS, ni. Su . www.ee . SSSSSEMESO SE SA 13.46 SUR SA SUS 30 S SUM 5. # 11 . 8 D E F G H New Office Building Z 3 4 Date 5 Property 6 Price 7 Down Payment Loan Amount 4.45% 180 Loan Payment Calculator 9/15/2021 Rate Charles Street Term Months 5 1,150,000 Monthly Payment S 230,000 Total Interest 92000 Total Cost Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation $1,020,000 4.45% 0.37% 15 180 1/3/2022 20 Years 5 4.25% 0.35% 20 240 1/3/2022 $ (6,000) $ n/a 8 Years 920.000 4.45% 0.37% 8 96 1/3/2022 (8,000) Rate Varying Interest Rates and Terms Number of Months 120 180 n/a 240 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 3.95% 4.05% 4.15% 4.25% 4.35% 4.45% 4,55% 4.654 4.75 4.85% 4.95% 5.05% 5.15% 14. Hide the Properties worksheet, which contains data Liam wants to keep private. 15. Go to the Equipment Loan worksheet, which contains details about a loan the company used for computer network equipment. 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: Display the possible errors and solutions for cell C2, and then select convert to number. b. 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. 16. 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. nal Figure 1: Loan Calculator Worksheet Date 5. S. LO Loan Am Amate Interest Rate La Priyan Loan ere the Startete Future 13.000 0.000 New Office Building Loan Calculator 9/15/2021 Rate Property Charles Street Temahe $1,650,000 Monthly Payment 2014. > Down Payment 5 230,000 Total $ 0.1 Lanmount 5 220.000 Total Com $1.601.23 10 vary tem 11 Rate 7,014 130 11 11 2.5 4.7.10 14 4.00 MOS 6.12.20 5.50 15 4.15 10 S. 90435 5 6.220.63 3. 17 4,75 515 8.35 TOSOS 4.59 9.9.25 7.14 5.1.23 20 2015 7.10 $ WS 7,165 . 9.00 TIS 7.2016 5,995.00 9,73956 7.2305 20 5.09 2.780.93 7.29.295 . 5.11 22 2. L WAT 5 cos 5 5 CWS W V nal Figure 2: Equipment Loan Worksheet Equipment Loan med Ware Number of www Most Wantes et tar S. SU S S St. UMS, ni. Su . www.ee . SSSSSEMESO SE SA 13.46 SUR SA SUS 30 S SUM 5. # 11 . 8 D E F G H New Office Building Z 3 4 Date 5 Property 6 Price 7 Down Payment Loan Amount 4.45% 180 Loan Payment Calculator 9/15/2021 Rate Charles Street Term Months 5 1,150,000 Monthly Payment S 230,000 Total Interest 92000 Total Cost Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation $1,020,000 4.45% 0.37% 15 180 1/3/2022 20 Years 5 4.25% 0.35% 20 240 1/3/2022 $ (6,000) $ n/a 8 Years 920.000 4.45% 0.37% 8 96 1/3/2022 (8,000) Rate Varying Interest Rates and Terms Number of Months 120 180 n/a 240 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 3.95% 4.05% 4.15% 4.25% 4.35% 4.45% 4,55% 4.654 4.75 4.85% 4.95% 5.05% 5.15%