SURVEYS AND REMINDERS: Along with your final oral project yo…

SURVEYS AND REMINDERS: Along with your final oral project you were instructed to complete a survey on your experience with LinguaMeeting. If you haven’t done so, please complete it here: https://ufl.qualtrics.com/jfe/form/SV_3UlHvbBY0oex9vD  This survey is different than the one completed with your language coach, and is required of all students.  Also, please consider participating in the LinguaMeeting contest by submitting the authorization form.   ——————————————————————————————————— Finally, it is extremely important that you complete this course’s evaluation found here: https://ufl.bluera.com/ufl Your feedback will shape and improve this course for future students and it is also a critical element of my personal file for promotion within the University.  ——————————————————————————————————— It has been a wonderful semester and it has been a pleasure to work with you all! Stay healthy!  

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 $27.5 million, Variable Costs of 28%, initial Revenue Growth of 12.5%, and SG&A of $500,000, $550,000 and $600,000 as indicated in initial problem 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 $30 million, Variable Costs of 30%, Initial Revenue Growth of 10%, 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?