Forecasting
please fill this excel sheet out
https://docs.google.com/spreadsheets/d/1tTL5zy6bn0gMoUeiOxu3P_p2u6K9boBqfuX3iUycCqU/edit?usp=sharing
??. forecastinglsx Excel Insert Page LayoutFormulas DataRevieViAdd-Ins XLMiner Platform Solver Home Tell me what you want to do.. Cut Eg Copy AutoSum Fill Clearier Select Calibri 11A A " wrap Text Paste Sort &Find & B 1 u ,?? '? .LL, E FE E Merge & Certer $. % , ' :.g Conditional Format as Cell Insert Delete Format Fonmatting Format Painter iTable Clipboard 7 INCOME STATEMENT 8 Year 9 Net Sales 10 Less: Cost of Goods Sold 11 Gross Profit 12 Other Operating Revenue 13 Less: Operating Expenses 4 Operating Income EBIT 15 Less: Interest Expense 16 Other Income (Ex 17 Gain (Loss 18 Incorme before Taxes EBT 19 Less:Taxes Related to Operatior 20 ?N.l. before Min. Ern. 21 Gan (Loss 22 Net Income [Loss) 2011 2013 2014 2015 2016 2017 % of Sales Forecasting an I/S and B/S 8995.10 9488.80 9893.00 5403.80 5784.90 6004.70 591.30 3703.90 3888.30 Use "Percent of Sales "appr B. Use the Trend function to forecast Sales Provide an analysis of the statisitical significance of the model 2606.40 2689.70 2820.40 84.901014.20 1067.90 .0058.70 47 23.20 34.10 919.20 921.40 1017.30 340.10 331.70 349.00 579.10 589.70 668.30 579.10 589.70 673.30 24 BALANCE SHEET 25 Year 26 ASSETS 27 Current Assets: 28 Cash 29 Gross Receivables 30 Less: Allowance for Bad Debts 31 Net Trade Receivables 32 Inventories 33 Prepaid Expenses 34 Other Current Assets 2013 2014 2015 2016 2017 54.30304.0O 575.50 1632.60 1693.50 1884.50 65.40 72.10 77.40 1567.20 1621.40 1807.10 1446.00 1424.10 1373.80 215.20 162.50 260.50 113.70113.30 140.80 Sheet1 Forecastin Ready ??. forecastinglsx Excel Insert Page LayoutFormulas DataRevieViAdd-Ins XLMiner Platform Solver Home Tell me what you want to do.. Cut Eg Copy AutoSum Fill Clearier Select Calibri 11A A " wrap Text Paste Sort &Find & B 1 u ,?? '? .LL, E FE E Merge & Certer $. % , ' :.g Conditional Format as Cell Insert Delete Format Fonmatting Format Painter iTable Clipboard 7 INCOME STATEMENT 8 Year 9 Net Sales 10 Less: Cost of Goods Sold 11 Gross Profit 12 Other Operating Revenue 13 Less: Operating Expenses 4 Operating Income EBIT 15 Less: Interest Expense 16 Other Income (Ex 17 Gain (Loss 18 Incorme before Taxes EBT 19 Less:Taxes Related to Operatior 20 ?N.l. before Min. Ern. 21 Gan (Loss 22 Net Income [Loss) 2011 2013 2014 2015 2016 2017 % of Sales Forecasting an I/S and B/S 8995.10 9488.80 9893.00 5403.80 5784.90 6004.70 591.30 3703.90 3888.30 Use "Percent of Sales "appr B. Use the Trend function to forecast Sales Provide an analysis of the statisitical significance of the model 2606.40 2689.70 2820.40 84.901014.20 1067.90 .0058.70 47 23.20 34.10 919.20 921.40 1017.30 340.10 331.70 349.00 579.10 589.70 668.30 579.10 589.70 673.30 24 BALANCE SHEET 25 Year 26 ASSETS 27 Current Assets: 28 Cash 29 Gross Receivables 30 Less: Allowance for Bad Debts 31 Net Trade Receivables 32 Inventories 33 Prepaid Expenses 34 Other Current Assets 2013 2014 2015 2016 2017 54.30304.0O 575.50 1632.60 1693.50 1884.50 65.40 72.10 77.40 1567.20 1621.40 1807.10 1446.00 1424.10 1373.80 215.20 162.50 260.50 113.70113.30 140.80 Sheet1 Forecastin Ready
