Amanda's current debt consists of three types of loans: a bank card, an auto loan and a department store card. She owes a total of $25,000 and her monthly payments sum to $521.77. The amount she owes, the monthly payment and the interest rates appear in the table below: Amanda is having a hard time meeting the monthly payments and is considering consolidating the three loans to reduce her total monthly payments. She has been offered two options. In both cases, she would borrow $25,000 to pay off her existing three loans leaving her with a single loan payment to a loan company. Option A: A \$25,000 home equity line of credit based on "7.8\% APR annualized over a 10 year term. The loan is amortized at 7.8% with monthly payments of $162.50. This reduces her monthly payments by $359.27. Option B: A $25,000 home equity loan based on " 7.8% APR amortized over a 10 year term with monthly payments of $300.68. This reduces her monthly payments by only $221.09. Here is the grading rubric for this project: - Project Presentation: 10 points (you need to type your work for this project, include the amortization schedules in the same file, and submit it all as one single .docx or pdf file) - Part I (Option A): 15 points - Part II (Option B): 15 points - Part III (Option C): 20 points - Part IV(Amortization Schedules): 20 points - Part V (What is your advice?): 20 points - Bonus: 10 points for group submissions. I. (15 points) Under option A: After ten years of making monthly payments of $162.50 at 7.8% compounded monthly, what will be her remaining account balance? Use the TVM Solver to find the answer, and round to the nearest cent. Use your work above to find: a) Balance of the account after 10 years of payments (be careful with how you interpret the cash-flow convention, which tells you how much you owe to the bank) b) How much does Amanda pay to the loan company during the 10 years under Option A? How much did she pay in interest, and how much for principal (balance) reduction? c) What type of loan is loan A ? II. (15 points) Under option B: After ten years of making the monthly payments of $300.68 at 7.8% compounded monthly, find the remaining account balance; round your answer to the nearest cent. Use your work above to find: a) Balance of the account after 10 years of payments (be careful with how you interpret the cash-flow convention, which tells you how much you owe to the bank) b) How much does Amanda pay to the loan company during the 10 years under Option B? How much did she pay in interest, and how much for principal (balance) reduction? c) What are the main differences between Option A and Option B? List at least three: III. (20 points) Option C Assume Amanda rejects both Options A and B and decides to continue making her current monthly payments. a) How many months will it take to pay off each of the original loans? b) How much in total will she pay for each loan? Put your answers in column 6 in the table below along with the corresponding number of months that she has to pay eac loan until it is paid off. What is the grand total amount paid on all three loans? Ent this number in the table also. IV. (20 Points) Use Excel or your favorite spreadsheet application to write down the amortization schedules fo each of these three loans, under option C (pay all loans without a consolidation plan). Include those amortization schedules to your project (you can just copy-paste from excel tables but be careful with how you format your project - recall that presentation is part of the V (20 points). What should Amanda do? Develop a good option D for Amanda. Should she take option A, B or C? Is there maybe a better financial solution for her to become debt free? Advise Amanda on what she should do and explain why your recommendations are good. Be specific and clear in your recommendation (this part of the project is worth 20 points and it should have 2-3 paragraphs): Amanda's current debt consists of three types of loans: a bank card, an auto loan and a department store card. She owes a total of $25,000 and her monthly payments sum to $521.77. The amount she owes, the monthly payment and the interest rates appear in the table below: Amanda is having a hard time meeting the monthly payments and is considering consolidating the three loans to reduce her total monthly payments. She has been offered two options. In both cases, she would borrow $25,000 to pay off her existing three loans leaving her with a single loan payment to a loan company. Option A: A \$25,000 home equity line of credit based on "7.8\% APR annualized over a 10 year term. The loan is amortized at 7.8% with monthly payments of $162.50. This reduces her monthly payments by $359.27. Option B: A $25,000 home equity loan based on " 7.8% APR amortized over a 10 year term with monthly payments of $300.68. This reduces her monthly payments by only $221.09. Here is the grading rubric for this project: - Project Presentation: 10 points (you need to type your work for this project, include the amortization schedules in the same file, and submit it all as one single .docx or pdf file) - Part I (Option A): 15 points - Part II (Option B): 15 points - Part III (Option C): 20 points - Part IV(Amortization Schedules): 20 points - Part V (What is your advice?): 20 points - Bonus: 10 points for group submissions. I. (15 points) Under option A: After ten years of making monthly payments of $162.50 at 7.8% compounded monthly, what will be her remaining account balance? Use the TVM Solver to find the answer, and round to the nearest cent. Use your work above to find: a) Balance of the account after 10 years of payments (be careful with how you interpret the cash-flow convention, which tells you how much you owe to the bank) b) How much does Amanda pay to the loan company during the 10 years under Option A? How much did she pay in interest, and how much for principal (balance) reduction? c) What type of loan is loan A ? II. (15 points) Under option B: After ten years of making the monthly payments of $300.68 at 7.8% compounded monthly, find the remaining account balance; round your answer to the nearest cent. Use your work above to find: a) Balance of the account after 10 years of payments (be careful with how you interpret the cash-flow convention, which tells you how much you owe to the bank) b) How much does Amanda pay to the loan company during the 10 years under Option B? How much did she pay in interest, and how much for principal (balance) reduction? c) What are the main differences between Option A and Option B? List at least three: III. (20 points) Option C Assume Amanda rejects both Options A and B and decides to continue making her current monthly payments. a) How many months will it take to pay off each of the original loans? b) How much in total will she pay for each loan? Put your answers in column 6 in the table below along with the corresponding number of months that she has to pay eac loan until it is paid off. What is the grand total amount paid on all three loans? Ent this number in the table also. IV. (20 Points) Use Excel or your favorite spreadsheet application to write down the amortization schedules fo each of these three loans, under option C (pay all loans without a consolidation plan). Include those amortization schedules to your project (you can just copy-paste from excel tables but be careful with how you format your project - recall that presentation is part of the V (20 points). What should Amanda do? Develop a good option D for Amanda. Should she take option A, B or C? Is there maybe a better financial solution for her to become debt free? Advise Amanda on what she should do and explain why your recommendations are good. Be specific and clear in your recommendation (this part of the project is worth 20 points and it should have 2-3 paragraphs)