Urgent 1

profilestudystudent
ACC206FinalPaperCashFlow3.xlsx
Home>Business & Finance homework help>Accounting homework help>Urgent 1

Sheet1

Use the column based upon this course start date
Use the following information and prepare a Statement of Cash Flows in good form
Jan-Feb Mar-Apr May-Jun Jul-Aug Sept-Oct Nov-Dec
Net Income 57000 67000 77000 87000 97000 107000
Depreciation 20000 25000 30000 35000 40000 45000
Purchased fixed assets paying cash 310000 310000 310000 310000 310000 310000
Received $90,000 cash for issuance of notes payable 90000 90000 90000 90000 90000 90000
Received $120,000 cash for issuance of common stock 120000 120000 120000 120000 120000 120000
Paid $20,000 for purchase of treasury stock 20000 20000 20000 20000 20000 20000
Ending cash balance 50000 65000 80000 95000 110000 125000
Class Start Date Jan-Feb Mar-Apr May-Jun Jul-Aug Sept-Oct Nov-Dec
Assets 2017 2016 2017 2016 2017 2016 2017 2016 2017 2016 2017 2016
Current assets:
Cash 50000 20000 65000 20000 80000 20000 95000 20000 110000 20000 125000 20000
Accounts receivable 75000 85000 75000 85000 75000 85000 75000 85000 75000 85000 75000 85000
Inventory 100000 80000 100000 80000 100000 80000 100000 80000 100000 80000 100000 80000
Long-term assets
Plant assets 430000 120000 430000 120000 430000 120000 430000 120000 430000 120000 430000 120000
Accumulated depreciation 12000 9000 12000 9000 12000 9000 12000 9000 12000 9000 12000 9000
Total Assets 667000 314000 682000 314000 697000 314000 712000 314000 727000 314000 742000 314000
Liabilities
Current liabilities
Accounts payable 32000 20000 32000 20000 32000 20000 32000 20000 32000 20000 32000 20000
Accrued liabilities 86000 15000 86000 15000 86000 15000 86000 15000 86000 15000 86000 15000
Long-term liabilities
Notes payable 90000 0 90000 0 90000 0 90000 0 90000 0 90000 0
Total liabilities 208000 35000 208000 35000 208000 35000 208000 35000 208000 35000 208000 35000
Stockholders equity
Common stock 220000 100000 220000 100000 220000 100000 220000 100000 220000 100000 220000 100000
Retained earnings 219000 179000 219000 179000 219000 179000 219000 179000 219000 179000 219000 179000
Treasury stock 20000 0 20000 0 20000 0 20000 0 20000 0 20000 0
Total stockholders equity 459000 279000 459000 279000 459000 279000 459000 279000 459000 279000 459000 279000
Total stockholders equity and liabilities 667000 314000 667000 314000 667000 314000 667000 314000 667000 314000 667000 314000