Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here is all the rest of it. I just need the bottom answered. Part 1: Financial Statements and Ratios 1A. Youre the chief financial officer

Here is all the rest of it. I just need the bottom answered.

Part 1: Financial Statements and Ratios

1A. Youre the chief financial officer (CFO) of Worldwide Widget Manufacturing, Inc. The company manufactures and sells widgets at factories in the United States and internationally. Listed below are partial financial statements for Worldwide Widget Manufacturing, Inc. Fill in the missing information in each of the following financial statements. Answer spaces are given below.

Worldwide Widget Manufacturing, Inc. Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars)

2015

2014

2015

2014

Assets

Liabilities and Equity

Current assets:

Current liabilities:

Cash and marketable securities

$ 347

$ 322

Accrued wages and taxes

$ 309

$ 257

Accounts receivable

a. ?

259

Accounts payable

381

b. ?

Inventory

895

797

Notes payable

$ 492

$ 421

Total

$1,542

$1,378

Total

$1,182

$997

Fixed assets:

Long-term debt:

1,934

c. ?

Gross plant and equipment

d. ?

$2,817

Total

3,116

1,129

Less: Depreciation

287

254

Stockholders equity:

Net plant and equipment

$2,872

$2,563

Preferred stock (30 million shares)

$ 30

$30

Other long-term assets

521

487

Common stock and paid-in surplus (250 million shares)

300

e. ?

Retained earnings

1,489

1,142

Total FA

f.?

$3,050

Total Equity

$1,819

$1,472

Total assets

$4,935

$4,428

Total liabilities and equity

$4,935

$4,428

Accounts receivable for 2015__$300____

Total current assets= cash and marketable securities + account rec + inventory

1,542=347+a/r+895

Accounts rec = $300

Accounts payable for 2014__$319_____

Total Current Liabilities = Accrued Wages and taxes + Accounts Payable + Notes Payable 997 = 257 + Accounts Payable + 421 Accounts Payable = $319

c. Gross plant and equipment for 2015_$3,159______

Net Plant and Equipment = Gross Plant and Equipment Depreciation 2,872 = Gross Plant and Equipment 287 Gross Plant and Equipment = $3,159

d. Long-term debt for 2014__$132_____

Total Debt = Long-term Debt + Current Liabilities 1,129 = Long-term Debt + 997 Long-term Debt = $132

e. Common stock and paid-in surplus (250 million shares) for 2014 $300

Total Equity = Preferred Stock + Common Stock and paid surplus + Retained Earnings 1,472 = 30 + Common Stock and paid surplus + 1,142 Common Stock and paid surplus = $300

f. Total FA for 2015 $3,393

Total FA = Net Plant and Equipment + Other long-term assets Total FA = $2,872 + 521 Total FA = $3,393

3

Graded Project

Worldwide Widget Manufacturing, Inc. Income Statement for Years Ending December 31, 2015 and 2014 (in millions of dollars)

2015

2014

Net sales

g. ?

$2,018

Less: Cost of goods sold

987

h. ?

Gross profits

$1,396

$1,189

Less: Other operating expenses

189

167

Earnings before interest, taxes, depreciation, and amortization (EBITDA)

$1,207

$1,022

Less: Depreciation

121

114

Earnings before interest and taxes (EBIT)

$1,086

$ 908

Less: Interest

i. ?

128

Earnings before taxes (EBT)

$ 949

$ 780

Less: Taxes

j. ?

23

Net income

$ 664

$ 546

Less: Preferred stock dividends

98

98

Net income available to common stock holders

$ 566

$ 448

Less: Common stock dividends

219

199

Addition to retained earnings

$ 347

$ 249

Per (common) share data:

Earnings per share (EPS)

k. ?

$1.79

Dividends per share (DPS)

$ 0.88

l. ?

Book value per share (BVPS)

m. ?

$ 5.77

Market value per share (MVPS)

$23.97

$22.47

g. Net sales for 2015_______

Net Sales Cost of Goods Sold = Gross Profit

Net Sales 987 = 1,396

Net Sales = $2,383

h. Less: Cost of goods sold for 2014_______

Net Sales Cost of Goods Sold = Gross Profit 2,018 - Cost of Goods Sold = 1,189 Cost of Goods Sold = $829

i. Less: Interest for 2015_______

EBIT- Interest = EBT 1,086 Interest = 949 Interest = $137

j. Less: Taxes for 2015_______

Net Income = EBT Taxes 644 = 949 Taxes Taxes = $305

k. Earnings per share (EPS) for 2015_______

Earning per share for 2015 = Net Income available to Common Stockholders / No of Common Stocks

Earning per share =566 / 250

Earning per share = $2.27 per share

l. Dividends per share (DPS) for 2014_______

Dividend per share = Common stock Dividend/ No of Common Stocks

Dividend per share = 219/250

Dividend per share = $0.88 per share

m. Book value per share (BVPS) for 2015_______

Book value per share= total common stockholders equity/No of Common Stocks

Book value per share= 1,789/250

Book value per share= 7.16

Worldwide Widget Manufacturing, Inc. Statement of Cash Flows for Year Ending December 31, 2015 (in millions of dollars)

Section A. Cash flows from operating activities

Net income

n. ?

Additions (sources of cash):

Depreciation

287

Increase in accrued wages and taxes

o. ?

Increase in accounts payable

62

Subtractions (uses of cash):

Increase in accounts receivable

41

Increase in inventory

p. ?

Net cash flow from operating activities

q. ?

Section B. Cash flows from investing activities

Subtractions:

Increase in fixed assets

$343

Increase in other long-term assets

r. ?

Net cash flow from investing activities:

s. ?

Section C. Cash flows from financing activities

Additions:

Increase in notes payable

t. ?

Increase in long-term debt

147

Increase in common and preferred stock

0

Subtractions:

Pay dividends

u. ?

Net cash flow from financing activities:

v. ?

Section D. Net change in cash and marketable securities

$25

n. Net income $664

o. Increase in accrued wages and taxes $309-$257= $52

p. Increase in inventory (895-797)= $ -98

q. Net cash flow from operating activities 664+287+52+62-41-98=$926

r. Increase in other long-term assets (521-487)= $-34

s. Net cash flow from investing activities -343-34=-377

t. Increase in notes payable 492-421= 71

u. Pay dividends 98+219= 317

v. Net cash flow from financing activities 71+147-317= -99

Worldwide Widget Manufacturing, Inc. Statement of Retained Earnings as of December 31, 2015 (in millions of dollars)

Balance of retained earnings, December 31, 2014

$1,142

Plus: Net income for 2015

w. ?

Less: Cash dividends paid

0

0

Preferred stock

x. ?

Common stock

219

Total cash dividends paid

317

Balance of retained earnings, December 31, 2015

$1,489

w. Plus: Net income for 2015 $664

x. Preferred stock $98

1B. For each of the items listed below, indicate on which of the major statements they would be found (1, 2, 3 or 4) and the amount shown on the statements above:

1. Balance sheet 3. Statement of cash flows

2. Income statement 4. Statement of retained earnings

1. Earnings before taxes for 2015 Income statement; $949

2. Gross plant and equipment for 2015 Balance Sheet; $3,159

3. Increase in fixed assets, December 31, 2015 Statement of cash flows; $-343

4. Net sales for 2015 Income statement; $2,383

5. Balance of retained earnings, December 31, 2015 Statement of retained earnings; $1,489

6. Common stock and paid-in surplus for 2014 Balance sheet; $300

7. Net cash flow from investing activities, December 31, 2015 Statement of cash flow; $-309

8. Increase in inventory, December 31, 2015 Statement of cash flow; $-98

9. Accrued wages and taxes for 2014 Balance sheet; $257

10. Book value per share (BVPS) for 2015 Income statement; $7.16

Worldwide Widget Manufacturing, Inc.

Company Industry Comparison
Current Ratio 2.2 times
Quick Ratio 1.1 times
Cash Ratio 0.35 times
Inventory Turnover 2 times or 1 time
Days' sales in inventory 135 days or 335 days
Average payment period 110 days
Sales to working capital 3 times
total asset turnover 0.6 times
debt to equity 1.1 times
profit margin 16.5%
gross profit margin 48.13%
ROA 8.78%
ROE 19.45%
Dividend payout 32%

A. Use the information found in Worldwide Widget Manufacturings financial statements to calculate all of the listed financial ratios in the above table for your company. Then, for each ratio, provide a comparison of the companys result with the industry standards, indicating if your companys results are lower than, higher than, slower than, or faster than the industry standards.

B. Calculate your companys internal and sustainable growth rates.

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

More Books

Students also viewed these Finance questions