Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance The Markets And Financial Management Of Multinational Business

Authors: Maurice D. Levi

3rd Edition

0070376875, 978-0070376878

More Books

Students also viewed these Finance questions