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=dOGYMLC8bZs 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: How did adjusting growth rate of sale and cost of good sold affect the income statement and balance sheet? o What 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. Be sure to read the criteria, by which your assignment will be evaluated, before you write, and again after you write. Facts and Assumptions Year Net sales Growth rate in sales Cost of goods sold Gen., sell,, and admin. Expenses Long-term debt Current portion long-term debt Interest rate Tax rate Dividend/earnings after tax Current assets Net fixed assets Current liabilities Owners' equity INCOME STATEMENT Year Net sales Cost of good sold Gross profit Gen., sell,, and admin. exp. Interest expense Earnings before tax Tax Earnings after tax Dividends paid Additions to retained earnings BALANCE SHEET Current assets Net fixed assets Total assets Current liabilities Long-term debt Equity Total liabilities and shareholders' equity EXTERNAL FUNDING REQUIRED 2015 $20.613 $27,828 $ 760 $ $ 100 $ $ 100 $ $1,730 2016 2017 2015 35% 50% 86% 86% 12% 11% 760 $760 100 $100 10% 10% 45% 45% 50% 50% 29% 29% 100 $100 14.5% 14.4% 2016 2017 $27,828 23,932 3,896 3,339 86 471 212 259 129 129 $ 8,070 100 8,170 4,035 760 1,859 6,654 $ 1,516 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=dOGYMLC8bZs 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: How did adjusting growth rate of sale and cost of good sold affect the income statement and balance sheet? o What 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. Be sure to read the criteria, by which your assignment will be evaluated, before you write, and again after you write. Facts and Assumptions Year Net sales Growth rate in sales Cost of goods sold Gen., sell,, and admin. Expenses Long-term debt Current portion long-term debt Interest rate Tax rate Dividend/earnings after tax Current assets Net fixed assets Current liabilities Owners' equity INCOME STATEMENT Year Net sales Cost of good sold Gross profit Gen., sell,, and admin. exp. Interest expense Earnings before tax Tax Earnings after tax Dividends paid Additions to retained earnings BALANCE SHEET Current assets Net fixed assets Total assets Current liabilities Long-term debt Equity Total liabilities and shareholders' equity EXTERNAL FUNDING REQUIRED 2015 $20.613 $27,828 $ 760 $ $ 100 $ $ 100 $ $1,730 2016 2017 2015 35% 50% 86% 86% 12% 11% 760 $760 100 $100 10% 10% 45% 45% 50% 50% 29% 29% 100 $100 14.5% 14.4% 2016 2017 $27,828 23,932 3,896 3,339 86 471 212 259 129 129 $ 8,070 100 8,170 4,035 760 1,859 6,654 $ 1,516 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=dOGYMLC8bZs 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: How did adjusting growth rate of sale and cost of good sold affect the income statement and balance sheet? o What 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. Be sure to read the criteria, by which your assignment will be evaluated, before you write, and again after you write. Facts and Assumptions Year Net sales Growth rate in sales Cost of goods sold Gen., sell,, and admin. Expenses Long-term debt Current portion long-term debt Interest rate Tax rate Dividend/earnings after tax Current assets Net fixed assets Current liabilities Owners' equity INCOME STATEMENT Year Net sales Cost of good sold Gross profit Gen., sell,, and admin. exp. Interest expense Earnings before tax Tax Earnings after tax Dividends paid Additions to retained earnings BALANCE SHEET Current assets Net fixed assets Total assets Current liabilities Long-term debt Equity Total liabilities and shareholders' equity EXTERNAL FUNDING REQUIRED 2015 $20.613 $27,828 $ 760 $ $ 100 $ $ 100 $ $1,730 2016 2017 2015 35% 50% 86% 86% 12% 11% 760 $760 100 $100 10% 10% 45% 45% 50% 50% 29% 29% 100 $100 14.5% 14.4% 2016 2017 $27,828 23,932 3,896 3,339 86 471 212 259 129 129 $ 8,070 100 8,170 4,035 760 1,859 6,654 $ 1,516