Could you help me to do a statment of cash flow for year 3? these are all the information for year 2 and 3
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 4899 Step 1: Compute PMT I/Y 0.08% 300 N 60 101 PV 44,100 302 FV :03 CPT PMT (754) 304 Truck 40,141 05 Note Payable 40.141 06 Compute Fair Value 107 I/Y 0.40% :08 CPT PV 40,141 :09 10 Payment Interest Expenses Note reduction Balance of note 11 0.40% 40,141 12 January 31. 20X3 754 161 (593) 39,548 13 February 28. 20X3 754 158 (596) 38,952 14 March 31. 20X3 754 156 (598) 38,354 Interest Expenses 1,768 6 April 30. 20X3 754 153 (601) 37,753 Note Payable 7,280 16 May 31. 20X3 754 151 (603) 37,150 Cash 9.048 17 June 30. 20X3 754 149 (605) 36,545 8 July 31. 20X3 754 146 (608) 35,937 19 August 31. 20X3 754 144 (610) 35,327 20 September 30. 20X3 754 141 (613) 34,714 21 October 31. 20X3 754 139 (615) 34,099 22 November 30. 20X3 754 136 (618) 33,481 23 December 31. 20X3 754 134 (620) 32,861 24 9,048 1768 (7,280)A 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 2Schedule M-1 Net income 120,989 Tax expense 47,051 Tax Expenses 47,051 Book depreciation expense 26,505 Deferred Tax asset- Allowance 320 Tax depreciation expense (46,918) Deferred Tax Payable- Depreciation 5,716 Book bad debt expense 31,864 Deferred Tax Payable Current Asset 532 Tax bad debt expense (30,720) Tax Payable 41,124 Unrealized gain on investments (1,900) Taxable income 146,872 Tax rate 28% Allowance for Doubtful Tax liability 41,124 31,864 30,720 1,144