Name(s) Loan companies offer a variety of options for consolidating debt. This assignment gives you an opportunity to study such offerings. Here is the problem: 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.4 The amount she owes, the monthly payment and the interest rates appear in the table below: Loan Type Annual Percentage Rate, Loan Amount Monthly (APR) Current Debt Payment Bank Card 18% $10,000 $203.21 Auto Loan 5.5% $12,500 $238.76 Department Store Card 15% $ 2,500 $ 79.80 TOTALS $25,000 S521.77 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. Options Loan Amount $25,000 $25,000 Total Monthly Payment $162.50 $300.68. Annual Percentage Rate, APR 7.8% 7.8% Option A Option B MTH 1310 Class Project Chapter 6 - Financial Math III. (20 points) Option C Assume Amanda rejects both Options A and B and decides to continue making her current monthly payments. ) How many months will it take to pay off each of the original loans? Bank Card Auto Loan Department Store Card TYM Solver: TVM Solver: TVM Solver N- N 1%- 1%- 1% PV PV = PV- PMT PMT - PMT- FV - FV = FV = P/Y - P/Y- P/Y C/Y C/Y - C/Y Pmt End Pmt End Pmt End N- 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 each loan until it is paid off. What is the grand total amount paid on all three loans? Enter this number in the table also Amount Paid Loan Type Number of months parving off the loan APR Loan Amount 18% $10.000 5.5% $12.500 15% $ 2.500 Monthly Payment $203.21 $238.76 $ 79.80 Bank Card Auto Loan Department Store Card TOTALS $25,000 S521.77 Grand total paid: IV. (20 Points) Use Excel or your favorite spreadsheet application to write down the amortization schedules for 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 project grade). Name(s) Loan companies offer a variety of options for consolidating debt. This assignment gives you an opportunity to study such offerings. Here is the problem: 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.4 The amount she owes, the monthly payment and the interest rates appear in the table below: Loan Type Annual Percentage Rate, Loan Amount Monthly (APR) Current Debt Payment Bank Card 18% $10,000 $203.21 Auto Loan 5.5% $12,500 $238.76 Department Store Card 15% $ 2,500 $ 79.80 TOTALS $25,000 S521.77 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. Options Loan Amount $25,000 $25,000 Total Monthly Payment $162.50 $300.68. Annual Percentage Rate, APR 7.8% 7.8% Option A Option B MTH 1310 Class Project Chapter 6 - Financial Math III. (20 points) Option C Assume Amanda rejects both Options A and B and decides to continue making her current monthly payments. ) How many months will it take to pay off each of the original loans? Bank Card Auto Loan Department Store Card TYM Solver: TVM Solver: TVM Solver N- N 1%- 1%- 1% PV PV = PV- PMT PMT - PMT- FV - FV = FV = P/Y - P/Y- P/Y C/Y C/Y - C/Y Pmt End Pmt End Pmt End N- 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 each loan until it is paid off. What is the grand total amount paid on all three loans? Enter this number in the table also Amount Paid Loan Type Number of months parving off the loan APR Loan Amount 18% $10.000 5.5% $12.500 15% $ 2.500 Monthly Payment $203.21 $238.76 $ 79.80 Bank Card Auto Loan Department Store Card TOTALS $25,000 S521.77 Grand total paid: IV. (20 Points) Use Excel or your favorite spreadsheet application to write down the amortization schedules for 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 project grade)