Question

RETIRING STUDENT LOAN DEBT You have just started a new job with a significant increase in...

RETIRING STUDENT LOAN DEBT

You have just started a new job with a significant increase in salary above what you were earning when you originally negotiated your student loan repayment. The salary increase affords you the opportunity of increasing your monthly loan payments, thereby allowing you to retire the debt sooner than originally planned. You have six years remaining in the original payback plan on a loan of $55,000, with an interest rate of 2.4% and a monthly payment of $566.74. With your new salary, you can afford a monthly payment of $672. You also will be eligible for end-of-year bonuses.

PART 1:    Use the concepts and techniques that you have learned throughout the semester to create a worksheet containing a loan calculator and an amortization schedule. Determine how soon you can retire the student loan debt with the new higher monthly payments. Assuming that you earn yearly bonuses of $6,000 at the end of each year, when could you pay off the remaining balance on your student loan if you kept the lower monthly payment?

PART 2:   Would you opt for increasing your monthly payment, or using any earned bonus money to retire the debt early? Explain the reason for your choice.

PART 3:    Create a PowerPoint presentation in which you summarize the spreadsheet and your decisions based on the spreadsheet. Choose your design, layout, font size, colors, and number of slides for the presentation. Please remember that PowerPoint is a visual and NOT a Word document.

Considerations:

Assume this is a fixed rate loan.
Most loans do not penalize for pre-payment.
In order to arrive at your answers, you will need to determine the following:

  1. Number of years for the original loan. There is a financial function that will help you obtain this information. To locate it, select the Formulas tab, click on Insert Function in the Function Library section. In the pop-up, type a brief description of what you want to do in the box provided, and then click Go. Once you select the appropriate function, specify the required parameters.
  2. Amortization schedule of the original loan.  You will need to provide the Principal and Interest portion for each period (month). Follow the same steps specified in A above to locate the necessary functions. Please note that, as time goes on, the principal amount paid in each period (month) will increase while the interest amount paid will decrease. The principal portion plus the interest portion will always equal the total amount paid on each period (month).
  3. Amount of loan still owed. You can obtain this from the amortization table of the original loan and the information provided of the current period (month) of the loan.
  4. Period (month) on which you will complete paying the loan, based on the new payment amount. You may either develop an adjusted amortization schedule for the remaining payments, or find a function that provides the number of periods based on the remaining amount in the loan, the fixed interest rate, and the new monthly payments. Follow the same steps specified in A above to locate any functions you may need.
  5. Apply the annual bonus to the loan payments. Please follow prior steps to determine the impact of using your annual bonus to accelerate the payment of your loan.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

ANSWER:

As per the given Question

Student Loan $55,000
Interest Rate 2.40%
Monthly payments $566.74
New Monthly Payments $672
Student Loan Amortization Schedule -As per old monthly payments of $566.74
Month Interest Principal Balance
1 110 456.74 54543.26
2 109.09 457.65 54085.61
3 108.17 458.57 53627.04
4 107.25 459.49 53167.55
5 106.34 460.40 52707.15
6 105.41 461.33 52245.82
7 104.49 462.25 51783.57
8 103.57 463.17 51320.40
9 102.64 464.10 50856.30
10 101.71 465.03 50391.27
11 100.78 465.96 49925.32
12 99.85 466.89 49458.43
13 98.92 467.82 48990.60
14 97.98 468.76 48521.84
15 97.04 469.70 48052.15
16 96.10 470.64 47581.51
17 95.16 471.58 47109.94
18 94.22 472.52 46637.42
19 93.27 473.47 46163.95
20 92.33 474.41 45689.54
21 91.38 475.36 45214.18
22 90.43 476.31 44737.87
23 89.48 477.26 44260.60
24 88.52 478.22 43782.38
25 87.56 479.18 43303.21
26 86.61 480.13 42823.07
27 85.65 481.09 42341.98
28 84.68 482.06 41859.92
29 83.72 483.02 41376.90
30 82.75 483.99 40892.92
31 81.79 484.95 40407.96
32 80.82 485.92 39922.04
33 79.84 486.90 39435.14
34 78.87 487.87 38947.27
35 77.89 488.85 38458.43
36 76.92 489.82 37968.61
37 75.94 490.80 37477.80
38 74.96 491.78 36986.02
[Because of the word limit constraint I am skipping the further table. By following the same
calculation you can prepare the table upto 108 months where the loan will be fully repaid.]
So Old Monthly payment plan would require 108 months i.e. 9 years to repay the loan
As the question specifies, after 3 years of making the payments you have a salary hike
and so you have increased your monthly loan repayment installment to $672.
After 3 years new loan amortization schedule will be as:
Student Loan Amortization Schedule -As per new monthly payments
Month Interest Principal Balance
37 75.94 596.06 37372.54
38 74.75 597.25 36775.29
39 73.55 598.45 36176.84
40 72.35 599.65 35577.19
41 71.15 600.85 34976.35
42 69.95 602.05 34374.30
43 68.75 603.25 33771.05
44 67.54 604.46 33166.59
45 66.33 605.67 32560.92
46 65.12 606.88 31954.04
47 63.91 608.09 31345.95
48 62.69 609.31 30736.64
49 61.47 610.53 30126.12
50 60.25 611.75 29514.37
51 59.03 612.97 28901.40
52 57.80 614.20 28287.20
53 56.57 615.43 27671.78
54 55.34 616.66 27055.12
55 54.11 617.89 26437.23
56 52.87 619.13 25818.10
57 51.64 620.36 25197.74
58 50.40 621.60 24576.14
59 49.15 622.85 23953.29
60 47.91 624.09 23329.19
61 46.66 625.34 22703.85
62 45.41 626.59 22077.26
63 44.15 627.85 21449.42
64 42.90 629.10 20820.31
65 41.64 630.36 20189.95
66 40.38 631.62 19558.33
67 39.12 632.88 18925.45
68 37.85 634.15 18291.30
69 36.58 635.42 17655.88
70 35.31 636.69 17019.20
71 34.04 637.96 16381.23
72 32.76 639.24 15742.00
73 31.48 640.52 15101.48
74 30.20 641.80 14459.68
75 28.92 643.08 13816.60
76 27.63 644.37 13172.24
77 26.34 645.66 12526.58
78 25.05 646.95 11879.63
79 23.76 648.24 11231.39
80 22.46 649.54 10581.86
81 21.16 650.84 9931.02
82 19.86 652.14 9278.88
83 18.56 653.44 8625.44
84 17.25 654.75 7970.69
85 15.94 656.06 7314.63
86 14.63 657.37 6657.26
87 13.31 658.69 5998.58
88 12.00 660.00 5338.57
89 10.68 661.32 4677.25
90 9.35 313.76 4363.49
91 8.73 313.76 4049.73
92 8.10 313.76 3735.97
93 7.47 313.76 3422.21
94 6.84 313.76 3108.45
95 6.22 313.76 2794.69
96 5.59 313.76 2480.93
97 4.96 313.76 2167.17
98 4.33 313.76 1853.41
99 3.71 313.76 1539.65
100 3.08 313.76 1225.89
101 2.45 313.76 912.13
102 1.82 313.76 598.37
103 1.20 313.76 284.61
104 0.57 284.61 0.00
Total Time required to repay the loan is 104 months i.e. 8 years & 8 months
From this it is clear that with new higher monthly payment you can repay the loan early by
4 months only.

With the help of this you can solve other parts.

Thank you for the Question.........kindly rate.....it helps me a lot

Add a comment
Know the answer?
Add Answer to:
RETIRING STUDENT LOAN DEBT You have just started a new job with a significant increase in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • MMS Corp borrows $1,650,000 today for a new building. The loan is an equal principal payment...

    MMS Corp borrows $1,650,000 today for a new building. The loan is an equal principal payment loan with an APR of 6.5% compounded monthly. Payments are due monthly and the term of the loan is 9 years. a) The interest component of the payment due in month 16 is? b) The payment due in month 16 is? c)The current portion of debt in month 16 is?

  • Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360...

    Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below): Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $465.71 per month? Note: Enter the...

  • You have $50,000 in student loans. You set up a plan to repay this debt with...

    You have $50,000 in student loans. You set up a plan to repay this debt with monthly payments over the next 15 years (so 180 total payments). Your first payment will be in one month, and you believe with raises at work that each payment can be 0.2% higher than the previous one (so, for example, if your first payment is $100, your second month payment would be $100.20). If your monthly interest rate on this loan is 0.4%, what...

  • 13. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward...

    13. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward the purchase of a home at 6% APR. The amortization schedule of your mortgage is set in the monthly payments for the next 30 years. A) What is the monthly loan payment?   B) What is the balance of the loan after 20 years of loan payments?     C) From the previous mortgage loan question, what will be the principal and the total interest that you...

  • 3. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward...

    3. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward the purchase of a home at 6% APR. The amortization schedule of your mortgage is set in the monthly payments for the next 30 years. A) What is the monthly loan payment?   B) What is the balance of the loan after 20 years of loan payments?         C) From the previous mortgage loan question, what will be the principal and the total interest that...

  • Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for...

    Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for $27,000. You pay the 3% tax of $810 up front and put down $5,000. The dealer offers a simple interest installment loan with an annual rate of 5% for 3 years. The projected resale value of the car after 2 years is $17,000. Compute the loan value and monthly loan payments. (10 pts) Create a monthly amortization schedule over the entire loan period. (10...

  • QUESTION 6 You have just obtained home financing from a bank. The principal amount is RM750,000...

    QUESTION 6 You have just obtained home financing from a bank. The principal amount is RM750,000 and the loan is to be repaid over a period of 20 years via equal end-of-the-month monthly installment payments. The bank charges an annual nominal rate of 6.6%. The calculations are based on the concept of amortization. Required: i. Calculate the monthly installment payment amount. ii. How much of the third monthly installment payment will go towards the repayment of principal? iii. How much...

  • 1.                 You have just purchased a new house and taken a mortgage for $100,000. The interest rate...

    1.                 You have just purchased a new house and taken a mortgage for $100,000. The interest rate is 12% compounded monthly and you will make payments for 25 years. a)     Find the size of the monthly payment. b)     The bank has a policy of rounding the payments up to the next cent. Find the new monthly payment and compute a new n. c)     What was the balance of the loan after three periods? d)     How much of your third payment was Principal?         Interest? e)     How much did...

  • Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual...

    Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of...

  • The interest rate for the first five years of an $100,000 mortgage loan is 9.4% compounded...

    The interest rate for the first five years of an $100,000 mortgage loan is 9.4% compounded semiannually. Monthly payments are calculated using a 20-year amortization. a. What will be the principal balance at the end of the five-year term? (Do not round intermediate calculations and round your final answer to 2 decimal places.)   Principal balance $      b. What will be the monthly payments if the loan is renewed at 6.8% compounded semiannually (and the original amortization period is continued)?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT