Arborista, Inc. Museum Quality 12/31/2019 Worksheets No. 1a-Nov. 9, 2019 CF Date Event 12/1/2019 1 Issued 10,000 shares of stock 2 Bank Loan Proceeds Due on 12/31/2021 2a Interest 6% per yr accrues ea mo % 800 Note All Columns need to be completed! Arborista, Inc. Mo/Yr end Cash Flow Statement 12/7/19 12/14/19 12/21/19 12/28/19 12/31/19 1/5/20 1/12/20 1/19/20 year ended 12/31/2019 Cash at Beginning 50,000 50,000 20,000 20,000 Operating Activities: Net Income Add(Deduct) items not affecting cash Depreciation expense -14,000 -14,000 Less Incr. in accounts receivable Less Incr. in other current assets Plus Incr. in current liabilities Cash provided from Operating Activities 3 Purchased 2 pick-up trucks last 5 yrs and be worth 2,000 total 200 (1,500) (600) 2.750 850 Prepaid wages Wages payable, Unearned revenue, & Interest payal Frank is hired paid when work completes Francois is hired paid in advance Investing Activities: Payments for Property, Plant Equipment (14,000) Tree Revenue = $75 per Tree (14,000) Cash used by Investing Activities Wage paid = $20 per Tree 12/18/2019 4 Imaprimadonna 20 trees for 12/19 Frank plants on 12/19/2020 cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2020 fr dialogue Frank paid on 1/5/2020 fr dialogue Financing Activities: Proceeds from issuance of common stock 50,000 Proceeds from Bank Loan 20,000 70,000 Cash provided by Financing Activities 12/18/2019 5 Bonappetit 30 trees planted Francois plants on 1/19/2020 Schedule for planting on 1/19/2020 cust. pays on 12/18/2019 Francois paid on 12/18/19 Cash at End 57,650 Agrees with Balance Sheet 2,250 -600 56,000 0 1,650 0 0 0 0 0 Cross Total Check 12-31 57,650 Arborista, Inc. Museum Quality 12/31/2019 Worksheets No. 1a-Nov. 9, 2019 CF Date Event 12/1/2019 1 Issued 10,000 shares of stock 2 Bank Loan Proceeds Due on 12/31/2021 2a Interest 6% per yr accrues ea mo % 800 Note All Columns need to be completed! Arborista, Inc. Mo/Yr end Cash Flow Statement 12/7/19 12/14/19 12/21/19 12/28/19 12/31/19 1/5/20 1/12/20 1/19/20 year ended 12/31/2019 Cash at Beginning 50,000 50,000 20,000 20,000 Operating Activities: Net Income Add(Deduct) items not affecting cash Depreciation expense -14,000 -14,000 Less Incr. in accounts receivable Less Incr. in other current assets Plus Incr. in current liabilities Cash provided from Operating Activities 3 Purchased 2 pick-up trucks last 5 yrs and be worth 2,000 total 200 (1,500) (600) 2.750 850 Prepaid wages Wages payable, Unearned revenue, & Interest payal Frank is hired paid when work completes Francois is hired paid in advance Investing Activities: Payments for Property, Plant Equipment (14,000) Tree Revenue = $75 per Tree (14,000) Cash used by Investing Activities Wage paid = $20 per Tree 12/18/2019 4 Imaprimadonna 20 trees for 12/19 Frank plants on 12/19/2020 cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2020 fr dialogue Frank paid on 1/5/2020 fr dialogue Financing Activities: Proceeds from issuance of common stock 50,000 Proceeds from Bank Loan 20,000 70,000 Cash provided by Financing Activities 12/18/2019 5 Bonappetit 30 trees planted Francois plants on 1/19/2020 Schedule for planting on 1/19/2020 cust. pays on 12/18/2019 Francois paid on 12/18/19 Cash at End 57,650 Agrees with Balance Sheet 2,250 -600 56,000 0 1,650 0 0 0 0 0 Cross Total Check 12-31 57,650
