Suppose you plan to purchase a $200,000 condo. The bank has offered you 30-year fixed rate...

Suppose you plan to purchase a $200,000 condo. The bank has offered you 30-year fixed rate mortgage with an APR of 6.5% and payments due monthly. If you make a 20% down payment, what is your monthly mortgage payment?

1,011

1,264

12,252

10,400

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

As nothing was mentioned excel is used.

jeff jeffy answered 11 months ago

You plan to purchase a house for $200,000 using a 30-year mortgage obtained from your local...

You plan to purchase a house for $200,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. a. Your bank offers you the following two options for payment. Which option should you choose? Option 1: Mortgage rate of 5.60 percent and...

Suppose you take a fixed-rate mortgage for $200,000 at 5.00% for 30 years, monthly payments. 1)...

Suppose you take a fixed-rate mortgage for $200,000 at 5.00% for 30 years, monthly payments. 1) How much of the payment is interest for month 100? How much interest do you pay in the first six years?

Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of...

Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of 10%. What is your total monthly payment? How much of the first month’s payment goes to reduce the size of the loan? If you can afford to pay $2,000 per month, how long would it take you to pay for this loan (still at 10% interest)? If you can only pay $1,700 per month, and still want to finish paying in 30 years, what...

You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit...

You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.50 percent. You will make a down payment of 20 percent of the purchase price. (LG 7-4) a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. please show in excel

b) Suppose that you are the manager of a bank that has K15 million of fixed-rate...

b) Suppose that you are the manager of a bank that has K15 million of fixed-rate assets, K30 million of rate sensitive assets, K25 million of fixed-rate liabilities, and K20 million of rate-sensitive liabilities. Conduct a gap analysis for the bank, and show what will happen to bank profits if interest rates rise by 5 percentage points. Mention three actions you could take to reduce the bank’s interest-rate risk? c) A bank manager wants to know what happens when interest...

a.Christine is getting a 30-year fixed rate $200,000 mortgage. She can get a mortgage rate of...

a.Christine is getting a 30-year fixed rate $200,000 mortgage. She can get a mortgage rate of 6.5% with no points or a rate of 6.0% with 2 points. She decides it's not worth it to pay the points. Why? b. One percent of the mortgage value, used as prepaid interest paid at time of purchase, is called a? c. If you buy a $200,000 home with 10% down payment, what will be your mortgage? And if you have a 5%...

Amortizing loans. Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo....

Amortizing loans. Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 6%, and payments on the loan are made annually at the end of each year. What is your annual payment on the loan? Construct a mortgage amortization table in Excel similar to Table 2.1, showing the interest payment, the amortization of the loan, and the loan balance for each year. What fraction of your initial loan payment...

Today, Malorie takes out a 30-year loan of $200,000, with a fixed interest rate of 4.5%...

Today, Malorie takes out a 30-year loan of $200,000, with a fixed interest rate of 4.5% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 30 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 4.5% will stay the same over the coming 30 years. (c) Calculate...

Suppose that the central bank has fixed the exchange rate at E but then the level...

Suppose that the central bank has fixed the exchange rate at E but then the level of domestic output suddenly falls. How should the central bank respond if it wants to maintain its fixed exchange rate? Briefly explain the underlying economic intuition / mechanisms!

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate,...

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate, fully amortized mortgage and the mortgage rate is 7.0% (APR, monthly). a. Find the monthly mortgage payment. b. Compute an amortization schedule for the first six months. c. What will the mortgage balance be at the end of the 15th year? d. If an investor purchased this mortgage, what will the timing of the cash flow be assuming that the borrower does not default?

Question