Question

In: Finance

Suppose you take a fixed-rate mortgage for $250,000 at 4.50% for 30 years, monthly payments. A....

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

Solutions

Expert Solution

1.
=FV(4.5%/12,99,PMT(4.5%/12,12*30,-250000),-250000)*4.5%/12=789.834921518944

2.
=PMT(4.5%/12,12*30,-250000)*12*6-(250000-FV(4.5%/12,12*6,PMT(4.5%/12,12*30,-250000),-250000))=64049.5726007456


Related Solutions

You just took a fixed-rate mortgage for $250,000 at 4.50% for 30 years, monthly payments, two...
You just took a fixed-rate mortgage for $250,000 at 4.50% for 30 years, monthly payments, two discount points. Before you make any payments you receive a nice raise so you plan to pay an extra $160 per month on top of your normal payment. A. (1 pt) How many monthly payments do have to make at the higher payment to fully amortize the loan? B. (1 pt) What is your net interest savings over the life of the loan, assuming...
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?
You take out a $250,000 30 year mortgage with monthly payments and a rate of 10%,...
You take out a $250,000 30 year mortgage with monthly payments and a rate of 10%, monthly compounded. What will your mortgage balance be after your first year of making your monthly payments? How much total interest you paid on this mortgage? work out on a financial calculator. explain the steps to take please.
1.Suppose you take a 30 year fixed-rate mortgage for $175,000 at 5.50%, monthly payments with a...
1.Suppose you take a 30 year fixed-rate mortgage for $175,000 at 5.50%, monthly payments with a two discount point rebate (negative discount points) to the borrower. Assume that you have no other financing fees. A.(1 pt) What is the APR of the loan? B.(1 pt) What is the effective cost with a five-year holding period?
suppose you take a mortgage for $95,000 at 6.50% for 30 years, monthly payments. the loan...
suppose you take a mortgage for $95,000 at 6.50% for 30 years, monthly payments. the loan has a 5% prepayment penalty if the loan is repaid within the first 5 years of life. if you repay the loan at the end of year 4 what is the payoff of the loan? A- 0 B- 4,515 C- 90,307 D-156,250 You to refinance your current mortgage that has a current balance of $150,000 and does not have a prepayment penalty. Your lender...
You plan to take out a $700,000 mortgage for 30 years with monthly payments. If you...
You plan to take out a $700,000 mortgage for 30 years with monthly payments. If you don’t have a down payment, they will offer you an interest rate of 5.7%. If you can make a down payment of at least $20,000 they will lower the interest rate to 5.2%. Calculate the monthly payment for each loan. You would like to see how long it will take you to come up with a down payment. You already have $6,000 and can...
Suppose you take a $200,000 thirty-year fixed-rate mortgage at 5.25%, two discount points, monthly payments. At...
Suppose you take a $200,000 thirty-year fixed-rate mortgage at 5.25%, two discount points, monthly payments. At the end of the first year you inherit $20,000 from your now-favorite aunt. You decide to apply this $20,000 to the principal balance of your loan. A. (1 pt) How many monthly payments are remaining after the extra lump sum payment is made? B. (1 pt) What is your net interest savings over the life of the loan, assuming the loan is held to...
You qualify for an $800,000 fully amortizing 30-year fixed rate mortgage with monthly payments. If the...
You qualify for an $800,000 fully amortizing 30-year fixed rate mortgage with monthly payments. If the annual interest rate is 3.63%, compounded monthly, what will the monthly mortgage payment be?
A $250,000 mortgage was originally financed at 8% annual interest over 30 years with monthly payments...
A $250,000 mortgage was originally financed at 8% annual interest over 30 years with monthly payments and compounding. After making your final payment in year 5, interest rates have fallen to 4% and you are considering refinancing. What is your monthly mortgage payment under the initial loan? What would be your new monthly mortgage payment after refinancing? If the refinancing cost is 2% of the remaining balance on your loan, how much longer would you need to remain in your...
Five years ago you took out a 30-year fixed $300,000 mortgage with monthly payments and an...
Five years ago you took out a 30-year fixed $300,000 mortgage with monthly payments and an APR of 8%, compounded monthly. You have made the normal payments in full, and, this morning, after making a normally scheduled payment, you are paying off the balance by taking out a new 30-year fixed mortgage at a lower APR of 6% (with monthly compounding). How much will each monthly payment be?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT