Calculate a periodic loan payment with consistent units
Your goal: Build a signed fixed-payment model, then reconcile total outlay with the amount borrowed.
Full 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.
Monthly end paymentsMatch the rate to each payment
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.
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Step 1 of 4
Match the rate to each payment
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.