4. Calculate the cumulative principal payments as follows: a. In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year I (payment I in cell Cl5 through payment 12 in cell Cl6 ). Use O as the type argument in your formula because payments are made at the end of the period. b. Use absolute references for the rate, nper. and pvarguments, which are listed in the range D5:D11. c. Use relative references for the start and end arguments. d. Fil the range D18:G18 with the formula in cell Cl 18 to calculate the principal paid in Years 25 and the total nrincinat: X Create a formula using a function. in the toon Payments worksheef, the formula in cell Gl8 should contain the CUMPRINC tunction. X Copy a formula into a range. In the Loan Payments worksheel ceil c 18 contains on incorrect formula. Mount Moreland Hospial - Neighborhood Nurse Van Loan Conditions and Payments