SOLVE WITH EXCEL DEATILED.

5. A financial planner trying to determine how to invest 1 million dollars for one of his clients. The cash flows for the five investments under consideration are summarized in the following table Summary of cash in-flows and out-flows (at the beginning for year Year 1.0 +0.4 +1.02 1.0 1.0 1.0 4 For example, if the financial planner invests $1 in investment A at the beginning of year 1, he will receive $0.4 at the beginning of year 2 and another $1.02 at the beginning of year 3. Alternatively, he can invest $1 in investment B at the beginning of year 2 and receive $1.4 at the beginning of year 4. Entries of "O" in the table (above) indicate times when no cash in-flows or out-flows can occur. Also, at the beginning of each year, the financial planner may also place any or all of the available money in a money market account that is expected to yield 10% per year How should the financial planner invest if he wants to maximize the amount of money available to his client at the end of year 4