Profitability Planner
	Currency values expressed as $000.
	Data relates to year ending Jan 2006.
	See instructions below.					Return on total assets (Profitability)					-14.3%
											-14.3%
										X
				Margin on sales			-6.8%				Investment turnover			2.1
							-6.8%							2.1
						%							-/-
			Net income		(317)		Sales	4,681		Sales	4,681				Total assets		2,219
			before taxes		(317)			4,681			4,681						2,219
						__										+			+
	Sales	4,681								Total costs	4,998		Net fixed	1,140		Net Intang	10		Current	1,069
		4,681									4,998		assets	1,140		assets	10		assets	1,069
		=									=			=						=
	Group1	1,435	=	Volume	1,435	X	Price	1.0		Cost of sales	2,688		Land, buildings	584					Cash
		1,435			1,435			1.0			2,688			584
		+									+			+						+
	Group2	1,042	=	Volume	1,042	X	Price	1.0		Overhead	2,106		Plant & machiner	341					Inventory	396
		1,042			1,042			1.0		expenses	2,106			341						396
		+									+			+						+
	Group3	514	=	Volume	514	X	Price	1.0		Net interest	69		Computers & equi	107					Accounts	608
		514			514			1.0		expense	69			107					receivable	608
		+									+			+						+
	Group4	120	=	Volume	120	X	Price	1.0		Depreciation	110		Automobiles, veh	107					Other	65
		120			120			1.0			110			107						65
		+									+
	Group5	240	=	Volume	240	X	Price	1.0		Other items	24
		240			240			1.0			24
		+
	Group6	1,330	=	Volume	1,330	X	Price	1.0
		1,330			1,330			1.0
		+
	Group7		=	Volume		X	Price			+			Group9		=	Volume		X	Price
		+												+
	Group8		=	Volume		X	Price			+			Group10		=	Volume		X	Price
	Instructions:
	1. Compile preliminary first-year projections.
	2. Press Update Values button to copy all calculated first-year values (in white cells) into the yellow assumption cells above.
	3. Change values in yellow assumption cells individually (or in combinations to take account of interactions). Examples:
	- An increase in sale prices might require an increase in accounts receivable and a possible reduction in sales volumes.
	- A substantial increase in sales volumes will require higher cost of sales and might also need additional fixed
	assets plus higher receivable & inventory levels.
	4. Press Recalculate Ratios button to update the profitability projection in the yellow cells.