Profitability Planner  
Help
Print Analysis
 
     
           
  Currency values expressed as $000.   Update Values
 
     
  Data relates to year ending Jan 2006.      
  See instructions below.     Return on total assets (Profitability) -14.4%   Recalculate Analysis
 
     
         
 
    -21.9%      
                 
        X        
                  Margin on sales -6.8%          Investment turnover 2.1      
         
 
  -10.4%  
 
  2.1      
           
        %     -/-          
    Net income (317)        Sales 4,681                 Sales 4,681       Total assets 2,201      
   
 
before taxes (485)   4,681   4,681  
 
  2,219      
           
      __   +   +      
        Sales 4,681         Total costs 4,998              Net fixed 1,140   Net Intang 10   Current 1,051    
    4,681     5,166                  assets 1,140         assets 10    assets 1,069    
    =   =     =     =    
  Group1 1,435 = Volume 1,435 X      Price 1.0   Cost of sales 2,688   Land, buildings  584   Cash      
    1,435     1,435     1.0   2,849   584        
    +         +     +     +    
  Group2 1,042 = Volume 1,042 X      Price 1.0   Overhead 2,106   Plant & machiner 341   Inventory 396    
    1,042     1,042     1.0   expenses 2,106   341   414    
    +         +     +     +    
  Group3 514 = Volume 514 X      Price 1.0   Net interest 69   Computers & equi 107   Accounts 590    
    514     514     1.0   expense 76   107   receivable 590    
    +         +     +   +    
  Group4 120 = Volume 120 X      Price 1.0   Depreciation 110   Automobiles, veh 107   Other 65    
    120     120     1.0   110   107   65    
    +         +        
  Group5 240 = Volume 240 X      Price 1.0   Other items 24      
    240     240     1.0   24      
    +                  
  Group6 1,330 = Volume 1,330 X      Price 1.0          
    1,330     1,330     1.0          
                                             
       
  Instructions:    
  1. Compile preliminary first-year projections.    
  2. Press Update Values button to copy all calculated first-year values (in white cells) into the yellow assumption cells above.  
  3. Change values in yellow assumption cells individually (or in combinations to take account of interactions). Examples:  
           - An increase in sale prices might require an increase in accounts receivable and a possible reduction in sales volumes.  
           - A substantial increase in sales volumes will require higher cost of sales and might also need additional fixed     
             assets plus higher receivable & inventory levels.    
  4. Press Recalculate Ratios button to update the profitability projection in the yellow cells.