Question

In: Finance

Loan Amount:               $20,000,000.00 Interest Rate:                6-3/4% Amortization:  &nbsp

Loan Amount:               $20,000,000.00

Interest Rate:                6-3/4%

Amortization:               30 years

Term:                           10 years

  1. Assume the above loan is interest only for the first three (3) years.
    1. What is the Annual Debt Service (ADS) in the first year?
    2. How much interest (cumulative) will have been paid at the end of year 3?
    3. How much principal will be due at maturity?
    4. How much interest will have been paid over the 10 year term?

Solutions

Expert Solution

Loan Amount $             20,000,000
Interest Rate 6.75%
Annual Interest =$20M*6.75%= $               1,350,000
Ans a Annual Debt Service = $               1,350,000
Ans b. As iterest is paid back each year , the
cumulative interest in 3 years = $               4,050,000
Ans c. After the initial interest only period of
3years the Principal due will be = $             20,000,000
After 10 years , the Principal due will be NIL
Ans d. Assuming Monthly payment of Installment
for remaining 7 years
Monthly Interest =6.75%/12=0.5625% per month
A= [i*P*(1+i)^n]/[(1+i)^n-1]
A = periodical installment=??
P=Loan amount =$20,000,000
i= interest rate per period=0.5625% per month
n=total no of payments=12*7=84
A=[0.5625%*20,000,000*1.005625^84]/(1.005625^84-1)
A=299,415.27
So Monthly Istallment to be paid = $            299,415.27
Total amount payable in 84 installments $             25,150,883
Less Principal Amount = $             20,000,000
So Interest paid over 7 years = $               5,150,883
Interest paid over 3 years interest only period= $               4,050,000
So Total Interest Paid over 10 years term= $              9,200,883

Related Solutions

Loan Amount:               $10,000,000.00 Interest Rate:                6-3/4% Amortization:  &nbsp
Loan Amount:               $10,000,000.00 Interest Rate:                6-3/4% Amortization:               30 years Term:                           10 years A homeowner obtains a $500,000.00 loan at an interest rate of 6-1/8% based on a 30 year amortization schedule. What is the monthly payment? What is the total amount of interest that would be paid over the life of the loan? Assume that after the 48th payment, the homeowner pays an additional $200.00 per month. At what month would the loan be paid in full? How many years...
Answer the questions below. Show all work. Loan Amount:       $10,000,000.00 Interest Rate:       6-3/4% Amortization:  ...
Answer the questions below. Show all work. Loan Amount:       $10,000,000.00 Interest Rate:       6-3/4% Amortization:       30 years Term:           10 years Assume the above loan is interest only for the first three (3) years. What is the Annual Debt Service (ADS) in the first year? How much interest (cumulative) will have been paid at the end of year 3? How much principal will be due at maturity? How much interest will have been paid over the 10...
Loan amortization schedule    Joan Messineo borrowed ​$40,000 at a 4​% annual rate of interest to be...
Loan amortization schedule    Joan Messineo borrowed ​$40,000 at a 4​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments a. Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of the​ equal, annual,​ end-of-year loan...
Consider a CPM loan in the amount of $150,000 with an interest rate of 4 percent...
Consider a CPM loan in the amount of $150,000 with an interest rate of 4 percent with a 15 year maturity. What will be the monthly payment on the loan? If this loan had a maturity of 25 years, what would be the monthly payment?
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?
Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years...
Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 60 month loan amortization schedule. How much is your total interest payment?
A loan amortization schedule allows you to see the amount you are paying towards interest and...
A loan amortization schedule allows you to see the amount you are paying towards interest and the outstanding balance of the loan. Since the amount of interest is based on the outstanding principal, you can compute the interest portion directly by multiplying the interest rate by the beginning of the period outstanding balance. When you subtract interest from the overall payment, you see the portion being applied towards the principal, which reduces the ending period outstanding balance, which hence becomes...
The amount of a loan is $100,000 with an interest rate of 8%. The life of...
The amount of a loan is $100,000 with an interest rate of 8%. The life of the loan is 4 years. Create a loan amortization table.
For a given interest rate and starting loan balance, a longer amortization will typically lead to:...
For a given interest rate and starting loan balance, a longer amortization will typically lead to: a. Higher payments and higher total interest paid. b. Higher payments and lower total interest paid. c. Lower payments and higher total interest paid. d. Lower payments and lower total interest paid Could you explain by formula?
1. Calculate the amortization period of a $500,000 loan, with an annual interest rate of 18%...
1. Calculate the amortization period of a $500,000 loan, with an annual interest rate of 18% requiring monthly payments of $7,716.56.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT