Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Split a selected loan payment into interest and principal

Your goal: Inspect one end-of-period payment and prove that its signed components add to the fixed payment.

Full task requirements

Fill E9:E12 separately for an end-of-period schedule (E6 must be 0). Use E7 as the selected one-based payment number. E9 is the signed payment, E10 its signed interest, E11 its signed principal and E12 the reconciliation residual E9-E10-E11, which should be zero.

First monthly paymentMatch the rate to each payment0 cells selected
Column E holds the model values beside their D labels. E4 is total payments; E5 is payments per year. Calculated results appear after your formulas pass.
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
Step 1 of 5

Match the rate to each payment

Select the source cells in the worksheet, then complete the choices below.

Rules for this step

Select the annual nominal rate and payments-per-year input. PMT, FV, IPMT and PPMT use the rate for one payment period.

0 cells selected