RC Incr Sales Cash Flow Worksheet

RC Incr Sales Cash Flow Worksheet - S 75,000 Notes Payable...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sales $3,500,000 Cost of Goods Sold % 57 Interest % 7 Income Tax % 32 Collection Period Days for A/R 45 Days Sales in Inventory 90 Purchase of New Equipment $375,000 Payment Period Days in A/P 45 $250,000 Number of New Shares of Stock 7,000 Dividends Paid for Full Year $100,000 Shares Purchased for Treasury 1,500 Balance Sheets Balance Sheet Titles Last Year This Year Incr / (Decr) Information for Operating Investing Financing 12/31/2008 12/31/2009 Cash Combine/Explode Area the Line Item Activities Activities Activities ASSETS Cash 115,000 88,788 (26,212) Accounts Rec. 246,000 617,014 U 371,014 increase A/R U 371,014 Inventory 280,000 703,836 U 423,836 increase Inventory U 423,836 600,000 975,000 U 375,000 purch Equipment U 375,000 Accum Depr. (160,000) (257,500) S 97,500 depreciation S 97,500 TOTAL ASSETS 1,081,000 2,127,138 LIABILITIES Accounts Payable 140,000 351,918 S 211,918 increase A/P S 211,918 Other Curr Liab. 100,000 175,000 S 75,000 incr. Oth Curr Liab
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: S 75,000 Notes Payable 300,000 550,000 S 250,000 borrow on N/P S 250,000 TOTAL LIABILITIES 540,000 1,076,918 EQUITY Common Stock 42,000 49,000 S 7,000 S 350,000 Issue Common Stock S 350,000 Paid in Cap in Excess 384,000 727,000 S 343,000 Retained Earnings 115,000 349,220 S 234,220 S 334,220 Net Income S 334,220 U 100,000 Dividends U 100,000 Treasury Stock 0 (75,000) U 75,000 purch Treas. Stock U 75,000 TOTAL EQUITY 541,000 1,050,220 TOTAL LIAB/EQUITY 1,081,000 2,127,138 (26,212) Total Sources S 1,218,638 S 718,638 S 0 S 600,000 Total Uses U 1,244,850 U 794,850 U 375,000 U 175,000 Net Sources/Uses U 26,212 U 76,212 U 375,000 S 425,000 U 26,212 Set Red Company's Input Variables to the Values Shown Below New Borrowing (Pay-Off) Jan 1 Cash Flow Worksheet to Produce Red Company's Statement of Cash Flows S ource of Cash U se of Cash...
View Full Document

Ask a homework question - tutors are online