2. James and Sky owe $24,000 on their student loans at an interest rate of 6.5%....

Free

70.2K

Verified Solution

Question

Finance

2. James and Sky owe $24,000 on their student loans at aninterest rate of 6.5%. The term is 20 years. Find their monthlypayment.
3. Construct the first row of the amortization table for theirstudent 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 remainingbalance?
4. Construct the second row of the amortization table for theirstudent 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 remainingbalance?
5. Continue constructing the amortization table for theirstudent loans until you have completed 12 rows of the table. Whatis the total amount of interest that Nick and Emily will pay ontheir student loans in the first year?

Answer & Explanation Solved by verified expert

4.3 Ratings (631 Votes)

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

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

2. James and Sky owe $24,000 on their student loans at aninterest rate of 6.5%. The term is 20 years. Find their monthlypayment.3. Construct the first row of the amortization table for theirstudent 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 remainingbalance?4. Construct the second row of the amortization table for theirstudent 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 remainingbalance?5. Continue constructing the amortization table for theirstudent loans until you have completed 12 rows of the table. Whatis the total amount of interest that Nick and Emily will pay ontheir student loans in the first year?