Question

In: Finance

A young couple borrow $5,000 on the 1st September, agreeing to repay it as well as...

A young couple borrow $5,000 on the 1st September, agreeing to repay it as well as the interest charged over 36 months with 36 equal repayments, at the interest rate of 3%. No interest is charged for their 3 interest-free months, but their first repayment is required on the 1st of October.

a) Show all mathematical workings and formulas to calculate the repayment required to repay the loan and interest.

b) Calculate the individual monthly repayments required for all 36 months, displaying them in a table with headings: "Month", "Amount Owing", "Interest" and "Repayment". Show that this calculation method yields the same result as part a).

Solutions

Expert Solution

Assume Equal Monthly Repayments =X

First three months are interest Free.

Hence Principal Balance after 3 months (1st December)=5000-3X

Number of balance instalments =(36-3)=33

Interest rate per month =(3/12)%=0.25%=0.0025

Capital Recovery Factor (CAF)=(A/P,i,N)=(i*((1+i)^N))/(((1+i)^N)-1)

N=number of Payments =33

i=Interest Rate =0.25%=0.0025

CAF=(A/P,0.25%,33)= (0.0025*(1.0025^33))/((1.0025^33)-1)=0.031608

Amount of Monthly Equal Repayment =X=0.031608*(5000-3X)

X=0.031608*5000-0.031608*3*X=158.0403-0.094824X

X=158.0403-0.094824X

1.094824X=158.0403

X=158.0403/1.094824=144.35

Amount to be paid per month =$144.35(Rounded off to2 decimal place)

REPAYMENT SCHEDULE(Ending Balance of $0.08 is because of rounding off effect)

A

B

C=A*0.25%

D=B-C

E=A-D

Beginning

Monthly

First Three Months=$0

Ending

Month

Balance

Payment

Interest

Principal

Balance

1

$5,000

$144.35

$0

$144.35

$4,855.65

2

$4,855.65

$144.35

$0

$144.35

$4,711.30

3

$4,711.30

$144.35

$0

$144.35

$4,566.95

4

$4,566.95

$144.35

$11.42

$132.93

$4,434.02

5

$4,434.02

$144.35

$11.09

$133.26

$4,300.75

6

$4,300.75

$144.35

$10.75

$133.60

$4,167.15

7

$4,167.15

$144.35

$10.42

$133.93

$4,033.22

8

$4,033.22

$144.35

$10.08

$134.27

$3,898.96

9

$3,898.96

$144.35

$9.75

$134.60

$3,764.35

10

$3,764.35

$144.35

$9.41

$134.94

$3,629.41

11

$3,629.41

$144.35

$9.07

$135.28

$3,494.14

12

$3,494.14

$144.35

$8.74

$135.61

$3,358.52

13

$3,358.52

$144.35

$8.40

$135.95

$3,222.57

14

$3,222.57

$144.35

$8.06

$136.29

$3,086.28

15

$3,086.28

$144.35

$7.72

$136.63

$2,949.64

16

$2,949.64

$144.35

$7.37

$136.98

$2,812.66

17

$2,812.66

$144.35

$7.03

$137.32

$2,675.35

18

$2,675.35

$144.35

$6.69

$137.66

$2,537.68

19

$2,537.68

$144.35

$6.34

$138.01

$2,399.68

20

$2,399.68

$144.35

$6.00

$138.35

$2,261.33

21

$2,261.33

$144.35

$5.65

$138.70

$2,122.63

22

$2,122.63

$144.35

$5.31

$139.04

$1,983.59

23

$1,983.59

$144.35

$4.96

$139.39

$1,844.20

24

$1,844.20

$144.35

$4.61

$139.74

$1,704.46

25

$1,704.46

$144.35

$4.26

$140.09

$1,564.37

26

$1,564.37

$144.35

$3.91

$140.44

$1,423.93

27

$1,423.93

$144.35

$3.56

$140.79

$1,283.14

28

$1,283.14

$144.35

$3.21

$141.14

$1,142.00

29

$1,142.00

$144.35

$2.85

$141.50

$1,000.50

30

$1,000.50

$144.35

$2.50

$141.85

$858.65

31

$858.65

$144.35

$2.15

$142.20

$716.45

32

$716.45

$144.35

$1.79

$142.56

$573.89

33

$573.89

$144.35

$1.43

$142.92

$430.98

34

$430.98

$144.35

$1.08

$143.27

$287.70

35

$287.70

$144.35

$0.72

$143.63

$144.07

36

$144.07

$144.35

$0.36

$143.99

$0.08


Related Solutions

A young couple buying their first home borrow $65,000 for 30 years at 7.4%, compounded monthly,...
A young couple buying their first home borrow $65,000 for 30 years at 7.4%, compounded monthly, and make payments of $450.05. After 5 years, they are able to make a one-time payment of $2000 along with their 60th payment. (a) Find the unpaid balance immediately after they pay the extra $2000 and their 60th payment. (Round your answer to the nearest cent.) $ (b) How many regular payments of $450.05 will amortize the unpaid balance from part (a)? (Round your...
A young couple buying their first home borrow $50,000 for 30 years at 7.5%, compounded monthly,...
A young couple buying their first home borrow $50,000 for 30 years at 7.5%, compounded monthly, and make payments of $349.61. After 5 years, they are able to make a one-time payment of $2000 along with their 60th payment. (a) Find the unpaid balance immediately after they pay the extra $2000 and their 60th payment. (Round your answer to the nearest cent.) $ (b) How many regular payments of $349.61 will amortize the unpaid balance from part (a)? (Round your...
A young couple buying their first home borrow $65,000 for 30 years at 7.4%, compounded monthly,...
A young couple buying their first home borrow $65,000 for 30 years at 7.4%, compounded monthly, and make payments of $450.05. After 5 years, they are able to make a one-time payment of $2000 along with their 60th payment. (a) Find the unpaid balance immediately after they pay the extra $2000 and their 60th payment. (Round your answer to the nearest cent.) $   (b) How many regular payments of $450.05 will amortize the unpaid balance from part (a)? (Round your...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume that the interest portion remains level throughout...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume that the interest portion remains level throughout...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest...
A 20-year loan of 150,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of 9,000 will apply during the first ten years and a higher level payment will apply during the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing the principal into a sinking fund with an annual effective interest rate of 4%. (Assume that the interest portion remains level throughout...
a man borrows 100.000 euro at 10%compounded annually agreeing to repay the loan in 20 equal...
a man borrows 100.000 euro at 10%compounded annually agreeing to repay the loan in 20 equal annual payments how much of the original principal is still unpaid after he has made the tenth payment
If you borrow a principal amount of $11,778 and are required to repay the loan in...
If you borrow a principal amount of $11,778 and are required to repay the loan in ten equal installments of $2,000, what is the interest rate associated with the loan?
Consider a T-bond maturing in March 2020 with coupon payments on September 1st and March 1st....
Consider a T-bond maturing in March 2020 with coupon payments on September 1st and March 1st. Assume that the bond has $1000 par value, 10% coupon rate, and YTM = 12.5%. The bond is traded on December 13, 2013. What is the Accrued Interest? What is the full price? What is the flat price?
Consider a T-bond maturing in March 2020 with coupon payments on September 1st and March 1st....
Consider a T-bond maturing in March 2020 with coupon payments on September 1st and March 1st. Assume that the bond has $1000 par value, 10% coupon rate, and YTM = 12.5%. The bond is traded on December 13, 2013. What is the Accrued Interest? What is the Full price? What is the flat price?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT