Could you help me to prepare a statement cash flow inderct method
Asset: 20X] 20X2 20X3 Cash 114,835 56.160 229,547 Account Receivable 66.145 116,010 114,430 Allowance For Doubtful accounts (1,144) Deffered Tax Asset- Allowance 320 Shop supplies on hand 1,070 820 820 office suplies on habd 620 740 660 prepaid insurance 10.500 9.820 15,180 Short Term Investment 21,300 Lumber Inventory 8.000 13.100 11,540 Total Current Assets 201,170 196.650 392,653 Truck 98,000 138,141 Accumlate Depreciation- Truck (9.300) 38.700 (22,114) 116,027 Tools 55,090 74,970 I Accumlate Depreciation- Tools (7,440) 47,650 (17,736) 57,234 Computer 4.850 13,580 Accumlate Depreciation- Computer (1,213) 3.638 (4,608) 8.973 3 Total Fixed Assets 201,170 139,988 182,233 4 Long term Investment 56050 72,050 Total Assets 201,170 392,688 646,936 6 Liablities: Account Payable 5,335 8,730 8.245 9 Tax Payable 20,002 7,658 24,124 0 Note Payable 32,861 Deferred Tax Payable- Current investm 532C E F H J K 21 Computer 4.850 13,580 22 Accumlate Depreciation- Computer (1,213) 3.638 (4,608) 8,973 23 Total Fixed Assets 201.170 139.988 182,233 24 Long term Investment 56050 72,050 25 Total Assets 201,170 392,688 646,936 26 27 Liablities: 28 Account Payable 5.335 8.730 8.245 29 Tax Payable 20.002 7.658 24,124 30 Note Payable 32,861 31 Deferred Tax Payable- Current investm 532 32 Dividends Payable 2.160 2.430 14,850 33 Totl Current Liablities 27.497 18,818 80,611 34 Deferred Taxes payable - Depreciation 5,778 11,494 35 Deferred Taxes Payable - Investment 756 5.236 36 Total Liablities 27,497 25,351 97,341 37 38 Shareholders' Equity Comon Stock 21,600 48.600 59,400 40 Additional Paid-in Capital in excess of F 75,900 195,200 258,500 41 Retain Earnings 76.173 121,592 218,231 42 Accumlate other comprehensive income 1,944 13,464 43 Total Equity 173.673 367.336 549,595 44 Total Liabllsties and Equity $ 201,170 $ 392,688 646,936 45 46 47 48A B C G H K L M N 0 P Q R Statement of Comprehensive Income 20X1 20X2 20X3 Net income 80,233 52.549 120,989 Other comprehensive income 2,700 16,000 Tax effect (756) 1.944 (4.480) 11,520 Comprehensive income 80.233 $ 54.493 $ 132.509 Kiline Inc. Statement of Owners' Equity For the year endedn December 31.20X1 Common Additional Other Comprehensive Retained Total Stock Paid- in Capital Income Earnings Beganing Balance $ $ $ $ $ Issuance of stock 21,600 21,600 Net income 80,233 80,233 Dividends declared (4,060) (4,060) Balance of December 31, 20X1 21,600 $ 75,900 $ - $ 76,173 $ 173,673 Issuance of stock 27/000 119,300 146,300 Net income 52,549 52,549 Other comprehensive income 1.944 1,944 Dividends declared (7.130) (7.130) Balance as of December 31,20% $ 48,600 $ 195,200 $ 1,944 $ 121,592 $367.336 Issuance of stock 10,800 63,300 74,100 Net income 120,989 120.989 Other comprehensive income 11,520 11,520 Dividends declared (24.350) (24.350) Balance as of December 31,20% 59,400 258,500 13,464 218,231 549,59520X1 20X2 20X3 Sales 334,100 385,600 525,500 8 Operating Expenses: 9 Lumber Expenses 45,350 82,200 84,010 Shop Suplies expenses 18,530 10,050 11,760 2 Office Suplies expenses 2,620 11,220 6,560 Marketing expenses 42,813 66,738 58,076 4 Gasoline expenses 16,816 19,055 20,176 5 Insurance expenses 21,000 31,080 37,960 6 Rent expenses 57,600 57,600 57,600 7 Interest Expenses 1,768 8 Depreciation expenses 17,953 26,505 9 Bad Debt Expenses 31,864 : 10 Utilities expenses 17,936 16,720 23,080 Total Operating Expenses 222,665 312,616 359,359 :2 Total Operating Income 111,435 72,985 166,141 :3 Unrelized Gain on STI 1,900 4 Pretax income 111,435 72,985 168,041 tax expesess 31,202 20,436 47,051 6 Net income $ 80,233 $ 52,549 120,989 7 Earning per share 3.71 1.08 2Direct Method For Operating Cash Flows m-m Cash Collected Pram Saies 253,955 - 335,735 Cash Paid For Lumber (43,015] - (33,905] Cash Paid For Shop Supplies [19,500] - [9,300] Cash Paid For Oice Supplies [3,240] - (11,340] Cash Paid For Marketing [42,313] - [66,333] Cash Paid For Gasoline [15,315] - [19,05 5] Cash Paid For Insurance [31,500] - [30,400] Cash Paid Pee Rent [53,5011] - [535500] Cash Pai Per Utililies [13,935] - [16,?2 0] Cash Paid For Taxes [11,2011] - [235002] Total Operating Cash ows 19,235 - 13,175 021 Jx A B C D E F Statement of Cash Flow For The Year Ended December 31 Operating Cash Flows 20X1 20X2 20X3 Net Income 80,233 52,549 120,989 Depreciation Expenses 17,953 26,505 Bad Debts Expenses 1,144 Unrealized Gain on ST Change in A/R (66,145) (49,865) 1,580 Change in deferred Tax asset (320) Change in Shop Supplies (1,070) 250 Change in Office Supplies (620) (120] 80 Change in Short Term - Investment (21,300] Change in Prepaid insurance (10,500) 680 (5,360) Change in lumber Inventory (8,000) (5,100) 1,560 Change in Account Payable 5,335 3,395 (485) Change in Taxes Payable 20,002 (12,344) 16,466 Change in deferred Tax Payable- Current inv 532 Change in deffered tax payable -Depreciation 5,778 5,716 Total Operating Cash Flows $ 19,235 13,175 147,107
