not in excel

Price Waterhousc Coopen (PWC), one of the big acoounting consultancy firms has recently recruited you as a Jumior Finance Executive. Your fint task is to advise to a elient, on which of the following iavestment (saving) options would be best. Your problem-solving skills necd to be deunonstrated, affer anatyzing the multiple cash flows carefully. (a) Fill out the table below and rank your recoemmendation from 1-5, with I being the most recommended option and 5 heing the least recommended option. Show your workings elearly and then fill out the table below. Please provide at least 2 decimal places in your answer. Assume 1 year is made up of 365 days Except for bank E, where the first payment is made at the beginning of the period, for all other banks, the first payment is made at the end of the first period. Initial iavestment 3,500,000 AED (b) If your client deoides to choose Bank A, but stopped depositing money after 5 years, how much would be there at the end of the 15 years? Clearly show your workings