Learn Calculations
Loan affordability worksheet.
Compare Conventional, FHA, VA, and USDA loan examples in one spreadsheet-style view. Enter the same row across each loan type, add debt rows as needed, and review front-end and back-end ratios below.
Mouse over each calculation to see the steps.
| Item | Conventional 28 / 36 | FHA 31 / 43 | VA N/A / 41 | USDA 29 / 41 |
|---|---|---|---|---|
| 1. Property And Payment | ||||
| House Price | ||||
| Down Payment |
|
|
|
|
| Loan Amount | ||||
| Interest Rate | ||||
| Period | ||||
| Monthly Tax | ||||
| Monthly Insurance | ||||
| 2. Income And Monthly Debts | ||||
| Monthly Income | ||||
| Add car payments, credit cards, student loans, or other recurring monthly debts. | ||||
| 3. Ratios And Affordability | ||||
| Front Ratio Amount | $0 | $0 | N/A | $0 |
| Back Ratio Amount | $0 | $0 | $0 | $0 |
| Back Ratio Housing Amount | $0 | $0 | $0 | $0 |
| Allowable Payment Amount | $0 | $0 | $0 | $0 |
| Current Payment | $0 | $0 | $0 | $0 |
| Max Loan From Ratios | $0 | $0 | $0 | $0 |
| Affordable? | Calculate | Calculate | Calculate | Calculate |