Home Insert Formulas Data Review View Automate Help Open in Calibri v 11 7 B LG v A v abe fx B D E F G H Income Statement Year 2 Sales Less: Cost of Goods Sold Gross Profit $500 125 375 Rent Expense 20 Total Operating Expense 20 Profit or (Loss) 355 1 2 13 14 15 16 17 18 19 20 21 22 23 24 25 Brendan's Bottled Water Ltd Statement of Owners Equity Year 2 Common Stock (paid-in capital) $80 75 355 Retained Earnings - beg of year add: Net Income Less: Dividends Retained Earnings - end of year Year 1 FS Year 2 FS Year 3 FS Year 4 FS 430 Year 5 FS + Calculation Mode: Automatic Workbook Statistics Calibri v 11 V BEO Av... Cu fx B D E F G H I Total Operating Expense 20 Profit or (Loss) 355 Brendan's Bottled Water Ltd Statement of Owners Equity Year 2 Common Stock (paid-in capital) $80 75 355 Retained Earnings - beg of year add: Net Income Less: Dividends Retained Earnings - end of year 430 Owner's Equity @ 12/31/15 $510 3 4 5 26 27 28 29 30 31 32 33 24 Brendan's Bottled Water Lid Comparative Balance Sheet Year 2 Year 1 Difference Accord Year 1 FS Year 2 FS Year 3 FS Year 4 FS Year 5 FS + Calculation Mode: Automatic Workbook Statistics DOO 4 esc F2 77 F3 4 # 3 % 5 & 7 1 2 4 6 Q W E R. T Y U Home Insert Formulas File Data Review View Automate Help automate Open in Desktop App v V Calibri 11 BECA Custom A1 f AB E F G H I Year 2 Year 1 Difference $460 $130 25 155 460 250 30 Brendan's Bottled Water Ltd 31 Comparative Balance Sheet 32 33 34 Assets 35 Cash 36 Inventory 37 Total Current Assets 38 39 CA-Cooler 40 41 Total Long Term Assets 42 Total Assets 43 44 Liabilities 45 Current Liabilities 46 47 Long Term Liabilities (Loan from Dad) 48 Total Liabilities 49 50 Equity 51 Common Stock 52 Retained Earnings 53 Total Equity Year 1 FS Year 2 F5 Year 3 F5 Year 4 FS Year 5 FS Calculation Mode: Automatic Workbook Statistics 250 710 155 200 200 $0 80 430 510 80 75 155 do not use + esc 80 dad 900 *** F 2 a & % 5 2 3 4 6 7 B Q W E R. T Y fab AS bristolccedu-my.sharepoint.com o. Excel Roberge, Zach > Documents Chap 16 Cash Flow Brendan 2020 upload File Home Insert Formulas Data Review View Automate Help Open in Desktop App Calibri 11 B BAY... 22 Custom 1 G AB D E F G H I $460 Cash Inventory $130 25 155 Total Current Assets 460 35 36 37 38 39 40 CA - Cooler 250 Total Long Term Assets 250 710 Total Assets 155 42 43 44 45 46 Liabilities Current Liabilities Long Term Liabilities (Loan from Dad) Total abilities 200 200 $0 47 48 49 50 51 52 53 54 55 56 57 Equity Common Stock Retained Earnings Total Equity 80 430 510 80 75 155 do not use Total Liabilities and Stockholder's Equity 710 155 Year 1 PS Year 2 FS Year 3 FS Year 4 FS Year 5 PS Calculation Mode Workbook Statistics esc Bo 000 *** 55 A # 3 $ 4 % 5 & 7 2 6 8 IAI D T Excel Roberge, Zach > Documents Chap 16 Cash Flow Brendan 2020 upload File Home Insert Formulas Data Review View Automate Help Open in Desktop App Calibri B v 29 Cust A1 fx D m F G H 60 61 62 63 Brendan's Bottled Water Lid Statement of Cash Flows Year 2 64 65 66 Cash Flows from Operating Activities Net Income add: Depreciation less or Loss on Sale of Capital Assets Change in Accounts Receivable Change in Inventory Change in Accounts Payable Change in Wages Payable Net Cash Flows from Operating Activities 58 69 70 71 72 73 74 75 76 77 78 79 Cash Flows from Investing Activities Cash used to purchase cooler Net Cash Flows from Investing Activities Cash Flows from Financing Activites Cash flows from Long Term Borrowing Cash flows from Sale of Stock Cash flows from Payment of Dividends Net Cash Flows from Financing Activites 81 82 85 Year 1 FS rear 2 Year 3 FS Year 4 FS Year 5 FS + Calculation Mode: Automate Workbook Statistics DOO esc 80 F3 ES 97 # 3 2 4 5 6 7 8 W E R Y tab Chap 16 Cash Flow Brendan 2020 up File Home Insert Formulas Data Review View Automate Help Open in Desktop Calibri v 11 00 B Av... Al fx B C D G H Net Cash Flows from Operating Activities 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 89 89 90 91 92 93 94 95 Cash Flows from Investing Activities Cash used to purchase cooler Net Cash Flows from Investing Activities Cash Flows from Financing Activites Cash flows from Long Term Borrowing Cash flows from Sale of Stock Cash flows from Payment of Dividends Net Cash Flows from Financing Activites Change in Cash Position Cash at beginning of period Cash at end of period Year 1 FS Year 2 FS Year 3 FS Year 4 FS Year 5 FS + Calculation Mode: Automatic WorkbookStatistics esc F COD GOO 4 F6 $ 4 % 5 N & 7 3 6 Q W E R. T tab