Data Table 1) 2) 3) 4) 9) Follow these steps to perform a What-If analysis using Data Table. Re-download the template file Investments2.xisx from the lab website. Rename the file to Lab5FirstNameLastName.xlIsx. Follow the Preparation Section of Lab 4's Tutorial to properly format and prepare your worksheet. Make a copy of \"Base Case\" worksheet, move it to the end of the file and rename it as \"Data Table". Create a column-oriented data table that shows how much future value of investment (E15) will change if the interest rate of US Bank changes between 1% and 2% by 0.1% steps. Create a row-oriented data table that shows how much the total future value of your investment (E15) will change if percentage of investment in US Bank changes between 10% and 30% by 5% steps. Make sure that you change the formulas in C10 through G12 such that they always add up to 100%. Please assume 50% of your investment goes to BoA and the other 50% to US Bank and Chase. A B C D E F IS 300 Lab 4: What-If Analyses and Charts / Graphs CO N 4 Number of years: 10 5 No. of Periods in Each Year: 1 6 Total periods: 10 7 Amount per period: 12000 8 9 Annual Interest Organization Name Percentage of | Amount per 10 Rate Investment Period Future Value Websites 11 US Bank 0,017 0,2 2400 25921,75939 www.usbank.com 12 CHASE 0,021 0,3 3600 39599,69287 www.chase.com 13 BOA 0,022 0,5 6000 66302,25725 www.bankofamerica.com 14 15 Total 1 12000 131823,7095 16 17 18 S 19 20 21 22