Commercial Financing Calculator Suite
Core calculators for commercial financing analysis.
LTV Calculator
Result will appear here.
DSCR Calculator
Result will appear here.
Debt Yield Calculator
Result will appear here.
Cap Rate Calculator
Result will appear here.
Interest Only Calculator
Result will appear here.
Balloon Payment Calculator
Result will appear here.
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 |
|---|