Reference no: EM132459383

Problem: It is September 1st, 2019 and Richard Spender has a probelm... HE SPENDS TOO MUCH! Richard has managed tor ack up some impressive debts over the past few years; however, he has another problem. He has four kids: a 14 year old son, a 13 year old daughter, and twins (a boy and a girl) aged 11 who will all be going to university. Each child will being university in Spetember of the year they turn 18 (so far his 14 year old son, there are exactly 4 years to go, for his 13 year old daughter there are 5 years to go, and for his twins there are 7 years to go). Each child will require $5,000 per year for four years, for tuition payments payable each Spetember. Richard would like to set up a savings plan to cover this expense. As his Financial Advisor, you can offer him an interest rate of 3% compounded monthly for a college savings plan. However, Richard must take care of his other debts as well:

Credit Card 1 $200

Credit Card 2 $200

Credit Card 3 $1,300

Credit Card 4 $50

Line of Credit $1,200

Car Loan $40,000

Mortgage $ 300,000

You have offered to consolidate all of Richard's debts into a single loan with a 10 year term and interest at 6% compunded monthly. Because he would like to pay as litttle as possible and will not accumulate any additional savings during the 10 years beyond what he is saving to meet his children's tuition expenses. Richard would like to make EQUAL payments at the end of each month that will save exactly enough to pay for his children's education and eliminate all his debts.

a) How much must richard save each month in the college savings plan?

b) How much must he pay each month towards his debts?