Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 Use the following information on Company X to answers questions (1)-(6) The following tables are the income statement and balance sheet for Company

QUESTION 1

Use the following information on Company X to answers questions (1)-(6)

The following tables are the income statement and balance sheet for Company X for year 2016.

Income Statement:

2016

Sales

5,555,000

Costs except Depr.

(2,756,300)

EBITDA

2,798,700

Depreciation

(599,000)

EBIT

2,199,700

Interest Expense (net)

(100,000)

Pretax Income

2,099,700

Income Tax

(734,895)

Net Income

1,364,805

Balance Sheet

2016

Assets

Cash and Equivalents

1,500,000

Accounts Receivable

1,880,000

Inventories

1,100,000

Total Current Assets

4,480,000

Property Plant and Equipment

2,700,000

Total Assets

7,180,000

Liabilities and Equity

Accounts Payable

1,667,000

Debt

1,350,000

Total Liabilities

3,017,000

Stockholders' Equity

4,163,000

Total Liabilities and Equity

7,180,000

The executives at Company X believe the sales for the company will grow during 2017 in 6%, compared to 2016. Calculate the pro-forma financial statements for Company X for 2017 using the percent sales method. To do this assume that the percentage values with respect to sales of the (i) costs except depreciation, (ii) depreciation, (iii) cash and equivalents, (iv) accounts receivable, (v) inventories, (vi) property, plant and equipment, and (vi) accounts payable will stay fixed at the values corresponding for 2016. Assume also that the interest expense and debt will not change in 2017 from its 2016 values, income tax will remain at 35% of the Pretax Income and that in 2017 Company X initially plans to payout 45% of its net income to its shareholders.

"1. What is the forecasted value of sales for 2017? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000."

10 points

QUESTION 2

"2. What is the forecasted value of net income for 2017? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000."

10 points

QUESTION 3

"3. What is the forecasted value of total assets for 2017? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000."

10 points

QUESTION 4

"4. What is the forecasted value of total liabilities for 2017? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000."

10 points

QUESTION 5

"5. What is the forecasted value of net new financing 2017? Express the numerical terms of your answer completely. For example: If your answer is one million dollars, write: 1000000."

10 points

QUESTION 6

6. What option can the financial manager of Corporation X implement in order to balance total assets and total liabilities and equity for 2017?

a. Increase the debt by the amount indicated in your calculations of net new financing;

b. Increase the dividends by the amount indicated in your calculations of net new financing;

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

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert Hughes

4th Edition

0256147175, 978-0256147179

More Books

Students also viewed these Finance questions