Split a selected loan payment into interest and principal
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.