Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following information to complete the income statement for Company Abc for the year ending December 31, 2010 (show work): Income Statement Information Revenue

Use the following information to complete the income statement for Company Abc for the year ending December 31, 2010 (show work):

Income Statement Information

Revenue

$ 125,000,000

Gross Margin

50.0%

Selling General and Administrative (SG&A)

20.0%

of revenue

Research and Development (R&D)

15.0%

of revenue

Depreciation expense (D&A)

$ 5,000,000

Interest Expense

$ 5,000,000

Interest Income

$ 2,000,000

Tax Rate

35%

Securities Information

Weighted Average Shares (12/31/1X)

10,000,000

A Warrants exercisable @ $2.00

2,200,000

B Warrants exercisable @ $3.00

2,500,000

Stock Price (12/31/1X)

$ 4.00

Complete the following Income Statement

Answers go in the yellow boxes

Revenue

$ 125,000,000

$ 125,000,000

Cost of Goods Sold

?

Gross Profit

?

Operating Expenses

SG&A

?

R&D

?

D&A

Operating Expenses Total

?

Operating Income

?

Interest Expense, net

?

Pre Tax Income

?

Tax

?

Net Income

?

?

EPS Basic

?

EPS Diluted

?

For losses, only Basic Shares are used in calculating Diluted EPS

Use this table (below) to help with your calculations

Diluted Share Calculations

Basic

10,000,000

A warrants

B warrants

Total

Proceeds

A warrants

B warrants

Total Proceeds

Shares repurchased

Diluted shares used to calculate Diluted EPS

This is the correct way to calculate the number of shares for Diluted EPS

Given the information below, calculate the Working Capital and Current Ratio

1

Cash and marketable securities -

$3,500,000

2

Accounts Receivable (Gross) -

$2,500,000

Allowance for doubtful accounts

$50,000

3

Accounts Payable -

$1,500,000

4

Accumulated Depreciation

2,500,000

6

Inventory -

$3,500,000

7

Other Current Assets -

$1,000,000

8

Common Stock at Par Value -

$100,000

9

Current portion of long term notes -

$800,000

10

Other Current Liabilities -

$550,000

11

Goodwill -

$10,000,000

12

Long-Term debt -

$8,000,000

Cash and marketable securities -

Accounts Receivable (Net) -

Inventory -

Working Capital

?

Other Current Assets -

Current Ratio

?

Total Current Assets

Accounts Payable -

Current portion of long term notes -

Other Current Liabilities -

Total Current Liabilities

Working Capital

Current Ratio

Given the following Information on ABC Corp, calculate the ratios below

ABC Corp. Year end statements

Balance Sheet 12/31/15

Balance Sheet 12/31/16

ASSETS

2015

LIABILITIES

2015

ASSETS

2016

LIABILITIES

2016

Cash

$ 3,000,000

Accounts Payable

1,700,000

Cash

3,500,000

Accounts Payable

1,900,000

Accounts Recievable

2,000,000

Current portion of LTD

900,000

Accounts Recievable

2,500,000

Current portion of LTD

900,000

Inventory

3,000,000

Accrued Liabilities

1,400,000

Inventory

3,000,000

Accrued Liabilities

1,200,000

Total Current Assets

8,000,000

Total Current Liabilities

$ 4,000,000

Total Current Assets

9,000,000

Total Current Liabilities

4,000,000

Property Plant & Equipment, net

8,000,000

Long Term Debt (LTD)

9,000,000

Property Plant & Equipment, net

8,000,000

Long Term Debt (LTD)

9,000,000

Other Assets

2,000,000

Shareholder's Equity

5,000,000

Other Assets

2,000,000

Shareholder's Equity

6,000,000

Total Assets

$ 18,000,000

Total Liabilities & Equity

18,000,000

Total Assets

$ 19,000,000

Total Liabilities & Equity

$19,000,000

Income Statement FY 12/31

2016

Revenue

$ 12,000,000

Cost of Goods Sold

5,000,000

Current ratio 12/31/16

?

Gross Profit

7,000,000

Accounts Receivable Turnover (2016)

?

Total Asset Turnover (2016)

?

Selling General & Admin

2,400,000

Inventory Turnover (2016)

?

Research and Development

1,500,000

Liabilities to Equity 12/31/16

?

Depreciation and Amortization

1,500,000

Revenue to Cash (2016)

?

Total Operating expenses

5,400,000

Days revenue in Cash (2016)

?

Days Inventory (2016)

?

Operating Profit

1,600,000

Return on Assets (2016)

?

Return on Equity (2016)

?

Interest Income

100,000

Interest Expense

700,000

Pre tax Profit

1,000,000

Tax (@35%)

350,000

Net income

$ 650,000

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

The Global Financial Crisis What Have We Learnt

Authors: Steven Kates

1st Edition

0857934228, 978-0857934222

More Books

Students also viewed these Finance questions

Question

What is the activity in becquerels of 1.0 kg of 238U?

Answered: 1 week ago

Question

Is it a critical high risk, and/or a safety item?

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago

Question

=+interactive online components, out-of-home messages, print ads,

Answered: 1 week ago

Question

=+Why does the brand want to advertise?

Answered: 1 week ago

Question

=+12. Did your concept illustrate the brand's personality?

Answered: 1 week ago