Financial Accounting II

j.tobias_module_2_spreedsheet_4-19-15.xlsx

Vertical_Horizonal Analysis

Week 1 fill in the numbers-this tab only. Complete blue highlighted areas only. There are no calculations in week one.
Table I
Company (enter your company name)				Vertical Analysis year 1	Vertical Analysis Year 2	Horizontal Analysis
Income Statement	2014	2013	2012
Net Revenue (net sales)	543,525	543,383	549,870
Cost of Goods	341,880	351,897	366,549
Gross Profit	201,645	191,486	183,321
Total Operating Expenses	117,722	119,133	113,842
Earnings from Operations	83,923	72,353	69,479
Interest Expense	7,321.00	12,130	4,685
Net Earnings	28,434	23,634	22,160
Balance Sheet
Cash/cash equivalents (cash)	100,108	88,283	63,862
Short term investments	39,450	33,572	18,746
Net Accounts Receivable	48,624	50,819	48,102
Inventory	70,379	61,856	62,383
Current Assets	264,621	240,111	197,241
Net Fixed Assets	645,765	648,298	649,496
Total Assets	910,386	888,409	846,737
Current Liabilities	64,459	60,121	60,765
Long Term Liabilities	154,791	147,983	136,157
Total liabilities	219,250	208,104	196,922
Stockholders Equity	691,136	680,305	649,815
Total liabilities + Stockholders Equity	910,386	888,409	846,737
Prepared by your name
Select numbers taken from financial statements
Include the source here
Optional Information
Any Preferred Stock
Dividends paid Common shareholder
Dividents paid to Preferred shareholder
Outstanding Shares Common Stock
Basic EPS (Earnings Per Share)
Auditing Firm

Table II
Company		Company*	Company*	Competition or Industry Ratio**
	Formula	Year 1	Year 2	give the year here
Liquidity Ratios					1. Complete the formula column. See example for gross profit percent.
Current Ratio					2. Use the numbers on the previous page to complete the ratios-Use Excel formulas.
Acid Test Ratio					3. One * means you did the calculations
					Two ** means you got the information from another source (cite that source)
Asset Management Ratio					4. For column E choose a competitor or the Industry.
Inventory Turnover					You do not need to calculate the competitor ratios, you can use pre-calculated ratios
					just remember to cite your source. (like a database)
Solvency Ratios
Debt ratio
Times Interest Earned Ratio
Profitability Ratios
Gross Profit Percent	Gross profit/net revenue
Return on Net Sales
EPS**
Market Analysis
Price Earning Ratio**
Dividend Yield**
*Calculated by Author
** Information from give souce
Prepared by