Urgent 7
BUS523 Quantitative
Analysis for Managers
Sensitivity of Financial Data Analysis
Due Date: Sunday by 11:59 p.m. EST 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 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.
This study source was downloaded by 100000790156070 from CourseHero.com on 01-29-2022 23:17:45 GMT -06:00
https://www.coursehero.com/file/66708192/BUS522-Unit-32-Assignment-and-Rubricpdf/
https://www.coursehero.com/file/66708192/BUS522-Unit-32-Assignment-and-Rubricpdf/
Evaluation Rubric for Sensitivity of Financial Data Assignment
CRITERIA Exemplary Proficient Deficient
(18 – 20 Points) (13 – 17 Points) (0 – 12 Points)
Growth Rate of Sales
Chart
Chart and evaluation
are clearly presented,
including all key
details.
Chart and evaluation
are presented,
though key details
may not be clearly
or completely
presented.
Chart and evaluation
are inadequate or
missing.
Cost of Goods
Sold/Net Sales
Chart and evaluation
are clearly presented,
including all key
details.
Chart and evaluation
are presented,
though key details
may not be clearly
or completely
presented.
Chart and evaluation
are inadequate or is
missing.
Results Analysis Analysis fully
addresses the results
of the growth rate in
sales and cost of
goods sold/net sales.
Analysis mostly
addresses the results
of the growth rate in
sales and cost of
goods sold/net sales.
Analysis is inadequate
or missing.
Impact Analysis Analysis fully
addresses how the
results may affect the
external funding.
Analysis mostly
addresses how the
results may affect the
external funding.
Analysis is inadequate
or missing.
(9 – 10 Points) (7 – 8 Points) (0 – 6 Points)
Length 2 pages 1 page Less than 1 page or
more than 2 pages
Clear and
Professional
Writing and APA
Format
Writing and format are
clear, professional,
APA compliant, and
error-free.
Few errors that do
not impede
professional
presentation.
Errors impede
professional
presentation;
guidelines not
followed.
This study source was downloaded by 100000790156070 from CourseHero.com on 01-29-2022 23:17:45 GMT -06:00
https://www.coursehero.com/file/66708192/BUS522-Unit-32-Assignment-and-Rubricpdf/
Powered by TCPDF (www.tcpdf.org)
https://www.coursehero.com/file/66708192/BUS522-Unit-32-Assignment-and-Rubricpdf/
http://www.tcpdf.org
