---

Overview

Arkusz1
Arkusz2

---

Sheet 1: Arkusz1

Balance sheet	2006	2007	2008		Cash flow statement	2006	2007	2008
Assets	6422	9683	6042		I. Operating cash flow	-1880
I. Fixed assets	1000	1800	1400		1. Net income	742
1. Net real assets	1000	1800	1400		2. Adjustments	-2622
2. Financial assets	0	0	0		a) Depreciation	200
II. Current assets	5422	7883	4642		b) Change in receivables	-2836
1. Inventories	2466	3205	1924		c) Change in inventories	-2466
2. Receivables	2836	4568	2644		d) Change in short-term liabilities	2480
3. Cash and marketable securities	120	110	74		II. Investment cash flow	-1200
Liabilities	6422	9683	6042		1. Purchase/Sale of real assets	-1200
I. Equity	2742	2653	778		2. Purchase/sale of financial assets	0
1. Issued capital	2000	2000	2000		III. Financial cash flow	3200
2. Retained earnings	0	242	653		1. Issue of shares	2000
3. Current earnings	742	411	-1875		2. Change in long-term liabilities	1200
II. Liabilities	3680	7030	5264		3. Dividends paid	0
1. Provisions	0	0	0		Cash at the beginning of the year	0
2. Long-term liabilities	1200	3800	3300		Net increase in cash	120
3. Short-term liabilities	2480	3230	1964		Cash at the end of the year	120
4. Accruals	0	0	0
Profit and loss statement	2006	2007	2008		1. Company was established on 01.01.2006
Revenue	17013	21925	12693		2. Company sells computer components
Operating expenses	15617	20623	13858		3. Fixed assets consists of two warehouses (each worth 1 mln PLN) and equipment worth 0,2 mln PLN
a) cost of goods sold	14794	19233	11539		4. Straight-line depreciation is used
b) materials and energy	110	270	330
c) services	50	95	180		The list of tasks is on the other side of the page
d) taxes and fares	50	20	20
e) payroll	300	500	900
f) payroll bonuses	63	105	189
g) depreciation	200	200	400
h) others	50	200	300
Net operating profit	1396	1302	-1165
Financial income	0	0	0
Financial costs	180	650	710
Profit before tax	1216	652	-1875
Income tax	474	241	0
Net income	742	411	-1875

---

Sheet 2: Arkusz2

Name		Simplified version		Pro version	Simplified version
Liquidity ratios					2006	2007	2008
Current ratio =		current assets		current assets	2,19
		current liabilities		current liabilities
Quick (acid test) =		current assets - inventories		current assets - inventories	1,19
		current liabilities		current liabilities
Liquidity cash ratio =		current assets-inventories-receivables		current assets-inventories-receivables	0,05
		current liabilities		current liabilities
									The analysis of a firm's financial standing should comprise:
Efficiency ratios									1. An overall evaluation of the firm standing
									2. An identification of a success or failure key-factors
Inventory turnover =		net sales		cost of goods sold	6,9				3. Establish connections between key-factors (mentioned above) and corresponding financial ratios
		inventories		average inventories					4. What was the external capital requirement in each year?
									5. What were the sources of external capital?
Daily sales outstanding	=	receivables		average receivables	60				6. What is a management's major task?
		net sales/365		net sales on credit/365
Net fixed assets turnover	=	net sales		net sales	17
		net fixed assets		average net fixed assets
Total assets turnover	=	net sales		net sales	2,65
		total assets		average total assets
Debt ratios
Total debt ratio =		total liabilities		total liabilities	57,3%
		total assets		total assets
Capital structure	=	total liabilities		total liabilities	1,34
		equity		equity
Times interest earned	=	net operating income		EBIT	7,76
		financial costs		financial costs
Profitability ratios
Net profit margin	=	net income		net income	4,36%
		net sales		net sales
Return on assets =		net income		net operating profit after taxes	11,55%
		total assets		average total assets
Return on equity =		net income		net income	27,05%
		equity		average equity
Market ratios
Price/Earnings (P/E) =		share price		share price
		earnings per share		earnings per share
Market value/Book value (MV/BV)	=	share price		share price
		book value of a price		book value of a price