Question

2. James and Sky owe $24,000 on their student loans at an interest rate of 6.5%. The term is 20 years. Find their monthly payment.

3. Construct the first row of the amortization table for their student loans.
How much of their first payment goes toward interest?
How much of their first payment goes toward principal?
After making their first payment, what is the remaining balance?

4. Construct the second row of the amortization table for their student loans.
How much of their second payment goes toward interest?
How much of their second payment goes toward principal?
After making their second payment, what is the remaining balance?

5. Continue constructing the amortization table for their student loans until you have completed 12 rows of the table. What is the total amount of interest that Nick and Emily will pay on their student loans in the first year?

Answer 1

EMI = [P * I * (1+I)^N]/[(1+I)^N-1]

P =loan amount or Principal = 24000

I = Interest rate per month = .065/12
N = the number of installments = 20*12 =240

EMI = [24000*.065/12*(1+(.065/12))^240]/[(1+(.065/12))^240-1]

= [24000*.065/12*3.65644670189]/[3.65644670189-1]

= 475.338071246/2.65644670189

= 178.94

Payment	Opening Balance	Total Payment	interest paid	principal paid	end balance
1	24000.00	178.94	130.00	48.94	23951.06
2	23951.06	178.94	129.73	49.21	23901.85
3	23901.85	178.94	129.47	49.47	23852.38
4	23852.38	178.94	129.20	49.74	23802.64
5	23802.64	178.94	128.93	50.01	23752.63
6	23752.63	178.94	128.66	50.28	23702.35
7	23702.35	178.94	128.39	50.55	23651.80
8	23651.80	178.94	128.11	50.83	23600.98
9	23600.98	178.94	127.84	51.10	23549.88
10	23549.88	178.94	127.56	51.38	23498.50
11	23498.50	178.94	127.28	51.66	23446.84
12	23446.84	178.94	127.00	51.94	23394.90

Interest paid = Opening Balance*6.5%/12

Principal paid = Total Payment - Interest paid

End balance = Opening Balance - Principal paid

total amount of interest that Nick and Emily will pay on their student loans in the first year = 1542.18