Question
information sheet Common Size Common Size Common Size XYZ Plumbing - Income Statement 2015 2016 2017E Revenue $ 10,000,000 100.0% $ 13,000,000 100.0% XYZ Plumbing
information sheet | Common Size | Common Size | Common Size | |||||||||||||||
XYZ Plumbing - Income Statement | ||||||||||||||||||
2015 | 2016 | 2017E | ||||||||||||||||
Revenue | $ 10,000,000 | 100.0% | $ 13,000,000 | 100.0% | XYZ Plumbing - Balance Sheet | |||||||||||||
CGS | 4,000,000 | 40.0% | 5,200,000 | 40.0% | 2015 | 2016 | 2015 | 2016 | ||||||||||
Gross Profit | $ 6,000,000 | 60.0% | $ 7,800,000 | 60.0% | ASSETS | LIABILITIES | ||||||||||||
Cash | 3,000,000 | 3,935,000 | Accounts Payable | 500,000 | 465,000 | |||||||||||||
SG&A | 2,000,000 | 20.0% | 2,600,000 | 20.0% | A/R | 1,000,000 | 1,600,000 | Notes Payable | 1,500,000 | 1,000,000 | ||||||||
R&D | 1,000,000 | 10.0% | 1,000,000 | 7.7% | 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 | 3.8% | Pre-paid expenses | 500,000 | 665,000 | Accrued Liabilities | 500,000 | 520,000 | ||||||||
Total Op. Expense | 3,500,000 | 35.0% | 4,100,000 | 31.5% | Total Current Assets | 6,500,000 | 8,500,000 | Total Current Liabilities | 3,500,000 | 2,985,000 | ||||||||
Operating Profit | $ 2,500,000 | 25.0% | $ 3,700,000 | 28.5% | 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 | ||||||||||||||||
Interest cost | 650,000 | 6.5% | 750,000 | 5.8% | 800,000 | 20,000,000 | 22,000,000 | Stockholder's Equity | ||||||||||
Interest income | 90,000 | 0.9% | 150,000 | 1.2% | 250,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,940,000 | 19.4% | $ 3,100,000 | 23.8% | Net PP&E | 19,500,000 | 21,000,000 | Retained Earnings | 500,000 | 2,515,000 | ||||||||
Tax (35% rate) | 679,000 | 35.0% | 1,085,000 | 35.0% | Total Stockholder's Equity | 10,500,000 | 12,515,000 | |||||||||||
Net Income | $ 1,261,000 | 12.6% | $ 2,015,000 | 15.5% | ||||||||||||||
Total Assets | 26,000,000 | 29,500,000 | Total Liabilities + Equity | 26,000,000 | 29,500,000 | |||||||||||||
EPS - Basic | $ 0.13 | $ 0.20 | ||||||||||||||||
EPS - Diluted | ||||||||||||||||||
- | ||||||||||||||||||
Average Shares Outstanding | 10,000,000 | 10,000,000 | 10,000,000 | |||||||||||||||
Diluted Shares | ||||||||||||||||||
Diluted 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 Shares | 10,000,000 |
Information sheet to solve question
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started