I need help with a and b.

PROJECT STEPS 1. Pranjali Kashyap is a financial analyst at Mount Moreland Hospital in Baltimore, Maryland. She is using an Excel workbook to analyze the financial data for a proposed program called Neighborhood Nurse. The program involves nurses and nurse practitioners providing healthcare services to Baltimore neighborhoods from a van outfitted with medical equipment and supplies. She asks for your help in correcting errors and making financial calculations in the workbook. Go to the Loan Payments worksheet. The hospital needs a loan to buy the medical van for the Neighborhood Nurse program. Before Pranjali can calculate the principal and interest payments on the loan, she asks you to correct the errors in the worksheet. Correct the first error as follows: a. b. In cell H17, use the Error Checking command to identify the error in the cell. Correct the error to total the values in the range C17:617. In a later step, you will calculate the interest and principal in the range C17:G18 to remove the remaining errors. Final Figure 1: Loan Payments Worksheet G H W C D E Mount Moreland Hospital - Neighborhood Nurse Van Loan Conditions and Payments Conditions Loon amount (pv) Annual interest rate Monthly interest rate (rate) Loan period in years Loan period in months (nper) Monthly payment Start date of loan Equipped Van $234.000 4.356 0.36% S 60 134.347) 1/4/2022 9 10 11 12 13 14 Annual Principal and Cumulative Interest Payments Year Year 2 1 13 Year 3 Year 4 Years 15 25 37 49 16 12 24 36 49 80 Total 17 18 19 interest Pencipal Principal remaining Remaining 5 ($9.332) ($42.826) $191,174 81.7% 157 431 ($44.727 $146,447 62.695 $546) (5.46 7123 $99.735 42.6 $3.37) ($48.785) $50.950 21.896 $ 1208) 1926.790 $50,950 $234 000) (50) 0.076 120 21 22 23 Documentation Loan Payments Depreciation Earnings projection Month Rew projections Investment PROJECT STEPS 1. Pranjali Kashyap is a financial analyst at Mount Moreland Hospital in Baltimore, Maryland. She is using an Excel workbook to analyze the financial data for a proposed program called Neighborhood Nurse. The program involves nurses and nurse practitioners providing healthcare services to Baltimore neighborhoods from a van outfitted with medical equipment and supplies. She asks for your help in correcting errors and making financial calculations in the workbook. Go to the Loan Payments worksheet. The hospital needs a loan to buy the medical van for the Neighborhood Nurse program. Before Pranjali can calculate the principal and interest payments on the loan, she asks you to correct the errors in the worksheet. Correct the first error as follows: a. b. In cell H17, use the Error Checking command to identify the error in the cell. Correct the error to total the values in the range C17:617. In a later step, you will calculate the interest and principal in the range C17:G18 to remove the remaining errors. Final Figure 1: Loan Payments Worksheet G H W C D E Mount Moreland Hospital - Neighborhood Nurse Van Loan Conditions and Payments Conditions Loon amount (pv) Annual interest rate Monthly interest rate (rate) Loan period in years Loan period in months (nper) Monthly payment Start date of loan Equipped Van $234.000 4.356 0.36% S 60 134.347) 1/4/2022 9 10 11 12 13 14 Annual Principal and Cumulative Interest Payments Year Year 2 1 13 Year 3 Year 4 Years 15 25 37 49 16 12 24 36 49 80 Total 17 18 19 interest Pencipal Principal remaining Remaining 5 ($9.332) ($42.826) $191,174 81.7% 157 431 ($44.727 $146,447 62.695 $546) (5.46 7123 $99.735 42.6 $3.37) ($48.785) $50.950 21.896 $ 1208) 1926.790 $50,950 $234 000) (50) 0.076 120 21 22 23 Documentation Loan Payments Depreciation Earnings projection Month Rew projections Investment