File Home Insert Formulas Data Review View Automate Help Open in De Dvo Calibri v 11 B av av 21 fx B C F D Brendan's Bottled Water Ltd Income Statement Year 3 $500 Less: Sales Cost of Goods Sold Gross Profit 125 375 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 30 20 Wage Expense Rent Expense Depreciation Expense Total Operating Expense 50 100 Profit or (Loss) 275 16 17 18 Brendan's Bottled Water Ltd Statement of Owners Equity Year 3 19 Profit or (Loss) 275 Brendan's Bottled Water Ltd Statement of Owners Equity Year 3 Common Stock (paid-in capital) $80 add: Less: 430 275 2. 3 24 25 26 27 28 29 30 31 32 Retained Earnings - beg of year Net Income Dividends Retained Earnings - end of year Owner's Equity @ 12/31/15 705 $785 Brendan's Bottled Water Ltd Comparativa Ralana Shant Year 2 FS Year 3 PS Year 4 FS Year 1 FS Year 5 FS + Calculation Mode: Automatic Workbook Statistics esc 80 F2 4 F3 000 F4 F6 # 3 $ 4 % 5 2 & 7 6 Q W E 20 T Y tab S D F F. H ps lock Home Insert Formulas Data Review View Automate Help Open in Desktop App Calibri v 11 V B HYA.. Custom fi B G H D UGOVU TIL Comparative Balance Sheet Year 3 Year 2 Difference Assets $460 Cash Accounts Receivable Inventory Total Current Assets $720 40 25 785 460 250 do not use CA-Cooler AD - Cooler Total Long Term Assets Total Assets 250 (50) 200 985 250 710 Liabilities Current Liabilities 5 -6 27 B 49 50 51 52 53 54 55 Long Term Liabilities (Loan from Dad) Total Liabilities 200 200 200 200 80 Equity Common Stock Retained Earnings Total Equity Year 1 FS Year 2 FS Year 3 FS 80 705 785 do not use BO Year 4 FS Year 5 FS + Caliculation Mode: Automatic Workbook Statistics esc 009 000 F 7 FT * $ 4 % 5 & 7 2 3 6 8 3 F RT TYU Home Insert Formulas Data Review View Automate Help Open in Desktop App V Calibri 11 BHOA v Custom fx B D E F G H I Total Long Term Assets 200 985 250 710 Total Assets Liabilities Current Liabilities Long Term Liabilities (Loan from Dad) Total Liabilities 200 200 200 200 80 Equity Common Stock Retained Earnings Total Equity 80 705 785 do not use 80 Total Liabilities and Stockholder's Equity 985 280 1 52 53 64 65 66 Brendan's Bottled Water Ltd Statement of Cash Flows Year 3 Flows from Operatine Activities Year 1 FS Year 2 FS Year 3 FS Year 4 FS Year 5 PS + Calculation Mode: Automatic Workbook Statistics esc Bo 73 a # 3 % 5 2 4 6 7 8 W E R. T fx HAB D E F G Brendan's Bottled Water Ltd Statement of Cash Flows Year 3 3 4 55 66 67 68 69 70 71 72 73 74 75 76 77 78 79 BO 81 82 83 B4 RS 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 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 Year 1 PS Year 2 FS Year 3 FS Year 4 PS Year 5 FS + Calculation Mode: Automatic Workbook Statistics esc * 20 DOO 000 F4 F F2 73 55 @ 2 # 3 $ 4 % 5 & 7 6 Q 3 E R Y tab Calibri ... li > A1 fx D E F G 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 A B 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 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 Workbook Statistics esc 0 20 F3 000 F 2 # 3 $ 4 % 5 6 & 7 Q tab W E R