NEED HELP ASAP!

Question 5 ( 6 Marks) It is September 1, 2019 and Richard Spender has a problem... HE SPENDS TOO MUCH! Richard has managed to rack 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 begin university in September of the year they turn 18 (so for his 14 year old son, there are exactly 4 years to go for his 13 year old daugter there are 5 years to go, and for his twins there are 7 years to go). Each child will require $5,144 per year for four years, for tuition payments payable each September. 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 1 compounded monthly for a college savings plan. However, Richard must take care of his other debts as wall: Type of Debt Credit Card 1 Credit Card 2 Credit Card Credit Card 4 Line of Credit Car Loan Mortgage Outstanding Principal $4,600 $5,000 $1,200 $ 3,220 $43,200 $44,000 $347.000 You have offered to consolidate all of Richard's debts into a single loan with a 10 year term and interest at 6 compounded monthly. Because he would like to continue his spending ways, Richard would like to pay a little 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 of his debts. Enter AS a) How much must Richard save each month in the college savings plan? (4 Marks) b) How much must ha pay each month towards his debts? (2 Marks) Enter