You and your spouse are considering purchasing your first new house. The house price is $300,000....

You and your spouse are considering purchasing your first new house. The house price is $300,000. You will make 10% down payment. The remaining balance can be financed with a 30 year mortgage loan with an annual interest of 6%.

A. What is the monthly mortgage payments?

B. How much do you need if you are to pay off the loan after 5 years (right after the 60th payment)?

C. How much interest (in $) will you save from paying the loan off early?

PLEASE USE TVM KEYS FROM FINANCIAL CALCULATOR

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

jeff jeffy answered 1 year ago

You and your spouse are considering purchasing a home. The home you are purchasing is $231,250....

You and your spouse are considering purchasing a home. The home you are purchasing is $231,250. You plan on offering full price today. You have a 10% down payment and your are financing the remaining balance for 30 years. (Round off the amount you are financing to nearest dollar.) You have checked with several lenders and find the best rate to be 4.5% for 30 years. In order to qualify for the loan the lender tells you that your front...

Suppose you are considering purchasing a new car. You and your spouse have narrowed it down...

Suppose you are considering purchasing a new car. You and your spouse have narrowed it down to two choices: a. Sedan Initial Price: $27,300 Annual O&M: $4,456 Expected trade-in value after 5 years: $9,100 b. SUV Initial Price: $38,795 Annual O&M: $3,050 Expected trade-in value after 5 years: $18,544 If you intend to keep your new vehicle for 5 years, then trade it in, determine the net present value (NPV) of each alternative, assuming a discount rate of 4.0%. Which...

Jasmine and her spouse are considering purchasing a larger house for their growing family. Below is...

Jasmine and her spouse are considering purchasing a larger house for their growing family. Below is a summary of their current combined income and expenses. Combined Salary (Net Annually) $97,500 Monthly Mortgage Payment $1,200 Master Card (minimum monthly payment) $1,000 Utilities (Heath and Electricity) $150 Car Loan Payment $850 Cable TV $50 Cell-Phone Plan $100 Line of Credit (minimum monthly payment) $200 Property Tax (annual) $2,000 Question 13 (1 point) What is Jasmine's family average monthly income? (1 mark) Question...

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.

You are considering purchasing a home that requires $300,000 mortgage at 5.25%. The payment on the...

You are considering purchasing a home that requires $300,000 mortgage at 5.25%. The payment on the 30 year mortgage for this amount is $1656.61 per month, the payment for a 15 year maturity is $2411.63 per month. A) What is the total amount that you would pay for the 30 year mortgage, including interest? B) What is the total amount that you would pay for the 15 year mortgage, including interest? C) What is the difference in the total interest...

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...

5. Suppose that you and your spouse have recently purchased a house with a loan of...

5. Suppose that you and your spouse have recently purchased a house with a loan of $50,000. The terms were 15 percent interest and annual payments of $7,988.07 for 20 years. What proportion of the loan will have been paid off after 20 years? 5 years? 8 years? 12 years?

Your house is worth $400,000 and you have $300,000 in a savingsaccount. There is a...

Your house is worth $400,000 and you have $300,000 in a savings account. There is a 1 percent chance of a fire in your house. If the fire occurs, there will be $300,000 in damages to your house.a. Suppose you do not have fire insurance. If the fire occurs, you will have to pay $300,000 to repair your house. What is the expected value of your wealth (including both the value of your home and your savings account) at the...

You are currently seeking to finance your first house. The price is $400,000. You can make...

You are currently seeking to finance your first house. The price is $400,000. You can make a down payment of $40,000, but you must obtain a mortgage (loan) for the other $360,000. Thanks to a special first time homebuyer’s program, your bank is willing to give you a 30-year, 4.8% APR loan for the amount. Interest on the loan will be compounded monthly. a) Calculate your monthly payment on the mortgage, assuming that the payments begin one month from the...

You are purchasing a house and your bank is giving you a special mortgage that will...

You are purchasing a house and your bank is giving you a special mortgage that will require annual payments for 25 years. The amount borrowed now is $350,000 and the first mortgage payment will be in one year. a. Using C as the payment amount, indicate on a timeline all of the cash flows from your perspective related to this mortgage (outflows should be indicated as a negative number). b. What will your payments be if the interest rate is...

Question