Financing Equation Worksheet
Financing Equation Worksheet
6.6.2
6.6.2
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 |
—
|
Compact version: narrower columns and result/action controls combined so all fields fit better on WordPress pages.
Amortization Schedule
| Pmt # | Payment | Interest | Principal | Balance |
|---|