Can I get some assistance
AutoSave (C O#) Financial Statements Final Exam Student Answer Short - FL19 - Excel Search Sign in X File Home Insert Draw Page layout Formulas Data Review View Help Share Comments P13 X A C D E F G HI K M NO P Q R 5 T Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $4.50, to answer the following three problems: Do not hype in the Else PROBLEM SOLVING Problem 1 Blue or Brown boxer Problem 2 or brown beres below Analysis Admin Statement of Cash Flows 2018 2018 Key TS Current Kano Net Income Quick Ratio Games Margin Adjustments Operating Margin Depreciation and amortization Accounts Receivable turnover Cash Provided by Operating Assets and Liabilities Inventory turnover 2 Total 14 Accounts Receivable Total asset turnover Inventories Debt to Equity Pre-paid expenses Return on Equity Accounts payable Acerand Halines Problem 3 Projections Admin Net Cash provided (used) by operating activities 2019E BGy Revenue Increase of 25% from 2019) Cash Provided from Investing Acthitles CGS Additions to property, plant and equipment Gross Profit (Grass Margin Increases by 9.85% from 2879) Net Cash provided (used) by tovesting activities SGKA (uprows by 10% from 2818) Cash Provided from Financing Acthittes R&D (Increases by 19's to roral dollars from 2616) Addicons to long term borrowing Degree & Amount (no change from 26/8) Addition to short term borrowing Total Op. Expense Net Cash provided (used) by financing activities Operating Profit Net Cash Flow Interest cost (gium) $ 475,000 Interest income (ghow) 50, 040 Total 20 Pre-Tax Instructions; Tax (21%% rate) Net Income 1. All answers go in the YELLOW shaded boxes. EPS - Basic S - ADIVA! 1. Make sure your name is written in the first YELLOW shaded box in the "2" row 43 3. Do not resize, reshape or change any of the boxes on this page. Total 10 44 Answer Sheet Information Sheet 1 Ready e O W 9 P - 10 all CNG B:16 PM 12/9/2019Diluted Shares Information Officers and Directors Options 3,000,000 Exercise Price $ 1.00 Publice Warrants 2,500,000 Exercise Price $ 4.00 Stock Price used for calculating Diluted Shares $ 4.50 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 $ 4.50 Total Shares repurchased Diluted SharesCommon Common Common Size Size Size XYZ Plumbing - Income Statement Assumptions 2017 2018 2018 - 2109 2019E Revenue 10,000.000 100.0% $ 12,500,000 100.0% Revenue increases by 25% ($ basis) XYZ Plumbing - Balance Sheet 4.500,000 45.0% 5,562,500 44.5% 2017 2018 2017 2018 CGS Gross Profit S 5,500,000 35.0% S 6,937,500 55.5% Gross MARGIN increases by 0.05% S ASSETS LIABILITIES Cash 1,500,000 1,500,000 Accounts Payable 1,800,000 2,000,000 SG&A 2,000,000 20.0% 2,375,000 19.0% SG&A improves by 1.0% (% basis) A/R 1,000,000 1,500,000 Notes Payable 1,500,000 1,500,000 R&I 1,000,000 10.0% 1,000,000 8.0% R&D increases by 10% ($ basis) Inventory 2,000,000 2,300,000 Current portion of LTD 1,000,000 1,000,000 Deprec & Amort 500.000 5.0% 500.000 4.0% No change in Deprec & Amort cost Pre-paid expenses 500.000 600.000 Accrued Liabilities 700.000 1,520,000 Total Op. Expense 3,500,000 35.0% 3,875,000 31.0% Total Current Assets 5,000,000 5,900,000 Total Current Liabilities 5,000,000 6,020,000 Operating Profit S 2,000,000 20.0% S 3,062,500 24.5% Building and Improvements 15,000,000 15,000,000 Long-Term Debt 9,000,000 10,000,000 Equipment 5,000,000 5,000,000 Interest cost 805,000 8.1% 875,000 7.0% Interest costs are given 875,000 20,000,000 20,000,000 Stockholder's Equity Interest income 45,000 0.5% 60,000 0.5% Interest income is given 80,000 Common Stock at Par 100,000 100,000 Depreciation 500.000 1,000,000 Paid in Capital 9,900,000 9,900,000 Pre-Tax $ 1,240,000 12.4% 2,247,500 18.0% Net PP&E 19,500,000 19,000,000 Retained Earnings 500,000 2,275,525 Tax (35% in 201 7. 21% rate in 2018 and 201: 434.000 35.0% 471,975 21.0% See D22 Total Stockholder's Equity 10,500,000 12,275,525 Net Income S 806,000 8.1% S 1,775,525 14.29 Total Assets 24,500,000 24,900,000 Total Liabilities + Equity 24,500,000 28,295,525 EPS - Basic S 0.08 S 0.18 EPS - Diluted Average Shares Outstanding 10,000,000 10,000,000 10,000,000 Diluted Shares
