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 ' 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.