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

Question # 00838707 Posted By: wildcraft Updated on: 02/16/2023 02:59 AM Due on: 02/16/2023
Question

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.

?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.

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.

Tutorials for this Question
1. ## Solution: POST BUS523 2022 December Unit 3 Assignment Sensitivity of Financial Data Analysis Latest

Tutorial # 00834166 Posted By: wildcraft Posted on: 02/16/2023 03:01 AM
Puchased By: 2
Tutorial Preview
The solution of POST BUS523 2022 December Unit 3 Assignment Sensitivity of Financial Data Analysis Latest...
Attachments
POST_BUS523_2022_December_Unit_3_Assignment_Sensitivity Latest.ZIP (18.96 KB)

Great! We have found the solution of this question!