Question

In: Finance

You are thinking of purchasing a house that costs $450,000. You have $55,000 in cash that...

You are thinking of purchasing a house that costs $450,000. You have $55,000 in cash that you can use as a down payment, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires monthly payments and has an annual interest rate of 6.32% per year.

  • What will your monthly payments be if you sign up for this mortgage?

  • Present the amortization schedule (Beginning balance, Monthly payment, Principal payment, Interest payment, Ending balance) on a monthly basis using Excel.

  • Calculate the total amount of interest paid throughout the life of the loan.

  • Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan.

Suppose the interest rate decreases to 5.47% per year and the length of repayment decreases to 15 years.

  • What will the new monthly payment be?

  • Present a new amortization schedule (Beginning balance, Monthly payment, Principal payment, Interest payment, Ending balance) in a separate Excel sheet.

  • Calculate the total amount of interest paid throughout the life of the loan.

  • Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan.

How much do you save if you go with the 15-year mortgage versus the 30-year mortgage example above? Compute the difference between the total interest paid in parts A and B.

Solutions

Expert Solution

Pleas Find EXCEL - https://drive.google.com/file/d/1d1QRsOVe1VM9sPI64zwUz13--xWciKOg/view?usp=sharing

Cost of House $ 4,50,000.00

Down payment $    55,000.00

Loan Amount $ 3,95,000.00

Interest Rate6.32%

Tenor30 Years

EMI $      2,450.10

Opening Balance $ 3,95,000.00

Monthly Payment= $ 2,450.1

Total Interest Paid= $487,030.08

Graph for Interest

Graph For Principle

Payment throughout the Tenor= $882,036

2nd Condition

EMI= $3,221.19

Total Interest paid = $ 579,814.2

Graph for interest

Graph for Principle

Difference in Interest = $302,214.53


Related Solutions

You are thinking of purchasing a house. The house costs 300000.You have 43000 in cash...
You are thinking of purchasing a house. The house costs 300000. You have 43000 in cash that you can use as a down payment on the house but you need to borrow the rest of the purchase price. The bank is offering a 30yr mortgage that requires annual payments and has an interest rate of 5 percent per year. What will be the annual payment?
You are thinking of purchasing a house. The house costs $200,000. You have $29,000 in cash...
You are thinking of purchasing a house. The house costs $200,000. You have $29,000 in cash that you can use as a down payment on the​ house, but you need to borrow the rest of the purchase price. The bank is offering a 30​-year mortgage that requires annual payments and has an interest rate of 7% per year. What will be your annual payment if you sign this​ mortgage?
You are thinking of purchasing a house. The house costs $250,000. You have $36,000 in cash...
You are thinking of purchasing a house. The house costs $250,000. You have $36,000 in cash that you can use as a down payment on the​ house, but you need to borrow the rest of the purchase price. The bank is offering a 30​-year mortgage that requires annual payments and has an interest rate of 8% per year. What will be your annual payment if you sign this​ mortgage?
You are thinking of purchasing a house that costs $245,000. You have $13,000 in cash that...
You are thinking of purchasing a house that costs $245,000. You have $13,000 in cash that you can use as a down payment but you need to borrow the rest of the purchase price. The bank is offering a 30 year mortgage that requires monthly payments and has an annual interest rate of 4.35% per year. What will your monthly payments be if you sign up for this mortgage? Draw the amortization schedule on a monthly basis using Excel. Calculate...
Part A You are thinking of purchasing a house. The house costs $350,000. You have $50,000...
Part A You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the house, but you need to borrow rest of the purchase price. The bank is offering a 20-year mortgage that requires monthly payments and has an annual interest rate of 5% per year. Determine your monthly payments if you sign up for this mortgage. Draw the amortization schedule, monthly, using Excel. Calculate the...
You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price.
  You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires monthly payments and has an annual interest rate of 4.55%. What will your monthly payments be if you sign up for this mortgage? Create the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid...
You would like to buy a house that costs $ 350000. You have $50,000 in cash...
You would like to buy a house that costs $ 350000. You have $50,000 in cash that you can put down on the? house, but you need to borrow the rest of the purchase price. The bank is offering you a? 30-year mortgage that requires annual payments and has an interest rate of 8% per year. You can afford to pay only $25,320 per year. The bank agrees to allow you to pay this amount each? year, yet still borrow...
You would like to buy a house that costs $350,000. You have $50,000 in cash that...
You would like to buy a house that costs $350,000. You have $50,000 in cash that you can put down on the house, but you need to borrow the rest of the purchase price. The bank is offering you a 30-year mortgage that requires annual payments and has an interest rate of 7% per year. You can afford to pay only $23,500 per year. The bank agrees to allow you to pay this amount each year, yet still borrow $300,000....
You would like to buy a house that costs $350,000. You have $50,000 in cash that...
You would like to buy a house that costs $350,000. You have $50,000 in cash that you can put down on the house, but you need to borrow the rest of the purchase price. The bank is offering you a 30-year mortgage that requires annual payments and has an interest rate of 7% per year. You can afford to pay only $23,500 per year. The bank agrees to allow you to pay this amount each year, yet still borrow $300,000....
After selling your house and purchasing a new house you have $25,000 left you wish to...
After selling your house and purchasing a new house you have $25,000 left you wish to invest. The first option you have is a one year T-Bill with a par value of $25,000 which costs $23,250. Your second option is to invest in a 12 month CD with a 6.5% interest rate. Of these two available options which would allow you to receive a higher rate of return. Make sure to show your calculations.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT