Question

In: Finance

How much interest will you pay in the 13th year of a $120,000, 8.5%, 25 year...

  1. How much interest will you pay in the 13th year of a $120,000, 8.5%, 25 year mortgage, assuming annual compounding?

a. 7,351.362

b. 7,514.997

c. 7,665.261

  1. How much interest will you pay in the 12th year of a $120,000, 8.5%, 25 year mortgage, assuming monthly compounding? (Hint: 144-AMORT, you need to think about what should be entered for INPUT)

Hint: INPUT = AMORT - # of specified periods + 1

a.7,411.813

b.7,648.124

c.7,911.599

  1. A reset mortgage allows for one interest rate reset during the life of the loan. The mortgage rate will be reset after 6 years, to fully amortize at the end of the original 30 year period (i.e. after 24 more years). For a 6.625%, $100,000, mortgage, please compute the reset payment if the new rate resets to 7.375%. (Hint: calculate how much balance is left after you pay for 6 years at the rate of 6.625%, then use the left balance as the new PV, pay it off for the rest of the 24 years @ the rate of 7.375%). Assuming monthly compounding.

First six years: 1-INPUT, 72-AMORT.

a. 450.76

b. 489.11

c. 652.37

d. 683.93

Solutions

Expert Solution

Formulas will be as follows:


Related Solutions

How much interest will you pay during the eighth year of a 25-year $350,000 loan with...
How much interest will you pay during the eighth year of a 25-year $350,000 loan with an APR of 5.5% if you only make the minimum monthly payments? A. $17,293 B. $15,941 C. $16,139 D. $28,989
How much will you pay on a 25 year, $400,000 mortgage if you make monthly payment...
How much will you pay on a 25 year, $400,000 mortgage if you make monthly payment at the beginning of month? Interest is 3.5%. Answer is $1,997
How much will Jones Company pay in interest each year? How much will Jones Company’s interest expense be for the first year?
  Question: Determining bond prices and interest expense Jones Company is planning to issue $490,000 of 9%, five-year bonds payable to borrow for a major expansion. The owner, Shane Jones, asks your advice on some related matters. Requirements 1. Answer the following questions: a. At what type of bond price Jones Company will have total interest expense equal to the cash interest payments? b. Under which type of bond price will Jones Company’s total interest expense be greater than the...
Suppose you obtain a 25-year mortgage loan of $194,000 at an annual interest rate of 8.5%....
Suppose you obtain a 25-year mortgage loan of $194,000 at an annual interest rate of 8.5%. The annual property tax bill is $971 and the annual fire insurance premium is $481. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.)
On a 15-year, $200K mortgage at 4% APR, how much interest will you pay in ONLY...
On a 15-year, $200K mortgage at 4% APR, how much interest will you pay in ONLY the second year if you make the regular monthly payments? Multiple Choice $8,366 $17,170 $1,497 $680 $9,083
How much interest will you pay during the last six years of a 15-year $300,000 loan...
How much interest will you pay during the last six years of a 15-year $300,000 loan with an APR of 3.15% assuming you only make the minimum required monthly payments? A. $13,915 B. $18,223 C. $18,641 D. $13,551
How much would you need to invest each year in an account earning 8.5% in order...
How much would you need to invest each year in an account earning 8.5% in order to have $1,000,000 thirty-five years from now? Show your work.
How much would you be willing to pay for an investment that will pay you and...
How much would you be willing to pay for an investment that will pay you and your heirs $16,000 each year in perpetuity if the first payment is to be received in 9 years? a) Assuming your opportunity cost is 6%? b) if you want the payments to grow by 2% indefinitely. problem must be in excel
How much are you going to pay? How much insurance company pays?
  Use the following information to answer the following questions deductible: $1000 coinsurance: 20% out-of-pocket maximum: $8000 let's say you have $30000 in covered medical expenses in January: How much are you going to pay? How much insurance company pays? if you have an additional $20000 in medical expenses: how much are you going to pay? how much insurance company pays?
How much would you pay today for an investment that provides you $2,830 each year for...
How much would you pay today for an investment that provides you $2,830 each year for the next 6 years, starting next year, and $11,126 12 years from now if the interest rate is 3.89% APR compounded annually?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT