Question: can you please do the chart and explain how to imput it into excel Describe the competition in the overnight package-delivery industry, and the strategies

can you please do the chart and explain how to imput it into excel

Describe the competition in the overnight package-delivery industry, and the strategies by which those two firms are meeting the competition. Discuss at least one enabling and inhibiting factor facing the two firms as they pursue their goals? Do you think that either firm can attain a sustainable competitive advantage in this business? (Refer to specific data from the case to support your points.)

How are FedEx and UPS performing financially? Which firm is doing better? Discuss the insights you derived from the two firms financial statements, financial ratios, economic profit, and stock-price performance. Complete the table below and refer to the information in your discussion.

2011

2011

2015

2015

UPS

FedEx

UPS

FedEx

Revenue

53,105

39,304

58,363

47,453

Operating income (EBIT)

6,080

2,378

7,668

1,867

Interest expense

348

86

341

235

Net income

3,804

1,452

4,844

1,050

Capital expenditures

2,005

3,434

2,379

4,347

Cash and marketable securities

4,275

2,328

4,726

3,763

Accounts receivable

6,246

4,581

7,134

5,719

Total current assets

12,284

8,285

13,208

10,941

Net prop., plant, and equip.

17,621

15,543

18,352

20,875

Total assets

34,077

27,385

38,311

37,069

Current liabilities

6,514

4,882

10,696

5,957

Total debt

11,128

1,685

14,334

7,268

Total stockholders equity

7,108

15,220

2,491

14,993

UPS

FedEx

UPS

FedEx

Growth

Revenue growth

Total asset growth

Operating income growth

Net income growth

Asset Efficiency Ratios

Working capital turnover

PPE turnover

Capital expenditure %

Total asset turnover

Liquidity and Leverage Ratios

Current ratio

Cash ratio

Total debt/equity ratio

Times interest earned

If you had to identify one of those companies as excellent, which company would you choose? On what basis did you make your decision? (Refer to at least three specific data points from the table above to support your choice.) Discuss long term vs. recent performance as well as stock price performance.

What do you estimate the revenue growth rate and Net Profit Margin to be for each firm over the next year? What is your estimation based on?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!