please use the excel sheet i gave to solve this. thamk you

thats all

insert Draw Page Layout Formulas Data Review View Tell m me ID A = Share % Paste Font Conditional Formatting Format as Table Alignment Number Cell Styles fx Estimated Initial Investment Capital Required Cells Editing Ideas Sensit X B D H 1 Pizza by Mario Franchise 2 Projected Franchise Startup Investment and Return 3 Estimated Initial Investment Capital Required Estimated Capital Investment Recovery Horizon 4 Franchise Fee 20,000 Projected Sales 5 Leasehold Improvements 45,000 Year 1 $ 485,000 6 Store Fixtures 35,000 7 Internal and external Signage 13,500 Net Profit Percent of Sales 8 Startup Inventory and Supplies 5,500 Year 1 $ 97,000 20% 9 Startup Advertising 2,500 LO Insurance 10,000 Net profit per month $ 8,083.33 11 Legal and Administrative Costs 8,500 12 Number of months $ 140,000 -3 Total Estimated Initial Investment 17 to recoup initial investment 4 5 6 7 8 9 Yolanda Robertson is continuing her work on the marketing information package for prospective new franchise owners. She has sent you a workbook named PBMStartup.xlsx. The workbook contains information on the estimated capital investment required to start a new franchise, along with estimated sales and profits for the first year. The workbook calculates the number of months in which a new franchisee can expect to recoup his or her investment based on estimated sales and profits for the first year. Yolanda wants you to use the What-If Analysis tools to find out the value that is needed for projected sales in year 1 to pay back the initial investment in 12 months (instead of 17). Accept the proposed solution and save the revised workbook and name it EL2-C5-CS-PI- PBMStartup. Print the worksheet. 2. After reviewing the printout from Part 1, Yolanda is concerned that the revised sales figure is not attainable in the first year. Restore the sales for year 1 to the original value of $485,000. Yolanda has created the following three models for the startup investment worksheet: Item Conservative Optimistic $590,000 Projected Sales $450,000 Aggressive $615,000 18% Profit Percent 20% 22% Yolanda would like you to set up the worksheet to save all three of these models. Hint: Use a comma to separate two cell references as the changing cells. Create a report that shows Yolanda the input variables for each model and how the model affects the number of months needed to recoup the initial investment. Save the revised workbook as EL2-C5-CS-P2-PBMStartup. Print the summary report. Switch to the worksheet and show the model that reduces the number of months to recoup the initial investment to the lowest value. Print the worksheet. Save EL2-C5-CS-P2-PBMStartup