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.

Solutions

Expert Solution

PV of Annuity:

Annuity is series of cash flows that are deposited at regular intervals for specific period of time. Here cash flows are happened at the end of the period. PV of annuity is current value of cash flows to be received at regular intervals discounted at specified int rate or discount rate to current date.

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
r - Int rate per period
n - No. of periods

PV of annuity = Loan Amount

EMI = Cashflow

Particulars	Amount
PV Annuity	$ 500,000.00
Int Rate	1.500%
Cash Flow	$ 7,716.56

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
$ 500000 = $ 7716.56 * [ 1 - [ ( 1 + 0.015 ) ^ - n ] ] /0.015
0.97194 = [ 1 - [ ( 1.015 ) ^ - n ] ]
[ ( 1.015 ) ^ - n ] = 1 - 0.97194
[ ( 1.015 ) ^ - n ] = 0.02806

Take Log on both sides
Log [ ( 1.015 ) ^ - n ] = Log ( 0.02806)
Log( a^ b ) = b * Log (a )

-n * Log ( 1.015 ) = Log ( 0.02806)
-n * 0.00647 = -1.55191
-n = -1.55191 / 0.00647
n = 1.55191 / 0.00647
n = 239.86

I.e 240 Months or 20 Years

Pls comment, if anyfurther assistance is required.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question. Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.

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...

FIN220 Bank offers you a 5-year loan for 500,000 Baht at an annual interest rate of...

FIN220 Bank offers you a 5-year loan for 500,000 Baht at an annual interest rate of 5 percent, compounded monthly. What will your monthly loan payment be? 115,487.40 100,000.00 4,166.67 9,435.62

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment...

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment b) Calculate balloon payment c) Value at 12% yield d) Prepare an amortization table

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...

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 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 year term?

1. Construct an amortization schedule for a $1,000, 8% annual rate loan with 3 equal payments....

1. Construct an amortization schedule for a $1,000, 8% annual rate loan with 3 equal payments. The first payment will be made at the end of the1st year. Find the required annual payments A) $355.8 B) $367.2 C)$388.0 D)$390.7 2. Based on the information from Question 1, what’s the ending balance of the amortized loan at the end of the third year A)$0 B)$349.7 C)$388.3 D)$692.0 3. Based on the information from Question 1 and 2, calculate the total amount...

1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective...

1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective semi-annual rate, effective quarterly rate, effective monthly rate, effective weekly rate (1 year = 52 weeks), effective daily rate (1 year = 365 days). 1.b The annual interest rate is 8% with monthly compounding. Please calculate effective monthly rate, effective annual rate, effective semi-annual rate, effective quarterly rate.

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?

a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and...

a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and the loan calls for equal payments. How much interest is paid in the fifth year? How much interest is paid over the life of the loan? b)What is the present value of $2,625 per year at a discount rate of 8%, if the first payment is received six years from now and the last payment is received 20 years from now?

Subjects