Part II - Mortgage Refinance Suppose your friend April is considering to refinan
ID: 2786306 • Letter: P
Question
Part II - Mortgage Refinance Suppose your friend April is considering to refinance her mortgage. She months ago at S 127,000. She paid cash to cover the 5% down payment plus all required closing costs (closing costs include application foe, appraisal fee, loan origination usually about 3%-5% of the loan amount). Since she had a decent credit history and relatively stable income, her mortgage rate was 5.25% for 30 years at the time of the purchase. Since down payment was less than 20% she had to pay monthly mortgage insurance premium which is $60 per month (premiums are automatically terminated when the LTV ratio (loan-to-value ratio falls below 80%). bought her house 60 fees and other costs, her Recently, mortgage rate has been dropping and she is considering to refinance her mortgage. She talked with a mortgage banker and got the following information: 3.75% 30 year conventional loan with out-of-pocket closing costs of S 1,800; b) a) 3.5% 30 year conventional loan with out-of-pocket closing costs of $3,000; c) 3.25% 30 year conventional loan with out-of-pocket closing costs of$4,000. Based on the recent appraisal, her house value has gone up to $151,000. Please advise her on the following: 1) Based on the information, please calculate her monthly mortgage payment on the original loan. Please show your process. 2) Please use online resources to show her amortization table. How much principle has she 3) 4) 5) paid off so far? How much interest has she paid over the past 60 payments? How much does she need to refinance now? Hint: You need to find her loan balance. Based on the new appraisal value, what is her LTV (loan-to-value) ratio now? Does she still need to pay the mortgage insurance premium after refinancing? Why? o) How much should her monthly payment be under each option (a, b, and e)? Show your 7) Would you suggest her to do the refinancing or not? Why? Notice that monthly payment calculations is reduced but she need to make 360 payments plus closing costs under the new mortgage versus 300 payments in the old mortgage. 8) Which option would you suget her kfs would affeet her choice and how?Explanation / Answer
Answer:
1)EMI for the month:$
Price of the house=127000
Payment made in cash is 5%=127000*0.05=6350
so .loan amount would be =127000-6350=120650
fees for closing all the cost includes assumed at 3% of total loan value=120650*0.03=3619
Monthly premium =60 per month since payment has been made below 20%=60*60=3600
So total loan amount would be = loan amount after making payment+ fees for closing loan+ Insurance premium
= 120650+3619.5+3600=127870
By using the formulae in the excel which is PMT function, we can calculate the number by punching the data in the format of PMT(Rate/12,nper(No of period), PV (present value of loan)
EMI =(5.25/12,480,127870)=706 for monthly payment for the total mortgage..
2. Principal and Interest amount for 60 periods can be calculated by using PPMT and IPMT function in the excel
EMI, Principal, and interest for 60 payments table below
Total principal repayment is in 60 period=10038 .41and interest payment is 3237.60= Total repayment of loan is equal to = Principal + Interest=42366.01
3) Total housing value amount after 60 periods to be paid is =170235.51 ie 127870-42366.01=170235.51
The total new refinance is required for 170235
4.New value is 151000
Loan is 127870 new appraised value is 151000
Loan to value ratio is =127870/151000=0.84=84%
5.No after appraisal of value there is no need to repay insurance premium since it has already crossed 80%. So if he refinances the loan the ratio cross 100% ie balanced amt/ appraised value=170235/151000=1.12% which is higher 80% so there is no need to pay premium.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 EMI -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 -706.10 Principal Part -146.67 -147.31 -147.96 -148.60 -149.25 -149.91 -150.56 -151.22 -151.88 -152.55 -153.22 -153.89 -154.56 -155.24 -155.91 -156.60 -157.28 -157.97 -158.66 -159.36 -160.05 -160.75 -161.46 -162.16 -162.87 -163.58 -164.30 -165.02 -165.74 -166.47 -167.19 -167.93 -168.66 -169.40 -170.14 -170.88 -171.63 -172.38 -173.14 -173.89 -174.65 -175.42 -176.19 -176.96 -177.73 -178.51 -179.29 -180.07 -180.86 -181.65 -182.45 -183.25 -184.05 -184.85 -185.66 -186.47 -187.29 -188.11 -188.93 -189.76 Interest part -559.43 -558.79 -558.14 -557.50 -556.85 -556.19 -555.54 -554.88 -554.22 -553.55 -552.88 -552.21 -551.54 -550.86 -550.19 -549.50 -548.82 -548.13 -547.44 -546.74 -546.05 -545.35 -544.64 -543.94 -543.23 -542.52 -541.80 -541.08 -540.36 -539.63 -538.91 -538.17 -537.44 -536.70 -535.96 -535.22 -534.47 -533.72 -532.96 -532.21 -531.45 -530.68 -529.91 -529.14 -528.37 -527.59 -526.81 -526.03 -525.24 -524.45 -523.65 -522.85 -522.05 -521.25 -520.44 -519.63 -518.81 -517.99 -517.17 -516.34