You are looking at buying a house with a $180,000 loan amount. You have 2 options...

You are looking at buying a house with a $180,000 loan amount. You have 2 options for this loan: 1) 15 Year Loan, you can get a monthly interest rate of 0.3% monthly. A) What is your monthly payment? B) What is the total amount you would pay out of pocket over the life of the loan? C) How much interest have you paid?

2) 30 year Loan, you can get a monthly interest rate of 0.3125% monthly. A) What is your monthly payment? B) What is the total amount you would pay over the life of the loan? C) How much interest have you paid?

Please do on excel and show formula/calculations

Expert Solution

Calculation is shown below

Working is given below

jeff jeffy answered 2 years ago

The Young household is looking at buying a house. The three houses they are looking at...

The Young household is looking at buying a house. The three houses they are looking at cost the following: $160,000, $190,000 and $210,000. They can pay up to $900 in monthly mortgage payments. They currently have $18,000 set aside for a down payment. Similarly to the Tremblay’s bank, the Youngs’ bank will add $40 to each mortgage payment if they put less than 20% down and an additional fee of $30 more to each payment if they put less than...

You are buying a house and trying to decide how to structure a the loan.

You are buying a house and trying to decide how to structure a the loan. You can borrow $120,000 at a 4.5 percent rate for 30 years with monthly payments, or you can borrow $120,000 at a 3.75 rate for 20 years with monthly payments. what should you consider when making this decision?

You are buying a house and trying to decide how to structure the loan. You can...

You are buying a house and trying to decide how to structure the loan. You can borrow $120,000 at a 4.5% rate for 30 years with monthly payments, or you can borrow $120,000 at a 3.75% rate for 20 years with monthly payments. What should you consider when making this decision?

6. Jim has an annual income of $180,000. Jim is looking to buy a house with...

6. Jim has an annual income of $180,000. Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner’s insurance of $70. Jim has $178 in monthly student loan payments. Apple bank has a maximum front end DTI limit of 28% and a maximum back end DTI limit of 36%. Both limits must be satisfied. Apple bank is offering a fully amortizing 30 year FRM at an annual rate of 4.5%, with monthly payments, compounded...

You want to buy a house that costs $180,000. You have $18,000 for a down payment,...

You want to buy a house that costs $180,000. You have $18,000 for a down payment, but your credit is such that mortage companies will not lend you the required $160,000. However, the realtor persuades the seller to take a $160,000 mortage (called a seller take-back mortage) at a rate of 7%, provided the loan is paid off in full in 3 years. You expected to inherit $180,000 in 3 years; but right now all you have is $18,000, and...

You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A) How...

You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A) How much will your monthly payments be? B) How much will go toward principal in the 75th month? How much will go toward interest in the 75th month? What will be the balance after 75 months? C) How much interest will you pay in total over the 30 years? D) If you do a 15-year loan instead of a 30-year one, how much will you...

You are buying a new house on a 30-year, 6.2% mortgage loan of $230,000. A. How...

You are buying a new house on a 30-year, 6.2% mortgage loan of $230,000. A. How much will your monthly payments be? B. How much will go toward principal in the 55th month? How much will go toward interest in the 55th month? What will be the balance after 55 months? C. How much interest will you pay in total over the 30 years? D. If you do a 15-year loan instead of a 30-year one, how much will you...

When you bought your current house, you obtained a loan in the amount of $185,000, with...

When you bought your current house, you obtained a loan in the amount of $185,000, with a 30-year term and an interest rate of 6.35%. That was 6 years ago, and you notice that mortgage rates have fallen significantly. Your banker has given you two refinancing alternatives. Alternative 1 is a 25 year loan with a fixed rate of 4.75%. This option requires a 2-point rate buy-down fee and closing costs of $1,700. Alternative 2 is a 25 year loan...

2. Assume that you are buying a house for $500, 000 and you haveto finance...

2. Assume that you are buying a house for $500, 000 and you have to finance 80% of it from the bank at 6% p.a. for 20 years. It is to be repaid monthly.a) What is the monthly repayment amount? Assume the interest is compounded monthly.b) At the end of year 5 you have to sell your house and move to the U.S.i. How much money do you still owe the bank?ii. How much principal and interest have you paid...

Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage...

Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage is a 30 year fixed rate mortgage with an APR of 5.25%. What is your monthly mortgage payment? Construct a loan amortization table in Excel for mortgage loan in the previous problem. You should do the problem in Excel using monthly payments and you must submit the spreadsheet with formulas.

Question