Quik-Plan Assumptions  
       
  1.  
Help about Quik-Plan
 
     
  2.  
Clear Quik-Plan Assumptions Report
 
     
  3.   Enter Basic Data &  Assumptions for Quik-Plan
 
     
       
  4.  
Run Quik-Plan
 
     
       
       
       
  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 " 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 420.0  US$000s  Enter sales value net of all sales taxes and discounts.  
   Desired average finished inventory 90.0 % of sales  Express as % average monthly sales. Set to zero for a distribution  
            or service business.  
   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 195.0  US$000s  } purchases/inventory for resale if a distribution business.  
           
   Average monthly direct costs  110.0  US$000s  May be zero in case of a distribution business.  
   Average monthly overhead expenses 100.0  US$000s  Exclude depreciation & interest.  
           
   Opening total cost of fixed assets 1,300.0  US$000s  Use cost at the start date of projections, not the depreciated value.  
   Accumulated opening depreciation 350.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 175.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) (100.0)  US$000s  If deficit (e.g. short-term loan or line of credit), enter minus value.  
   Opening longterm debt/notes 450.0  US$000s  Combine value of all outstanding long-term debt/loans/notes etc.  
   Net change in longterm debt/notes in yr 125.0  US$000s  Use + for a net increase and - for a net reduction during the year.  
           
   Opening accounts receivable 700.0  US$000s  As at start date of projections. Exclude expected bad debts.  
   Opening accounts payable 500.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 50.0  US$000s  Indicate dividends declared.  
   Opening number of shares 100.0  000s  Indicate issued shares only.  
   Proceeds of new stock issues 100.0  US$000s  Specify proceeds net of all fund-raising costs.  
   Number of new shares issued 12.0  000s  This number will be added to the opening number of shares.  
  Assumptions for Following Years  
   Variables 2nd Yr    3-5 Yrs (Enter annual averages)  
   % 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 100.0 190.0  US$000s. Average per year.  
   Net change in longterm debt/notes 70.0 100.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 70.0 90.0  US$000s. Average per year.  
   Proceeds of new stock issues 150.0  US$000s Specify proceeds net of costs.  
   Number of new shares issued 10.0  000s Indicates numbers of shares.