Question

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) ?

Homework Answers

Answer #1

I have attached the screeshot of soultion caluclated using excel formula. For interest CUMIPMT and for principal CUMPRINC.

In case of any query please leave a comment.

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 have just purchased a home and taken out a $450,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $450,000 mortgage. The mortgage has a 30 year term with monthly payments and an APR of 6.88%. 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 will you pay in​ principal, during the 20th year​ (i.e., between 19 and 20 years from​ now)?
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?
1.A couple has just purchased a home for $307,000.00. They will pay 20% down in cash,...
1.A couple has just purchased a home for $307,000.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 3.60% APR with monthly compounding. The mortgage has a term of 30 years. What is the monthly payment on the loan? 2. A couple has just purchased a home for $307,000.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them...
You just purchased a home and agreed to a mortgage payment of $1,264 a month for...
You just purchased a home and agreed to a mortgage payment of $1,264 a month for 30 years at 7.5 percent interest, compounded monthly. How much interest will you pay over the life of this mortgage assuming that you make all payments as agreed? PLEASE INCLUDE HOW TO ENTER ON FINANCIAL CALCULATOR.
A couple has just purchased a home for $312,100.00. They will pay 20% down in cash,...
A couple has just purchased a home for $312,100.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.64% APR with monthly compounding. The mortgage has a term of 30 years. What is the size of the loan taken out by the couple?
A couple has just purchased a home for $348,400.00. They will pay 20% down in cash,...
A couple has just purchased a home for $348,400.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.04% APR with monthly compounding. The mortgage has a term of 30 years. What is the monthly payment on the loan?
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....
Adam Wilson just purchased a home and took out a $250,000 mortgage for 30 years at...
Adam Wilson just purchased a home and took out a $250,000 mortgage for 30 years at 8%, compounded monthly. a. How much is Adam’s monthly mortgage payment? b. How much sooner would Adam pay off his mortgage if he made an additional $100 payment each month? The financial tables in Appendix A are not sufficiently detailed to do parts (c) and (d). c. Assume Adam makes his normal mortgage payments and at the end of five years, he refinances the...
purchase of your first home for $600,000. You have just purchased the house and have put...
purchase of your first home for $600,000. You have just purchased the house and have put a 20% down payment, and will borrow the remaining amount.  The 15-year fixed rate loan has an Annual Percentage Rate (APR) of 3.875%.   You will make monthly payments for the life of the loan. Question 12 related to your purchase of your first home for $600,000. You have just purchased the house and have put a 20% down payment, and will borrow the remaining amount.  The 15-year...
Audrey Sanborn has just arranged to purchase a $540,000 vacation home in the Bahamas with a...
Audrey Sanborn has just arranged to purchase a $540,000 vacation home in the Bahamas with a 30 percent down payment. The mortgage has a 6 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...