Question

In: Finance

If John wants to purchase a new home for $300,000 and finance $220,000 with either a...

If John wants to purchase a new home for $300,000 and finance $220,000 with either a 4.%, 30- year mortgage or a 3.5%, 15-year mortgage. a. What is the monthly payment on each of the above alternatives? b. How much interest would be paid in the first 12 payments for each of the above alternatives? c. What would the loan balance be after 10 years for each of the above alternatives?

Solutions

Expert Solution

Loan amount L=220000

Option A: 4% ,30 Years

Interest rate =4%

Monthly interest rate r=4%/12=0.33%

Number of years =30

Number of Payments N=30*12=360

Payment per month P=L*r/(1-(1+r)^-N) =220000*0.33%/(1-(1+0.33%)^-360)

P=$1050.31

Outstanding amount after 12 months A=P*(1-(1+r)^(N-12)/r

A=1050.31*(1-(1+0.33%)^348)/0.33%

A=$216125.72

Interest paid in first 12 months = 12*P-(L-A)=12*1050.31-(220000-216125.72)=$8729.48

Loan balance after 10 years B=P*(1-(1+r)^(N-120)/r

B=1050.31*(1-(1+0.33%)^240)/0.33%=$173324.71

Option A: 3.5% ,15 Years

Interest rate =3.5%

Monthly interest rate r=3.5%/12=0.292%

Number of years =15

Number of Payments N=15*12=180

Payment per month P=L*r/(1-(1+r)^-N) =220000*0.292%/(1-(1+0.292%)^-180)

P=$1572.74

Outstanding amount after 12 months A=P*(1-(1+r)^(N-12)/r

A=1572.74*(1-(1+0.0.292%)^168)/0.292%

A=$208646.11

Interest paid in first 12 months = 12*P-(L-A)=12*1572.74-(220000-208646.11)=$7519.01

Loan balance after 10 years B=P*(1-(1+r)^(N-120)/r

B=1572.74*(1-(1+0.292%)^60)/0.292%=$86453.59


Related Solutions

If John wants to purchase a new home for $300,000 and finance $220,000 with either a...
If John wants to purchase a new home for $300,000 and finance $220,000 with either a 4.%, 30- year mortgage or a 3.5%, 15-year mortgage. a. What is the monthly payment on each of the above alternatives? b. How much interest would be paid in the first 12 payments for each of the above alternatives? c. What would the loan balance be after 10 years for each of the above alternatives?
Facts: There is a home you want to purchase with a selling price of $220,000. You...
Facts: There is a home you want to purchase with a selling price of $220,000. You have saved $42,000 for a down payment. The bank charges 2 points on the balance of the note (before taking fees into account) in exchange for a 3% rate. The bank also charges financing fees of $800. You request that the fees and points be added to the balance of the mortgage, which the bank agrees to. Required: Based on the preceding facts, prepare...
To finance the purchase of a new home, a homebuyer takes-out a fully amortizing loan in...
To finance the purchase of a new home, a homebuyer takes-out a fully amortizing loan in the amount of $500,000 at 9% interest per year, compounded monthly, for a term of 20 years. 1. What is the outstanding balance of the loan at the end of 5 years? 2. At the end of year 5, the market rate of interest is 6%. What is the market value of the loan at the end of 5 years? 3. If this loan...
home / study / business / finance / finance questions and answers / john ross graduated...
home / study / business / finance / finance questions and answers / john ross graduated from college 6 years ago with a finance undergraduate degree. although ... Your question has been answered Let us know if you got a helpful answer. Rate this answer Question: John Ross graduated from college 6 years ago with a finance undergraduate degree. Although he is ... John Ross graduated from college 6 years ago with a finance undergraduate degree. Although he is satisfied...
Suppose that you want to purchase a home for $220,000 using a down payment as described...
Suppose that you want to purchase a home for $220,000 using a down payment as described below and you finance the rest of the purchase by taking out a 15-year mortgage at 4.5% interest compounded monthly.  The amount of the down payment is $56,083. Construct an amortization table for the entire length of the loan making sure to include columns for the payment number, the amount of the payment, the amount of each payment that goes towards the principal, the amount...
A married couple are comparing the financing costs for the purchase of a $300,000 home. The...
A married couple are comparing the financing costs for the purchase of a $300,000 home. The couple have good credit score of 790 and the required down payment, and as a result, can obtain a conventional mortgage loan with an 80 percent loan to value mortgage at a rate of 4.5% for a term of 30 year fixed rate mortgage. Closing costs for the conventional loan are 3% of the amount of the new mortgage. Compute the following for the...
A married couple are comparing the financing costs for the purchase of a $300,000 home. The...
A married couple are comparing the financing costs for the purchase of a $300,000 home. The couple have good credit score of 790 and the required down payment, and as a result, can obtain a conventional mortgage loan with an 80 percent loan to value mortgage at a rate of 4.5% for a term of 30 year fixed rate mortgage. Closing costs for the conventional loan are 3% of the amount of the new mortgage. Compute the following for the...
Purchase of a new home John and Jane had planned to save $60 000 dollars over...
Purchase of a new home John and Jane had planned to save $60 000 dollars over the next five years as a down payment on a house. Jane assured John that if they contributed $1000 each month to a savings account that pays an annual rate of interest of 2.5% compounded monthly that they would have enough money to put a down payment of $60 000 on their new house. Wanting their daughter to have a house, Jane’s parents (The...
Purchase of a new home John and Jane had planned to save $60 000 dollars over...
Purchase of a new home John and Jane had planned to save $60 000 dollars over the next five years as a down payment on a house. Jane assured John that if they contributed $1000 each month to a savings account that pays an annual rate of interest of 2.5% compounded monthly that they would have enough money to put a down payment of $60 000 on their new house. Wanting their daughter to have a house, Jane’s parents (The...
Finance Charges.  Bill wants to purchase a new car for ​$42 comma 000. Bill has no​...
Finance Charges.  Bill wants to purchase a new car for ​$42 comma 000. Bill has no​ savings, so he needs to finance the entire purchase amount. With no down​ payment, the interest rate on the loan is 17​% and the maturity of the loan is six years. His monthly payments will be ​$934.34. ​Bill's monthly net cash flows are ​$667. Bill also has a credit card with a ​$12 comma 055 limit and an interest rate of 22​%. If Bill...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT