Janet just graduated from college, has a job she's scheduled to begin in 3 months and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working full-time. To do the trip, she's thinking of applying for a personal loan of $3500, and the bank she uses for her checking and savings account has offered her an interest rate of 24%. She has a goal of paying off the trip within two years, so she uses a Bankrate.com .loan calculator with a starting date of 2/22/22 and gets the following amortization schedule: Payment Dete Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Payment Principal $185.05 $115.05 $185.05 $117.35 $185.05 $119.70 $185.05 $122.09 $185.05 $124.53 $185.05 $127.02 $129.56 $132.15 $134.80 $137.49 $140.24 $143.05 $145.91 $148.83 $151.80 $154.84 $157.94 $161.10 $164.32 $167.60 $170.96 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $174.38 $177.86 $181.42 Interest $70.00 $67.70 $65.35 $62.96 $60.52 $58.03 $55.49 $52.89 $50.25 $47.55 $44.80 $42.00 $39,14 $36.22 $33.24 $30.21 $27.11 $23.95 $20.73 $17.44 $14.09 $10.67 $7.19 $3.63 Total intarest $70.00 $137.70 $203.05 $256.01 $326.53 $384.55 $440.04 $492.93 $543.18 $590.74 $635.54 $677.54 $716.68 $752.90 $786.15 $816.35 $843.46 $867.42 $888.15 $905.59 $919.68 $930.36 $937.54 $941.17 Balance $3,384.95 $3,267.60 $3,147.90nce; $3,025.81 $2,901.28 $2,774.26 $2,644.69 $2,512.54 $2,377.74 $2,240.25 $2,100.00 $1,956.95 $1,811.04 $1,662.22 $1,510.41 $1,355.57 $1,197.63 $1,036.54 24%2F 12 3500x 27 $872.22 $704.62 $533.66 $359.28 $181.42 $0.00 3520-payme Part I: Amortization Basics Answer the following questions using the amortization schedule above. 1. How much is Janet going to pay every month? 2. On Mar 1, 2022, how much of Janet's payment goes toward: a interest? b. principal? 3. Look at Janet's repayment on April 1, 2022. a. How do the interest and principal compare to what she paid in the previous month? b. Explain why this happened. 4. By the time Janet pays off her entire loan, a. How much interest will she have paid? b. How much will the trip have cost her in total? 5. Let's suppose Janet received a year-end bonus and can afford to pay $285.05 during March 2023 a. Rewrite the line of the amortization schedule for 3/1/2023 using her new payment. DATE 3/1/2023 PAYMENT PRINCIPAL INTEREST $285.05 TOTAL INTEREST BALANCE b. What will be the general impact on Janet's amortization schedule by making this single larger payment? Part II: Change Janet's Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in March 2023. You did it by hand, but the Bankrate calculator has a feature that allows you to adjust the entire schedule. 6. Using the Bankrate.com loan calculator, enter in the original loan amount, loan term, and interest rate. 7. Then, click on "Calculate" to get the monthly loan payment of $185.05. 8. Click "Show Amortization Schedule" and scroll down to the table. Make sure that the "Start Date" of the payment in the table is 02/22/2022. 9. Click on "ADD EXTRA PAYMENTS" under the blue Calculate button. Add an extra one-time payment of $100 in March 2023 and click the blue button "APPLY EXTRA PAYMENTS." 10. Now, scroll down to March 2023 in the amortization table. You should see that there is now a one-time payment of $285.05 for that month. a. How did the extra, one-time payment of $100 affect the total interest Janet pays on the loan? 40 b. What was the impact on the number of months it will take Janet to pay off her loan? 11. This new calculation has Janet curious -- if she'd been making $285.05 payments for the entire duration of the loan", a. what would be the impact on the total interest Janet would have paid? b. What would be the impact on the number of months to pay off the loan? "When using the calculator for question 7, be sure to take off the extra $100 payment in Mar 2023; otherwise, she'd be paying $385.05 that month. 12. Reset Janet's loan back to $3500, 24% interest, but pretend she decided from the start that her pay-off goal was 4 years instead of 2. a. What is Janet's new monthly payment? b. What's the impact on the total interest she'll pay? c. Look at the very first payment month. How does the amount of her payment that is applied to interest compare with the amount applied to the principal balance? d. Explain how your observation in part c impacts the total amount of interest Janet will pay over the life of the loan. 13. What would be the benefit of taking a longer time to pay back your loan (ex: 4 years instead of 2)? Part III: In Summary 14. What advice would you give Janet as she tries to decide how to structure this loan to finance her trip to South America? 15. If a friend who'd never heard of amortization before asked you to explain how loan payments work, what would you say? 16. Challenge question: Home mortgages use amortization schedules, but the principal balance might be 10 or 100 times larger than Janet's $3500 trip. They're typically paid back over a period of 30 years at a much lower interest rate (~4%). Explain what you think that amortization schedule might look like. Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working full-time. To do the trip, she's thinking of applying for a personal loan of $3500, and the bank she uses for her checking and savings account has offered her an interest rate of 24%. She has a goal of paying off the trip within two years, so she uses a Bankrate.com .loan calculator with a starting date of 2/22/22 and gets the following amortization schedule: Payment Dete Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Payment Principal $185.05 $115.05 $185.05 $117.35 $185.05 $119.70 $185.05 $122.09 $185.05 $124.53 $185.05 $127.02 $129.56 $132.15 $134.80 $137.49 $140.24 $143.05 $145.91 $148.83 $151.80 $154.84 $157.94 $161.10 $164.32 $167.60 $170.96 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $174.38 $177.86 $181.42 Interest $70.00 $67.70 $65.35 $62.96 $60.52 $58.03 $55.49 $52.89 $50.25 $47.55 $44.80 $42.00 $39,14 $36.22 $33.24 $30.21 $27.11 $23.95 $20.73 $17.44 $14.09 $10.67 $7.19 $3.63 Total intarest $70.00 $137.70 $203.05 $256.01 $326.53 $384.55 $440.04 $492.93 $543.18 $590.74 $635.54 $677.54 $716.68 $752.90 $786.15 $816.35 $843.46 $867.42 $888.15 $905.59 $919.68 $930.36 $937.54 $941.17 Balance $3,384.95 $3,267.60 $3,147.90nce; $3,025.81 $2,901.28 $2,774.26 $2,644.69 $2,512.54 $2,377.74 $2,240.25 $2,100.00 $1,956.95 $1,811.04 $1,662.22 $1,510.41 $1,355.57 $1,197.63 $1,036.54 24%2F 12 3500x 27 $872.22 $704.62 $533.66 $359.28 $181.42 $0.00 3520-payme Part I: Amortization Basics Answer the following questions using the amortization schedule above. 1. How much is Janet going to pay every month? 2. On Mar 1, 2022, how much of Janet's payment goes toward: a interest? b. principal? 3. Look at Janet's repayment on April 1, 2022. a. How do the interest and principal compare to what she paid in the previous month? b. Explain why this happened. 4. By the time Janet pays off her entire loan, a. How much interest will she have paid? b. How much will the trip have cost her in total? 5. Let's suppose Janet received a year-end bonus and can afford to pay $285.05 during March 2023 a. Rewrite the line of the amortization schedule for 3/1/2023 using her new payment. DATE 3/1/2023 PAYMENT PRINCIPAL INTEREST $285.05 TOTAL INTEREST BALANCE b. What will be the general impact on Janet's amortization schedule by making this single larger payment? Part II: Change Janet's Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in March 2023. You did it by hand, but the Bankrate calculator has a feature that allows you to adjust the entire schedule. 6. Using the Bankrate.com loan calculator, enter in the original loan amount, loan term, and interest rate. 7. Then, click on "Calculate" to get the monthly loan payment of $185.05. 8. Click "Show Amortization Schedule" and scroll down to the table. Make sure that the "Start Date" of the payment in the table is 02/22/2022. 9. Click on "ADD EXTRA PAYMENTS" under the blue Calculate button. Add an extra one-time payment of $100 in March 2023 and click the blue button "APPLY EXTRA PAYMENTS." 10. Now, scroll down to March 2023 in the amortization table. You should see that there is now a one-time payment of $285.05 for that month. a. How did the extra, one-time payment of $100 affect the total interest Janet pays on the loan? 40 b. What was the impact on the number of months it will take Janet to pay off her loan? 11. This new calculation has Janet curious -- if she'd been making $285.05 payments for the entire duration of the loan", a. what would be the impact on the total interest Janet would have paid? b. What would be the impact on the number of months to pay off the loan? "When using the calculator for question 7, be sure to take off the extra $100 payment in Mar 2023; otherwise, she'd be paying $385.05 that month. 12. Reset Janet's loan back to $3500, 24% interest, but pretend she decided from the start that her pay-off goal was 4 years instead of 2. a. What is Janet's new monthly payment? b. What's the impact on the total interest she'll pay? c. Look at the very first payment month. How does the amount of her payment that is applied to interest compare with the amount applied to the principal balance? d. Explain how your observation in part c impacts the total amount of interest Janet will pay over the life of the loan. 13. What would be the benefit of taking a longer time to pay back your loan (ex: 4 years instead of 2)? Part III: In Summary 14. What advice would you give Janet as she tries to decide how to structure this loan to finance her trip to South America? 15. If a friend who'd never heard of amortization before asked you to explain how loan payments work, what would you say? 16. Challenge question: Home mortgages use amortization schedules, but the principal balance might be 10 or 100 times larger than Janet's $3500 trip. They're typically paid back over a period of 30 years at a much lower interest rate (~4%). Explain what you think that amortization schedule might look like. Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working full-time. To do the trip, she's thinking of applying for a personal loan of $3500, and the bank she uses for her checking and savings account has offered her an interest rate of 24%. She has a goal of paying off the trip within two years, so she uses a Bankrate.com .loan calculator with a starting date of 2/22/22 and gets the following amortization schedule: Payment Dete Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Payment Principal $185.05 $115.05 $185.05 $117.35 $185.05 $119.70 $185.05 $122.09 $185.05 $124.53 $185.05 $127.02 $129.56 $132.15 $134.80 $137.49 $140.24 $143.05 $145.91 $148.83 $151.80 $154.84 $157.94 $161.10 $164.32 $167.60 $170.96 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $174.38 $177.86 $181.42 Interest $70.00 $67.70 $65.35 $62.96 $60.52 $58.03 $55.49 $52.89 $50.25 $47.55 $44.80 $42.00 $39,14 $36.22 $33.24 $30.21 $27.11 $23.95 $20.73 $17.44 $14.09 $10.67 $7.19 $3.63 Total intarest $70.00 $137.70 $203.05 $256.01 $326.53 $384.55 $440.04 $492.93 $543.18 $590.74 $635.54 $677.54 $716.68 $752.90 $786.15 $816.35 $843.46 $867.42 $888.15 $905.59 $919.68 $930.36 $937.54 $941.17 Balance $3,384.95 $3,267.60 $3,147.90nce; $3,025.81 $2,901.28 $2,774.26 $2,644.69 $2,512.54 $2,377.74 $2,240.25 $2,100.00 $1,956.95 $1,811.04 $1,662.22 $1,510.41 $1,355.57 $1,197.63 $1,036.54 24%2F 12 3500x 27 $872.22 $704.62 $533.66 $359.28 $181.42 $0.00 3520-payme Part I: Amortization Basics Answer the following questions using the amortization schedule above. 1. How much is Janet going to pay every month? 2. On Mar 1, 2022, how much of Janet's payment goes toward: a interest? b. principal? 3. Look at Janet's repayment on April 1, 2022. a. How do the interest and principal compare to what she paid in the previous month? b. Explain why this happened. 4. By the time Janet pays off her entire loan, a. How much interest will she have paid? b. How much will the trip have cost her in total? 5. Let's suppose Janet received a year-end bonus and can afford to pay $285.05 during March 2023 a. Rewrite the line of the amortization schedule for 3/1/2023 using her new payment. DATE 3/1/2023 PAYMENT PRINCIPAL INTEREST $285.05 TOTAL INTEREST BALANCE b. What will be the general impact on Janet's amortization schedule by making this single larger payment? Part II: Change Janet's Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in March 2023. You did it by hand, but the Bankrate calculator has a feature that allows you to adjust the entire schedule. 6. Using the Bankrate.com loan calculator, enter in the original loan amount, loan term, and interest rate. 7. Then, click on "Calculate" to get the monthly loan payment of $185.05. 8. Click "Show Amortization Schedule" and scroll down to the table. Make sure that the "Start Date" of the payment in the table is 02/22/2022. 9. Click on "ADD EXTRA PAYMENTS" under the blue Calculate button. Add an extra one-time payment of $100 in March 2023 and click the blue button "APPLY EXTRA PAYMENTS." 10. Now, scroll down to March 2023 in the amortization table. You should see that there is now a one-time payment of $285.05 for that month. a. How did the extra, one-time payment of $100 affect the total interest Janet pays on the loan? 40 b. What was the impact on the number of months it will take Janet to pay off her loan? 11. This new calculation has Janet curious -- if she'd been making $285.05 payments for the entire duration of the loan", a. what would be the impact on the total interest Janet would have paid? b. What would be the impact on the number of months to pay off the loan? "When using the calculator for question 7, be sure to take off the extra $100 payment in Mar 2023; otherwise, she'd be paying $385.05 that month. 12. Reset Janet's loan back to $3500, 24% interest, but pretend she decided from the start that her pay-off goal was 4 years instead of 2. a. What is Janet's new monthly payment? b. What's the impact on the total interest she'll pay? c. Look at the very first payment month. How does the amount of her payment that is applied to interest compare with the amount applied to the principal balance? d. Explain how your observation in part c impacts the total amount of interest Janet will pay over the life of the loan. 13. What would be the benefit of taking a longer time to pay back your loan (ex: 4 years instead of 2)? Part III: In Summary 14. What advice would you give Janet as she tries to decide how to structure this loan to finance her trip to South America? 15. If a friend who'd never heard of amortization before asked you to explain how loan payments work, what would you say? 16. Challenge question: Home mortgages use amortization schedules, but the principal balance might be 10 or 100 times larger than Janet's $3500 trip. They're typically paid back over a period of 30 years at a much lower interest rate (~4%). Explain what you think that amortization schedule might look like. Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working full-time. To do the trip, she's thinking of applying for a personal loan of $3500, and the bank she uses for her checking and savings account has offered her an interest rate of 24%. She has a goal of paying off the trip within two years, so she uses a Bankrate.com .loan calculator with a starting date of 2/22/22 and gets the following amortization schedule: Payment Dete Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Payment Principal $185.05 $115.05 $185.05 $117.35 $185.05 $119.70 $185.05 $122.09 $185.05 $124.53 $185.05 $127.02 $129.56 $132.15 $134.80 $137.49 $140.24 $143.05 $145.91 $148.83 $151.80 $154.84 $157.94 $161.10 $164.32 $167.60 $170.96 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $174.38 $177.86 $181.42 Interest $70.00 $67.70 $65.35 $62.96 $60.52 $58.03 $55.49 $52.89 $50.25 $47.55 $44.80 $42.00 $39,14 $36.22 $33.24 $30.21 $27.11 $23.95 $20.73 $17.44 $14.09 $10.67 $7.19 $3.63 Total intarest $70.00 $137.70 $203.05 $256.01 $326.53 $384.55 $440.04 $492.93 $543.18 $590.74 $635.54 $677.54 $716.68 $752.90 $786.15 $816.35 $843.46 $867.42 $888.15 $905.59 $919.68 $930.36 $937.54 $941.17 Balance $3,384.95 $3,267.60 $3,147.90nce; $3,025.81 $2,901.28 $2,774.26 $2,644.69 $2,512.54 $2,377.74 $2,240.25 $2,100.00 $1,956.95 $1,811.04 $1,662.22 $1,510.41 $1,355.57 $1,197.63 $1,036.54 24%2F 12 3500x 27 $872.22 $704.62 $533.66 $359.28 $181.42 $0.00 3520-payme Part I: Amortization Basics Answer the following questions using the amortization schedule above. 1. How much is Janet going to pay every month? 2. On Mar 1, 2022, how much of Janet's payment goes toward: a interest? b. principal? 3. Look at Janet's repayment on April 1, 2022. a. How do the interest and principal compare to what she paid in the previous month? b. Explain why this happened. 4. By the time Janet pays off her entire loan, a. How much interest will she have paid? b. How much will the trip have cost her in total? 5. Let's suppose Janet received a year-end bonus and can afford to pay $285.05 during March 2023 a. Rewrite the line of the amortization schedule for 3/1/2023 using her new payment. DATE 3/1/2023 PAYMENT PRINCIPAL INTEREST $285.05 TOTAL INTEREST BALANCE b. What will be the general impact on Janet's amortization schedule by making this single larger payment? Part II: Change Janet's Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in March 2023. You did it by hand, but the Bankrate calculator has a feature that allows you to adjust the entire schedule. 6. Using the Bankrate.com loan calculator, enter in the original loan amount, loan term, and interest rate. 7. Then, click on "Calculate" to get the monthly loan payment of $185.05. 8. Click "Show Amortization Schedule" and scroll down to the table. Make sure that the "Start Date" of the payment in the table is 02/22/2022. 9. Click on "ADD EXTRA PAYMENTS" under the blue Calculate button. Add an extra one-time payment of $100 in March 2023 and click the blue button "APPLY EXTRA PAYMENTS." 10. Now, scroll down to March 2023 in the amortization table. You should see that there is now a one-time payment of $285.05 for that month. a. How did the extra, one-time payment of $100 affect the total interest Janet pays on the loan? 40 b. What was the impact on the number of months it will take Janet to pay off her loan? 11. This new calculation has Janet curious -- if she'd been making $285.05 payments for the entire duration of the loan", a. what would be the impact on the total interest Janet would have paid? b. What would be the impact on the number of months to pay off the loan? "When using the calculator for question 7, be sure to take off the extra $100 payment in Mar 2023; otherwise, she'd be paying $385.05 that month. 12. Reset Janet's loan back to $3500, 24% interest, but pretend she decided from the start that her pay-off goal was 4 years instead of 2. a. What is Janet's new monthly payment? b. What's the impact on the total interest she'll pay? c. Look at the very first payment month. How does the amount of her payment that is applied to interest compare with the amount applied to the principal balance? d. Explain how your observation in part c impacts the total amount of interest Janet will pay over the life of the loan. 13. What would be the benefit of taking a longer time to pay back your loan (ex: 4 years instead of 2)? Part III: In Summary 14. What advice would you give Janet as she tries to decide how to structure this loan to finance her trip to South America? 15. If a friend who'd never heard of amortization before asked you to explain how loan payments work, what would you say? 16. Challenge question: Home mortgages use amortization schedules, but the principal balance might be 10 or 100 times larger than Janet's $3500 trip. They're typically paid back over a period of 30 years at a much lower interest rate (~4%). Explain what you think that amortization schedule might look like. Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working full-time. To do the trip, she's thinking of applying for a personal loan of $3500, and the bank she uses for her checking and savings account has offered her an interest rate of 24%. She has a goal of paying off the trip within two years, so she uses a Bankrate.com .loan calculator with a starting date of 2/22/22 and gets the following amortization schedule: Payment Dete Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Payment Principal $185.05 $115.05 $185.05 $117.35 $185.05 $119.70 $185.05 $122.09 $185.05 $124.53 $185.05 $127.02 $129.56 $132.15 $134.80 $137.49 $140.24 $143.05 $145.91 $148.83 $151.80 $154.84 $157.94 $161.10 $164.32 $167.60 $170.96 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $174.38 $177.86 $181.42 Interest $70.00 $67.70 $65.35 $62.96 $60.52 $58.03 $55.49 $52.89 $50.25 $47.55 $44.80 $42.00 $39,14 $36.22 $33.24 $30.21 $27.11 $23.95 $20.73 $17.44 $14.09 $10.67 $7.19 $3.63 Total intarest $70.00 $137.70 $203.05 $256.01 $326.53 $384.55 $440.04 $492.93 $543.18 $590.74 $635.54 $677.54 $716.68 $752.90 $786.15 $816.35 $843.46 $867.42 $888.15 $905.59 $919.68 $930.36 $937.54 $941.17 Balance $3,384.95 $3,267.60 $3,147.90nce; $3,025.81 $2,901.28 $2,774.26 $2,644.69 $2,512.54 $2,377.74 $2,240.25 $2,100.00 $1,956.95 $1,811.04 $1,662.22 $1,510.41 $1,355.57 $1,197.63 $1,036.54 24%2F 12 3500x 27 $872.22 $704.62 $533.66 $359.28 $181.42 $0.00 3520-payme Part I: Amortization Basics Answer the following questions using the amortization schedule above. 1. How much is Janet going to pay every month? 2. On Mar 1, 2022, how much of Janet's payment goes toward: a interest? b. principal? 3. Look at Janet's repayment on April 1, 2022. a. How do the interest and principal compare to what she paid in the previous month? b. Explain why this happened. 4. By the time Janet pays off her entire loan, a. How much interest will she have paid? b. How much will the trip have cost her in total? 5. Let's suppose Janet received a year-end bonus and can afford to pay $285.05 during March 2023 a. Rewrite the line of the amortization schedule for 3/1/2023 using her new payment. DATE 3/1/2023 PAYMENT PRINCIPAL INTEREST $285.05 TOTAL INTEREST BALANCE b. What will be the general impact on Janet's amortization schedule by making this single larger payment? Part II: Change Janet's Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in March 2023. You did it by hand, but the Bankrate calculator has a feature that allows you to adjust the entire schedule. 6. Using the Bankrate.com loan calculator, enter in the original loan amount, loan term, and interest rate. 7. Then, click on "Calculate" to get the monthly loan payment of $185.05. 8. Click "Show Amortization Schedule" and scroll down to the table. Make sure that the "Start Date" of the payment in the table is 02/22/2022. 9. Click on "ADD EXTRA PAYMENTS" under the blue Calculate button. Add an extra one-time payment of $100 in March 2023 and click the blue button "APPLY EXTRA PAYMENTS." 10. Now, scroll down to March 2023 in the amortization table. You should see that there is now a one-time payment of $285.05 for that month. a. How did the extra, one-time payment of $100 affect the total interest Janet pays on the loan? 40 b. What was the impact on the number of months it will take Janet to pay off her loan? 11. This new calculation has Janet curious -- if she'd been making $285.05 payments for the entire duration of the loan", a. what would be the impact on the total interest Janet would have paid? b. What would be the impact on the number of months to pay off the loan? "When using the calculator for question 7, be sure to take off the extra $100 payment in Mar 2023; otherwise, she'd be paying $385.05 that month. 12. Reset Janet's loan back to $3500, 24% interest, but pretend she decided from the start that her pay-off goal was 4 years instead of 2. a. What is Janet's new monthly payment? b. What's the impact on the total interest she'll pay? c. Look at the very first payment month. How does the amount of her payment that is applied to interest compare with the amount applied to the principal balance? d. Explain how your observation in part c impacts the total amount of interest Janet will pay over the life of the loan. 13. What would be the benefit of taking a longer time to pay back your loan (ex: 4 years instead of 2)? Part III: In Summary 14. What advice would you give Janet as she tries to decide how to structure this loan to finance her trip to South America? 15. If a friend who'd never heard of amortization before asked you to explain how loan payments work, what would you say? 16. Challenge question: Home mortgages use amortization schedules, but the principal balance might be 10 or 100 times larger than Janet's $3500 trip. They're typically paid back over a period of 30 years at a much lower interest rate (~4%). Explain what you think that amortization schedule might look like. Janet just graduated from college, has a job she's scheduled to begin in 3 months and has decided to treat herself to 6 weeks of travel across South America before she buckles down and starts working full-time. To do the trip, she's thinking of applying for a personal loan of $3500, and the bank she uses for her checking and savings account has offered her an interest rate of 24%. She has a goal of paying off the trip within two years, so she uses a Bankrate.com .loan calculator with a starting date of 2/22/22 and gets the following amortization schedule: Payment Dete Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023 Feb 2023 Mar 2023 Apr 2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec 2023 Jan 2024 Feb 2024 Payment Principal $185.05 $115.05 $185.05 $117.35 $185.05 $119.70 $185.05 $122.09 $185.05 $124.53 $185.05 $127.02 $129.56 $132.15 $134.80 $137.49 $140.24 $143.05 $145.91 $148.83 $151.80 $154.84 $157.94 $161.10 $164.32 $167.60 $170.96 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $185.05 $174.38 $177.86 $181.42 Interest $70.00 $67.70 $65.35 $62.96 $60.52 $58.03 $55.49 $52.89 $50.25 $47.55 $44.80 $42.00 $39,14 $36.22 $33.24 $30.21 $27.11 $23.95 $20.73 $17.44 $14.09 $10.67 $7.19 $3.63 Total intarest $70.00 $137.70 $203.05 $256.01 $326.53 $384.55 $440.04 $492.93 $543.18 $590.74 $635.54 $677.54 $716.68 $752.90 $786.15 $816.35 $843.46 $867.42 $888.15 $905.59 $919.68 $930.36 $937.54 $941.17 Balance $3,384.95 $3,267.60 $3,147.90nce; $3,025.81 $2,901.28 $2,774.26 $2,644.69 $2,512.54 $2,377.74 $2,240.25 $2,100.00 $1,956.95 $1,811.04 $1,662.22 $1,510.41 $1,355.57 $1,197.63 $1,036.54 24%2F 12 3500x 27 $872.22 $704.62 $533.66 $359.28 $181.42 $0.00 3520-payme Part I: Amortization Basics Answer the following questions using the amortization schedule above. 1. How much is Janet going to pay every month? 2. On Mar 1, 2022, how much of Janet's payment goes toward: a interest? b. principal? 3. Look at Janet's repayment on April 1, 2022. a. How do the interest and principal compare to what she paid in the previous month? b. Explain why this happened. 4. By the time Janet pays off her entire loan, a. How much interest will she have paid? b. How much will the trip have cost her in total? 5. Let's suppose Janet received a year-end bonus and can afford to pay $285.05 during March 2023 a. Rewrite the line of the amortization schedule for 3/1/2023 using her new payment. DATE 3/1/2023 PAYMENT PRINCIPAL INTEREST $285.05 TOTAL INTEREST BALANCE b. What will be the general impact on Janet's amortization schedule by making this single larger payment? Part II: Change Janet's Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in March 2023. You did it by hand, but the Bankrate calculator has a feature that allows you to adjust the entire schedule. 6. Using the Bankrate.com loan calculator, enter in the original loan amount, loan term, and interest rate. 7. Then, click on "Calculate" to get the monthly loan payment of $185.05. 8. Click "Show Amortization Schedule" and scroll down to the table. Make sure that the "Start Date" of the payment in the table is 02/22/2022. 9. Click on "ADD EXTRA PAYMENTS" under the blue Calculate button. Add an extra one-time payment of $100 in March 2023 and click the blue button "APPLY EXTRA PAYMENTS." 10. Now, scroll down to March 2023 in the amortization table. You should see that there is now a one-time payment of $285.05 for that month. a. How did the extra, one-time payment of $100 affect the total interest Janet pays on the loan? 40 b. What was the impact on the number of months it will take Janet to pay off her loan? 11. This new calculation has Janet curious -- if she'd been making $285.05 payments for the entire duration of the loan", a. what would be the impact on the total interest Janet would have paid? b. What would be the impact on the number of months to pay off the loan? "When using the calculator for question 7, be sure to take off the extra $100 payment in Mar 2023; otherwise, she'd be paying $385.05 that month. 12. Reset Janet's loan back to $3500, 24% interest, but pretend she decided from the start that her pay-off goal was 4 years instead of 2. a. What is Janet's new monthly payment? b. What's the impact on the total interest she'll pay? c. Look at the very first payment month. How does the amount of her payment that is applied to interest compare with the amount applied to the principal balance? d. Explain how your observation in part c impacts the total amount of interest Janet will pay over the life of the loan. 13. What would be the benefit of taking a longer time to pay back your loan (ex: 4 years instead of 2)? Part III: In Summary 14. What advice would you give Janet as she tries to decide how to structure this loan to finance her trip to South America? 15. If a friend who'd never heard of amortization before asked you to explain how loan payments work, what would you say? 16. Challenge question: Home mortgages use amortization schedules, but the principal balance might be 10 or 100 times larger than Janet's $3500 trip. They're typically paid back over a period of 30 years at a much lower interest rate (~4%). Explain what you think that amortization schedule might look like.
Expert Answer:
Answer rating: 100% (QA)
1 How much is Janet going to pay every month Janet is going to pay 18505 every month 2 On Mar 1 2022 the breakdown of Janets payment is as follows a The interest portion is 7000 b The principal portio... View the full answer
Related Book For
Construction accounting and financial management
ISBN: 978-0135017111
2nd Edition
Authors: Steven j. Peterson
Posted Date:
Students also viewed these finance questions
-
Janet Wilhitehas just graduated from college and needs to buy a car to commute to work. She estimates that she can afford to pay about $450 per month for a loan or lease and has about $2,000 in...
-
Janet just graduated from a womens college in Mississippi with a degree in business administration, and she is about to start a new job with a large financial services firm based in Tampa, Florida....
-
Your 23 years old client just graduated from college and started a job with monthly salary of $5,000 per month. He wants to retire when he is 60 years old and wants to start saving for retirement...
-
Consider the following independent situations found during audit testing of Faran Ltd, which has a balance date of 30 June 2019. Assume that all the situations are material. (i)Recent industrial...
-
A gas mixture is found to contain two diatomic A and B species for which the partial pressures of both are 0.05065MPa (0.5atm). This mixture is to be enriched in the partial pressure of the A species...
-
In Section 12.4, we presented a formula for V(0 + 1x*) and a CI for 0 + 1x*. Taking x* = 0 gives (20 and a CI for 0. Use the data of Example 12.11 to calculate the estimated standard deviation of 0...
-
Bierko Company is considering two different, mutually exclusive capital expenditure proposals. Project A will cost \($395,000\), has an expected useful life of 10 years, a salvage value of zero, and...
-
a. Prepare a cross tabulation of the data on Industry (rows) and Brand Revenue ($ billions). Use class intervals of 25 starting at 0 for Brand Revenue ($ billions). b. Prepare a frequency...
-
Question 31 Points 2 What is the third step in the construction of congruent line segment to the given line segment AB? Set the compass to the length of the original line segment. Without changing...
-
Perot Corporation is developing a new CPU chip based on a new type of technology. Its new chip, the Patay2 chip, will take two years to develop. However, because other chip manufacturers will be able...
-
Using the disk method, find the volumes of the following solids of revolution: 1 (a) y=z, z=0, y = 1, rotated around the z-axis; (b) y, z=2, y = 3, rotated around the z-axis; (c) y=y, y=1, rotated...
-
The managing director of a growing private limited company stated: All these accounting concepts and standards seem like a lot of red tape to me, and weve got financial accountants and management...
-
Financial statements are produced each year by businesses, using prescribed formats. Should major plcs be allowed to reflect their individuality in their financial statements?
-
Accounting standards in general are reasonably unambiguous. Are there any major areas where accountants may disagree in balance sheet accounting?
-
Wembley Stadium II (the Football Associations replacement for the original iconic Wembley Stadium) was planned to open in 2003 but due to numerous problems financing the construction, problems in the...
-
(i) Name each of the books of account and ledgers in an accounting system. (ii) What are they used for?
-
Please help. Moving to another question will save this response. Question A company uses special journals for sales, purchases, cash receipts, cash payments, and uses a general journal. Match each...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Determine the payback period without interest for Problem 6. If the maximum allowable payback period without interest for your company is four years, should your company purchase the loader? In...
-
Using the chart of accounts in Figure 2-1, determine the changes to the balance sheet, income statement, job cost ledger, and equipment ledger as the result of paying the employees in Problem 2 for...
-
Determine the profit and overhead markup for a company that wants to maintain a 12% gross profit margin.
-
What is the natural temptation of a company that is required to pay out 100% of its earnings, in terms of how much earnings it records?
-
Is a manager who holds stock options in favour of a high-dividend policy? Why or why not?
-
Explain why a sharp increase in dividend often results in a decrease in the value of the companys borrowings.
Study smarter with the SolutionInn App