POST BUS523 2022 December Unit 3 Assignment Sensitivity of Financial Data Analysis Latest

BUS523 Quantitative Analysis for Decision Making

Unit 3 Assignment

Sensitivity of Financial Data Analysis

Instructions:

?On the Excel Financial Forecast worksheet fill in the information highlighted in red with data from your company.

?Repeat the formulas in column C row 18-37 in column D. Doing this should allow you to adjust values in the Fact and Assumptions part of column D and see its affect in row 18-27 of the same column.

https://www.youtube.com/watch?v=d0GyMLC8bZs

?Using the Excel Financial Forecast worksheet, determine the ‘sensitivity’ of the model by adjusting the values of growth rate in sales and cost of goods sold in column D. Increase and decreases the % values for 2017 and observe and record the results. Create an Excel chart for each (growth rate in sales and cost of goods sold) the resulting impact on external funding required.

?Explain your observations on:

oHow did adjusting growth rate of sale and cost of good sold affect the income statement and balance sheet?

oWhat is External Funding Required and how was it affected by adjusting sales projections and cost of goods sold?

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.

?Forecast model must be included with the word document.