i need help creating a statement of cash flows for the provided data

chapter 2, problem 1 (isbn 1337298042)

Using the data presented below Mike Owjai Manufacturing Income Statements For the Years 2013 and 2014 2014 2013 Sales $2.422 500 $2.625,000 Cost of Goods Gross Profit 1.704,975 920,025 1621875 800,625 Depreciation Sellng& Adain. Expense Lease Experse 63,000 53,250 652.350 48,750 155,925 626250 48,750 72375 51,000 21375 Net Operating Income latcrest Expecse Earaings Before Taies S4,000 71,925 Taxes 25,174 7,481 Net Iacome $46,751 $13,894 Notes: Tax Rate 35.00% 35.00% Shares 75,000 60,000 Eanings per Shace 50.62 $0.23 Mike Owjai Manufacturing Balaace Sheet Fer the Year Eaded December 31, 2014 2014 2013 Arset Cash $39,000 $30,750 15,750 Marketable Secuides 1826 315.000 Accounts Receivable 279,000 315,000 640 500 1,627,500 363,750 1263,750 laveatory Total Current Asse 386250 742,076 2010.000 Gross Fixed Assets Accumlated Depreciation Net Plans & Equipmen Tetel Asset 426,750 1583,250 $2.325,326 $1,904,250 Liabites&Owner's Equity Accounts Payable Accrued Expesses Total Currens Liablaies Long-tem Debt 217,500 378,750 26.250 22,500 405,000 240,000 878.325 795,750 Tonal Liabinies Common Stock ($1.00 par) Addticnal Paid-Cpeal Retaised Eaming Total Ouner's Equity 1,283,325 1,035,750 60,000 406500 402.000 868500 75,000 518.250 448.751 1,042.001 Tetel Liah &Owner's Equity 52,325,326 $1,904,250 a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly b. On another worksheet, create a statement of cash flows for 2014. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets. Using the data presented below Mike Owjal Manufacturing Income Statements For the Years 2013 and 2014 2014 2013 Sales $2.625.000 1,704975 920,025 $2,422.500 Cost of Goods 1621875 Gross Proft 800,625 Depreciation Selling & Admin Expense Lease Expense Net Operating Income latcrest Expecse Earaings Befere Taxes 63,000 53.250 652.350 626250 48,750 48,750 155,925 72.375 84,000 S1.000 71,925 21,375 Taxes 25,174 7481 Net Income $46,751 $13,894 Notes: Tax Rate 35.00% 35.00% Shares 75,000 60,000 Eartings per Share so.62 $0.23 Mike Owjai Manufacturing Balance Sheet For the Year Eaded December 31, 2014 2014 2013 Assets Cash $39,000 $30,750 Marketable Securities 1826 15,750 279.000 Accounts Receivable 315.000 386 250 742.076 2010 000 426 750 1383 250 $2.325,326 laventory Total CurrentAste 315,000 640 500 Gross Fixed Assets 1,627 500 Accumlated Depreciation Net Plans &Equipment 363,750 1 263,750 Tetal Assets $1.904,250 Labilifies&Ouner's Equity Accounts Payable Accrued Expeases Total Current Liabilities Long-tera Deb Total Liabtlines 378 750 217,500 26,250 22.500 405.000 240,000 878.325 795,750 L035,750 1283325 Common Stock ($1.00 par) Additional Paid-ib-Capital Retained Earnn Toal Owner's Equity Teal Liah & Owners Equity 75.000 60,000 518.250 448,751 406.500 402.000 868,500 $1,904,250 1,042.001 52.325 326