Complete the Projected Financial Statement Analysis (Pro Forma 3-Year Financial Plan) for Coca - cola including the Questions tab, 12 Month P& L" tab, Year 1 tab, "Year 2 P&L tab, and Year 3 P&L tab. The first year is monthly and the second and third year are presented quarterly. Please note the questions in the Questions tab may be answered at different points in completing the Profit and Loss information.

How can i send excel document to this question?

d separately and cost of sales for eac Ten Eleven Twelve - Instructions Give careful thought to the headings. Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales liste Month One Two Three Four Five Six Seven Eight Nine Income Sales Sale of goods/services Sundry Income (e-g. Commission earned, frachise $ - $ - $ - $ - $ - $ - $ - $ - $ - Etc. $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Sales $ - $ - $ - $ - $ - $ - $ - $ - $ . Less Discounts/Commissions Sales Discounts given $ - $ - $ - $ - $ - $ - $ - $ - $ - Sales Commissions paid $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Discounts/ Commissions $ - $ - $ - $ - $ - $ - $ - $ - $ . Total Net Income $ - $ - $ - $ - $ - $ - $ - $ - $ . Cost of Sales Opening Stock $ - $ - $ - $ - $ - $ - $ - $ - $ . Stock Purchased $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Less Closing Stock $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Cost of Sales $ - $ - $ . $ . $ - $ - $ $ $ - - $ $ - - $ $ $ $ $ $ - - - - $ $ $ $ - - - - $ $ $ $ - . . $ $ $ - - - - . $ $ $ $ $ - - - - . $ $ $ $ $ - - - . - $ - $ . $ - $ - $ - $ .! $ - $ - $ - $ $ $ - $ - - - - $ $ Gross Profit $ Expenses General & Administrative Bank charges $ Credit card commission $ Consultant fees Office Supplies License fees Business insurance Etc. Total General & Administrative $ 99 - $ . $ - $ - - - $ S $ - - - - $ $ $ $ - - - $ $ $ $ $ - - - - - - - - $ $ $ $ $ $ $ $ 12.00 $ . $ - $ - $ d separately and cost of sales for eac Ten Eleven Twelve - Instructions Give careful thought to the headings. Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales liste Month One Two Three Four Five Six Seven Eight Nine Income Sales Sale of goods/services Sundry Income (e-g. Commission earned, frachise $ - $ - $ - $ - $ - $ - $ - $ - $ - Etc. $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Sales $ - $ - $ - $ - $ - $ - $ - $ - $ . Less Discounts/Commissions Sales Discounts given $ - $ - $ - $ - $ - $ - $ - $ - $ - Sales Commissions paid $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Discounts/ Commissions $ - $ - $ - $ - $ - $ - $ - $ - $ . Total Net Income $ - $ - $ - $ - $ - $ - $ - $ - $ . Cost of Sales Opening Stock $ - $ - $ - $ - $ - $ - $ - $ - $ . Stock Purchased $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Less Closing Stock $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Cost of Sales $ - $ - $ . $ . $ - $ - $ $ $ - - $ $ - - $ $ $ $ $ $ - - - - $ $ $ $ - - - - $ $ $ $ - . . $ $ $ - - - - . $ $ $ $ $ - - - - . $ $ $ $ $ - - - . - $ - $ . $ - $ - $ - $ .! $ - $ - $ - $ $ $ - $ - - - - $ $ Gross Profit $ Expenses General & Administrative Bank charges $ Credit card commission $ Consultant fees Office Supplies License fees Business insurance Etc. Total General & Administrative $ 99 - $ . $ - $ - - - $ S $ - - - - $ $ $ $ - - - $ $ $ $ $ - - - - - - - - $ $ $ $ $ $ $ $ 12.00 $ . $ - $ - $