Calculate a periodic loan payment with consistent units
Fill E9:E11 separately. E9 is the signed unrounded payment for principal E2, nominal annual rate E3, total payment count E4, payment frequency E5 and timing E6. E10 is positive total scheduled outlay; E11 is positive total scheduled interest. The remaining balance is zero and fees are excluded.
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:E11 separately. E9 is the signed unrounded payment for principal E2, nominal annual rate E3, total payment count E4, payment frequency E5 and timing E6. E10 is positive total scheduled outlay; E11 is positive total scheduled interest. The remaining balance is zero and fees are excluded.
No account. No upload. Just try it.