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	10	Enter month number - between 1 to 12
	Currency unit	000	Enter "000 (thousands - note the " before 000), Mln (millions) or Bn (billions)
	Currency symbol	US$	Enter up to 3 characters as label and press F9 to update the units below
	Assumptions for First Year
	Variables	Values	Units (Press F9 to Update)           Guidance
	Average monthly sales	42.0	US$000s	Enter sales value net of all sales taxes and discounts.
	Cost of materials/goods	41.0	As % sales	} Set to zero for a labor-only service business. These can refer to
	Target materials/goods inventory	20.0	US$000s	} purchases/inventory for resale if a distribution business.
	Average monthly direct costs	11.0	US$000s	May be zero in case of a distribution business.
	Average monthly overhead expenses	10.0	US$000s	Exclude depreciation & interest.
	Opening total cost of fixed assets	130.0	US$000s	Use cost at the start date of projections, not the depreciated value.
	Accumulated opening depreciation	35.0	US$000s	Use value at the start day of projections.
	Average depreciation rate	8.0	% p.a.	Use approximate weighted-average rate covering all fixed assets.
	Planned capital expenditure for year	18.0	US$000s
	Interest rate for cash balances	6.0	% p.a.	Use approximate weighted-average rate.
	Interest rate for all debt/notes	12.0	% p.a.	Use approximate weighted-average rate.
	Opening cash balance (deficit)	(10.0)	US$000s	If deficit (e.g. short-term loan or line of credit), enter minus value.
	Opening longterm debt/notes	45.0	US$000s	Combine value of all outstanding long-term debt/loans/notes etc.
	Net change in longterm debt/notes in yr	12.0	US$000s	Use + for a net increase and - for a net reduction during the year.
	Opening accounts receivable	70.0	US$000s	As at start date of projections. Exclude expected bad debts.
	Opening accounts payable	50.0	US$000s	As at start date of projections. Include any other planned payments.
	Average credit given on sales	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	35.0	%	Use the effective, rather than standard, rate.
	Planned dividend for year	5.0	US$000s	Indicate dividends declared.
	Opening number of shares	10.0	000s	Indicate issued shares only.
	Proceeds of new stock issues	10.0	US$000s	Specify proceeds net of all fund-raising costs.
	Number of new shares issued	1.0	000s	This number will be added to the opening number of shares.
	Assumptions for Following Years
	Variables	2nd Yr	3rd Yr
	% annual change - sales	5.0	10.0	% change over previous year. Allow for volume or price changes.
	Cost of materials/goods	42.0	43.0	As % sales. This should be consistent with % used for the first year.
	% annual change - direct costs	4.0	7.0	} % changes over previous year. Take account of any changes in
	% annual change - overhead expenses	5.0	9.0	} sales volumes, cost inflation and productivity.
	Planned capital expenditure	10.0	20.0	US$000s. Average per year.
	Net change in longterm debt/notes	7.0	10.0	US$000s. Average per year. Use + for net increase & - for net reduction.
	Expected federal/state tax rate	30.0	35.0	%. Use the effective, not standard, rates.
	Planned dividends	7.0	9.0	US$000s. Average per year.
	Proceeds of new stock issues	15.0	US$000s	Specify proceeds net of costs.
	Number of new shares issued	1.0	000s	Indicates numbers of shares.