WILL VIEW Automate Help Open in Desktop App Calibri v 11 B v v Av. ab B Cust fx A D E F H Brendan's Bottled Water Ltd Income Statement Year 5 $200 Less: Sales Cost of Goods Sold Gross Profit 50 150 30 20 Wage Expense Rent Expense Depreciation Expense Total Operating Expense 50 add: Gain on Sale of Capital Asset Profit or (Loss) 25 Cooler was sold for $175 125 Brendan's Bottled Water Ltd Statement of Owners Equity Year 5 1 $80 D E F G Pront or (LOSS) 125 Brendan's Bottled Water Ltd Statement of Owners Equity Year 5 Common Stock (paid-in capital) $80 add: Less: Retained Earnings - beg of year Net Income Dividends Retained Earnings - end of year 1,130 125 (500) 755 Owner's Equity @ 12/31/15 $835 Brendan's Bottled Water Ltd Comparative Balance Sheet 3 4 35 36 37 Year 5 Year 4 Difference Assets Cash $835 $1,240 Calibri 11 B v Gv ... V Custom fx B E F G 1 D Brendan's Bottled Water Ltd Comparative Balance Sheet Year 5 Year 4 Difference Assets $835 $1,240 Cash Accounts Receivable Inventory Total Current Assets 25 860 50 1,290 Cooler was sold for $175 CA - Cooler AD - Cooler not use 250 (100) 150 1,440 Total Long Term Assets Total Assets 860 5 6 48 25 Liabilities Accounts Payable Wages Payable Current Liabilities 200 30 230 25 50 51 52 Long Term Liabilities (Loan from Dad) Total abilities 50 25 230 55 Equity Year 1 15 Year 2 FS Year 3 FS Year 4 FS Year 5 FS Calculation Mate Workbook esc 06 Bo DDD DDG 14 @ A * # 3 % 5 & 7 2 4 6 9 Q W E R Fab T Y Y U 0 S D F G . K slock Z C B M TUNTUIS wala Review View Automate Help Open in Desktop App Calibri V 11 B Eva A vable 3 Custor fx B D G 25 Liabilities Accounts Payable Wages Payable Current Liabilities 200 30 25 230 Long Term Liabilities (Loan from Dad) Total Liabilities 25 230 Equity Common Stock Retained Earnings Total Equity 80 755 835 80 1,130 do not use 1,210 860 1,440 Total Liabilities and Stockholder's Equity 3 7 5 6 57 Brendan's Bottled Water Ltd Statement of Cash Flows Year 5 E 1 fx B E G Brendan's Bottled Water Ltd Statement of Cash Flows Year 5 Cash Flows from Operating Activities Net Income add: Depreciation less: Gain 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 Cash Flows from Investing Activities Cash received from sale of cooler Net Cash Flows from Investing Activities 1 32 33 84 85 86 87 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 Year 1 FS Year 2 FS Year 3 FS Year 4 FS Year 5 FS + Calculation Mode: Automatic Workbook Statistics esc 20 DOG FI F3 F4 F5 52 2 $ 4 % 5 3 & 7. 6 TAL C File Home Insert Formulas Data Review View Automate Help Open in Desk V Calibri v 11 B Ev V V f B E F G 9 30 31 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 D Cash Flows from Investing Activities Cash received from sale of 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 PS Year 2 F5 Year 3 FS Calculation Mode: Automatic Workbook Statistics Year 4 FS Year 5 FS + esc F2 20 COD F3 55 # 3 2 $ 4. % 5 * & 7 6 8
