I NEED HELP CALCULATING RATIOS AND CASH FLOWS. PLEASE SHOW HOW TO SOLVE USING EXCEL FOR EXAMPLE: =SUM(B4:B10)-B15

DATA:

NEED CASH FLOWS

NEED RATIOS

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 E 3 3 900 3 3 YoyoDyne Propulsion Systems Complete the cells colored in BLUE. All cells should have formula Statement of Cash Flows Possible or link to values. Remember, the Net Change should correspond to For the Year Ended December 31, 2016 10 0 the Balance Sheet's year over year change. 4 Cash Flows from Operations Net Income $ 10,605 Depreciation Expense (2,300) (Remember, you need to ADD this back into Net Income since it's a non-cash event.) Change in Accounts Receivable (HINT: If A/R decreased, then the company RECEIVED cash since payments were received; and vi Change in Other Current Assets (231) Change in Inventory (4,900) (HINT: If Inventory increased, the company PAID cash.) 0 Change in Accounts Payable (1,190) (HINT: If Accounts Payable increased, the company ADDs to cash.) 1 Change in Other Current Liabilities 198 (HINT: If Current Liabilities decreased the company PAID cash) 2 Total Cash Flows from Operations 3,082 3 0 3 Cash Flows from Investing 4 Change in Plant & Equipment 3,726 5 Total Cash Flows from Investing 3,726 2 0 6 Cash Flows from Financing 7 Change in Short-Term Notes 1,400 Change in Long-Term Debt (2,355) 9 Payment of Dividends (4,510) (HINT: Look at the change in Retained Earnings. Does the change correspond to Net Income?) C0 Change in Common Stock (5,465) 1 Total Cash Flows from Financing (10,930) 3 0 -2 Net Change in Cash Balance -3 -4 -5 -6 -7 Check figure -8 2006 Cash from Balance Sheet 0 -9 2007 Cash from Balance Sheet 0 EO Net Change in Cash Balance 0