In: Finance
You want to buy a $252,000 home. You plan to pay 10% as a down
payment, and take out a 30 year loan for the rest.
a) How much is the loan amount going to be?
$
b) What will your monthly payments be if the interest rate is
6%?
$
c) What will your monthly payments be if the interest rate is
7%?
$
a) loan amount = house value*(1-downpayment %age) = 252000*(1-0.1) = 226800
b)
Monthly rate(M)= | yearly rate/12= | 0.50% | Monthly payment= | 1356.66 | |
Month | Beginning balance (A) | Monthly payment | Interest = M*A | Principal paid | Ending balance |
1 | 226800.00 | 1356.66 | 1134.00 | 222.66 | 226577.34 |
2 | 226577.34 | 1356.66 | 1132.89 | 223.77 | 226353.57 |
3 | 226353.57 | 1356.66 | 1131.77 | 224.89 | 226128.67 |
4 | 226128.67 | 1356.66 | 1130.64 | 226.02 | 225902.66 |
5 | 225902.66 | 1356.66 | 1129.51 | 227.15 | 225675.51 |
6 | 225675.51 | 1356.66 | 1128.38 | 228.28 | 225447.23 |
7 | 225447.23 | 1356.66 | 1127.24 | 229.42 | 225217.80 |
8 | 225217.80 | 1356.66 | 1126.09 | 230.57 | 224987.23 |
9 | 224987.23 | 1356.66 | 1124.94 | 231.72 | 224755.51 |
10 | 224755.51 | 1356.66 | 1123.78 | 232.88 | 224522.62 |
11 | 224522.62 | 1356.66 | 1122.61 | 234.05 | 224288.57 |
12 | 224288.57 | 1356.66 | 1121.44 | 235.22 | 224053.36 |
13 | 224053.36 | 1356.66 | 1120.27 | 236.39 | 223816.96 |
14 | 223816.96 | 1356.66 | 1119.08 | 237.58 | 223579.39 |
15 | 223579.39 | 1356.66 | 1117.90 | 238.76 | 223340.62 |
16 | 223340.62 | 1356.66 | 1116.70 | 239.96 | 223100.67 |
Where |
Interest paid = Beginning balance * Monthly interest rate |
Principal = Monthly payment – interest paid |
Ending balance = beginning balance – principal paid |
Beginning balance = previous Month ending balance c) |
Monthly rate(M)= | yearly rate/12= | 0.58% | Monthly payment= | 1505.16 | |
Month | Beginning balance (A) | Monthly payment | Interest = M*A | Principal paid | Ending balance |
1 | 226800.00 | 1505.16 | 1323.00 | 182.16 | 226617.84 |
2 | 226617.84 | 1505.16 | 1321.94 | 183.22 | 226434.62 |
3 | 226434.62 | 1505.16 | 1320.87 | 184.29 | 226250.34 |
4 | 226250.34 | 1505.16 | 1319.79 | 185.36 | 226064.97 |
5 | 226064.97 | 1505.16 | 1318.71 | 186.44 | 225878.53 |
6 | 225878.53 | 1505.16 | 1317.62 | 187.53 | 225690.99 |
7 | 225690.99 | 1505.16 | 1316.53 | 188.63 | 225502.37 |
8 | 225502.37 | 1505.16 | 1315.43 | 189.73 | 225312.64 |
9 | 225312.64 | 1505.16 | 1314.32 | 190.83 | 225121.81 |
10 | 225121.81 | 1505.16 | 1313.21 | 191.95 | 224929.86 |
11 | 224929.86 | 1505.16 | 1312.09 | 193.07 | 224736.80 |
12 | 224736.80 | 1505.16 | 1310.96 | 194.19 | 224542.60 |
13 | 224542.60 | 1505.16 | 1309.83 | 195.33 | 224347.28 |
14 | 224347.28 | 1505.16 | 1308.69 | 196.46 | 224150.81 |
15 | 224150.81 | 1505.16 | 1307.55 | 197.61 | 223953.20 |
16 | 223953.20 | 1505.16 | 1306.39 | 198.76 | 223754.44 |
17 | 223754.44 | 1505.16 | 1305.23 | 199.92 | 223554.52 |
18 | 223554.52 | 1505.16 | 1304.07 | 201.09 | 223353.43 |
19 | 223353.43 | 1505.16 | 1302.90 | 202.26 | 223151.17 |
Where |
Interest paid = Beginning balance * Monthly interest rate |
Principal = Monthly payment – interest paid |
Ending balance = beginning balance – principal paid |
Beginning balance = previous Month ending balance |