Can you please help with the attached spreadsheet. It is in several attachments.

Thank you!

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 Problem 1 Problem 2 Analysis Admin Statement of Cash Flows 2018 Admin 2018 Key Pts Key Pts Current Ratio Net Income 1 Gross Margin Liabilities to Assets Adjustments Operating Margin Depreciation and amortization 1 Return on Assets Cash Provided by Operating Assets and Liabilities Return on Equity Total 10 Accounts Receivable Inventories Problem 3 Projections Admin Pre-paid expenses 2019E Key Pts Accounts payable Revenue (Increase of 22% from 2018) Accrued liabilities CGS Net Cash provided (used) by operating activities Gross Profit (Gross Margin increases by 1.0% from 2018) Cash Provided from Investing Activities SG&A (Improves by 1.0% from 2018) Additions to property, plant and equipment R&D (Increases by 5% in total dollars from 2018) Net Cash provided (used) by investing activities 1 Deprec & Amort (no change) Total Op. Expense Cash Provided from Financing Activities Additions to long term borrowing Operating Profit Addition to short term borrowing Net Cash provided (used) by financing activities 2 Interest cost (given) 800,000 S 800,000 Interest income (given) 250,000 |$ 250,000 Net Cash Flow 2 Pre-Tax Tax (21% rate) Net Income Total 22 EPS - Basic 3Ize IZE XYZ Plumbing - Income Statement 2017 2018 2019E Revenue 10,000,000 100.0% 69 13,000,000 CGS 4.000,000 40.0% 5,200,000 Gross Profit S 6,000,000 60.0% S 7,800,000 SG&A 2,000,000 20.0% 2,600,000 R&D 1,000,000 10.0% 1,000,000 Deprec & Amort 500.000 5.0% 500.000 Total Op. Expense 3,500,000 35.0% 4,100,000 Operating Profit S 2,500,000 25.0% S 3,700,000 Interest cost 650,000 6.5% 750,000 800,000 Interest income 90,000 0.9% 150,000 250,000 Pre-Tax $ 1,940,000 19.4% 3,100,000 Tax (35% rate in 2017, 21% in 2018 and 2019)) 679.000 35.0% 651,000 Net Income S 1,261,000 12.6% S 2,449,000 EPS - Basic S 0.13 S 0.24 EPS - Diluted Average Shares Outstanding 10,000,000 10,000,000 10,000,000 Diluted SharesDiluted Shares Information Officers and Directors Options 2,000,000 Exercise Price $ 3.50 Publice Warrants 4.000.000 Exercise Price $ 3.00 Stock Price used for calculating Diluted Shares $ 5.00 Diluted Shares Calculation Table Basic Shares 10.000,000 O&D warrants Public Total 10,000,000 Proceeds Officers and Directors Public Shareholders Total Proceeds Buyback Price $ 5.00 Total Shares repurchased Diluted SharesXYZ Plumbing - Balance Sheet 2017 2018 2017 2018 ASSETS LIABILITIES Cash 3,000,000 3,000,000 Accounts Payable 500,000 465.000 AR 1,000,000 1,600,000 Notes Payable 1,000,000 1,000,000 Inventory 1,500,000 2,300,000 Current portion of LTD 1,000,000 1,000,000 Pre-paid expenses 500,000 665.000 Accrued Liabilities 500,000 520,000 Total Current Assets 6,000,000 7,565,000 Total Current Liabilities 3,000,000 2.985,000 Building and Improvements 15,000,000 15,000,000 Long-Term Debt 12,000,000 14,000,000 Equipment 5,000,000 7,000,000 20,000,000 22,000,000 Stockholder's Equity Common Stock at Par 100,000 100,000 Depreciation 500,000 1,000,000 Paid in Capital 9,900,000 9,900,000 Net PP &E 19,500,000 21,000,000 Retained Earnings 500,000 2.949,000 Total Stockholder's Equity 10,500,000 12,949,000 Total Assets 28,565,000 Total Liabilities + Equity 25,500,000 29,934,000