Financial Analysis Project with Ongoing, weekly deadlines

Import Financial Statements

Stock Prices

200														200
190														190
180														180
170														170
160														160
150														150
140														140
130														130
120														120
110														110
100														100
90														90
80														80
70														70
60														60
50														50
40														40
30														30
20														20
10														10
0														0
	1	2	3	4	1	2	3	4	1	2	3	4

Horizontal Analysis-IS

	HORIZONTAL ANALYSIS
	ABC Corporation
	Comparative Income Statements
	For the Years Ending December 31
						Percentage Difference
		Current Year (CY)	Prior Year (PY)	2 Years Prior (2YP)		(CY - PY)/PY	(PY - 2YP)/2YP
	Net Sales
	Cost of goods sold
	Gross Margin
	Operating expenses:
	Selling expenses
	Administrative expenses
	Total operating expenses
	Income from continuing operations
	Income tax expense
	Nonrecurring items
	Net income

Vertical Analysis-IS

	VERTICAL ANALYSIS
	ABC Corporation
	Comparative Income Statements
	For the Years Ending December 31
		Current Year (CY)	Prior Year (PY)	2 Years Prior (2YP)
	Net Sales	100%	100%	100%
	Cost of goods sold
	Gross Margin
	Operating expenses:
	Selling expenses
	Administrative expenses
	Total operating expenses
	Income from continuing operations
	Income tax expense
	Nonrecurring items
	Net income

IS Comparison

	2YP	PY	CY
Net Sales
COGS
Gross Margin
Net Income

2YP Net Sales COGS Gross Margin Net Income PY Net Sales COGS Gross Margin Net Income CY Net Sales COGS Gross Margin Net Income

Horizontal Analysis-BS

	HORIZONTAL ANALYSIS
	ABC Corporation
	Comparative Balance Sheets
	For the Years Ending December 31
						Percentage Difference
		Current Year (CY)	Prior Year (PY)	2 Years Prior (2YP)		(CY - PY)/PY	(PY - 2YP)/2YP
	Current assets
	Long-term investments
	Property, plant, & equipment
	Intangible assets
	Other assets
	Total assets
	Current liabilities
	Long-term liabilities
	Total liabilities
	Paid-in capital
	Retained earnings
	Treasury stock
	Total stockholders' equity
	Total liabilities & stockholders' equity

Vertical Analysis-BS

	VERTICAL ANALYSIS
	ABC Corporation
	Comparative Balance Sheets
	For the Years Ending December 31
		Current Year (CY)	Prior Year (PY)	2 Years Prior (2YP)
	Current assets
	Long-term investments
	Property, plant, & equipment
	Intangible assets
	Other assets
	Total assets	100%	100%	100%
	Current liabilities
	Long-term liabilities
	Total liabilities
	Paid-in capital
	Retained earnings
	Treasury stock
	Total stockholders' equity
	Total liabilities and stockholders' equity	100%	100%	100%

BS Comparison

	2 YP	PY	CY
Assets
Liabilities
Stockholders' Equity

2 YP Assets Liabilities Stockholders' Equity PY Assets Liabilities Stockholders' Equity CY Assets Liabilities Stockholders' Equity

SE

	ABC Corporation
	Statement of Stockholders' Equity
	For the Year Ending December 31, CY
		Common Stock, $x Par	APIC - CS	Retained Earnings	Treasury Stock	Total Stockholders' Equity
	Balance, January 1
	Issuance for additiona shares for cash
	Purchase of treasury stock
	Net income (loss)
	Cash dividends
	Treasury stock
	Balance, December 31
		2 Years Prior (2YP)	Prior Year (PY)	Current Year (CY)
	Number of shares outstanding

CF

	Statement of Cash Flows
	ABC Corporation
	For the Years Ending December 31
	Cash Flow Activity	Current Year (CY)	Prior Year (PY)	2 Years Prior (2YP)
	Net cash provided (used by) operating activities
	Net cash provided (used by) investing activities
	Net cash provided (used by) financing activities
	Increase (decrease) in cash
	Beginning cash balance
	Ending cash balance

CF Comparison

	2 YP	PY	CY
Operating Activities
Investing Activities
Financing Activities
Ending Balance

2 YP Operating Activities Investing Activities Financing Activities Ending Balance PY Operating Activities Investing Activities Financing Activities Ending Balance CY Operating Activities Investing Activities Financing Activities Ending Balance

NI and CF

	2 YP	PY	CY
Net Income
Operating Activities

2 YP Net Income Operating Activities PY Net Income Operating Activities CY Net Income Operating Activities

Competitors & Industry

		COMPETITORS
	Corporation	1	2	3	4	5	Industry
Liquidity Ratios:
Current ratio
Quick (acid-test) ratio
Current cash debt ratio
Profitability Ratios:
Profit margin on sales
Return on assets
Return on common equity
Earnings per share
Price-earnings ratio
Payout ratio
Efficiency Ratios:
Accounts receivable turnover
Inventory turnover
Asset turnover
Solvency Ratios:
Debt to assets
Times interest earned
Cash debt coverage