Question

In: Finance

Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes...

Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes an APR of 4%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid?

Do not round at intermediate steps in your calculation

A) $9,619.05

B)$6,412.70

C)$5,284.99

D)$7,500.27

.

Solutions

Expert Solution

The interest amount paid between the 109th and 120th months is calculated using CUMIPMT function in Excel :

rate = 4%/12 (converting annual rate into monthly rate)

nper = 15*12 (15 year loan with 12 monthly payments each year)

pv = 300000 (loan amount)

start period = 109 (We are calculating principal paid off between 1st and 72nd month)

end period = 120 (We are calculating principal paid off between 1st and 72nd month)

type = 0 (each payment is made at the end of month)

CUMIPMT is calculated to be $5,284.99


Related Solutions

Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes an APR of 4%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid? Do not round at intermediate steps in your calculation.
1. Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender...
1. Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes an APR of 4%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid? Do not round at intermediate steps in your calculation. 2. Suppose that you take out a mortgage loan with the...
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes an APR of 7.28%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. After 17 years of payments, what is the balance outstanding on your loan? Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do not type the $ symbol.
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes an APR of 7.8%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. After 15 years of payments, what is the balance outstanding on your loan? Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do not type the $ symbol
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes an APR of 2.78%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. What would be your monthly mortgage payment?
Suppose that you are considering a conventional, fixed-rate 20-year mortgage loan for $250,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 20-year mortgage loan for $250,000. The lender quotes an APR of 7%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid? Do not round at intermediate steps in your calculation. Group of answer choices $15,199.56 $13,159.65 $12,112.53 $14,064.27
Suppose that you are considering a conventional, fixed-rate30-year mortgage loan for $100,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes an APR of 5.38%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. After 19 years of payments, what is the balance outstanding on your loan? Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do not type the $ symbol.
Suppose that you are considering a conventional, fixed-rate30-year mortgage loan for $100,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 30-year mortgage loan for $100,000. The lender quotes an APR of 5.78%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. After 6 years of payments, what is the balance outstanding on your loan? Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do not type the $ symbol.
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?
You are considering an adjustable rate mortgage loan with the following characteristics: • Loan amount: $300,000...
You are considering an adjustable rate mortgage loan with the following characteristics: • Loan amount: $300,000 • Term: 20 years • Index: one year T-Bill • Margin: 2.5% • Periodic cap: 2% • Lifetime cap: 5% • Negative amortization: not allowed • Financing costs: $3,500 in origination fees and 1 discount point Suppose the Treasury bill yield is 3.5% at the outset and is then moves to 4.5% at the beginning of the second year and to 8.5% at the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT