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.3%   Recalculate Analysis
 
     
         
 
    -14.3%      
                 
        X        
                  Margin on sales -6.8%          Investment turnover 2.1      
         
 
  -6.8%  
 
  2.1      
           
        %     -/-          
    Net income (317)        Sales 4,681                 Sales 4,681       Total assets 2,219      
   
 
before taxes (317)   4,681   4,681  
 
  2,219      
           
      __   +   +      
        Sales 4,681         Total costs 4,998              Net fixed 1,140   Net Intang 10   Current 1,069    
    4,681     4,998                  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,688   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   396    
    +         +     +     +    
  Group3 514 = Volume 514 X      Price 1.0   Net interest 69   Computers & equi 107   Accounts 608    
    514     514     1.0   expense 69   107   receivable 608    
    +         +     +   +    
  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                          
    +                      
  Group7   = Volume   X      Price     +   Group9   = Volume   X      Price      
                                           
    +                 +            
  Group8   = Volume   X      Price     +   Group10   = Volume   X      Price      
                                         
                                             
       
  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.