770-144 YOUR NAME Show your work whenever appropriate Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $6.00 (used for Diluted Shares calculations), to answer the following three problems: Do not type in the Do not type in the Blue PROBLEM SOLVING Problem 1 Blue or Brown Problem 2 or Brown boxes below Analysis Admin Statement of Cash Flows 2022 Admin 2021 Key Pts Key Pts Current Ratio 0.000 X Net Income Quick Ratio 0.000 X Gross Margin 0.0% Adjustments Operating Margin 0.00% Depreciation and amortization 1 Accounts Receivable turnover 0.00 times Cash Provided by Operating Assets and Liabilities Inventory turnover 0.00 times Accounts Receivable Total asset turnover 0.000 times Inventories Debt to Equity 0.0000 times Pre-paid expenses Return on Equity 0.00% Accounts payable Accrued liabilities Problem 3 Projections Admin Net Cash provided (used) by operating activities 2023E Key Pts Revenue (Increase of 20% from 2021) S Cash Provided from Investing Activities CGS Additions to property, plant and equipment Gross Profit (Gross Margin increases by 0.5% from 2021) S Net Cash provided (used) by investing activities SG&A (Improves by 1.5% from 2021) 1 Cash Provided from Financing Activities R&D (Increases by 10% in total dollars from 2021) Additions to long term borrowing Deprec & Amort (no change from 2021) Addition to short term borrowing Total Op. Expense Net Cash provided (used) by financing activities Operating Profit S Net Cash Flow 2 Interest cost (given) $ 750,000 Interest income (given) S 62,000 Total 20 Pre-Tax S ctions: Tax (21% rate) Net Income S nswers go in the YELLOW shaded boxes. EPS - Basic S EPS - Diluted (See Information sheet for Equity Structure) S sure your name is written in the first YELLOW shaded box in the "2" row