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:
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
RETIRING STUDENT LOAN DEBT You have just started a new job with a significant increase in...
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 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 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 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 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 $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 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 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 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 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)?...