Plumbing (F puble company with the most ing stock price of Use the following information to answer the following three problems: Do not type in the Blue or Brown boxes below De not type in the Blue or Brown boxes below PROBLEM SOLVING Problem 1 Problem 2 Analysis Admin Key Statement of Cash Flows 2019 2019 Pts Admin Key Pts 1 Net Income 1 1 1 1 1 Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable turnover Inventory turnover Total asset tumover Debt to Equity Return on Equity 2 2 Adjustments Depreciation and amortization Cash Provided by Operating Assets and Liabilities Accounts Receivable Inventories Pre-paid expenses Accounts payable Accrued liabilities Net Cash provided (used) by operating activities Total 1 1 1 2 2 2 Problem 3 Projections 1 1 Admin Key 2020E Pts 1 Revenue (Increase of 20% from 2019) CGS Gross Profit (Gross Margin increases by 1.0% from 2019) Cash Provided from Investing Activities Additions to property, plant and equipment Net Cash provided (used) by investing activities 1 1 1 Cash Provided from Financing Activities Additions to long term borrowing Addition to short term borrowing Net Cash provided (used) by financing activities SG&A (Improves by 1.0% from 2019) R&D (Increases by 10% in total dollars from 2019) Deprec & Amort (no change from 2018) Total Op. Expense 1 2 2 Operating Profit 1 Net Cash Flow Interest cost (given) Interest income (given) $ $ 875,000 80,000 875,000 80,000 Total 20 1 Instructions: Pre Tax Tax (21% rate) Net Income 1 1. All answers go in the YELLOW shaded boxes. 1 EPS - Basic EPS - Diluted (See Information sheet for Equity Structure) 2. Make sure your name is written in the first YELLOW shaded box in the "2" row 3. Do not resize, reshape or change any of the boxes on this page. Total 16 4. Save this file by adding your name to the end i.e., GRAND TOTAL 50 "Final Exam Answer Sheet - Spring 2020 - Mintz" 5. All the information needed is on this sheet and the Information Sheet Plumbing (F puble company with the most ing stock price of Use the following information to answer the following three problems: Do not type in the Blue or Brown boxes below De not type in the Blue or Brown boxes below PROBLEM SOLVING Problem 1 Problem 2 Analysis Admin Key Statement of Cash Flows 2019 2019 Pts Admin Key Pts 1 Net Income 1 1 1 1 1 Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable turnover Inventory turnover Total asset tumover Debt to Equity Return on Equity 2 2 Adjustments Depreciation and amortization Cash Provided by Operating Assets and Liabilities Accounts Receivable Inventories Pre-paid expenses Accounts payable Accrued liabilities Net Cash provided (used) by operating activities Total 1 1 1 2 2 2 Problem 3 Projections 1 1 Admin Key 2020E Pts 1 Revenue (Increase of 20% from 2019) CGS Gross Profit (Gross Margin increases by 1.0% from 2019) Cash Provided from Investing Activities Additions to property, plant and equipment Net Cash provided (used) by investing activities 1 1 1 Cash Provided from Financing Activities Additions to long term borrowing Addition to short term borrowing Net Cash provided (used) by financing activities SG&A (Improves by 1.0% from 2019) R&D (Increases by 10% in total dollars from 2019) Deprec & Amort (no change from 2018) Total Op. Expense 1 2 2 Operating Profit 1 Net Cash Flow Interest cost (given) Interest income (given) $ $ 875,000 80,000 875,000 80,000 Total 20 1 Instructions: Pre Tax Tax (21% rate) Net Income 1 1. All answers go in the YELLOW shaded boxes. 1 EPS - Basic EPS - Diluted (See Information sheet for Equity Structure) 2. Make sure your name is written in the first YELLOW shaded box in the "2" row 3. Do not resize, reshape or change any of the boxes on this page. Total 16 4. Save this file by adding your name to the end i.e., GRAND TOTAL 50 "Final Exam Answer Sheet - Spring 2020 - Mintz" 5. All the information needed is on this sheet and the Information Sheet
