Question

In: Finance

a 30 year loan of 1000 is repaid with payments at the end of each year....

a 30 year loan of 1000 is repaid with payments at the end of each year. Each of the first 10 payments equals the amount of interest due. Each of the next 10 payments equals 150% of the amount of interest due. Each of the last 10 payments is X. The lender charges interest at an effective annual rate of 10%. Calculate X.

please explain, having much trouble with this problem, Thanks!

Solutions

Expert Solution

For first 10 years the loan principal for not paid only interest was paid hence outstanding balance of loan is $ 1000 (because interest = payment).

For next 10 years the loan principal balance:

Years

Principal at beginning of the years = Outstanding Principal - Payment

Interest = 10% of Principal at beginning

Principal paid

Payment = 150%*Interest

Outstanding Principal

11

                      1,000.00

                         100.00

                           50.00

                         150.00

                         950.00

12

                         950.00

                           95.00

                           47.50

                         142.50

                         902.50

13

                         902.50

                           90.25

                           45.13

                         135.38

                         857.38

14

                         857.38

                           85.74

                           42.87

                         128.61

                         814.51

15

                         814.51

                           81.45

                           40.73

                         122.18

                         773.78

16

                         773.78

                           77.38

                           38.69

                         116.07

                         735.09

17

                         735.09

                           73.51

                           36.75

                         110.26

                         698.34

18

                         698.34

                           69.83

                           34.92

                         104.75

                         663.42

19

                         663.42

                           66.34

                           33.17

                           99.51

                         630.25

20

                         630.25

                           63.02

                           31.51

                           94.54

                         598.74

Loan balance at 20th year end = 598.74

Finding payment per period:

P = Loan balance =

$598.74

R = Rate =

10.000000%

N = Numbers of payment = Balance 10 years =

                     10

PMT = Payment = P x R x (1+R)^N / ((1+R)^N - 1) = X =

                97.44

Formula for calculating payment (working)

PMT = P x R x (1+R)^N / ((1+R)^N - 1)

PMT = 598.74*10%*(1+10%)^10/((1+10%)^10-1)

PMT = $97.44 (Rounding to nearest cent or two decimal places)

Payment or X = $ 97.44

Years

Principal at beginning of the years

Interest

Principal paid

Payment

Outstanding Principal

21

                         598.74

                           59.87

                           37.57

                           97.44

                         561.17

22

                         561.17

                           56.12

                           41.32

                           97.44

                         519.85

23

                         519.85

                           51.98

                           45.46

                           97.44

                         474.39

24

                         474.39

                           47.44

                           50.00

                           97.44

                         424.39

25

                         424.39

                           42.44

                           55.00

                           97.44

                         369.39

26

                         369.39

                           36.94

                           60.50

                           97.44

                         308.89

27

                         308.89

                           30.89

                           66.55

                           97.44

                         242.34

28

                         242.34

                           24.23

                           73.21

                           97.44

                         169.13

29

                         169.13

                           16.91

                           80.53

                           97.44

                           88.61

30

                           88.61

                              8.86

                           88.58

                           97.44

                              0.03


Related Solutions

A $1000 loan is being repaid with level payments at the end of each year for...
A $1000 loan is being repaid with level payments at the end of each year for 4 years using a sinking fund method. The loan has 10% effective interest per year and the sinking fund has 8% interest per year. Create a sinking fund table for this payment plan. Include a column for the period, interest paid that period, sinking fund deposit that period, interest earned in the sinking fund that period and the balance in the sinking fund at...
A 30-year loan of 1,000 is repaid with payments at the end of each year. Each...
A 30-year loan of 1,000 is repaid with payments at the end of each year. Each of the first ten payments equals the amount of interest due. Each of the next ten payments equals 150% of the amount of interst due. Each of the last ten payments is X. The lender charges interest at an annual effective rate of 10%. Calculate X.
1. A $1000 loan is being repaid by payments of $100 at the end of each...
1. A $1000 loan is being repaid by payments of $100 at the end of each quarter for as long as necessary, plus a smaller final payment. If the nominal rate of interest convertible quarterly is 16%, find the amount of principal and interest in the fourth payment. 2. A loan is being repaid with level payments at the end of each year for 20 years at 9% effective annual interest. In which payment are the principal and the interest...
A 10-year loan of 120,000 is to be repaid with payments at the end of each...
A 10-year loan of 120,000 is to be repaid with payments at the end of each month. Interest is at an annual effective rate of 6.00%. The first monthly payment is 800. Each additional payment will be k more than the previous month payment. Find k.
A loan of $5000 is repaid with annual payments at the end of each year of...
A loan of $5000 is repaid with annual payments at the end of each year of $1200,$800,$1300 and X. Assume the loan has 10% effective interest per year. a) Determine X b) Determine the amount of interest paid with the third payment.
A loan of $10,000 is being repaid with 10 payments at the end of each year,...
A loan of $10,000 is being repaid with 10 payments at the end of each year, where each payment includes equal amount of repayment of the principal and the interest at a rate of 5% based on the outstanding balance after the previous payment. Immediately after the loan was made, the right of the loan was sold at a price that yields an annual effective rate of 10%. Find the price paid for the right of the loan. (Answer: $8072.28)...
A loan is to be repaid in end of quarter payments of $1,000 each, with there...
A loan is to be repaid in end of quarter payments of $1,000 each, with there being 20 end of quarter payments total. The interest rate for the first two years is 6% convertible quarterly, and the interest rate for the last three years is 8% convertible quarterly. Find the outstanding loan balance right after the 6th payment.
A loan of 10000$ is to be repaid with annual payments, at the end of each...
A loan of 10000$ is to be repaid with annual payments, at the end of each year, for the next 20 years. For the rst 5 years the payments are k per year ; the second 5 years, 2k per year ; the third 5 years, 3k per year ; and the fourth 5 years, 4k per year. (a) Draw two timelines describing this series of payments. (b) For each of the timelines in (a), find an expression for k...
A 18 year loan is being repaid with level payments at the end of each month....
A 18 year loan is being repaid with level payments at the end of each month. The loan rate of interest is 15.6% compounded monthly. In which month is the interest portion approximately equal to 5 times principal the portion? Give an integer answer.
A loan of $20,000 is repaid through annual, end of year payments of $2,500 each. The...
A loan of $20,000 is repaid through annual, end of year payments of $2,500 each. The end of year final payment is reduced and the annual effective rate is 8%. Find the outstanding loan balance after $15,000 has been repaid.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT