PLEASE SHOW ALL FORMULAS USING EXCEL. FOR EXAMPLE =SUMIF(G12:G47,"

C11 30200 A B D E N- 3 1) Prepare the Income Statement, Balance Sheet and Statement of Cash Flows for YoyoDyne 4. Propulsion Systems (YPS) using the following information. 2) Include Common Size Statements for the Income Statement and the Balance Sheet. 5 3) Fill in all of the ratios on the final tab. 6 7 2016 2015 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 FINANCIAL STATEMENT COMPONENTS Accounts Payable Accounts Receivable Accumulated Depreciation Cash & Equivalents Common Stock Cost of Goods Sold Depreciation Expense Fixed Expenses Interest Expense Inventory Long-Term Debt Other Current Assets Other Current Liabilities Plant & Equipment Retained Earnings Sales Selling. G&A Expense Short-Term Notes Tax Rate Cost of Capital 18,450 54,400 30,200 10,500 40,500 107,200 2,300 7,700 3,400 42,700 32,155 6,616 8,406 56,945 22,750 151,250 15,500 18,700 30% 9.75% 17,2601 55,3001 27,900 9,700 40,500 93,250 2,250 7,1501 2,9051 37,800 29,800 6,385 8,604 53,219 18,240 138,250 13,400 20,100 30% 9.75% 23 24 25 26 27 28 29 Grade YPS Data Income Statement Common-Size Inc Statement Balance A8 3 X Other Current Assets D E F G H K 1 Possible 10 0 Now make a Common Size Balance Sheet. Again, this should be laid out exactly like your Balance Sheet but expressed in percentages. B. YoyoDyne Propulsion Systems 2 Common-size Balance Sheet 3 For the Years Ended December 31, 2016 and 2015 4 2016 2015 5 Assets 6 Cash & Equivalents 7 Accounts Receivable 8 Other Current Assets 9 Inventory 10 Total Current Assets 11 Plant & Equipment 12 Accumulated Depreciation 13 Net Plant & Equipment 14 Total Assets 15 16 Liabilities & Owner's Equity 17 Accounts Payable 18 Other Current Liabilities 19 Short-Term Notes 20 Total Current Liabilities 21 Long-Term Debt 22 Total Liabilities 23 Common Stock 24 Retained Earnings 25 Total Owner's Equity 26 Total Liab. & Owner's Equity 27 28