Question

In: Finance

The bank has agreed to give you a mortgage for $400,000 to buy a new house....

The bank has agreed to give you a mortgage for $400,000 to buy a new house. Current mortgage rates have an APR of 4% compounded semi-annually for a term of 25 years. How much interest will you pay in total over the life of the loan?

Select one:

a. $121,433.25

b. $143,645.25

c. $231,224.25

d. $237,378.25

e. None of the above.

Solutions

Expert Solution

Sol:

Principal (P) = $400,000

Interest rate (r) = 4% (semi annual) = 4%/2 = 2%

Period (n) = 25 (semi annual) = 25 x 2 = 50, (Monthly) = 25 x 12 = 300

Now to compute interest paid in total over the life of the loan we have to find Equal Monthly Payment (EMI):

Effective interest rate = (1+r/n)^n -1

2% = (1+r) ^6 - 1

Monthly interest rate (r) = 0.00330589

EMI = P x r (1+r)^n/(1 + r)^n – 1

EMI = 400000 x 0.00330589 (1+0.00330589)^300/(1+0.00330589)^300 - 1

EMI = 1322.356 (1.00330589)^300/(1.00300589^300)-1

EMI = 1322.356 x (2.6915877678 / 1.6915877678)

EMI = 1322.356 x 1.591160576

EMI = 2104.08

Total loan paid = EMI x Period = 2104.08 x 300 = 631224.25

Interest paid in total over the life of the loan = Total loan paid - Principal

Interest paid in total over the life of the loan = 631224.25 - 400000 = 231224.25

Therefore interest paid in total over the life of the loan will be $231,224.25

Answer is C - $231,224.25


Related Solutions

You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7...
You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7 year term with a 22 year amortization. The rate on the mortgage is 2.75% APR with monthly compounding and monthly payments. What is the balloon payment on the mortgage? Round your answer to 2 decimal places. (For example 2.437 = 2.44)
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and...
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and wish to repay the mortgage loan and the interest in 5 equal annual payments, the first one being payable on 12/31/20x1. The mortgage loan bears interest at 7%.         a) Calculate the annual mortgage payment required. Round off to the nearest cent (e.g.,    $112,753.32). b) Construct the mortgage payment schedule to see if the loan and interest will be paid    in full...
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge...
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge interest at the rate of 9% annually and requires a minimum monthly payment of $500. At the end of five years, you must pay off the entire mortgage by a “balloon payment”. You plan to pay only the minimum amount each month and then pay off the loan with the final payment. Find this balloon payment. (Answer: $49966.07) please answer in excel format
House Appreciation and Mortgage Payments Say that you purchase a house for $400,000 by getting a...
House Appreciation and Mortgage Payments Say that you purchase a house for $400,000 by getting a mortgage for $320,000 and paying a $80,000 down payment. A. If you get a 20-year mortgage with a 4 percent interest rate, what are the monthly payments? B. What would the loan balance be in ten years? C. If the house appreciates at 6 percent per year, what will be the value of the house in ten years? D. How much equity do you...
Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house....
Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house. The interest rate is 1.2% (APR) and you have to make payments monthly. Part 1 What is your monthly payment? Part 2 How much of your first monthly payment goes towards paying down the outstanding balance (in $)? Part 3 How much of your 13th monthly payment goes towards paying down the outstanding balance (in $)?
You want to buy a house. You have found the house you like and have agreed...
You want to buy a house. You have found the house you like and have agreed to purchase the house for $300,000. You go to the bank to get a loan and have decided that a 30 year mortgage loan is the best loan duration. What do you think the interst rate will be on your loan given the following data? "Real" interest rate given current macro econmomic conditions = 2.0% The inflation rate forecasted for the future is =...
To finance your new​ house, you have obtained a 35 year $750,000 mortgage. The bank has...
To finance your new​ house, you have obtained a 35 year $750,000 mortgage. The bank has offered you an interest rate of 5.7​%. You​ can't decide on a payment frequency. Complete the following table to help you make a decision. number of payment per year mortgage payment 12 24 26 52
Ann wants a mortgage to buy a house. Ann gives the following information to the bank:...
Ann wants a mortgage to buy a house. Ann gives the following information to the bank: Income: $240k/year or 20k/month Average monthly debt: $2k Estimated monthly Taxes + Insurance: $700 Down-payment: $50k saved -Ann’s down-payment will be $50k, she will take out a mortgage for the remainder Ann qualifies for a 30 year FA-CPM-FRM (monthly payments & monthly compounding) with: Annual interest rate: 4% Income test: (28%/36%) Collateral test: Closing costs + buy-down points: $5,000 + 1.75% of the balance...
: Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in...
: Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047...
You take out a 25-year mortgage for $300,000 to buy a new house. What will your...
You take out a 25-year mortgage for $300,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 8 percent? Now, calculate the portion of the 48th monthly payment that goes toward interest and principal. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT