Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a financial consultant who has been retained to analyze the company's performance and find out what's going wrong. The following additional information is

You are a financial consultant who has been retained to analyze the company's performance and find out what's going wrong. The following additional information is provided with the financial statements. Depreciation for 20X7, 20X8, and 20X9 was $200, $250, and $275 million respectively. No stock was sold or repurchased, and like many fast growing companies, Prospec paid no dividends. Assume the tax rate is a flat 34% and the firm pays 10% interest on its debt.

Calculate the indicated ratios for all three years:

Current ratio, quick ratio, accounts receivable days, inventory turnover, fixed asset turnover, total asset turnover, debt ratio, debt equity, TIE, ROS, ROA, ROE, equity multiplier

Analyze trends in each ratio and compare each with the industry average

20X7

20X8

20X8

Sales

$1,578

$2,106

$3,265

COGS

631

906

1,502

Gross Margin

$ 947

$1,200

$1,763

Expenses

Marketing

$316

$495

$882

R & D

158

211

327

Admin.

126

179

294

Total Expenses

$ 600

$ 885

$1,503

EBIT

$347

$315

$260

Interest

63

95

143

EBT

$284

$220

$117

Tax

97

75

40

EAT

$187

$145

$ 77

20X7

20X8

20X9

ASSETS

Cash

$ 30

$ 40

$ 62

Accounts Receivable

175

351

590

Inventory

90

151

300

Current Assets

$ 295

$ 542

$ 952

Fixed Assets

Gross

$1,565

$2,373

$2,718

Accum. Depreciation

(610)

(860)

(1,135)

Net

$ 955

$1,513

$1,583

Total Assets

$1,250

$2,055

$2,535

LIABILITIES

Accounts Payable

$56

$81

$134

Accruals

15

20

30

Current Liabilities

$71

$101

$164

Capital

Long-Term Debt

$630

$1,260

$1,600

Equity

549

694

771

Total Liability & Equity

$1,250

$2,055

$2,535

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

Rehabilitation Tax Credit IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304114686, 978-1304114686

More Books

Students also viewed these Accounting questions