Question

In: Finance

A couple takes out a fully amortizing fixed rate thirty-year loan for $375,000. The couple makes...

A couple takes out a fully amortizing fixed rate thirty-year loan for $375,000. The couple makes monthly payments and the annual interest rate on the loan is 4.5%. The couple also pays 3 points in up- front fees to obtain the loan. (a) Calculate the loan’s APR [8 points] (b) Assuming a holding period of 12 years, calculate the loan’s EBC

Solutions

Expert Solution

Sol:

Loan amount = $375,000

Interest rate (r) = 4.5% (Monthly payment) = 4.5%/12 = 0.3745%

Period (n) = 30 years (Monthly) = 30 x 12 = 360

Fees for loan = 3% of $375,000 = $11,250

PMT = PV/ ((1-(1/(1+r)^n))/r)

PMT = 375000/ [(1-(1/(1+0.375%)^360))/0.375%]

PMT = 375000/ [(1-(1/(1.00375)^360))/0.00375]

PMT = 1900

Now total interest paid over 30 years = (1900 x 360) - 375000 = 309000

APR = ((Interest + fees ) / (n x Principal) x 12

APR = (309000 + 11250)/(30 x 375000 )

APR = 0.028467 or 2.85%

b) Assuming holding period of 12 years, loan’s EBC wil be as follows.

PMT = 375000/ ((1-(1/(1+0.375%)^144))/0.375%) = 3375

Total interest paid = (3375 x 144) - 375000 = 111000

Total finance cost (f) = 111000+11250 = 122250

Total amount paid (a) = 3375 x 144 = 486000

EBC = 2 x (f x 12) / (a x (n+1))

EBC = 2(122250 x 12)/(486000 x 145)

EBC = 2(1467000 / 70470000)

EBC = 0.0416 or 4.16%

Therefore APR will be 2.85% and EBC will be 4.16%


Related Solutions

A couple takes out a fully amortizing fixed rate thirty-year loan for $375,000. The couple makes...
A couple takes out a fully amortizing fixed rate thirty-year loan for $375,000. The couple makes monthly payments and the annual interest rate on the loan is 4.5%. The couple also pays 3 points in up- front fees to obtain the loan. (a) Calculate the loan’s APR [8 points] (b) Assuming a holding period of 12 years, calculate the loan’s EBC
To finance the purchase of a new home, a homebuyer takes-out a fully amortizing loan in...
To finance the purchase of a new home, a homebuyer takes-out a fully amortizing loan in the amount of $500,000 at 9% interest per year, compounded monthly, for a term of 20 years. 1. What is the outstanding balance of the loan at the end of 5 years? 2. At the end of year 5, the market rate of interest is 6%. What is the market value of the loan at the end of 5 years? 3. If this loan...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the original loan balance is remaining? Can you teach me how to do it on excel, please? I am confused on how to make it monthly compounding.
Solve using excel: A. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan...
Solve using excel: A. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 
 B. Assume you have taken out a partially amortizing loan for $325,000 that has a term of 7 years, but amortizes over 30 years. Calculate the balloon payment at maturity (Year 7) if the interest rate on...
Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%.
Show work through excel formulas: please actually show how you do it   on excel exactly! 1. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 
 A. $1,054.82 B. $120,603.78 C. $124,570.18 D. $124,875.56 2. Assume you have taken out a partially amortizing loan for $325,000 that has a term of...
Today, Malorie takes out a 30-year loan of $200,000, with a fixed interest rate of 4.5%...
Today, Malorie takes out a 30-year loan of $200,000, with a fixed interest rate of 4.5% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 30 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 4.5% will stay the same over the coming 30 years. (c) Calculate...
Today, Malorie takes out a 20-year loan of $200,000, with a fixed interest rate of 4.5%...
Today, Malorie takes out a 20-year loan of $200,000, with a fixed interest rate of 4.5% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 20 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 4.5% will stay the same over the coming 20 years. (b) Calculate...
Today, Malorie takes out a 10-year loan of $200,000, with a fixed interest rate of 5.7%...
Today, Malorie takes out a 10-year loan of $200,000, with a fixed interest rate of 5.7% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 10 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 5.7% will stay the same over the coming 10 years. (a) Calculate...
Today, Malorie takes out a 10-year loan of $200,000, with a fixed interest rate of 3.6%...
Today, Malorie takes out a 10-year loan of $200,000, with a fixed interest rate of 3.6% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 10 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 3.6% will stay the same over the coming 10 years. (a) Calculate...
Today, Malorie takes out a 10-year loan of $200,000, with a fixed interest rate of 3.6%...
Today, Malorie takes out a 10-year loan of $200,000, with a fixed interest rate of 3.6% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 10 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 3.6% will stay the same over the coming 10 years. (a) Calculate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT