| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | NOTE: This is a view only file. For personal use, click on 'File'>'Make a copy' to save to your device or Google drive. | |||||||
2 | ||||||||
3 |  | Home Buying Calculator | ||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | ||||||||
8 | ||||||||
9 | Section 1: Assess Your Income | |||||||
10 | Primary Job Income | 4000 | Instructions: Sections 1-3: Fill in your information in the highlighted cells Section 4: Enter your estimated closing costs (typically between 2% and %% of the total loan amount. Make sure you Housing Cost Percentage is between the recommended amount. Section 5: Enter your current savings. Closing costs will auto-populate based on Section 4. Enter the down payment percentage required by your type of loan or the amount you want to put down. | |||||
11 | Secondary Income | |||||||
12 | Other Income | |||||||
13 | Total Monthly Income | 4000 | ||||||
14 | Section 2: Calculate Your Monthly Expenses | |||||||
15 | Rent/Mortgage | |||||||
16 | Utilities | |||||||
17 | Transportation | |||||||
18 | Groceries | Section 4: Evaluate Affordability | ||||||
19 | Debt Payments | Housing Cost Percentage | 0 | |||||
20 | Subscriptions/Memberships | Recommended Housing Cost % | 28% - 30% | |||||
21 | Entertainment/Dining Out | Estimated Closing Costs | 5000 | |||||
22 | Other Expenses | Do you have enough savings for closing costs? | Yes | |||||
23 | Total Monthly Expenses | 0 | Section 5: Determine Available Savings | |||||
24 | Section 3: Estimate Monthly Housing Costs | Current Savings | $20,000.00 | |||||
25 | Mortgage Payment (Principal & Interest) | Estimated Closing Costs | $5,000.00 | |||||
26 | Property Taxes | Down Payment Percentage | 10% | |||||
27 | Homeowners Insurance | Maximum Home Price | $150,000.00 | |||||
28 | HOA Fees (if applicable) | Ideal Home Price Range | $135,000 - $165,000 | |||||
29 | Maintenance/Repairs | |||||||
30 | Total Monthly Housing Costs | 0 | ||||||