Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is suppose to be a cash flow statement and I was having trouble filling this out AutoSave OF Ao 3-31-20 Arborista Reports - Worksheets
This is suppose to be a cash flow statement and I was having trouble filling this out
AutoSave OF Ao 3-31-20 Arborista Reports - Worksheets No. 1a Museum Quality-1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibrl (Body) v 11 ~ A Insert v Number 4 [G 2 Wrap Text Merge & Center Paste BIU A Delete Format Y Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G15 R 5 T V W A B C 1 Arborista, Inc. Museum Quality 4/10/20 Worksheets No 1a-Mar 31, 2020 3 CF Helping Hand 4 Date Event 5 12/1/18 1 Issue: 10,000 shares afsock 2 Bank Laan Process Ducon 12/31/2021 A 2a Interesi 6% pery screen mo D D E F H I L M Note All Columns need to be completed! Arborista, Inc. Mayr end Cash Flow Statement 12/7/19 12/14/19 12/21/10 12/28/19 12/31/19 1/5/201/12/20 1/19/20 year ended 12/31/2019 Cash at leginning 50,000 50,000 20,000 20,000 Operating Activities Nat income Ade Deduct) items rol alTecting 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 900 3 Purchase 2 pick-up trucks last 5 yrs and be worth 2,000 to 200 (1.500) (500) 2,750 350 Prepaid we Wages payable, Unearned revenue & Interest apable Frank is hired paid when work complete 10 11 12 13 14 15 16 17 18 19 20 Francois shired paid in advance Investing Activities Poyrents for Property, Plant Equipment 114,000) ) Trec Revenue=$75 per Tree Cash used by Investing Activities 114,000) ) Wage paid - $20 per Tree 12/18/15 4 Imprimaanra 20 trees for 12:19 Frank plants an 12/19/2020 cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2020 Frank palc ar 1/5/2020 Financing Activities Praces from issuance at common stock 22 23 24 25 26 27 22 29 30 50,000 1,500 ir dialogue fr dialogue 400 Praceeds from Bank Loan 20,000 70,000 Cash provided by Financire Activities 12/18/19 5 no 30 trees plante 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 2,250 Cash at End 57,650 Agrees with Balance shee 56,000 1,650 400 0 1,500 Cross Total Check 12 31 57.550 32 33 34 35 36 37 32 39 40 0 41 CF IS BS Joumal and GL Your Comments Sheet1 + + 100% AutoSave OF Ao 3-31-20 Arborista Reports - Worksheets No. 1a Museum Quality-1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibrl (Body) v 11 ~ A Insert v Number 4 [G 2 Wrap Text Merge & Center Paste BIU A Delete Format Y Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G15 R 5 T V W A B C 1 Arborista, Inc. Museum Quality 4/10/20 Worksheets No 1a-Mar 31, 2020 3 CF Helping Hand 4 Date Event 5 12/1/18 1 Issue: 10,000 shares afsock 2 Bank Laan Process Ducon 12/31/2021 A 2a Interesi 6% pery screen mo D D E F H I L M Note All Columns need to be completed! Arborista, Inc. Mayr end Cash Flow Statement 12/7/19 12/14/19 12/21/10 12/28/19 12/31/19 1/5/201/12/20 1/19/20 year ended 12/31/2019 Cash at leginning 50,000 50,000 20,000 20,000 Operating Activities Nat income Ade Deduct) items rol alTecting 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 900 3 Purchase 2 pick-up trucks last 5 yrs and be worth 2,000 to 200 (1.500) (500) 2,750 350 Prepaid we Wages payable, Unearned revenue & Interest apable Frank is hired paid when work complete 10 11 12 13 14 15 16 17 18 19 20 Francois shired paid in advance Investing Activities Poyrents for Property, Plant Equipment 114,000) ) Trec Revenue=$75 per Tree Cash used by Investing Activities 114,000) ) Wage paid - $20 per Tree 12/18/15 4 Imprimaanra 20 trees for 12:19 Frank plants an 12/19/2020 cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2020 Frank palc ar 1/5/2020 Financing Activities Praces from issuance at common stock 22 23 24 25 26 27 22 29 30 50,000 1,500 ir dialogue fr dialogue 400 Praceeds from Bank Loan 20,000 70,000 Cash provided by Financire Activities 12/18/19 5 no 30 trees plante 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 2,250 Cash at End 57,650 Agrees with Balance shee 56,000 1,650 400 0 1,500 Cross Total Check 12 31 57.550 32 33 34 35 36 37 32 39 40 0 41 CF IS BS Joumal and GL Your Comments Sheet1 + + 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started