IN EXCEL ONLY -Create financial statements in excel that can balanced and integrated Finish the income statement and make up the other numbers for the rest of the financial statements as long as they balance. ( for 3 years- 2016, 2017, 2018) Then Create an Excel Data Table that lists the projected second-year income and interest expense for your firm under five sales growth scenarios, e.g. 0%, 5%, 10%, 15%, or 20% sales growth. [Variable Data Tables, MacDonald] 2) Create a Drop-Down User Input Cell with five choices for the firms growth prospects: Poor, OK, Expected, Good, & High [Data Validation with Lists, MacDonald]. 3) Place Formulas in two nearby output-cells that display the corresponding net income and interest expense amounts listed in the data table from part (a). Use the Excel Lookup Function [MacDonald] with Nested Excel If Statements [ MacDonald] to extract the data from the data table. Use Nested Excel If Statements to translate the user selection from the drop-down input in part (b) to one of the percentage sales growths used to form the data table in part (a), e.g. if the user selects Expected, the if statement returns 10% (0.10). Use the Lookup Function to find and display the net income and interest expense corresponding to the given sales growth in the data table. 4) Generate a Well-Formatted Chart [MacDonald] to display the data listed in the data table from part (a). 5) Use labels and formatting as appropriate to guide the user in using the functionality added in parts (a) (c).

Current Balance Sheet Statement of Cash Flows Net Income Add Back Depreciation Income Statement Revenue Sales Revenue Less: Sales discounts & returns Net Sales Less: Cost of Goods Sold Gross Margin Operating Expenses Advertising expense Office Supplies expense Salaries expense Past Year 2016 2017 Assets $12,212,000.00 3,000.00 12,209,000.00 s 3,000,000.00 $9,209,000.00 Current Assets Cash and Cash Equivalents Accounts Receivable Inventory Change in Inventory aid enses Short term Investments Total Current Assets Fixed Long Term Assets Long term investments Property, Plant, and Equipment Le Accumulated depreciation) Change in Accruals $500,000.00 $10,000.00 $499,600.00 44,000.00 $13,000.00 $3,000.00 $ 3,000.00 $10,000.00 S 50,000.00 $ 200,000.00 $300,000.00 $4,000.00 1,000.00 $8,000.00 $10,000.00 $50,000.00 $800,000.00 $ 2,505,600.00 $ 6,703,400.00 6,730.50 $ 6,696,669.50 Net Cash from Operations Property & Equip. Purchases, net Net Cash Investing Activities en Insurance Utilities Fees Maintenance and repairs Research and Development Short Term Financing, Net Long Term Financing, Net Owner's Contribution, Net Net Cash from Financing Act. Total other assets Total Assets Liabilities and Owner's Equity Current Liabilities Accounts Payable Notes Payable accrued salaries and wages unearned revenue Total Current Liabilities Long term debt Deferred income tax Total Long term Liabilities Owner's Equity Owner's Investment Retained earnings Total Equity Total Liabilities and Equity Distributions to Owners Funds Needed Net Change in Cash Cash, Beginning of Year Cash, End of Year web hosting and domains Miscellaneous Depreciation Travel commission Total Operationg Costs Interest Income before taxes Income Tax Expense Income from continuing operations Income from discontinued operations Effect of accounting changes Extraordinary items 0 ncome