Now you are going to create a scenario analysis in your Echo…
Now you are going to create a scenario analysis in your Echolab solution, so first copy your initial valuation to a new sheet and name it “Scenario”. You will create a table to model the following scenarios to the right of the model inputs: United States: Sales Year 1 of $28 million, Variable Costs of 27.5%, initial Revenue Growth of 14%, and SG&A of $500,000, $550,000 and $600,000 Slovakia: Sales year 1 of $25 million, Variable Costs of 25%, Initial Revenue Growth of 15%, and SG&A of $300,000, $325,000, and $350,000 France: Sales year 1 of $32 million, Variable Costs of 30%, Initial Revenue Growth of 12%, and SG&A of $400,000, $450,000, and $500,000 Make sure to have a dropdown menu for your audience to choose the different scenarios. You should use each of the following at least once each in your model: match, index, offset, and lookup. Which scenario would you tell the company to choose?