Question

In: Statistics and Probability

my question is about 3.2.13 which is A loan of amount L is to be repaid...

my question is about 3.2.13 which is

A loan of amount L is to be repaid by n payments, starting one period after the loan is made, with interest at rate I per period. Two repayment schemes are considered:

i) level payments for the lifetime of the loan;

ii) each payment consists of principal repaid of L/n plus interest on the previous outstanding balance.

Find the total interest repaid under each scheme and show algebraically that the interest paid under scheme (i) is larger than that paid under scheme (ii).

Show that for each t = 1, 2, . . . , n − 1, OBt is larger under scheme (i) than under scheme (ii).

Verify algebraically that L is the present value at the time of the loan, at rate of interest i per payment period, of all payments made under scheme (ii).

Solutions

Expert Solution

solution:

Lets L (Loan amount) be $1,000,000 and i (rate of interest ) be 10% per annum and N (no. of periods) be 5 years

NOW, there are two ways in which the repayment loan can be done:

(i) level payments (Equal) for the lifetime of the loan, or

(ii) Each payment which consists of equal principal payments and interest on the outstanding balance

Case (I) - level payments

the amount of equal payments, is given by A = L / sum of annuity factors

where, A = annual level payments, L = Loan amount

NOW sum of annuity factors can be calculated by present value of 10% interest for 5 years = 3.79079

therefore, A = $1,000.000/3.79079 = $263,797 per annum

the total payments will be = 263,797*5 = $1,318,985

thus interest paid = $1. 318,985 -$1.000.000 = $3,18,985

Case (II) - Equal principal payments and interest on the outstanding balance

Equal annual principal payments in 5 years can be made by = $1,000,000/5 = $200,000

therefore, total interest will be on the outstanding balances, so at the end of year 1 payment will be =

200,000 + 1,000,000 * 10% = 300,000

at the end of year 2 = 200,000 + 800,000 * 10% = 280,000

at the end of year 3 = 2,00,000 + 600,000 * 10% = 260,000

at the end of year 4 = 2,00,000 + 400,000 * 10% = 240,000

at the end of year 5 = 2,00,000 + 200,000 * 10% = 220,000

Thus, total payment = $1,300,000

Interest paid = $1,300,000 - $1,00,000 = $3,00,000

(A) Therefore, higher interest of $18,985 is paid in Case (i) as compared to Case (ii).

(B) Following is the schedule of payments for both the cases

case(i) payment Schedule

Year Outstanding at the beginning (A) Payment amount (B) Interest amount (C) Principal Amount (D) Outstanding at the end (E = A-D)
1 1,000,000 263,797 100,000 163,797 836,203
2 836,203 263,797 83,620 180,177 656,026
3 656,026 263,797 65,603 198,194 457,832
4 457,832 263,797 45,783 218,014 239818
5 239818 263,797 23979 239818 0

   Case (iI) Payment Schedule

Year Outstanding at the beginning (A) Payment amount (B) Interest amount (C) Principal Amount (D) Outstanding at the end (E = A-D)
1 1,000,000 300,000 100,000 200,000 800,000
2 800,000 280,000 80,000 200,000 600,000
3 600,000 260,000 60,000 200,000 400,000
4 400,000 240,000 40,000 200,000 200,000
5 200,000 220,000 20,000 200,000 0

thus, we can see that the outstanding amount in Case (i) is always higher than Case (ii)

(C) We know that in level payments, the sum of the present value of lease amounts paid is equal the loan value as presented in the table below

Year Payment Amount Interest rate factor @ 10% Present Value
1 263,797 0.9091 239,818
2 263,797 0.8264 218,002
3 263,797 0.7513 198,190
4 263,797 0.6830 180,173
5 263,797 0.6209 163,792
Total 1,318,958

999,974 or ~1000,000

please thumb up


Related Solutions

A loan of amount L is to be repaid by n(n > 1) payments, starting one...
A loan of amount L is to be repaid by n(n > 1) payments, starting one period after the loan is made, with interest at rate i per period. Two repayment schemes are considered: (i) level payments for the lifetime of the loan; (ii) each payment consists of principal repaid of L n plus interest on the previous outstanding balance. (a) Find the total interest repaid under each scheme and show algebraically that the interest paid under scheme (i) is...
A loan of amount $17820 is to be repaid in payments that each consist of a...
A loan of amount $17820 is to be repaid in payments that each consist of a principal repayment of $540 plus the interest on the previous outstanding balance. What is the total interest paid if the interest per payment period is 2.1%?
A loan L is repaid with annual payments of $500, $400,$300, and $200 at the end...
A loan L is repaid with annual payments of $500, $400,$300, and $200 at the end of each year using a sinking fund method. If the loan has 10%effective interest rate per year and the sinking fund has 8% effective interest our year, find L
A loan of $1500 can be repaid in 18 months by paying the principal amount borrowed...
A loan of $1500 can be repaid in 18 months by paying the principal amount borrowed plus $225.00 interest. What was the rate of interest charged?
James has a loan of 10,000, which is to be repaid with 10 level annual payments...
James has a loan of 10,000, which is to be repaid with 10 level annual payments at an annual effective interest rate of 14.5%. Calculate the Macaulay duration of the loan using the 14.5% interest rate.
James has a loan of 10,000, which is to be repaid with 10 level annual payments...
James has a loan of 10,000, which is to be repaid with 10 level annual payments at an annual effective interest rate of 14.5%. Calculate the Macaulay duration of the loan using the 14.5% interest rate.
FINANCIAL MATH QUESTION 1 The loan of $ 20,000, received at 9% annual interest, is repaid...
FINANCIAL MATH QUESTION 1 The loan of $ 20,000, received at 9% annual interest, is repaid as follows: (a) after 2 months $ 5,000, (b) after 5 months, the amount X, (c) after 9 months $ 8,000. How much to pay after 5 months? Interest is calculated on the balance of the debt. Time calculation method "30/360".
Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid...
Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid over 48 months at an annual interest rate of 6%. What is your monthly payment? _$_ What is the total dollar amount of payments made over the life of this loan? $____ What is the total dollar amount of interest paid over the life of this loan? $___________ How many months will it take to pay off the loan if you pay an extra...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments,...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments, followed by a final smaller repayment, i.e., there are 11 repayments in total. The first of the level repayments will occur exactly 2 years from today, and each subsequent repayment (including the final smaller repayment) will occur exactly 1 year after the previous repayment. Explicitly, the final repayment will occur exactly 12 years from today. If the interest being charged on this loan is...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments,...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments, followed by a final smaller repayment, i.e., there are 11 repayments in total. The first of the level repayments will occur exactly 2 years from today, and each subsequent repayment (including the final smaller repayment) will occur exactly 1 year after the previous repayment. Explicitly, the final repayment will occur exactly 12 years from today. If the interest being charged on this loan is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT