can you answer this

\begin{tabular}{|c|} \hline \\ \hline 1 \\ \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ \hline 6 \\ \hline 7 \\ \hline 8 \\ \hline 9 \\ \hline 10 \\ \hline 11 \\ \hline 12 \\ 13 \\ 14 \\ \hline 15 \\ \hline 16 \\ \hline 17 \\ \hline 18 \\ \hline 19 \\ \hline \end{tabular} A B C F K additional offers. Which option would you accept if you were advising Ronaldo. The interest rate is 8%. a. Current offer would be fine b. 1st Offer c. 2nd Offer d. 3rd Offer A C D E F Problem 9 Annuities You are now 50 years old and plan to retire at age 65 . You currently have an equity portfolio worth 150000, an a pension plan worth 250000 and a money market account worth 50,000. Your equity portfolio is expected to provide you annual returns of 12 per cent, your pension plan will earn you 9.5 per cent annually and the money market account earns 5.25 per cent, compounded monthly. a. If you do not save another cent for the next 15 years, how much will you have from your current savings when you retire at age 65? Hint: Determine the future value of each account and then the grand total of all three. Use the future value of a lump sum equation as well as the FV function: FV(rate,nper,pmt,pv,type) Expected value of portfolio at age 65 (formula): Expected value of portfolio at age 65 (function): Pension Plan Current value of portfolio: Expected return on portfolio: Years to retirement: Expected value of portfolio at age 65 (formula): Expected value of portfolio at age 65 (function): Money Market Account Current value of portfolio: Expected return on portfolio: Years to retirement: Frequency of compounding: Expected value of portfolio at age 65 (formula): Expected value of portfolio at age 65 (function): Total of all three investments