Financing Equation Worksheet
Financing Equation Worksheet
6.4
6.4
N = Years or Months | I = Annual Interest Rate | PV = Loan Amount | PMT = Monthly Payment
How to use:
Select what you want to solve for, leave that field blank, and complete the other required fields. Use each row Calc button or Calculate All Rows.
| # | Solve For | N | N Type | I % | PV | PMT | Result / Action |
|---|---|---|---|---|---|---|---|
| 1 |
—
|
||||||
| 2 |
—
|
||||||
| 3 |
—
|
||||||
| 4 |
—
|
||||||
| 5 |
—
|
||||||
| 6 |
—
|
||||||
| 7 |
—
|
||||||
| 8 |
—
|
||||||
| 9 |
—
|
||||||
| 10 |
—
|
||||||
| 11 |
—
|
||||||
| 12 |
—
|
||||||
| 13 |
—
|
||||||
| 14 |
—
|
||||||
| 15 |
—
|
||||||
| 16 |
—
|
||||||
| 17 |
—
|
||||||
| 18 |
—
|
||||||
| 19 |
—
|
||||||
| 20 |
—
|
||||||
| 21 |
—
|
||||||
| 22 |
—
|
Compact version: narrower columns and result/action controls combined so all fields fit better on WordPress pages.
Amortization Schedule
| Pmt # | Payment | Interest | Principal | Balance |
|---|