6200:450 Advanced Spreadsheet Modeling VBA Case Study 1 Analytical Tasks 1. Build the macro to format the data in a new worksheet to exactly match the following picture D Time Year 1 Year 2 $300 Year 3 $100 Year 4 $400 Year 5 $500 $200 2 Cash Flow 3 Interest Rate 5 Future Value Formula 7 Future Value a) 18 Future Value b) 2. Add the buttons 3. Write the formula for the FV of the cash flows 4. Write the VBA formula for the FV of the cash flows using native VBA code 5. Write the VBA formula for the FV of the cash flows using native VBA code using Application. WorksheetFunction 6. Show the results by applying you function in the appropriate cells in column B