Quik-Plan Assumptions
	1.
	2.
	3.
	4.
	Quik-Plan Assumptions Report
	Year in which to start projections	2004	Enter as 4 digits - like 200X
	Month for start of the projections	9	Enter month number - between 1 to 12
	Currency unit	000	Enter '000 (thousands - note the ' immediately before 000), Mln (millions) or Bn (billions)
	Currency symbol	$	Enter up to 3 characters as label and press F9 to update the units below
	Assumptions for Initial Three Years
	Variables	1st	2nd	3rd	Units (Press F9 to Update)           Guidance
	Average monthly sales for each year	420.0	500.0	600.0	$000s	Enter sales value net of all sales taxes and discounts.
	Desired finished inventory for each year	90.0	100.0	110.0	% of sales	Express as % average monthly sales. Set to zero for a distribution
						or service business.
	Cost of materials/goods for each year	41.0	42.0	43.0	As % sales	} Set to zero for a labor-only service business. These can refer to
	Target materials/goods inventory for each year	195.0	200.0	210.0	$000s	} purchases/inventory for resale if a distribution business.
	Average monthly direct costs for each year	120.0	135.0	160.0	$000s	May be zero in case of a distribution business.
	Average monthly overhead exs for each year	100.0	120.0	130.0	$000s	Exclude depreciation & interest.
	Opening total cost of fixed assets	1,300.0	$000s			Use cost at the start date of projections, not the depreciated value.
	Accumulated opening depreciation	350.0	$000s			Use value at the start day of projections
	Average annual depreciation rate for all years	8.0	% p.a.			Use approximate weighted-average rate covering all fixed assets.
	Planned capital expenditure for each year	250.0	400.0	425.0	$000s
	Interest rate for cash balances for all years	4.0	% p.a.			Use approximate weighted-average rate.
	Interest rate for all debt/notes for all years	10.0	% p.a.			Use approximate weighted-average rate.
	Opening cash balance (deficit)	(100.0)	$000s			If deficit (e.g. short-term loan or line of credit), enter minus value.
	Opening longterm debt/notes	450.0	$000s			Combine value of all outstanding long-term debt/loans/notes etc.
	Net change in longterm debt/notes in each year	125.0	135.0	145.0	$000s	Use + for a net increase and - for a net reduction during each year.
	Opening accounts receivable	700.0	$000s			As at start date of projections. Exclude expected bad debts.
	Opening accounts payable	300.0	$000s			As at start date of projections. Include any other planned payments.
	Average credit given on sales for all years	61	Days sales			Use estimate which takes any cash sales into account.
	Average credit taken for materials/goods	46	Days sales			Estimate should take account of any suppliers which give no credit.
	Expected federal/state tax rate for each year	35.0	30.0	25.0	%	Use the effective, rather than standard, rate.
	Planned dividends for each year	50.0	60.0	80.0	$000s	Indicate dividends declared
	Opening number of shares	100.0	000s			Indicate issued shares only
	Proceeds of new stock issues in each year	500.0	120.0	140.0	$000s	Specify proceeds net of all fund-raising costs
	Number of new shares issued in each year	60.0	11.0	10.0	000s	These numbers will be added to the opening number of shares
	Assumptions for Following Years
	Variables	4th	5th		Guidance
	% annual change - sales	5.0	10.0	% change	Indicate % changes over previous year. Allow for volume or price changes.
	Cost of materials/goods	42.0	43.0	% sales	Express as % sales. This should be consistent with % used for the first three year.
	% annual change - direct costs	4.0	7.0	% change	} Indicate % changes over previous year. Take account of any changes in
	% annual change - overhead expenses	5.0	9.0	% change	} sales volumes, cost inflation and productivity.
	Planned capital expenditure	500.0	500.0	$000s	indicate average for each year.
	Net change in longterm debt/notes	70.0	100.0	$000s	Indicate average for each year. Use "+" for net increaseand "-" for net reduction.
	Expected federal/state tax rate	30.0	35.0	%	Use the effective, not standard, rates for each year.
	Planned dividends	100.0	120.0	$000s	indicate average for each year.
	Proceeds of new stock issues	150.0	170.0	$000s	Specify proceeds net of costs in each year.
	Number of new shares issued	8.0	6.0	000s	Indicates numbers of shares issued in each year.
		Await a message while Quik-Plan removes existing assumptions,
		inserts the Quik-Plan assumptions & recalculates several times.