Need help with financial data analysis

Due Date: Sunday of Unit 3 Total Points: 100 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 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 two- page 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.

Be sure to read the criteria, by which your assignment will be evaluated,

before you write, and again after you write.

BUS522 Financial Tools for Managers

Unit 3 Assignment: Sensitivity of Financial Data Analysis

Evaluation Rubric for Unit 3 Assignment

CRITERIA Exemplary Proficient Deficient (9 – 10 Points) (7 – 8 Points) (0 – 6 Points)

Overview of Adjusted Growth Rate of Sales, Cost of Goods Sold/Net Sales

An overview is clearly presented including all key details.

An overview is presented, though key details may not be clearly or completely presented.

Does not provide an overview or the overview is missing key details.

(18 – 20 Points) (13 – 17 Points) (0 – 12 Points) Excel Chart Created for Growth Rate of Sales

Chart and evaluation is clearly presented including all key details.

Chart and evaluation is presented, though key details may not be clearly or completely presented.

Does not provide chart and evaluation or is missing key details.

Excel Chart Created for Cost of Goods Sold/Net Sales

Chart and evaluation is clearly presented including all key details.

Chart and evaluation is presented, though key details may not be clearly or completely presented.

Does not provide chart and evaluation or is missing key details.

The Resulting Impact on External Funding

The impact statement is clearly presented including all key details.

The impact statement is presented, though key details may not be clearly or completely presented.

Does not provide impact statement or is missing key details.

Executive Summary Format

Executive summary is clearly presented including all key details.

Executive summary format is presented, though key details may not be clearly or completely presented.

Does not provide executive summary format or is missing key details.

(9 – 10 Points) (7 – 8 Points) (0 – 6 Points) Clear and Professional Writing and APA Format

Writing and format is clear, professional, APA compliant, and error free.

Few errors that do not impede professional presentation.

Errors impede professional presentation; guidelines not followed.