Using the Excel Financial Forecast worksheet from Assignment #1, determine the ‘sensitivity’ of the model by adjusting the values of growth rate in sales and cost of goods sold/net sales.
finance
Description
Instructions:
Using the Excel Financial Forecast worksheet from Assignment #1, 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 explain the resulting impact on external funding required.
o 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 and provide justification.
Explain the results of your analysis of the growth rate in sales and cost of goods sold/net sales.
o Include the two charts (properly labeled) in your summary
Explain how these results may affect the external funding the client is looking for. 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. Be sure to read the criteria, by which your assignment will be evaluated, before you write, and again after you write.
