Question

3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly...

3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly payments for 10 years, 120 payments in all, with the first payment in one month. The bank charges you an interest rate of 9.6% (APR with monthly compounding).

a. How much of your first payment is interest, and how much is repayment of principal?

b. What is the loan balance immediately after the 10th payment? (Calculate the loan balance using the annuity formula.)

c. How much of your 10th payment is interest, and how much is repayment of principal?

Homework Answers

Answer #1

a.

Calculating Monthly Payment,

Using TVM Calculation,

PMT = [PV = 500,000, FV = 0, N = 120, I = 0.096/12]

PMT = $6,497.28

Interest = (0.096/12)500,000 = $4,000

Principal = 6,497.28 - 4,000 = $2,497.28

b.

Calculating Loan Balance after 10th payment,

Using TVM Calculation,

FV = [PV = 500,000, PMT = -6,497.28, N = 10, I = 0.096/12]

FV = $474,108.73

c.

Calculating Loan Balance after 9th payment,

Using TVM Calculation,

FV = [PV = 500,000, PMT = -6,497.28, N = 9, I = 0.096/12]

FV = $476,791.68

Interest Paid in 10th payment = (0.096/12)(476,791.68) = $3,814.33

Principal Paid in 10th payment = 6,497.28 - 3,814.33

Principal Paid in 10th payment = $2,682.95

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home....
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home. The bank charges 5.5% annual interest compounded monthly. You are going to pay off this loan by fixed installments (fixed total payment) to be made at the end of each month for thirty years. How much is each installment payment? How much is the total principal repayment after four months? How much is the total interest payment after four months. Draw an amortization table...
you borrowed $500,000 to buy a house. The mortgage rate s 24% (APR, monthly). The loan...
you borrowed $500,000 to buy a house. The mortgage rate s 24% (APR, monthly). The loan is to be repaid in equal monthly payments over 30 years. 29 years has passed. How much you owe to the bank on your home (loan principal) since you have 1 year left from your mortgage? Assume that each month is equal to 1/12 of a year.
You have just purchased a home and taken out a $275,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $275,000 mortgage. The mortgage has a 25-year term with monthly payments and an APR of 3% compounding monthly. How much of your 288th payment will be interest and how much will go toward reducing your principal?
you just took out a $500,000, 20-year mortgage from CIBC. ASSume your effective monthly rate of...
you just took out a $500,000, 20-year mortgage from CIBC. ASSume your effective monthly rate of interest is 0.5% and your monthly payments are $3582.16. (a) How much of your first monthly payment goes toward principal repayment? (b) how much of your 50th monthly payment goes toward interest?
Suppose that you take out a mortgage loan with the following characteristics: compounding period is monthly...
Suppose that you take out a mortgage loan with the following characteristics: compounding period is monthly loan is for $350,000 APR = 5% life of loan for the purpose of calculating the mortgage payments is 30 years the loan requires a balloon payment of the balance of the principal owed at the end of year 5, i.e., the balance owed immediately after the 60th payment. What is the size of the balloon payment? Do not round at intermediate steps in...
Assume you’ve recently purchased a home for $129,000 and you will be making monthly payments on...
Assume you’ve recently purchased a home for $129,000 and you will be making monthly payments on the mortgage. If the mortgage is for 30 years at an interest rate of 5%, what will be the monthly payment? For the first monthly payment, how much will go towards interest payment and how much will go towards repayment of the principal? Show your work.
Amanda Rice has just arranged to purchase a $530,000 vacation home in the Bahamas with a...
Amanda Rice has just arranged to purchase a $530,000 vacation home in the Bahamas with a 20 percent down payment. The mortgage has a 5.9 percent APR compounded monthly and calls for equal monthly payments over the next 30 years. Her first payment will be due one month from now. However, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of Year 8. There were no other transaction...
Steve is buying home that costs $500,000. You have been offered a 30-year mortgage that requires...
Steve is buying home that costs $500,000. You have been offered a 30-year mortgage that requires a 20% down payment for the house. The loan is to be repaid in equal monthly installments. The APR of the mortgage is 4%. Compute the EAR and the amount of your monthly payment on the mortgage. Show all calculations. you need to find the amount of the monthly payment in two different ways: 1) using the built-in Excel function 2) using the annuity...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much will be your principal repayment from your monthly mortgage payment at the end of the second month?(Make a table for the mortgage loan payment schedule) Can you explain how to get interest and principle repaid please
You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR 9with semi-annual compounding) of 7.04%. A. How much will you pay in interest, and how much will you pay in principal, during the first year ? B. How much will you pay in interest, and how much you in pay in principal, during the the Twentieth year (i.e. between 19 and 20 years from now) ?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT