Applied Financial Analysis

Please help with the following

Fidelity Diversified Date International 12/31/15 11.47 12/31/16 26.89 12/31/17 24.58 12/31/18 27.91 12/31/19 25.31 12/31/20 21.37 Solve for the average simple Holding Period Return (P1/P0-1) but use an Array Function to do it in one step: Note: do not use the formula for continuously compounded return. Average Discrete Return Parse the following data dynamically (using RIGHT or LEFT as appropriate): Note: There should be no spaces in either field. Last Name First Name Elon Musk Jeff Bezos Mark Zuckerberg Warren Buffet Bill Gates Howard Schultz Sergio Marchionne Market performance over the upcoming year (select one):Market performance over the upcoming year (select one): Create a Data Validation List containing the following text: Fantastic Returns, Good Return, Flat, Poor Return, Horrible Return Return (discrete annual compounding) Fantastic Return 10.00% Good Return 4.00% Flat 0.00% Poor Return 2.00% Horrible Return -10.00% Investment $ 25,000.00 Years 10 Return Use a formula to bring in the appropriate rate based on what the user selected above. Future Value (Use a simple future value calculation to solve - assume discrete annual compounding) Create a Data Table to depict the future value when you vary the interest rate and the investment amount. Use the following assumptions: Interest Rates: Investment Amounts: 15.0% $ 25,000.00 -13.0% $ 50,000.00 -11.0% $ 75,000.00 -9.0% $ 100,000.00 -7.0% -5.0% -3.0% -1.0% 1.0% 3.0% 5.0% 7.0% 9.0% 11.0% 13.0% 15.0%