PLEASE SHOW ALL FORMULAS USING EXCEL. FOR EXAMPLE =SUMIF(G12:G47,"
A8 X V fx Other Current Assets A B C D E F G H K M N O YoyoDyne Propulsion Systems IN Balance Sheets For the Years Ended December 31, 2016 and 2015 Possible For the Balance Sheet, show the following components: 2016 2015 20 0 Total Current Assets, Net Plant & Equipment, Total Assets Assets Current Liabilities, Total Liabilities, Total Owner's Equity, Total Liabilities 6 Cash & Equivalents & Owner's Equity. 7 Accounts Receivable 8 Other Current Assets And don't forget formatting and styling! 9 Inventory And again, all cells should have formulas. 10 Total Current Assets 11 Plant & Equipment Please use the same period assets/liabilities for calculations vs. the 12 Accumulated Depreciation average of periods technique. 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 29 30A22 X v fx Net Change in Cash Balance A B C D F F G H J K L M N O YoyoDyne Propulsion Systems W N Statement of Cash Flows Possible Complete the cells colored in BLUE. All cells should have formula or link to values.. Remember, the Net Change should correspond to For the Year Ended December 31, 2016 10 the Balance Sheet's year over year change. Cash Flows from Operations 5 Net Income 6 Depreciation Expense (Remember, you need to ADD this back into Net Income since it's a non-cash event.) 7 Change in Accounts Receivable (HINT: If A/R decreased, then the company RECEIVED cash since payments were received; and vice versa) 8 Change in Other Current Assets 9 Change in Inventory (HINT: If Inventory increased, the company PAID cash.) 10 Change in Accounts Payable (HINT: If Accounts Payable increased, the company ADDs to cash.) 11 Change in Other Current Liabilities (HINT: If Current Liabilities decreased, the company PAID cash) 12 Total Cash Flows from Operations 3 0 13 Cash Flows from Investing 14 Change in Plant & Equipment 15 Total Cash Flows from Investing 2 0 16 Cash Flows from Financing 17 Change in Short-Term Notes 18 Change in Long-Term Debt 19 Payment of Dividends (HINT: Look at the change in Retained Earnings. Does the change correspond to Net Income?) 20 Change in Common Stock 21 Total Cash Flows from Financing 3 0 22 Net Change in Cash Balance 23 24 25 26 27 Check figure 28 2006 Cash from Balance Sheet 29 2007 Cash from Balance Sheet 30 Net Change in Cash Balance 0
