Question

The problem: Monica'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 $549.61.The amount she owes, the monthly payment and the interest rates appear in the table below: Loan Type Annual Percentage rate, APR Loan Amount Monthly Payment Current Debt) S12,000 $11,500 S 1,500 $25,000 Bank Card Auto Loan 18% 5.5% $243.85 $257.88 Department Store Card | 15% 47.88 TOTALS Monica is having a hard time meeting the monthly payments and is considering consolidating the three loans to reduce her total monthly payments. She could borrow $25,000 to pay off her existing three loans leaving her with a single loan payment to the loan company. She has received a mail offer advertising a $25,000 home equity line of credit based on 7.9% APR amortized over a 10 year term with monthly payments of $164.58. (This reduces Monica's monthly payments by $385.03.) l. After ten years of making monthlypayments of $164.58 at 7.9% compounded monthly at the end of each compounding period, will the loan amount be zero? Use the TVM solver to calculate the FV. Round the answer to the nearest cent. TVM Solver: PMT FV- P/Y C/Y Pmt End 2. How much does Monica pay to the loan company during the 10 years under this offer? Pmt End 2. How much does Monica pay to the loan company during the 10 years under this offer? 3. How much would the monthly payment have to be in order for Monica to have the debt completely paid off in the 10 years? Use the TVM solver to calculate the PMT. Round the answer to the nearest cent. 1 0 TVM Solver: N= 1% PV- PMT FV- C/Y = Pmt End

Answer 1

1.

Future Value
Present Value	0.00
Payment	164.58
Interest Rate	7.90%
Years(NPER)	10
Future Value	$29,941.87

2.If Monika pay $ 164.58 per month for 10 years ( for 120 months tenure) she is paying only interest portion , she is not paying any principal in this EMI.

Proof : Principal : 25000, Rate of Interest : 7.90% /12 ( since paying monthly instalment)

=25000*7.90%/12

=164.58

3. If Monika wants to pay her debt in 10 years she has to pay $ 301.95  per month.