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.