W08 Peer Feedback- Building a Cash Flow Statement.xlsx -...

This preview shows page 1 - 6 out of 6 pages.

W08 Building Cash Flow Statement P Dec Jan Feb Mar Ukulele Sales 12,500 12,563 12,625 Cost of Goods Sold 8,125 8,166 8,206 Gross Pofit 4,375 4,397 4,419 Advertising Cost 3,250 3,266 3,283 Rent 500 500 500 Internet 50 50 50 Legal Fees 500 - - Wages - - - Total expenses 4,300 3,816 3,833 Net Income before taxes and Depreciation 75 581 586 Income Taxes 12 93 94 Depreciation 22 22 22 Net Income 41 466 471 Operating Activities Net Income $ 41 $ 466 $ 471 Changes in Cur. Assets and Liabilites Change in Accounts Receivable $ (12,500) $ (12,563) $ (125) Change in Inventory $ - $ (2,050) $ (3,024) Change in Accounts Payable $ - $ - $ - Non-cash expenses Depreciation $ 22 $ 22 $ 22 Cash Flow From Operating Activities $ (12,437) $ (14,125) $ (2,657) Investing Activities Change in Equipment $ - $ - $ - Cash Flow form Investing Activities $ - $ - $ - Financing Activities Change in Notes Payable $ 26,919 $ - $ - Change in Paid-in-Capital $ - $ - $ - Change in Owner's Withdrawal $ - $ - $ - Cash Flow from Financing Activities $ 26,919 $ - $ - Net increase in cash $ 14,482 $ (14,125) $ (2,657) Cash--beginning of month $ 5,000 $ 19,482 $ 5,357 Cash--end of month $ 19,482 $ 5,357 $ 2,700
Assets Cash 5000 19,482 5,357 2,700 Accounts Receivable 0 12,500 25,063 25,188 Inventory 3015 3,015 5,065 8,089 Equipment 1310 1,310 1,310 1,310 Less Accumulated Depreciation (22) (44) (66) Total Assets 9,325 36,285 36,751 37,222 Liabililities Accounts Payable - - - Notes Payable 0 26,919 26,919 26,919 Total Liabilities - 26,919 26,919 26,919 Owners Equity Paid-in-Capital 5000 5,000 5,000 5,000 Owner's Withdrawal - - - Retained Earnings 4325 4,366 4,832 5,303 Total Owner's Equity 9,325 9,366 9,832 10,303 Total Liabilities and Owner's Equity 9,325 36,285 36,751 37,222
Profit and Loss Statement Apr May Jun Jul Aug Sep Oct Nov 12,688 12,752 12,816 12,880 13,056 13,354 14,565 15,123 8,247 8,289 8,330 8,372 8,486 8,680 9,467 9,830 4,441 4,463 4,485 4,508 4,570 4,674 5,098 5,293 3,299 3,315 3,332 3,349 3,365 3,382 3,399 3,416 500 500 500 500 500

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture