Question
Using the Excel Financial Forecast worksheet from (WICKED GOOD CUPCAKES ASSIGNEMNT THAT IS POSTED ON CHEGG) determine the sensitivity of the model by adjusting the
Using the Excel Financial Forecast worksheet from (WICKED GOOD CUPCAKES ASSIGNEMNT THAT IS POSTED ON CHEGG) determine the sensitivity of the model by adjusting the values of growth rate in sales and cost of goods sold/net sales. Increase and decreases the % values for 2016 and observe and record the results. Create an Excel chart for each (growth rate in sales and cost of goods sold/net sales) and the resulting impact on external funding required. For example: Change growth in sales from 70% to 95% by 5% increments, recording and charting the resulting change in external funding required. Chart this data. In a twopage executive summary explain your finding. Include the two charts (properly labeled) in your summary. Requirements: . All questions posed must be addressed completely. Length: two-page executive summary Include the two charts. All sources used must be properly cited in APA format. CHART WEBSITE BELOW
https://www.chegg.com/homework-help/questions-and-answers/evaluating-financial-performance-ratio-analysis-assignment-comparing-financial-ratios-wick-q29369377?trackid=206bff5a&strackid=7c3329e4&ii=10
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started