Based on the information provided below, prepare a Statement of Cash Flows. Remember to include all three sections of this statement as well as the necessary reconciliation of cash flows at the bottom of the statement. (It may be helpful to copy the below information and paste it into Excel for easier accessibility when completing the Statement of Cash Flows. Then copy your solution from Excel and paste into the response box below) Balance Sheet Income Statement Assets Cash Accounts receivable Inventory PPE Less Accumulated Depreciation 12/31/41 12/31/YO 20,2000 5,0600 4,2000 75,000 0 Sales revenue Cost of goods sold Gross margin Wages Expense Utilities Expense Year 1 7,560 1,800 5760 450 2,000 875 Depreciation Expense 875 Land 2,500 0 106,085 0 2,435 1.875 Total Assets Operating Income Interest Expense Earnings before income tax Income tax Net Income 560 196 364 12/31/Y1 12/31/YO 3,400 250 0 1,875 0 196 0 Liabilities Accounts Payable Wages Payable Interest Payable Taxes Payable Total Current Liabilities Notes Payable Total Liabilities Equity Common stock Preferred stock Additional Paid-in Capital - 5,721 75,000 80,721 0 0 0 2500 10,0000 4.750 0 Net Income 364 Accounts Payable Wages Payable Interest Payable Taxes Payable Total Current Liabilities Notes Payable Total Liabilities Equity Common stock Preferred stock Additional Paid-in Capital CS Additional Paid-in Capital - 3,400 0 2500 1,875 0 196 0 5,7210 75,0000 80,721 0 250 10,000 4,7500 Oo oo oo PS Retained earnings Total Equity 10,000 364 25364 Total Liabilities & Equity 106,085 0 Additional Information: a. Jan 1st, issued 500 shares of common stock ($0.50 par value) for $5000. b. Feb 1st, paid $2500 to purchase land. C. Feb 28th, issued 100 shares of preferred stock ($100 par value) for $20,000. d. June 30th, paid $75,000 for a building (estimated useful life of 40 years: salvage value = $5,000) by signing a 5 year Note Payable, promising to pay 5% interest at the end of each of those 5 years (i.e. on June 30th of each year). TABLE LI Present Value of $1 010650 OSNO CROSO ORSO NIE ON 000 016 . OS 0510 OBE SOCHO LED G 08036 085349 016 GOCIO 09214 O 10 070250 OS SOCO eno vo 0291 OS OSOS 0.64461 00111 0.14409 Present Value of $1 SO TO 2 45 LEO OS 0.7220 0.20133 0. 66112 0.41 2017 NOSO 757 100 OS OS 0.00135 2 OS OR DEO 0.49811 DO One BEO TO ON 00 SO SO SO 24 0.67275 6.490 004 8862 O CEO TO TO 19 COLO 11 10000 07719 SO . DES LOWO WHO RO ES 44 LIDO SO LO COCO DE 053 4500 0316 to SZEZO 1577 100 so 0611 1100 755 WED SO SOCO DO 246 2018 16151 Pest Value of $1 TO OCENTO WHO 2016 SOURCE re 0.255 033199 2000 021 0233 O2000 2003 13210 01571 1411 OD 200 09 D 11 0122 04 100 0920 000 017 HOLDE EOS 0151 TABLE 1.2 Present Value of Annuity of $1 Periods 1.ON SIND 90010 1920-40 294099 COSO HII OSMET 191147 CECI 60 272508 3.62990 185041 272325 10002 201412 2.000 2010 1651 L 126 521507 2.71710 4571 5.41719 6.23028 012941 SOS 4 579548 6.72819 7651 410020 444 0.94340 101 267301 2.46511 2123 49172 5.5820 62097 60169 700 1346 5.6014) 6.67199 7.154 16224 524214 S. HINCE 610200 792027 821279 673274 7.41533 311090 6.6637 75135 801009 6.46321 7. OTR2 772173 59710 55153 7020 9.47130 Presest Value of Annuity of $1 ON 1036763 NE TES 1057534 TE PRICE EE 7.49857 7.94200 COSEC 6 SEE 12.13374 1100370 SOS 1471787 55622 16 11 201 045 12.106.25 12 1357771 1429187 1499203 164 1610 115234 9.25252 315400 1063 19601 1193794 126110 116612 13.15151 1432380 148774 1741315 19.60044 9.52209 10.10 10. 72 111 11.87017 12.449 1297045 13.41731 1316 16.0420 17 9.3045 1056312 11119 11 6230 126 12 13.1994 1359 15.62200 112903 8.64354 9 250 98251 10 1909 10 11401 119315 12.4059 12 13.20 15.21734 16.77902 10.376 10 1117 111001 11659 1208512 12 . 1694 971225 10.10500 106125 100 1115812 12 127330 13 10542 10791 9. ES 1622 100 10 1500 100 1165350 12 000 Pr o fit of $1 COCO 09176 SO ORT CEO 00000 12 2.60 10245 25129 252710 31201 O TOOS 2.40133 103735 16040 41114 456376 O 166 236115 2916 151733 1995 42251 22 29111 10 2 2023 25 125216 144000 15200 2160 O 370 20 254 ME 4 50 WE OCH 2106 2. 2006 115 160459 13310 COM 1927 21 11511 120 1604 514) LETE SO SOLES CES 5320 5602 18 Soat 21617 11 2520so Present Value of Any of $1 530519 DIS S02 12700 16 620652 16 SE 1 SS ES 7 7 6215 6621 512101 60 11 LINES HERE 09 SE WE 51216 0155 2014 1916 79 162 78929 697 711 2016 110 30 Future Value of $1 102010 16:1030 1.04060 103000 106090 109273 100250 100681 113300 118115 123135 20060 102000 104040 1.06121 1000 1.10400 112616 14 117166 1.19509 1219 117000 119102 1264 133023 1412 107000 1.14450 122104 131000 1.40255 1.Son 1.05100 127620 1.15027 1.19405 1.06152 1.07214 171819 1.09369 126677 130477 134092 142331 149014 79005 195715 38423 1923 Future Value of $1 Period 1.11567 112683 1139 114947 1.16097 124337 126124 1991 LON 15345 1.60103 16657 1673 11786 1.79087 1.56699 171034 1.79586 188565 197993 201220 213293 2.26090 257853 2.75000 1.1725 134587 137279 1.40024 14285 145681 146853 151259 155797 1.60471 1.65285 1024 1.75351 ******** 155545 151378 1.6700 173709 13022 12001 1500 2012 220202 115 3168 180004 1872 194790 2022 21068 219112 266584 324340 113430 1515 120011 122019 12820 114285 2540 200277 24 302560 320714 2.000 2.11529 220519 225891 20 Esma 25 265330 1 164061 5.4270 2.09078 2.42726 251017 3017 181136 41219 SHONES 100% 13.05 WOS 25000 112000 125440 140493 157352 19 1414 153 2014 -....... 109300 1.10000 118810 11000 1.23503 1.33100 141158 146410 15 161051 167710 56 19472 115093 1.93256 2.1435 1.99900 217189 2.35795 215292235735259374 111000 1.23210 1.1153 151807 16 181041 201516 2.30454 255804 2.83942 112250 15203 174501 201116 2106 266002 1304 208105 152541 2107 250227 120000 14000 1.72800 207350 243232 2. 353318 429982 5.15978 19174 11100 19732 2.2106 2479 277308 3.10585 5.96046 300404 3.25195 3 39457370722 3.51788 404556 Future Value of $1 Perla 10. 11. 14.05 --- 285312 313843 1516 3.49045 4110 2518172 1266 2.71962 350 291719 14173 2.17217 1 54248 3.47594 3 97071 320002 437763 3.99002 7 1712 5.14166 5160 6 1006266 226768 13706 147855 6 3.08 342 81190 36349 871155375 56157 21174 513039 13725 536604 76 02411057511 2.79756 4.17725 459497 50546 5.31089 51 2745 2 33 55 51115 6.11591 672750 1187000 12 14300 16.50est ** 305231 1350546 22 19230 17.0940 23 11 9501662111121131025 7.15129 3650 1197 100 11 11 12979 Future Value of $1 136 11. SO 126 12.80780 14.19201 15. 01 15.9173 12345 12. 12 13 41209 14. 15.8734 17294 1481212 16 1790 10 16.900 16 GEN 129191 2009 19.50 21 23.657 2017 20 01207 21.41231 22 17 18 2015 2018 23. 25.11 26 COOK 23232 23.09 2564540 2767120 21778 2207900 202020 2017 60 SO 02271 . 07575.42 Future of A 16 21100 2 12000 20 12 LIS LESOT ES 5971 1159 12271 3120 10663 9.2004 11 15 19 122 135 1590 6720 135414 CADED Folyo SOS 11 2016012 33 TE 51117 21 205221 27.97050 2271319 221164 02 HE 2010 27.15211 2501919 121990 1727971 72015 109 OSETE D 1 17 41 550 51100