Question

In: Finance

Suppose you take out a 30 year mortgage for $460000 at an annual interest rate of...

Suppose you take out a 30 year mortgage for $460000
at an annual interest rate of 3.5%.
You plan to sell the house after 10 years.

Question 1

How much do you owe on the house after five years?

Question 2


How much do you owe on the house after ten years?

After five years you have the opportunity to refinance what you owe
at an interest rate of 3.25% for 30 years.

Question 3

How much would you gain per month during the next 60 periods?

Question 4

What is the maximum amount you would pay to refinance?

Solutions

Expert Solution

1

Monthly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          460,000
Rate of interest per period:
Annual rate of interest 3.500%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.035 /12 = 0.2917%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                        30
Total number of payments N 30 × 12 = 360
Period payment using the formula = [ 460000 × 0.00292 × (1+0.00292)^360] / [(1+0.00292 ^360 -1]
Monthly payment = $                                                         2,065.61
Loan balance = PV * (1+r)^n - P[(1+r)^n-1]/r
Loan amount PV = 460,000.00
Rate of interest r= 0.2917%
nth payment n= 60
Payment P= 2,065.61
Loan balance = 460000*(1+0.00292)^60 - 2065.61*[(1+0.00292)^60-1]/0.00292
Loan balance =                                                                         412,606.24

Balance after five years is $412,606.24

2

Loan balance = PV * (1+r)^n - P[(1+r)^n-1]/r
Loan amount PV = 460,000.00
Rate of interest r= 0.2917%
nth payment n= 120
Payment P= 2,065.61
Loan balance = 460000*(1+0.00292)^120 - 2065.61*[(1+0.00292)^120-1]/0.00292
Loan balance =                                                                         356,162.99

Amount owed after ten years is $356,162.99

3

New loan
Rate 3.25%
Period 360
Loan amount $      412,606.24
Monthly payment $           1,795.69
Less: existing payment $           2,065.61
Gain per month $              269.92

4

Particulars Amount × factor Present value
Monthly payment
balance
$           2,065.61 $205.21 $      423,874.66
Points paid today $                       -  
Total present value $      423,874.66
Less: loan balance $      412,606.24
Savings of refinance $         11,268.42

Maximum payment for refinance is $11,268.42


Related Solutions

Suppose you take out a 30 year mortgage for $490000 at an annual interest rate of...
Suppose you take out a 30 year mortgage for $490000 at an annual interest rate of 4.0%. You plan to sell the house after 10 years. Question 1 How much do you owe on the house after five years?(No Response) Question 2 How much do you owe on the house after ten years?(No Response) After five years you have the opportunity to refinance what you owe at an interest rate of 3.75% for 30 years. Question 3 How much would...
1. Suppose you take out a 30-year mortgage for $207,418 at an annual interest rate of...
1. Suppose you take out a 30-year mortgage for $207,418 at an annual interest rate of 3.1%. After 20 years, you refinance to an annual rate of 2.0%. How much interest did you pay on this loan? Round your answer to the nearest dollar. _____________________ 2. Consider a 20-year mortgage for $183,858 at an annual interest rate of 4.9%. After 10 years, the mortgage is refinanced to an annual interest rate of 2.9%. What are the monthly payments after refinancing?...
Suppose you take out a 30-year mortgage for $197,298 at an annual interest rate of 3.1%....
Suppose you take out a 30-year mortgage for $197,298 at an annual interest rate of 3.1%. After 16 years, you refinance to an annual rate of 1.3%. How much interest did you pay on this loan?
Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of...
Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of 10%. What is your total monthly payment? How much of the first month’s payment goes to reduce the size of the loan? If you can afford to pay $2,000 per month, how long would it take you to pay for this loan (still at 10% interest)? If you can only pay $1,700 per month, and still want to finish paying in 30 years, what...
You take out a 30-year $500,000 mortgage at an effective annual interest rate of 8%. Immediately...
You take out a 30-year $500,000 mortgage at an effective annual interest rate of 8%. Immediately after your 12th payment, you make an additional principal repayment of $50,000, and then refinance the outstanding balance with a new 15-yeatr mortgage at a 4% effective annual interest rate. Both mortgages require annual year-end level amortization payments. Find the amount of interest in the 5th payment of the new mortgage. PLEASE NO EXCEL!!!! :)
Suppose you take a 21-year mortgage of $110000. The annual interest rate is 4%, and the...
Suppose you take a 21-year mortgage of $110000. The annual interest rate is 4%, and the annual APR is 4.24%. Compounding done on yearly basis. Loan payments are made annually. Calculate the amortized fees and expenses for this loan (in dollars, provide your answer with $1 precision).
Suppose you take a 27-year mortgage of $280000. The annual interest rate is 4%, and the...
Suppose you take a 27-year mortgage of $280000. The annual interest rate is 4%, and the annual APR is 4.6%. Compounding done on yearly basis. Loan payments are made annually. Calculate the amortized fees and expenses for this loan (in dollars, provide your answer with $1 precision).
You take out a 30-year $200,000 mortgage with a 4.5% mortgage rate. a. What are the...
You take out a 30-year $200,000 mortgage with a 4.5% mortgage rate. a. What are the month payments? b. How much of the first payment was interest and principal?  
Eight years ago you took out a $400,000, 30-year mortgage with an annual interest rate of...
Eight years ago you took out a $400,000, 30-year mortgage with an annual interest rate of 6 percent and monthly payments of $2,398.20. What is the outstanding balance on your current loan if you just make the 96th payment?
Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate...
Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 4%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Construct a mortgage amortization. (Do not round intermediate calculations. Round your answers to 2 decimal places.) c....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT