 |
| Advanced | Simple | Early Payoff | Refinance | HELOC | Recast | Interest Only | Biweekly | Extra Payments | Free Widget |
I Make $30,000 a Year How Much House Can I Afford?
You can afford a $37,075.81 house with a monthly payment of $300.00.
Mortgage Calculator Results |
|
| Home Value: | $37,075.81 |
| Mortgage Amount: | $17,075.81 |
| Monthly Principal & Interest: | $91.67 |
| Monthly Property Tax: | $166.67 |
| Monthly Home Insurance: | $41.67 |
| Monthly Monthly PMI: | $100.00 |
| Monthly HOA Fees: | $0.00 |
Total Monthly Payment: |
$300.00 |
| Total # Of Payments: | 360 |
| Start Date: | 2022-01-01 |
| Payoff Date: | Dec, 2051 |
| Down Payment: | $20,000.00 |
| Principal: | $17,075.81 |
| Total Interest Paid: | $15,924.19 |
| Total Tax, Insurance & Fees: | $111,000.00 |
Total of all Payments: |
$164,000.00 |
Mortgage Amortization Schedule |
||||||
| Date | Payment # | Interest | Principal | Tax, Insurance & Fees | Total Payment | Balance |
|---|---|---|---|---|---|---|
| Jan, 2022 | 1 | $71.15 | $20.52 | $308.33 | $400.00 | $17,055.30 |
| Feb, 2022 | 2 | $71.06 | $20.60 | $308.33 | $400.00 | $17,034.69 |
| Mar, 2022 | 3 | $70.98 | $20.69 | $308.33 | $400.00 | $17,014.01 |
| Apr, 2022 | 4 | $70.89 | $20.77 | $308.33 | $400.00 | $16,993.23 |
| May, 2022 | 5 | $70.81 | $20.86 | $308.33 | $400.00 | $16,972.37 |
| Jun, 2022 | 6 | $70.72 | $20.95 | $308.33 | $400.00 | $16,951.42 |
| Jul, 2022 | 7 | $70.63 | $21.04 | $308.33 | $400.00 | $16,930.39 |
| Aug, 2022 | 8 | $70.54 | $21.12 | $308.33 | $400.00 | $16,909.26 |
| Sep, 2022 | 9 | $70.46 | $21.21 | $308.33 | $400.00 | $16,888.05 |
| Oct, 2022 | 10 | $70.37 | $21.30 | $308.33 | $400.00 | $16,866.75 |
| Nov, 2022 | 11 | $70.28 | $21.39 | $308.33 | $400.00 | $16,845.36 |
| Dec, 2022 | 12 | $70.19 | $21.48 | $308.33 | $400.00 | $16,823.88 |
| Jan, 2023 | 13 | $70.10 | $21.57 | $308.33 | $400.00 | $16,802.32 |
| Feb, 2023 | 14 | $70.01 | $21.66 | $308.33 | $400.00 | $16,780.66 |
| Mar, 2023 | 15 | $69.92 | $21.75 | $308.33 | $400.00 | $16,758.91 |
| Apr, 2023 | 16 | $69.83 | $21.84 | $308.33 | $400.00 | $16,737.07 |
| May, 2023 | 17 | $69.74 | $21.93 | $308.33 | $400.00 | $16,715.15 |
| Jun, 2023 | 18 | $69.65 | $22.02 | $308.33 | $400.00 | $16,693.13 |
| Jul, 2023 | 19 | $69.55 | $22.11 | $308.33 | $400.00 | $16,671.01 |
| Aug, 2023 | 20 | $69.46 | $22.20 | $308.33 | $400.00 | $16,648.81 |
| Sep, 2023 | 21 | $69.37 | $22.30 | $308.33 | $400.00 | $16,626.51 |
| Oct, 2023 | 22 | $69.28 | $22.39 | $308.33 | $400.00 | $16,604.12 |
| Nov, 2023 | 23 | $69.18 | $22.48 | $308.33 | $400.00 | $16,581.64 |
| Dec, 2023 | 24 | $69.09 | $22.58 | $308.33 | $400.00 | $16,559.06 |
| Jan, 2024 | 25 | $69.00 | $22.67 | $308.33 | $400.00 | $16,536.39 |
| Feb, 2024 | 26 | $68.90 | $22.77 | $308.33 | $400.00 | $16,513.63 |
| Mar, 2024 | 27 | $68.81 | $22.86 | $308.33 | $400.00 | $16,490.77 |
| Apr, 2024 | 28 | $68.71 | $22.96 | $308.33 | $400.00 | $16,467.81 |
| May, 2024 | 29 | $68.62 | $23.05 | $308.33 | $400.00 | $16,444.76 |
| Jun, 2024 | 30 | $68.52 | $23.15 | $308.33 | $400.00 | $16,421.62 |
| Jul, 2024 | 31 | $68.42 | $23.24 | $308.33 | $400.00 | $16,398.37 |
| Aug, 2024 | 32 | $68.33 | $23.34 | $308.33 | $400.00 | $16,375.03 |
| Sep, 2024 | 33 | $68.23 | $23.44 | $308.33 | $400.00 | $16,351.60 |
| Oct, 2024 | 34 | $68.13 | $23.54 | $308.33 | $400.00 | $16,328.06 |
| Nov, 2024 | 35 | $68.03 | $23.63 | $308.33 | $400.00 | $16,304.43 |
| Dec, 2024 | 36 | $67.94 | $23.73 | $308.33 | $400.00 | $16,280.70 |
| Jan, 2025 | 37 | $67.84 | $23.83 | $308.33 | $400.00 | $16,256.87 |
| Feb, 2025 | 38 | $67.74 | $23.93 | $308.33 | $400.00 | $16,232.94 |
| Mar, 2025 | 39 | $67.64 | $24.03 | $308.33 | $400.00 | $16,208.91 |
| Apr, 2025 | 40 | $67.54 | $24.13 | $308.33 | $400.00 | $16,184.78 |
| May, 2025 | 41 | $67.44 | $24.23 | $308.33 | $400.00 | $16,160.55 |
| Jun, 2025 | 42 | $67.34 | $24.33 | $308.33 | $400.00 | $16,136.22 |
| Jul, 2025 | 43 | $67.23 | $24.43 | $308.33 | $400.00 | $16,111.78 |
| Aug, 2025 | 44 | $67.13 | $24.53 | $308.33 | $400.00 | $16,087.25 |
| Sep, 2025 | 45 | $67.03 | $24.64 | $308.33 | $400.00 | $16,062.61 |
| Oct, 2025 | 46 | $66.93 | $24.74 | $308.33 | $400.00 | $16,037.87 |
| Nov, 2025 | 47 | $66.82 | $24.84 | $308.33 | $400.00 | $16,013.03 |
| Dec, 2025 | 48 | $66.72 | $24.95 | $308.33 | $400.00 | $15,988.09 |
| Jan, 2026 | 49 | $66.62 | $25.05 | $308.33 | $400.00 | $15,963.04 |
| Feb, 2026 | 50 | $66.51 | $25.15 | $308.33 | $400.00 | $15,937.88 |
| Mar, 2026 | 51 | $66.41 | $25.26 | $308.33 | $400.00 | $15,912.62 |
| Apr, 2026 | 52 | $66.30 | $25.36 | $308.33 | $400.00 | $15,887.26 |
| May, 2026 | 53 | $66.20 | $25.47 | $308.33 | $400.00 | $15,861.79 |
| Jun, 2026 | 54 | $66.09 | $25.58 | $308.33 | $400.00 | $15,836.21 |
| Jul, 2026 | 55 | $65.98 | $25.68 | $308.33 | $400.00 | $15,810.53 |
| Aug, 2026 | 56 | $65.88 | $25.79 | $308.33 | $400.00 | $15,784.74 |
| Sep, 2026 | 57 | $65.77 | $25.90 | $308.33 | $400.00 | $15,758.84 |
| Oct, 2026 | 58 | $65.66 | $26.00 | $308.33 | $400.00 | $15,732.84 |
| Nov, 2026 | 59 | $65.55 | $26.11 | $308.33 | $400.00 | $15,706.73 |
| Dec, 2026 | 60 | $65.44 | $26.22 | $308.33 | $400.00 | $15,680.50 |
| Jan, 2027 | 61 | $65.34 | $26.33 | $308.33 | $400.00 | $15,654.17 |
| Feb, 2027 | 62 | $65.23 | $26.44 | $308.33 | $400.00 | $15,627.73 |
| Mar, 2027 | 63 | $65.12 | $26.55 | $308.33 | $400.00 | $15,601.18 |
| Apr, 2027 | 64 | $65.00 | $26.66 | $308.33 | $400.00 | $15,574.52 |
| May, 2027 | 65 | $64.89 | $26.77 | $308.33 | $400.00 | $15,547.75 |
| Jun, 2027 | 66 | $64.78 | $26.88 | $308.33 | $400.00 | $15,520.86 |
| Jul, 2027 | 67 | $64.67 | $27.00 | $308.33 | $400.00 | $15,493.87 |
| Aug, 2027 | 68 | $64.56 | $27.11 | $308.33 | $400.00 | $15,466.76 |
| Sep, 2027 | 69 | $64.44 | $27.22 | $308.33 | $400.00 | $15,439.53 |
| Oct, 2027 | 70 | $64.33 | $27.34 | $308.33 | $400.00 | $15,412.20 |
| Nov, 2027 | 71 | $64.22 | $27.45 | $308.33 | $400.00 | $15,384.75 |
| Dec, 2027 | 72 | $64.10 | $27.56 | $308.33 | $400.00 | $15,357.19 |
| Jan, 2028 | 73 | $63.99 | $27.68 | $308.33 | $400.00 | $15,329.51 |
| Feb, 2028 | 74 | $63.87 | $27.79 | $308.33 | $400.00 | $15,301.71 |
| Mar, 2028 | 75 | $63.76 | $27.91 | $308.33 | $400.00 | $15,273.81 |
| Apr, 2028 | 76 | $63.64 | $28.03 | $308.33 | $400.00 | $15,245.78 |
| May, 2028 | 77 | $63.52 | $28.14 | $308.33 | $400.00 | $15,217.64 |
| Jun, 2028 | 78 | $63.41 | $28.26 | $308.33 | $400.00 | $15,189.38 |
| Jul, 2028 | 79 | $63.29 | $28.38 | $308.33 | $400.00 | $15,161.00 |
| Aug, 2028 | 80 | $63.17 | $28.50 | $308.33 | $400.00 | $15,132.50 |
| Sep, 2028 | 81 | $63.05 | $28.61 | $308.33 | $400.00 | $15,103.89 |
| Oct, 2028 | 82 | $62.93 | $28.73 | $308.33 | $400.00 | $15,075.16 |
| Nov, 2028 | 83 | $62.81 | $28.85 | $308.33 | $400.00 | $15,046.30 |
| Dec, 2028 | 84 | $62.69 | $28.97 | $308.33 | $400.00 | $15,017.33 |
| Jan, 2029 | 85 | $62.57 | $29.09 | $308.33 | $400.00 | $14,988.23 |
| Feb, 2029 | 86 | $62.45 | $29.22 | $308.33 | $400.00 | $14,959.02 |
| Mar, 2029 | 87 | $62.33 | $29.34 | $308.33 | $400.00 | $14,929.68 |
| Apr, 2029 | 88 | $62.21 | $29.46 | $308.33 | $400.00 | $14,900.22 |
| May, 2029 | 89 | $62.08 | $29.58 | $308.33 | $400.00 | $14,870.64 |
| Jun, 2029 | 90 | $61.96 | $29.71 | $308.33 | $400.00 | $14,840.93 |
| Jul, 2029 | 91 | $61.84 | $29.83 | $308.33 | $400.00 | $14,811.10 |
| Aug, 2029 | 92 | $61.71 | $29.95 | $308.33 | $400.00 | $14,781.15 |
| Sep, 2029 | 93 | $61.59 | $30.08 | $308.33 | $400.00 | $14,751.07 |
| Oct, 2029 | 94 | $61.46 | $30.20 | $308.33 | $400.00 | $14,720.87 |
| Nov, 2029 | 95 | $61.34 | $30.33 | $308.33 | $400.00 | $14,690.54 |
| Dec, 2029 | 96 | $61.21 | $30.46 | $308.33 | $400.00 | $14,660.08 |
| Jan, 2030 | 97 | $61.08 | $30.58 | $308.33 | $400.00 | $14,629.50 |
| Feb, 2030 | 98 | $60.96 | $30.71 | $308.33 | $400.00 | $14,598.79 |
| Mar, 2030 | 99 | $60.83 | $30.84 | $308.33 | $400.00 | $14,567.95 |
| Apr, 2030 | 100 | $60.70 | $30.97 | $308.33 | $400.00 | $14,536.98 |
| May, 2030 | 101 | $60.57 | $31.10 | $308.33 | $400.00 | $14,505.89 |
| Jun, 2030 | 102 | $60.44 | $31.23 | $308.33 | $400.00 | $14,474.66 |
| Jul, 2030 | 103 | $60.31 | $31.36 | $308.33 | $400.00 | $14,443.31 |
| Aug, 2030 | 104 | $60.18 | $31.49 | $308.33 | $400.00 | $14,411.82 |
| Sep, 2030 | 105 | $60.05 | $31.62 | $308.33 | $400.00 | $14,380.20 |
| Oct, 2030 | 106 | $59.92 | $31.75 | $308.33 | $400.00 | $14,348.45 |
| Nov, 2030 | 107 | $59.79 | $31.88 | $308.33 | $400.00 | $14,316.57 |
| Dec, 2030 | 108 | $59.65 | $32.01 | $308.33 | $400.00 | $14,284.56 |
| Jan, 2031 | 109 | $59.52 | $32.15 | $308.33 | $400.00 | $14,252.41 |
| Feb, 2031 | 110 | $59.39 | $32.28 | $308.33 | $400.00 | $14,220.13 |
| Mar, 2031 | 111 | $59.25 | $32.42 | $308.33 | $400.00 | $14,187.71 |
| Apr, 2031 | 112 | $59.12 | $32.55 | $308.33 | $400.00 | $14,155.16 |
| May, 2031 | 113 | $58.98 | $32.69 | $308.33 | $400.00 | $14,122.47 |
| Jun, 2031 | 114 | $58.84 | $32.82 | $308.33 | $400.00 | $14,089.65 |
| Jul, 2031 | 115 | $58.71 | $32.96 | $308.33 | $400.00 | $14,056.69 |
| Aug, 2031 | 116 | $58.57 | $33.10 | $308.33 | $400.00 | $14,023.59 |
| Sep, 2031 | 117 | $58.43 | $33.24 | $308.33 | $400.00 | $13,990.36 |
| Oct, 2031 | 118 | $58.29 | $33.37 | $308.33 | $400.00 | $13,956.99 |
| Nov, 2031 | 119 | $58.15 | $33.51 | $308.33 | $400.00 | $13,923.47 |
| Dec, 2031 | 120 | $58.01 | $33.65 | $308.33 | $400.00 | $13,889.82 |
| Jan, 2032 | 121 | $57.87 | $33.79 | $308.33 | $400.00 | $13,856.03 |
| Feb, 2032 | 122 | $57.73 | $33.93 | $308.33 | $400.00 | $13,822.09 |
| Mar, 2032 | 123 | $57.59 | $34.07 | $308.33 | $400.00 | $13,788.02 |
| Apr, 2032 | 124 | $57.45 | $34.22 | $308.33 | $400.00 | $13,753.80 |
| May, 2032 | 125 | $57.31 | $34.36 | $308.33 | $400.00 | $13,719.44 |
| Jun, 2032 | 126 | $57.16 | $34.50 | $308.33 | $400.00 | $13,684.94 |
| Jul, 2032 | 127 | $57.02 | $34.65 | $308.33 | $400.00 | $13,650.30 |
| Aug, 2032 | 128 | $56.88 | $34.79 | $308.33 | $400.00 | $13,615.51 |
| Sep, 2032 | 129 | $56.73 | $34.94 | $308.33 | $400.00 | $13,580.57 |
| Oct, 2032 | 130 | $56.59 | $35.08 | $308.33 | $400.00 | $13,545.49 |
| Nov, 2032 | 131 | $56.44 | $35.23 | $308.33 | $400.00 | $13,510.26 |
| Dec, 2032 | 132 | $56.29 | $35.37 | $308.33 | $400.00 | $13,474.89 |
| Jan, 2033 | 133 | $56.15 | $35.52 | $308.33 | $400.00 | $13,439.37 |
| Feb, 2033 | 134 | $56.00 | $35.67 | $308.33 | $400.00 | $13,403.70 |
| Mar, 2033 | 135 | $55.85 | $35.82 | $308.33 | $400.00 | $13,367.88 |
| Apr, 2033 | 136 | $55.70 | $35.97 | $308.33 | $400.00 | $13,331.91 |
| May, 2033 | 137 | $55.55 | $36.12 | $308.33 | $400.00 | $13,295.80 |
| Jun, 2033 | 138 | $55.40 | $36.27 | $308.33 | $400.00 | $13,259.53 |
| Jul, 2033 | 139 | $55.25 | $36.42 | $308.33 | $400.00 | $13,223.11 |
| Aug, 2033 | 140 | $55.10 | $36.57 | $308.33 | $400.00 | $13,186.54 |
| Sep, 2033 | 141 | $54.94 | $36.72 | $308.33 | $400.00 | $13,149.82 |
| Oct, 2033 | 142 | $54.79 | $36.88 | $308.33 | $400.00 | $13,112.94 |
| Nov, 2033 | 143 | $54.64 | $37.03 | $308.33 | $400.00 | $13,075.91 |
| Dec, 2033 | 144 | $54.48 | $37.18 | $308.33 | $400.00 | $13,038.73 |
| Jan, 2034 | 145 | $54.33 | $37.34 | $308.33 | $400.00 | $13,001.39 |
| Feb, 2034 | 146 | $54.17 | $37.49 | $308.33 | $400.00 | $12,963.89 |
| Mar, 2034 | 147 | $54.02 | $37.65 | $308.33 | $400.00 | $12,926.24 |
| Apr, 2034 | 148 | $53.86 | $37.81 | $308.33 | $400.00 | $12,888.44 |
| May, 2034 | 149 | $53.70 | $37.96 | $308.33 | $400.00 | $12,850.47 |
| Jun, 2034 | 150 | $53.54 | $38.12 | $308.33 | $400.00 | $12,812.35 |
| Jul, 2034 | 151 | $53.38 | $38.28 | $308.33 | $400.00 | $12,774.07 |
| Aug, 2034 | 152 | $53.23 | $38.44 | $308.33 | $400.00 | $12,735.63 |
| Sep, 2034 | 153 | $53.07 | $38.60 | $308.33 | $400.00 | $12,697.02 |
| Oct, 2034 | 154 | $52.90 | $38.76 | $308.33 | $400.00 | $12,658.26 |
| Nov, 2034 | 155 | $52.74 | $38.92 | $308.33 | $400.00 | $12,619.34 |
| Dec, 2034 | 156 | $52.58 | $39.09 | $308.33 | $400.00 | $12,580.25 |
| Jan, 2035 | 157 | $52.42 | $39.25 | $308.33 | $400.00 | $12,541.00 |
| Feb, 2035 | 158 | $52.25 | $39.41 | $308.33 | $400.00 | $12,501.59 |
| Mar, 2035 | 159 | $52.09 | $39.58 | $308.33 | $400.00 | $12,462.01 |
| Apr, 2035 | 160 | $51.93 | $39.74 | $308.33 | $400.00 | $12,422.27 |
| May, 2035 | 161 | $51.76 | $39.91 | $308.33 | $400.00 | $12,382.36 |
| Jun, 2035 | 162 | $51.59 | $40.07 | $308.33 | $400.00 | $12,342.29 |
| Jul, 2035 | 163 | $51.43 | $40.24 | $308.33 | $400.00 | $12,302.05 |
| Aug, 2035 | 164 | $51.26 | $40.41 | $308.33 | $400.00 | $12,261.64 |
| Sep, 2035 | 165 | $51.09 | $40.58 | $308.33 | $400.00 | $12,221.07 |
| Oct, 2035 | 166 | $50.92 | $40.75 | $308.33 | $400.00 | $12,180.32 |
| Nov, 2035 | 167 | $50.75 | $40.92 | $308.33 | $400.00 | $12,139.41 |
| Dec, 2035 | 168 | $50.58 | $41.09 | $308.33 | $400.00 | $12,098.32 |
| Jan, 2036 | 169 | $50.41 | $41.26 | $308.33 | $400.00 | $12,057.06 |
| Feb, 2036 | 170 | $50.24 | $41.43 | $308.33 | $400.00 | $12,015.63 |
| Mar, 2036 | 171 | $50.07 | $41.60 | $308.33 | $400.00 | $11,974.03 |
| Apr, 2036 | 172 | $49.89 | $41.77 | $308.33 | $400.00 | $11,932.26 |
| May, 2036 | 173 | $49.72 | $41.95 | $308.33 | $400.00 | $11,890.31 |
| Jun, 2036 | 174 | $49.54 | $42.12 | $308.33 | $400.00 | $11,848.18 |
| Jul, 2036 | 175 | $49.37 | $42.30 | $308.33 | $400.00 | $11,805.89 |
| Aug, 2036 | 176 | $49.19 | $42.48 | $308.33 | $400.00 | $11,763.41 |
| Sep, 2036 | 177 | $49.01 | $42.65 | $308.33 | $400.00 | $11,720.76 |
| Oct, 2036 | 178 | $48.84 | $42.83 | $308.33 | $400.00 | $11,677.93 |
| Nov, 2036 | 179 | $48.66 | $43.01 | $308.33 | $400.00 | $11,634.92 |
| Dec, 2036 | 180 | $48.48 | $43.19 | $308.33 | $400.00 | $11,591.73 |
| Jan, 2037 | 181 | $48.30 | $43.37 | $308.33 | $400.00 | $11,548.36 |
| Feb, 2037 | 182 | $48.12 | $43.55 | $308.33 | $400.00 | $11,504.81 |
| Mar, 2037 | 183 | $47.94 | $43.73 | $308.33 | $400.00 | $11,461.08 |
| Apr, 2037 | 184 | $47.75 | $43.91 | $308.33 | $400.00 | $11,417.17 |
| May, 2037 | 185 | $47.57 | $44.10 | $308.33 | $400.00 | $11,373.08 |
| Jun, 2037 | 186 | $47.39 | $44.28 | $308.33 | $400.00 | $11,328.80 |
| Jul, 2037 | 187 | $47.20 | $44.46 | $308.33 | $400.00 | $11,284.33 |
| Aug, 2037 | 188 | $47.02 | $44.65 | $308.33 | $400.00 | $11,239.69 |
| Sep, 2037 | 189 | $46.83 | $44.83 | $308.33 | $400.00 | $11,194.85 |
| Oct, 2037 | 190 | $46.65 | $45.02 | $308.33 | $400.00 | $11,149.83 |
| Nov, 2037 | 191 | $46.46 | $45.21 | $308.33 | $400.00 | $11,104.62 |
| Dec, 2037 | 192 | $46.27 | $45.40 | $308.33 | $400.00 | $11,059.22 |
| Jan, 2038 | 193 | $46.08 | $45.59 | $308.33 | $400.00 | $11,013.64 |
| Feb, 2038 | 194 | $45.89 | $45.78 | $308.33 | $400.00 | $10,967.86 |
| Mar, 2038 | 195 | $45.70 | $45.97 | $308.33 | $400.00 | $10,921.89 |
| Apr, 2038 | 196 | $45.51 | $46.16 | $308.33 | $400.00 | $10,875.73 |
| May, 2038 | 197 | $45.32 | $46.35 | $308.33 | $400.00 | $10,829.38 |
| Jun, 2038 | 198 | $45.12 | $46.54 | $308.33 | $400.00 | $10,782.84 |
| Jul, 2038 | 199 | $44.93 | $46.74 | $308.33 | $400.00 | $10,736.10 |
| Aug, 2038 | 200 | $44.73 | $46.93 | $308.33 | $400.00 | $10,689.17 |
| Sep, 2038 | 201 | $44.54 | $47.13 | $308.33 | $400.00 | $10,642.04 |
| Oct, 2038 | 202 | $44.34 | $47.32 | $308.33 | $400.00 | $10,594.71 |
| Nov, 2038 | 203 | $44.14 | $47.52 | $308.33 | $400.00 | $10,547.19 |
| Dec, 2038 | 204 | $43.95 | $47.72 | $308.33 | $400.00 | $10,499.47 |
| Jan, 2039 | 205 | $43.75 | $47.92 | $308.33 | $400.00 | $10,451.55 |
| Feb, 2039 | 206 | $43.55 | $48.12 | $308.33 | $400.00 | $10,403.44 |
| Mar, 2039 | 207 | $43.35 | $48.32 | $308.33 | $400.00 | $10,355.12 |
| Apr, 2039 | 208 | $43.15 | $48.52 | $308.33 | $400.00 | $10,306.60 |
| May, 2039 | 209 | $42.94 | $48.72 | $308.33 | $400.00 | $10,257.87 |
| Jun, 2039 | 210 | $42.74 | $48.93 | $308.33 | $400.00 | $10,208.95 |
| Jul, 2039 | 211 | $42.54 | $49.13 | $308.33 | $400.00 | $10,159.82 |
| Aug, 2039 | 212 | $42.33 | $49.33 | $308.33 | $400.00 | $10,110.48 |
| Sep, 2039 | 213 | $42.13 | $49.54 | $308.33 | $400.00 | $10,060.94 |
| Oct, 2039 | 214 | $41.92 | $49.75 | $308.33 | $400.00 | $10,011.20 |
| Nov, 2039 | 215 | $41.71 | $49.95 | $308.33 | $400.00 | $9,961.25 |
| Dec, 2039 | 216 | $41.51 | $50.16 | $308.33 | $400.00 | $9,911.08 |
| Jan, 2040 | 217 | $41.30 | $50.37 | $308.33 | $400.00 | $9,860.71 |
| Feb, 2040 | 218 | $41.09 | $50.58 | $308.33 | $400.00 | $9,810.13 |
| Mar, 2040 | 219 | $40.88 | $50.79 | $308.33 | $400.00 | $9,759.34 |
| Apr, 2040 | 220 | $40.66 | $51.00 | $308.33 | $400.00 | $9,708.34 |
| May, 2040 | 221 | $40.45 | $51.22 | $308.33 | $400.00 | $9,657.12 |
| Jun, 2040 | 222 | $40.24 | $51.43 | $308.33 | $400.00 | $9,605.70 |
| Jul, 2040 | 223 | $40.02 | $51.64 | $308.33 | $400.00 | $9,554.05 |
| Aug, 2040 | 224 | $39.81 | $51.86 | $308.33 | $400.00 | $9,502.19 |
| Sep, 2040 | 225 | $39.59 | $52.07 | $308.33 | $400.00 | $9,450.12 |
| Oct, 2040 | 226 | $39.38 | $52.29 | $308.33 | $400.00 | $9,397.83 |
| Nov, 2040 | 227 | $39.16 | $52.51 | $308.33 | $400.00 | $9,345.32 |
| Dec, 2040 | 228 | $38.94 | $52.73 | $308.33 | $400.00 | $9,292.59 |
| Jan, 2041 | 229 | $38.72 | $52.95 | $308.33 | $400.00 | $9,239.64 |
| Feb, 2041 | 230 | $38.50 | $53.17 | $308.33 | $400.00 | $9,186.48 |
| Mar, 2041 | 231 | $38.28 | $53.39 | $308.33 | $400.00 | $9,133.09 |
| Apr, 2041 | 232 | $38.05 | $53.61 | $308.33 | $400.00 | $9,079.47 |
| May, 2041 | 233 | $37.83 | $53.84 | $308.33 | $400.00 | $9,025.64 |
| Jun, 2041 | 234 | $37.61 | $54.06 | $308.33 | $400.00 | $8,971.58 |
| Jul, 2041 | 235 | $37.38 | $54.29 | $308.33 | $400.00 | $8,917.29 |
| Aug, 2041 | 236 | $37.16 | $54.51 | $308.33 | $400.00 | $8,862.78 |
| Sep, 2041 | 237 | $36.93 | $54.74 | $308.33 | $400.00 | $8,808.04 |
| Oct, 2041 | 238 | $36.70 | $54.97 | $308.33 | $400.00 | $8,753.08 |
| Nov, 2041 | 239 | $36.47 | $55.20 | $308.33 | $400.00 | $8,697.88 |
| Dec, 2041 | 240 | $36.24 | $55.43 | $308.33 | $400.00 | $8,642.46 |
| Jan, 2042 | 241 | $36.01 | $55.66 | $308.33 | $400.00 | $8,586.80 |
| Feb, 2042 | 242 | $35.78 | $55.89 | $308.33 | $400.00 | $8,530.91 |
| Mar, 2042 | 243 | $35.55 | $56.12 | $308.33 | $400.00 | $8,474.79 |
| Apr, 2042 | 244 | $35.31 | $56.36 | $308.33 | $400.00 | $8,418.44 |
| May, 2042 | 245 | $35.08 | $56.59 | $308.33 | $400.00 | $8,361.85 |
| Jun, 2042 | 246 | $34.84 | $56.83 | $308.33 | $400.00 | $8,305.02 |
| Jul, 2042 | 247 | $34.60 | $57.06 | $308.33 | $400.00 | $8,247.96 |
| Aug, 2042 | 248 | $34.37 | $57.30 | $308.33 | $400.00 | $8,190.66 |
| Sep, 2042 | 249 | $34.13 | $57.54 | $308.33 | $400.00 | $8,133.12 |
| Oct, 2042 | 250 | $33.89 | $57.78 | $308.33 | $400.00 | $8,075.34 |
| Nov, 2042 | 251 | $33.65 | $58.02 | $308.33 | $400.00 | $8,017.32 |
| Dec, 2042 | 252 | $33.41 | $58.26 | $308.33 | $400.00 | $7,959.06 |
| Jan, 2043 | 253 | $33.16 | $58.50 | $308.33 | $400.00 | $7,900.56 |
| Feb, 2043 | 254 | $32.92 | $58.75 | $308.33 | $400.00 | $7,841.81 |
| Mar, 2043 | 255 | $32.67 | $58.99 | $308.33 | $400.00 | $7,782.82 |
| Apr, 2043 | 256 | $32.43 | $59.24 | $308.33 | $400.00 | $7,723.58 |
| May, 2043 | 257 | $32.18 | $59.49 | $308.33 | $400.00 | $7,664.09 |
| Jun, 2043 | 258 | $31.93 | $59.73 | $308.33 | $400.00 | $7,604.36 |
| Jul, 2043 | 259 | $31.68 | $59.98 | $308.33 | $400.00 | $7,544.38 |
| Aug, 2043 | 260 | $31.43 | $60.23 | $308.33 | $400.00 | $7,484.15 |
| Sep, 2043 | 261 | $31.18 | $60.48 | $308.33 | $400.00 | $7,423.66 |
| Oct, 2043 | 262 | $30.93 | $60.73 | $308.33 | $400.00 | $7,362.93 |
| Nov, 2043 | 263 | $30.68 | $60.99 | $308.33 | $400.00 | $7,301.94 |
| Dec, 2043 | 264 | $30.42 | $61.24 | $308.33 | $400.00 | $7,240.70 |
| Jan, 2044 | 265 | $30.17 | $61.50 | $308.33 | $400.00 | $7,179.20 |
| Feb, 2044 | 266 | $29.91 | $61.75 | $308.33 | $400.00 | $7,117.45 |
| Mar, 2044 | 267 | $29.66 | $62.01 | $308.33 | $400.00 | $7,055.44 |
| Apr, 2044 | 268 | $29.40 | $62.27 | $308.33 | $400.00 | $6,993.17 |
| May, 2044 | 269 | $29.14 | $62.53 | $308.33 | $400.00 | $6,930.64 |
| Jun, 2044 | 270 | $28.88 | $62.79 | $308.33 | $400.00 | $6,867.85 |
| Jul, 2044 | 271 | $28.62 | $63.05 | $308.33 | $400.00 | $6,804.80 |
| Aug, 2044 | 272 | $28.35 | $63.31 | $308.33 | $400.00 | $6,741.49 |
| Sep, 2044 | 273 | $28.09 | $63.58 | $308.33 | $400.00 | $6,677.91 |
| Oct, 2044 | 274 | $27.82 | $63.84 | $308.33 | $400.00 | $6,614.07 |
| Nov, 2044 | 275 | $27.56 | $64.11 | $308.33 | $400.00 | $6,549.96 |
| Dec, 2044 | 276 | $27.29 | $64.38 | $308.33 | $400.00 | $6,485.58 |
| Jan, 2045 | 277 | $27.02 | $64.64 | $308.33 | $400.00 | $6,420.94 |
| Feb, 2045 | 278 | $26.75 | $64.91 | $308.33 | $400.00 | $6,356.03 |
| Mar, 2045 | 279 | $26.48 | $65.18 | $308.33 | $400.00 | $6,290.85 |
| Apr, 2045 | 280 | $26.21 | $65.45 | $308.33 | $400.00 | $6,225.39 |
| May, 2045 | 281 | $25.94 | $65.73 | $308.33 | $400.00 | $6,159.66 |
| Jun, 2045 | 282 | $25.67 | $66.00 | $308.33 | $400.00 | $6,093.66 |
| Jul, 2045 | 283 | $25.39 | $66.28 | $308.33 | $400.00 | $6,027.39 |
| Aug, 2045 | 284 | $25.11 | $66.55 | $308.33 | $400.00 | $5,960.83 |
| Sep, 2045 | 285 | $24.84 | $66.83 | $308.33 | $400.00 | $5,894.00 |
| Oct, 2045 | 286 | $24.56 | $67.11 | $308.33 | $400.00 | $5,826.89 |
| Nov, 2045 | 287 | $24.28 | $67.39 | $308.33 | $400.00 | $5,759.51 |
| Dec, 2045 | 288 | $24.00 | $67.67 | $308.33 | $400.00 | $5,691.84 |
| Jan, 2046 | 289 | $23.72 | $67.95 | $308.33 | $400.00 | $5,623.89 |
| Feb, 2046 | 290 | $23.43 | $68.23 | $308.33 | $400.00 | $5,555.65 |
| Mar, 2046 | 291 | $23.15 | $68.52 | $308.33 | $400.00 | $5,487.14 |
| Apr, 2046 | 292 | $22.86 | $68.80 | $308.33 | $400.00 | $5,418.33 |
| May, 2046 | 293 | $22.58 | $69.09 | $308.33 | $400.00 | $5,349.24 |
| Jun, 2046 | 294 | $22.29 | $69.38 | $308.33 | $400.00 | $5,279.86 |
| Jul, 2046 | 295 | $22.00 | $69.67 | $308.33 | $400.00 | $5,210.20 |
| Aug, 2046 | 296 | $21.71 | $69.96 | $308.33 | $400.00 | $5,140.24 |
| Sep, 2046 | 297 | $21.42 | $70.25 | $308.33 | $400.00 | $5,069.99 |
| Oct, 2046 | 298 | $21.12 | $70.54 | $308.33 | $400.00 | $4,999.45 |
| Nov, 2046 | 299 | $20.83 | $70.84 | $308.33 | $400.00 | $4,928.61 |
| Dec, 2046 | 300 | $20.54 | $71.13 | $308.33 | $400.00 | $4,857.48 |
| Jan, 2047 | 301 | $20.24 | $71.43 | $308.33 | $400.00 | $4,786.05 |
| Feb, 2047 | 302 | $19.94 | $71.72 | $308.33 | $400.00 | $4,714.33 |
| Mar, 2047 | 303 | $19.64 | $72.02 | $308.33 | $400.00 | $4,642.31 |
| Apr, 2047 | 304 | $19.34 | $72.32 | $308.33 | $400.00 | $4,569.98 |
| May, 2047 | 305 | $19.04 | $72.63 | $308.33 | $400.00 | $4,497.36 |
| Jun, 2047 | 306 | $18.74 | $72.93 | $308.33 | $400.00 | $4,424.43 |
| Jul, 2047 | 307 | $18.44 | $73.23 | $308.33 | $400.00 | $4,351.20 |
| Aug, 2047 | 308 | $18.13 | $73.54 | $308.33 | $400.00 | $4,277.66 |
| Sep, 2047 | 309 | $17.82 | $73.84 | $308.33 | $400.00 | $4,203.82 |
| Oct, 2047 | 310 | $17.52 | $74.15 | $308.33 | $400.00 | $4,129.67 |
| Nov, 2047 | 311 | $17.21 | $74.46 | $308.33 | $400.00 | $4,055.21 |
| Dec, 2047 | 312 | $16.90 | $74.77 | $308.33 | $400.00 | $3,980.44 |
| Jan, 2048 | 313 | $16.59 | $75.08 | $308.33 | $400.00 | $3,905.36 |
| Feb, 2048 | 314 | $16.27 | $75.39 | $308.33 | $400.00 | $3,829.96 |
| Mar, 2048 | 315 | $15.96 | $75.71 | $308.33 | $400.00 | $3,754.25 |
| Apr, 2048 | 316 | $15.64 | $76.02 | $308.33 | $400.00 | $3,678.23 |
| May, 2048 | 317 | $15.33 | $76.34 | $308.33 | $400.00 | $3,601.89 |
| Jun, 2048 | 318 | $15.01 | $76.66 | $308.33 | $400.00 | $3,525.23 |
| Jul, 2048 | 319 | $14.69 | $76.98 | $308.33 | $400.00 | $3,448.25 |
| Aug, 2048 | 320 | $14.37 | $77.30 | $308.33 | $400.00 | $3,370.95 |
| Sep, 2048 | 321 | $14.05 | $77.62 | $308.33 | $400.00 | $3,293.33 |
| Oct, 2048 | 322 | $13.72 | $77.94 | $308.33 | $400.00 | $3,215.39 |
| Nov, 2048 | 323 | $13.40 | $78.27 | $308.33 | $400.00 | $3,137.12 |
| Dec, 2048 | 324 | $13.07 | $78.60 | $308.33 | $400.00 | $3,058.52 |
| Jan, 2049 | 325 | $12.74 | $78.92 | $308.33 | $400.00 | $2,979.60 |
| Feb, 2049 | 326 | $12.41 | $79.25 | $308.33 | $400.00 | $2,900.35 |
| Mar, 2049 | 327 | $12.08 | $79.58 | $308.33 | $400.00 | $2,820.77 |
| Apr, 2049 | 328 | $11.75 | $79.91 | $308.33 | $400.00 | $2,740.85 |
| May, 2049 | 329 | $11.42 | $80.25 | $308.33 | $400.00 | $2,660.61 |
| Jun, 2049 | 330 | $11.09 | $80.58 | $308.33 | $400.00 | $2,580.03 |
| Jul, 2049 | 331 | $10.75 | $80.92 | $308.33 | $400.00 | $2,499.11 |
| Aug, 2049 | 332 | $10.41 | $81.25 | $308.33 | $400.00 | $2,417.86 |
| Sep, 2049 | 333 | $10.07 | $81.59 | $308.33 | $400.00 | $2,336.26 |
| Oct, 2049 | 334 | $9.73 | $81.93 | $308.33 | $400.00 | $2,254.33 |
| Nov, 2049 | 335 | $9.39 | $82.27 | $308.33 | $400.00 | $2,172.06 |
| Dec, 2049 | 336 | $9.05 | $82.62 | $308.33 | $400.00 | $2,089.44 |
| Jan, 2050 | 337 | $8.71 | $82.96 | $308.33 | $400.00 | $2,006.48 |
| Feb, 2050 | 338 | $8.36 | $83.31 | $308.33 | $400.00 | $1,923.17 |
| Mar, 2050 | 339 | $8.01 | $83.65 | $308.33 | $400.00 | $1,839.52 |
| Apr, 2050 | 340 | $7.66 | $84.00 | $308.33 | $400.00 | $1,755.52 |
| May, 2050 | 341 | $7.31 | $84.35 | $308.33 | $400.00 | $1,671.17 |
| Jun, 2050 | 342 | $6.96 | $84.70 | $308.33 | $400.00 | $1,586.46 |
| Jul, 2050 | 343 | $6.61 | $85.06 | $308.33 | $400.00 | $1,501.41 |
| Aug, 2050 | 344 | $6.26 | $85.41 | $308.33 | $400.00 | $1,416.00 |
| Sep, 2050 | 345 | $5.90 | $85.77 | $308.33 | $400.00 | $1,330.23 |
| Oct, 2050 | 346 | $5.54 | $86.12 | $308.33 | $400.00 | $1,244.10 |
| Nov, 2050 | 347 | $5.18 | $86.48 | $308.33 | $400.00 | $1,157.62 |
| Dec, 2050 | 348 | $4.82 | $86.84 | $308.33 | $400.00 | $1,070.78 |
| Jan, 2051 | 349 | $4.46 | $87.21 | $308.33 | $400.00 | $983.57 |
| Feb, 2051 | 350 | $4.10 | $87.57 | $308.33 | $400.00 | $896.01 |
| Mar, 2051 | 351 | $3.73 | $87.93 | $308.33 | $400.00 | $808.07 |
| Apr, 2051 | 352 | $3.37 | $88.30 | $308.33 | $400.00 | $719.77 |
| May, 2051 | 353 | $3.00 | $88.67 | $308.33 | $400.00 | $631.10 |
| Jun, 2051 | 354 | $2.63 | $89.04 | $308.33 | $400.00 | $542.07 |
| Jul, 2051 | 355 | $2.26 | $89.41 | $308.33 | $400.00 | $452.66 |
| Aug, 2051 | 356 | $1.89 | $89.78 | $308.33 | $400.00 | $362.88 |
| Sep, 2051 | 357 | $1.51 | $90.15 | $308.33 | $400.00 | $272.72 |
| Oct, 2051 | 358 | $1.14 | $90.53 | $308.33 | $400.00 | $182.19 |
| Nov, 2051 | 359 | $0.76 | $90.91 | $308.33 | $400.00 | $91.29 |
| Dec, 2051 | 360 | $0.38 | $91.29 | $308.33 | $400.00 | $0.00 |
Estimate how much house you can afford if you make $30,000 a year with our home affordability calculator. Generate an amortization schedule that will give you a breakdown of each monthly payment, and a summary of the total interest, principal paid, and payments at payoff. You have the options to include property tax, insurance, and HOA fees into your calculation.
I Make $30,000 a Year How Much Home Can I Afford?
The home affordability calculator will give you a rough estimation of how much home can I afford if I make $30,000 a year. As a general rule, to find out how much house you can afford, multiply your annual gross income by a factor of 2.5 - 4. If you make $30,000 per year, you can afford a house anywhere from $75,000 to $120,000.
The 28/36 Rule
You can also use the 28% - 36% rule to calculate how much you can afford to pay each month on mortgage payments. The 28% rule states that you should never spend 28% of your gross monthly income on mortgage payments. If you make $30,000, your monthly income would be $2,500.00, and 28% of $2,500.00 is $700.00. The 28% rule states that one should not make mortgage payments of more than $2,333. The 36% rule is the debt ratio of all of your debts including mortgage payments. It states that all your debt added together should not exceed 36% of your gross monthly income.
How much mortgage can I get?
Keep in mind, there are many other variables that may affect how much you can borrow from the bank and how much you can repay each month, which in turn impacts how much house you can buy.
- Down Payment - First of all, how much is your down payment? If you have saved a large amount of money and are planning to make a big down payment, you will be able to afford a nicer house than someone with a small down payment.
- Monthly Debt - Do you have any monthly debt such as your car loan, payment for child support, credit card debts, and so on.
- Annual Income - Obviously the more you make, the larger the mortgage you can apply. Banks will decide how much loan you qualify for based on your income.
- Credit Score - Your credit score determines the interest rate that you will be getting from the bank. The higher your credit score is, the lower the interest rate that you will expect to get. If you have a bad credit score, some banks might not take your business. Even if you do get a mortgage, you will probably need to pay a much higher interest rate than someone with a good credit score.
- Interest Rate - The interest rate determines how much you will be paying back to the bank each month. If your interest rate is high, you will need to pay a higher monthly payment which means you will have to buy a cheaper house.
- Mortgage Terms - Another variable that affects how much mortgage you can afford is the term. If you plan to apply for a 15-year term, you will have to buy a smaller house than if you were to get a 30-year term.
- Closing Costs - In addition to a down payment, and the monthly mortgage payments, you will also need to pay for closing costs. Closing costs vary from state to state, and lender to lender, it could be anywhere from 1.5% - 4% of the house price. Do you have money set aside for closing costs?
- Private Mortgage Insurance - If your down payment is less than 20%, banks will require you to pay for PMI, which is monthly mortgage insurance that you need to pay on top of your mortgage payments.
- Property Tax and Home Insurance - Each quarter, you need to pay for property tax, and pay home insurance each year.
- Home Repairs & Maintenance - Is the house that you like in good condition or do you have to spend extra money for renovation. There are also the costs of owning a house such as home repairs and maintenance that you need after you purchase a home.
Buy what you can afford
There are other considerations that you may need to take into account such as the cost of living. The cost of living varies state by state, if you buy a house, do you need to cut costs on your other expenses, such as eating out? The most important thing to remember is to buy what you can afford as costs can add up quickly. If you are not sure what kind of house you can afford, always take the conservative route and buy a house that you are 100% sure that you can afford. Every family is different, it is hard to calculate exactly how much you can afford based on your income. However, you can use our home affordability calculator to get a general sense of what kind of house you can afford.
I make $30,500 a year how much house can I affordI make $31,000 a year how much house can I afford
I make $31,500 a year how much house can I afford
I make $32,000 a year how much house can I afford
I make $32,500 a year how much house can I afford
I make $33,000 a year how much house can I afford
I make $33,500 a year how much house can I afford
I make $34,000 a year how much house can I afford
I make $34,500 a year how much house can I afford
I make $35,000 a year how much house can I afford
I make $35,500 a year how much house can I afford
I make $36,000 a year how much house can I afford
I make $36,500 a year how much house can I afford
I make $37,000 a year how much house can I afford
I make $37,500 a year how much house can I afford
I make $38,000 a year how much house can I afford
I make $38,500 a year how much house can I afford
I make $39,000 a year how much house can I afford
I make $39,500 a year how much house can I afford
I make $35,000 a year how much house can I afford
Refinance Calculators
Mortgage Refinance CalculatorCash Out Refinance Calculator
Refinance Break Even Calculator
Mortgage Recast Calculator
Mortgage Calculators
FHA Loan CalculatorVA Loan Calculator
USDA Loan Mortgage Calculator
Simple Mortgage Calculator
PITI Mortgage Calculator
Interest Only Mortgage Calculator
Balloon Mortgage Calculator
Early Mortgage Payoff Calculators
Early Mortgage Payoff CalculatorBiweekly Mortgage Calculator with Extra Payments
Mortgage Calculator With Extra Payments
Mortgage Prepayment Calculator
Mortgage Payoff Calculator
Real Estate Investment Calculators
Commercial Mortgage CalculatorMortgage Comparison Calculator
Investment Property Calculator
Home Improvement Loan Calculator
Home Sale Net Proceeds Calculator
Closing Costs Calculator
Construction Loan Calculator
Home Appreciation Calculator
Real Estate Commission Calculator
Commercial Real Estate Commission Calculator
BRRRR Calculator
Hard Money Loan Calculator
70% Rule Calculator
Interest Rate Calculator
Mortgage Related Calculators
Mortgage Interest Tax Deduction CalculatorAPR Calculator
Property Tax Calculator
Down Payment Calculator
Mortgage Affordability Calculator
Mortgage Balance Calculator
Mortgage Points Calculator
Mortgage Calculator App
Monthly Mortgage Payment Calculator
Reverse Mortgage Calculator
How Much House Can I Afford
HELOC Calculator
HELOC Payoff Calculator
HELOC Payment Calculator
PMI Removal Calculator
Mortgage Insurance Calculator
Amortization Schedule With Irregular Payments
15 Year Mortgage Calculator
30 Year Mortgage Calculator
Condo Mortgage Calculator
Second Mortgage Calculator
Mortgage Calculator Canada
Mortgage Calculator UK
Mortgage Calculator By State
Auto Loan Calculators
Car Loan Amortization Schedule ExcelAuto Loan Payoff Calculator
Auto Loan Calculator with Trade in
Auto Refinance Calculator
RV Loan Calculator
Motorcycle Loan Calculator
Car Lease Calculator
Car Depreciation Calculator
LTV Calculator Auto
Reverse Auto Loan Calculator
How Much Car Can I Afford
Loan Calculators
Printable Amortization ScheduleAmortization Schedule Excel
Amortization Schedule With Extra Payments
LTV Calculator
Debt To Income Ratio Calculator
Debt Payoff Calculator
How Much Rent Can I Afford
Boat Loan Calculator
Student Loan Calculator
Student Loan Payoff Calculator
Student Loan Refinancing Calculator
Personal Loan Calculator
Personal Loan Payoff Calculator
Personal Loan Refinance Calculator
Land Loan Calculator
Loan Payoff Calculator
Loan Calculator Excel
Reverse Loan Calculator
Lump Sum Payment Calculator
Savings & Investments Calculators
Compound Interest CalculatorAirbnb Calculator
Credit Card Calculators
Credit Card CalculatorCredit Card Payoff Calculator
Credit Card Minimum Payment Calculator
Credit Card Interest Calculator
Multiple Credit Card Payoff Calculator
Mortgage Guide
How to Pay Off Mortgage EarlierHow to Improve Credit Score
What Percent Do Real Estate Agents Make
Mortgage Calculator Widget
Free Mortgage Calculator WidgetMortgage Calculator | Terms | Privacy | Disclaimer | Contact
©2022 Mortgage Calculator Excel