a. In cell G10, enter a formula using the CUMPRINC function...
Calculate the cumulative principal payments as follows:
a. In cell G10, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year 1 (payment 1 in cell G7 through payment 12 in cell G8). Use 0 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 pv arguments, which are listed in the range D6:D12.
c. Use relative references for the start and end arguments.
d. Fill the range H10:K10 with the formula in cell G10 to calculate the principal paid in Years 2–5 and the total principal.
