Question

In: Finance

You want to buy a $252,000 home. You plan to pay 10% as a down payment,...

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%?

$

Solutions

Expert Solution

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

Related Solutions

You want to buy a home for $259,000. You plan to pay a 10% down payment,...
You want to buy a home for $259,000. You plan to pay a 10% down payment, and take out a 30 year loan for the rest. a. How much will the loan amount be? b. What will your monthly payments be if the interest rate is 5% C. what will your monthly payments be if the interest rate is 6%?
You want to buy a $188,000 home. You plan to pay 20% as a down payment,...
You want to buy a $188,000 home. You plan to pay 20% 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 5%? $ c) What will your monthly payments be if the interest rate is 6%? $
You want to buy a $198,000 home. You plan to pay 20% as a down payment,...
You want to buy a $198,000 home. You plan to pay 20% 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%? $
You want to buy a $201,000 home. You plan to pay 20% as a down payment,...
You want to buy a $201,000 home. You plan to pay 20% 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%?
You want to buy a $240,000 home. You plan to pay 20% as a down payment,...
You want to buy a $240,000 home. You plan to pay 20% 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%?
You want to buy a $197,000 home. You plan to pay 20% as a down payment,...
You want to buy a $197,000 home. You plan to pay 20% 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 5%? $ c) What will your monthly payments be if the interest rate is 6%? $
You want to buy a $202,000 home. You plan to pay 20% as a down payment,...
You want to buy a $202,000 home. You plan to pay 20% 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 5%? $ c) What will your monthly payments be if the interest rate is 6%? $
You want to buy a $249,000 home. You plan to pay 15% as a down payment, and take out a 30 year loan
You want to buy a $249,000 home. You plan to pay 15% 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 5%? $c) What will your monthly payments be if the interest rate is 6%?
2) You want to buy a house for $400,000 with 10% down payment. You take two...
2) You want to buy a house for $400,000 with 10% down payment. You take two mortgages to over the $360,000 needed to buy the house. They are: • Loan 1: Loan amount $160,000, fully amortizing 30-year fixed rate mortgage for 4.2%. This loan has 2 points and 1% pre-payment penalty. • Loan 2: Loan amount $200,000, fully amortizing 15-year, 5-year ARM with reset every five years. Initial interest rate is 3.6%. Margin set at 2% over prime rate. Expected...
You want to buy a house for $400,000 with 10% down payment.  You take two mortgages to...
You want to buy a house for $400,000 with 10% down payment.  You take two mortgages to over the $360,000 needed to buy the house.  They are: Loan 1: Loan amount $160,000, fully amortizing 30-year fixed rate mortgage for 4.2%.   This loan has 2 points and 1% pre-payment penalty.    Loan 2: Loan amount $200,000, fully amortizing 15-year, 5-year ARM with reset every five years. Initial interest rate is 3.6%.  Margin set at 2% over prime rate.  Expected prime rates: 4% at end of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT