Question

In: Accounting

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 is sold at market value at the end of year 5, is this loan sold at a discount?

use financial calculator, explain why please.

Solutions

Expert Solution

1. Principal value of loan (P) = $ 500000

Rate of interest (r) = 9% p.a. i.e, 0.75% per month (9/12).

No. of months (m) = 12*5 = 60

To compute Outstanding balance of loan at end of 5 years,

A = P(1+r)^n

=500000(1+0.0075)^60

= $ 782840.5

2. Since, at the end of year 5, the market value of interest has fallen to 6%, Loan value at mkt interest rate :

P=500000

n= 15 years*12 months= 130 months remaining for the loan to become repayable

r = 6/12 = 0.5% per month

A = P(1+r)^n

=500000(1+0.005)^130

= $ 956220

3. Loan value after 5 years at current interest rate :

P=500000

r=0.75% per month

n= 15 years*12 months.

A = P(1+r)^n

=500000(1+0.0075)^130

= $ 1320770

Hence, if the loan is sold at the end of 5 years at Market value of $ 956220 on the date of sale, compared to value of $ 1320770, it will be cosidered as sold for discount since the realising value (market value) would be lower than the value of loan in respect of current interest rate on loan at which it is purchased. Market value would be lower due to fall in interest rate in future, making the valuation of loan lower for the remaining 15 years, from the expiry of 5 years, compared to current committed rate of interest.


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
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
The following loan is fully amortizing. The loan is for $13,000 at 9% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 9% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.
suppose you took out a fully amortized $30,000 automobile loan to finance your purchase over 48...
suppose you took out a fully amortized $30,000 automobile loan to finance your purchase over 48 months at an APR of 3.5%. So far, you have made two years of payments in a timely fashion so the next payment will be your 25th. what percentage of the next payment will be allocated toward reducing the outstanding balance on the loan and what percentage will be interest?
When you purchased your home, you took out a fully amortizing mortgage for $250,000 with a...
When you purchased your home, you took out a fully amortizing mortgage for $250,000 with a 6.5% rate for a 30-year term. After 10 years, you have a chance to refinance for the remaining 20 years with a rate of 4.5%, fully amortizing over the remaining 20 years; however, you have to pay $4,500 up front for the new loan. Based on the fee and how much you will be saving per month, what is the effective annualized return (RATE...
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan...
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan has 4.0% APR with monthly payments of $1,800. How much do you owe on the loan today? The remaining loan balance is $________. (round to the nearest dollar) How much interest did you pay on the loan in the past year? The interest paid in year five was $______. (round to the nearest dollar) Over the entire period of 10 years, how much interest...
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.
If Lester Corporation takes out a bank loan to purchase a machine used in production and...
If Lester Corporation takes out a bank loan to purchase a machine used in production and everything else stays the same, its equity multiplier will ________, and its ROE will ________. options: decrease; increase decrease; decrease increase; increase increase; decrease
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT