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:

1. Calculate the cumulative principal payments as follows:
   1. In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year 1 (payment 1 in cell C15 through payment 12 in cell C16). Use 0 as the type argument in your formula because payments are made at the end of the period.
   2. Use absolute references for the rate, nper, and pv arguments, which are listed in the range D5:D11.
   3. Use relative references for the start and end arguments.
   4. Fill the range D18:G18 with the formula in cell C18 to calculate the principal paid in Years 25 and the total principal.