Earnings per share of common stock

I need the answers and formulas for:

-Earings per share of common stock

-Price Earnings ratio

-Book value per share of common stock

 

Note – company does not have perfered shares, only common. 

S

tatement

A

nalysis

1 Task 1 319.1.2-

1-10,

-01-03 Financial Statement Analysis Student Template

evised April 12, 2011

nitial

ast Name

ompany

rinciples,

ild, 18th ed.

ecember 31,

ears 12 and 11

Initial

Sales

Sales

GS

orizontal Analysis

4,550,000

08,000

8.91%

Year 12 Year 11

A

123,708,000

86,409,000

23,478,000 38% 37%

123,708,000

123,708,000

86,409,000 23,478,000 38% 37%

erchandise Sold

86,409,000

8%

C

123,708,000

86,409,000 23,478,000 38% 37%

D

123,708,000

86,409,000 23,478,000 38% 37%

E 135,895,500 123,708,000 93,648,210

86,409,000 23,478,000 38% 37%

F

123,708,000

86,409,000 23,478,000 38% 37%

25,827,000 23,478,000

G

123,708,000

86,409,000 23,478,000 38% 37%

H 136,874,625 123,708,000 94,322,944

86,409,000 23,478,000 38% 37% 3,980,000 9,890,000

I

123,708,000

86,409,000 23,478,000 38% 37%

136,336,425 123,708,000 93,952,060

86,409,000 23,478,000 38% 37% 4,000,000 9,980,000

135,895,500 123,708,000 93,648,210

0%

86,409,000 23,478,000 38% 37% 4,120,000 9,815,000

(Expense):

L 135,491,850 123,708,000 93,370,047

86,409,000 23,478,000 38% 37% 3,950,000

Interest Income

66,000

M 134,684,550 123,708,000 92,813,721

86,409,000 23,478,000 38% 37% 4,200,000 10,160,000

2%

N 135,155,475 123,708,000 93,138,245

86,409,000 23,478,000 38% 37% 4,060,000 9,850,000

uartile

,

O 136,336,425 123,708,000 93,952,060

86,409,000 23,478,000 38% 37% 4,000,000 9,980,000

, or

P 135,895,500 123,708,000 93,648,210

86,409,000 23,478,000 38% 37% 4,120,000 9,815,000

Year 12 Year 11

Q 135,491,850 123,708,000 93,370,047

0%

86,409,000 23,478,000 38% 37% 3,950,000 10,210,000

R 137,547,375 123,708,000 94,786,549

86,409,000 23,478,000 38% 37% 3,960,000 9,950,000

S 137,547,375 123,708,000 94,786,549

86,409,000 23,478,000 38% 37% 3,960,000 9,950,000

2.1 Weakness T 134,684,550 123,708,000 92,813,721

86,409,000 23,478,000 38% 37% 4,200,000 10,160,000

135,155,475 123,708,000 93,138,245

86,409,000 23,478,000 38% 37% 4,060,000 9,850,000

Company G

136,336,425 123,708,000 93,952,060

86,409,000 23,478,000 38% 37% 4,000,000 9,980,000

W 134,886,375 123,708,000 92,952,803

86,409,000 23,478,000 38% 37% 4,050,000 9,800,000

0.9 Weakness X

123,708,000

86,409,000 23,478,000 38% 37%

10,533,000

0.6 Y 134,886,375 123,708,000 92,952,803

86,409,000 23,478,000 38% 37% 4,050,000 9,800,000

Year 12 Year 11

134,886,375 123,708,000 92,952,803

86,409,000 23,478,000 38% 37% 4,050,000 9,800,000

13

Weakness

4,120,000

8.3

X

123,708,000

20,503,000

Strength

92,721,000 86,409,000

688000

37,299,000

12,843,000

3%

11.8

Strength

25,827,000 23,478,000

24,933,000

222000 267000

9,411,000

2,316,000 2,163,000

47,187,000

28,365,000 25,908,000

8,235,000

11,391,000

38,952,000

Select Option: 10,533,000

9,815,000

1,869,000

1,233,000

5%

Select Option:

2,619,000

Notes Payable 3,051,000

162,000

12.30% Select Option:

1,134,000

4,185,000

Select Option:

10,000,000 10,000,000 0

13,530,000

0.9

Select Option:

0 -4,620,000

66,937,000 59,260,000 7,677,000 12.95% 7

6.3 Select Option:

6

common stock

5.5 Select Option:

4.9
Select Option:
Strength
Weakness
No Concern
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W

X

Y
Z
F N T 0 2.1
R
Student Name: E Akin
First

I L
Select your first initial from the drop down menu and enter your last name in the field above.
C G The below rules are from Financial Accounting

P W
Comparative Income Statements
D Y Year 12 Year 11 Year 12 C

O Year 10 COGS 2011 Exp 2010 Exp Year 11 tax rate Year 10 Tax Rate 2011 Cash 2011 AP
H X 13 123,

7 92,721,000 6 86,409,000 25,827,000 23,478,000 38% 37% 3,5

66,000 10,533,000
Change % Inc (Dec) 134,684,550 92,813,721 0.10% 26,002,000 4,200,000 10,160,000
NET SALES 135,895,500 12,187,500 9.85% B 134,886,375 92,952,803 0.15% 4,050,000 9,800,000
Cost of

M 93,648,210 7,239,210 8.3 135,155,475 93,138,245 0.20% 4,060,000 9,850,000
GROSS PROFIT 42,247,290 37,299,000 4,948,290 13.27% 135,491,850 93,370,047 0.25% 3,950,000 10,210,000
This column is not graded. It is provided for students to use as they analyze the ratios for the essay. 0.30% 4,120,000 9,815,000
Operating Expenses: 136,336,425 93,952,060 0.35% 4,000,000 9,980,000
Selling and Store Operating 2,349,000 10.01% 136,874,625 94,322,944 0.40% 3,980,000 9,890,000
Pre-Opening 222000 267000 -45,000 -16.85% 0.45%
General and Administrative 2,316,000 2,163,000 153,000 7.07% 137,547,375 94,786,549 0.50% 3,960,000 9,950,000
Total Operating Expenses 28,365,000 25,908,000 2,457,000 9.48% ↑↑↑ J 0.55%
OPERATING INCOME 13,882,290 11,391,000 2,491,290 21.87% Apply the above mathematics rules to your work in this task. Enter — in the answer field when appropriate. K 0.6
Interest Income 0.65% 10,300,000
183000 117000 56.41% 0.70%
Less: Interest Expense 384000 366000 18,000 4.9 0.75%
Interest, net -201000 -249000 48,000 -19.28% Q Select

Strength 0.80%
EARNINGS BEFORE INCOME TAXES 13,681,290 11,142,000 2,539,290 22.79% Company G Industry Weakness 0.85%
Ratio Analysis: Data No Concern 0.9
Provision for Income Taxes 5,052,000 4,419,000 633,000 14.32% Ratio: 0.95%
NET EARNINGS 8,629,290 6,723,000 1,906,290 28.35% 3.1 1.00%
Current Ratio 1.80 1.86 1.05%
1.4 U 1.10%
V 1.15%
Comparative Balance Sheets 1.6 1.20%
December 31, Years 12 and 11 Acid-Test Ratio 0.44 0.64 136,568,250 94,111,815 1.25% 3,566,000
1.30%
Z 1.35%
ASSETS
Current Assets: Inventory Turnover 5.2 6.1 10.2 Data Summary by First Initial
Cash and Cash Equivalents 5,562,000 -1,442,000 -25.93%
Short-Term Investments 36,000 162,000 -126,000 -77.78% F, J, O, V 20,503,000
Accounts Receivable, net 2,638,000 2,686,000 -48,000 -1.79% 35.2 A, M, T 134,550,000 688000
Merchandise Inventory 15,534,000 4,969,000 31.99% Accounts Receivable Turnover 30.6 32.2 33.5 D, L, Q 21,191,000
Other Current Assets 393000 295,000 75.06% (This formula in Horngren only includes credit sales) 31.4 C, N, U 41,829,000
Total Current Assets 27,985,000 24,337,000 3,648,000 14.99% I, R, S 12,843,000
Property and Equipment, at cost: 15.1 K, E, P 24,933,000
Land 11,484,000 1,359,000 11.8 Day’s Sales in receivables 11.1 13.5 B, W, Y, Z 9,411,000
Buildings 21,939,000 2,994,000 13.65% (Horngren reference includes all sales. Modify the formula to use only credit sales. Cash sales are already collected.) 11.3 G, H 47,187,000
Furniture, Fixtures and Equipment 7,860,000 1,551,000 19.73% 8,235,000
41,283,000 5,904,000 14.30% 30.0% 38,952,000
Less Accumulated Depreciation 6,360,000 1,875,000 29.48% Debt Ratio 29.46% 28.34% 45.0% Select Option: 13,464,000 60,143,000
Net Property and Equipment 34,923,000 4,029,000 11.54% 66.0%
TOTAL ASSETS 66,937,000 59,260,000 7,677,000 12.95%
29.7
LIABILITIES Times-interest-earned ratio 36.15 31.12 17.2
Current Liabilities: 8.1 1,869,000
Accounts and

Notes Payable 7,938,000 1,877,000 23.65% 1,233,000
Accrued Salaries and Related Expense 1,656,000 213,000 12.86% 7.55% 2,619,000
Sales and Income Taxes Payable 1,290,000 -57,000 -4.42% Rate of return on net sales 6.3 5.43% 6.12% 16,254,000
Other Accrued Expenses 2,166,000 453,000 20.91% 4.20%
Total Current Liabilities 15,536,000 13,050,000 2,486,000 19.05% 3,051,000
Long-Term Liabilities: 17.20% 1,134,000
2,889,000 5.61% Rate of return on total assets 14.28% 12.30% 4,185,000
Other Long-Term Liabilities 858000 276,000 32.17% 8.60% 20,439,000
Total Long-Term Liabilities 3747000 438,000 11.69%
Total Liabilities 19,721,000 16,797,000 2,924,000 17.41% Rate of return on common 18.60%
stockholder’s equity 19.24% 20.20% 16.30% 10,000,000
STOCKHOLDERS’ EQUITY: 12.80% 13,530,000
Common Stock ($1.00 Par) 0.00% 27,134,000
Paid In Capital 12,501,000 1,029,000 8.23% Earnings per share of
Retained Earnings 28,306,000 19,962,000 8,344,000 41.80% common stock $0.672 0.87
Treasury Stock (2,000,000 shares, at cost) -4,620,000 -100.00% 0.83
Total Stockholders’ Equity 47,216,000 42,463,000 4,753,000 11.19%
TOTAL LIABILITIES and EQUITY
Price earnings ratio $5.21
5.5
Book value per share of
$4.25
Below data is used for drop down box.
DO NOT REMOVE.
Still stressed with your coursework?
Get quality coursework help from an expert!