Earnings per share of common stock

profileebain8
fnt1_statement_analysis_template.xls
Home>Business & Finance homework help>Accounting homework help>Earnings per share of common stock

Statement Analysis

FNT1 Task 1 319.1.2-01-10, 2.1-01-03 Financial Statement Analysis Student Template
Revised April 12, 2011
Student Name: E Akin
First Initial Last Name
Select your first initial from the drop down menu and enter your last name in the field above.
Company G The below rules are from Financial Accounting Principles, Wild, 18th ed.
Comparative Income Statements
December 31, Years 12 and 11 Initial Year 12 Sales Year 11 Sales Year 12 COGS Year 10 COGS 2011 Exp 2010 Exp Year 11 tax rate Year 10 Tax Rate 2011 Cash 2011 AP
Horizontal Analysis X 134,550,000 123,708,000 92,721,000 68.91% 86,409,000 25,827,000 23,478,000 38% 37% 3,566,000 10,533,000
Year 12 Year 11 Change % Inc (Dec) A 134,684,550 123,708,000 92,813,721 0.10% 86,409,000 26,002,000 23,478,000 38% 37% 4,200,000 10,160,000
NET SALES 135,895,500 123,708,000 12,187,500 9.85% B 134,886,375 123,708,000 92,952,803 0.15% 86,409,000 23,478,000 38% 37% 4,050,000 9,800,000
Cost of Merchandise Sold 93,648,210 86,409,000 7,239,210 8.38% C 135,155,475 123,708,000 93,138,245 0.20% 86,409,000 23,478,000 38% 37% 4,060,000 9,850,000
GROSS PROFIT 42,247,290 37,299,000 4,948,290 13.27% D 135,491,850 123,708,000 93,370,047 0.25% 86,409,000 23,478,000 38% 37% 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. E 135,895,500 123,708,000 93,648,210 0.30% 86,409,000 23,478,000 38% 37% 4,120,000 9,815,000
Operating Expenses: F 136,336,425 123,708,000 93,952,060 0.35% 86,409,000 23,478,000 38% 37% 4,000,000 9,980,000
Selling and Store Operating 25,827,000 23,478,000 2,349,000 10.01% G 136,874,625 123,708,000 94,322,944 0.40% 86,409,000 23,478,000 38% 37% 3,980,000 9,890,000
Pre-Opening 222000 267000 -45,000 -16.85% H 136,874,625 123,708,000 94,322,944 0.45% 86,409,000 23,478,000 38% 37% 3,980,000 9,890,000
General and Administrative 2,316,000 2,163,000 153,000 7.07% I 137,547,375 123,708,000 94,786,549 0.50% 86,409,000 23,478,000 38% 37% 3,960,000 9,950,000
Total Operating Expenses 28,365,000 25,908,000 2,457,000 9.48% ↑↑↑ J 136,336,425 123,708,000 93,952,060 0.55% 86,409,000 23,478,000 38% 37% 4,000,000 9,980,000
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 135,895,500 123,708,000 93,648,210 0.60% 86,409,000 23,478,000 38% 37% 4,120,000 9,815,000
Interest Income (Expense): L 135,491,850 123,708,000 93,370,047 0.65% 86,409,000 23,478,000 38% 37% 3,950,000 10,300,000
Interest Income 183000 117000 66,000 56.41% M 134,684,550 123,708,000 92,813,721 0.70% 86,409,000 23,478,000 38% 37% 4,200,000 10,160,000
Less: Interest Expense 384000 366000 18,000 4.92% N 135,155,475 123,708,000 93,138,245 0.75% 86,409,000 23,478,000 38% 37% 4,060,000 9,850,000
Interest, net -201000 -249000 48,000 -19.28% Quartile Select Strength, O 136,336,425 123,708,000 93,952,060 0.80% 86,409,000 23,478,000 38% 37% 4,000,000 9,980,000
EARNINGS BEFORE INCOME TAXES 13,681,290 11,142,000 2,539,290 22.79% Company G Industry Weakness, or P 135,895,500 123,708,000 93,648,210 0.85% 86,409,000 23,478,000 38% 37% 4,120,000 9,815,000
Ratio Analysis: Year 12 Year 11 Data No Concern Q 135,491,850 123,708,000 93,370,047 0.90% 86,409,000 23,478,000 38% 37% 3,950,000 10,210,000
Provision for Income Taxes 5,052,000 4,419,000 633,000 14.32% Ratio: R 137,547,375 123,708,000 94,786,549 0.95% 86,409,000 23,478,000 38% 37% 3,960,000 9,950,000
NET EARNINGS 8,629,290 6,723,000 1,906,290 28.35% 3.1 S 137,547,375 123,708,000 94,786,549 1.00% 86,409,000 23,478,000 38% 37% 3,960,000 9,950,000
Current Ratio 1.80 1.86 2.1 Weakness T 134,684,550 123,708,000 92,813,721 1.05% 86,409,000 23,478,000 38% 37% 4,200,000 10,160,000
1.4 U 135,155,475 123,708,000 93,138,245 1.10% 86,409,000 23,478,000 38% 37% 4,060,000 9,850,000
Company G V 136,336,425 123,708,000 93,952,060 1.15% 86,409,000 23,478,000 38% 37% 4,000,000 9,980,000
Comparative Balance Sheets 1.6 W 134,886,375 123,708,000 92,952,803 1.20% 86,409,000 23,478,000 38% 37% 4,050,000 9,800,000
December 31, Years 12 and 11 Acid-Test Ratio 0.44 0.64 0.9 Weakness X 136,568,250 123,708,000 94,111,815 1.25% 86,409,000 23,478,000 38% 37% 3,566,000 10,533,000
0.6 Y 134,886,375 123,708,000 92,952,803 1.30% 86,409,000 23,478,000 38% 37% 4,050,000 9,800,000
Year 12 Year 11 Z 134,886,375 123,708,000 92,952,803 1.35% 86,409,000 23,478,000 38% 37% 4,050,000 9,800,000
ASSETS 13
Current Assets: Inventory Turnover 5.2 6.1 10.2 Weakness Data Summary by First Initial
Cash and Cash Equivalents 4,120,000 5,562,000 -1,442,000 -25.93% 8.3 X
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 123,708,000 688000
Merchandise Inventory 20,503,000 15,534,000 4,969,000 31.99% Accounts Receivable Turnover 30.6 32.2 33.5 Strength D, L, Q 92,721,000 86,409,000 21,191,000
Other Current Assets 688000 393000 295,000 75.06% (This formula in Horngren only includes credit sales) 31.4 C, N, U 41,829,000 37,299,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 12,843,000 11,484,000 1,359,000 11.83% Day's Sales in receivables 11.8 11.1 13.5 Strength B, W, Y, Z 25,827,000 23,478,000 9,411,000
Buildings 24,933,000 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 222000 267000 47,187,000
Furniture, Fixtures and Equipment 9,411,000 7,860,000 1,551,000 19.73% 2,316,000 2,163,000 8,235,000
47,187,000 41,283,000 5,904,000 14.30% 30.0% 28,365,000 25,908,000 38,952,000
Less Accumulated Depreciation 8,235,000 6,360,000 1,875,000 29.48% Debt Ratio 29.46% 28.34% 45.0% Select Option: 13,464,000 11,391,000 60,143,000
Net Property and Equipment 38,952,000 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 Select Option: 10,533,000
Current Liabilities: 8.1 1,869,000
Accounts and Notes Payable 9,815,000 7,938,000 1,877,000 23.65% 1,233,000
Accrued Salaries and Related Expense 1,869,000 1,656,000 213,000 12.86% 7.55% 2,619,000
Sales and Income Taxes Payable 1,233,000 1,290,000 -57,000 -4.42% Rate of return on net sales 6.35% 5.43% 6.12% Select Option: 16,254,000
Other Accrued Expenses 2,619,000 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
Notes Payable 3,051,000 2,889,000 162,000 5.61% Rate of return on total assets 14.28% 12.30% 12.30% Select Option: 4,185,000
Other Long-Term Liabilities 1,134,000 858000 276,000 32.17% 8.60% 20,439,000
Total Long-Term Liabilities 4,185,000 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% Select Option: 10,000,000
STOCKHOLDERS' EQUITY: 12.80% 13,530,000
Common Stock ($1.00 Par) 10,000,000 10,000,000 0 0.00% 27,134,000
Paid In Capital 13,530,000 12,501,000 1,029,000 8.23% Earnings per share of 0.9
Retained Earnings 28,306,000 19,962,000 8,344,000 41.80% common stock $0.672 0.87 Select Option:
Treasury Stock (2,000,000 shares, at cost) -4,620,000 0 -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 66,937,000 59,260,000 7,677,000 12.95% 7
Price earnings ratio $5.21 6.3 Select Option:
5.5
Book value per share of 6
common stock $4.25 5.5 Select Option:
4.9
Below data is used for drop down box.
DO NOT REMOVE.
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