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 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 13.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 19.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.