Use the following information about XYZ Plumbing (FY-12/31), a public company with the most recent closing stock price of $5.00, to answer the following three problems: PROBLEM SOLVING Statement of Cash Flows Net Income Adjustments Cash Provided by Operating Assets and Liabilities Problem 1 Problem 2 Analysis 2017 2017 Current Ratio Accounts Receivable turmover Inventory tumover Revenue to Cash Retum on Assets Returm on Equity Accounts Receivable Inventories Pre-paid expenses Accounts payable Accrued liabilities Problem 3 Projections 2018E Revenue (increase of 25% from 2017) Net Cash provided (used) by operating activities Cash Provided from Investing Activities Net Cash provided (used by investing activities Cash Provided from Financing Activities Gross Profit (Gross Margin increases by 1.0% from 2017 SG&A (in proves by 1.0% from 2017 RAD (increases by 1 0% in total dollars from 2017 Deprec & Amort (no ckange) Total Op. Expense Additions to property, plant and equipment Additions to long term borrowing Addition to short term borrowing Operating Profit Net Cash provided (used) by financing activities Interest cost (given) Interest income (given) Pre-Tax Tax (35% rate) Net Income s 800,000 s 250,000 Net Cash Flow EPS- Basic EPS Diluted Z Pleming lacome Statement 017 s 10,000,000 1000% $ 13,000,000 1000% 200,00 40,0% d00% $ 7,000,000 d00% AYZ Plumhing-Balance Skeet 4,000.00 400% 2016 2017 2016 2017 Grass Profit 200% 20.0% 10% 35.0% 2.500,000 20.0% 1,000,000 77% 0,000 % 300,000 95,000 Accouets Payable 000,000 1,600,000 Notes Payable 2000,000 2300000 Curreet pertion ef LTD 599,009 665,000 Acorsed Liabliies SOkA 2,000,000 1,000,000 500,000 1,000000 L,000,000 1,000,000 ,00 5500,000 Pre-paid espenses Total Curret Assets 7,000,000 $00,000 Total Op Espe Total Cumt Liablies Operatiag Profit 2,500,000 25.0% 1,100,000 28.5% Buldqud improvwe l5,000,000 15,000,000 Lo Term Debt 000,000 34,000,000 650,000 0.1% 105.000 1.1% 50,0008 800,000 020000 Stockchoider's Equity ntest inco 00,00000,000 900,000 Paid in Capital 00000 100000 Retained Eaning 900,000 9.900,000 Tetal Stockholder's Equity 10,300,000 12.315,000 500,000 90 Total Liabilities Equity 500000 29500,000 $ 1355,000 19.6% $ 1,100,000 23.8% Pre-Tax Taa (35% rate) N PPRE 684230, 350% 1,270.759 22.1% s 2,015,000 15.3% Total Assets EPS Diasted Average Shares Outstandiag Diluted Shares Iaformarion Oeicers and Directors Options Exeroise Price Publice Wamants Evercise Price Seock Price used for calculating 000,000 3 50 Dileted Shares Calicalaticn Table 0,000,000 10,000,000 Proceeds Oicers and Directors Public Sharehelders Total Proceeds Buyback Price Total Shares repurchased Diluted Shares 55.00