Profitability Planner  
Print Analysis
Help
 
     
           
  Currency values expressed as $000      
  Data relates to year ending Dec 2005.   Update Values
 
     
  See instructions below.     Return on total assets (Profitability) -41.4%      
         
 
    -41.4%      
              Recalculate Ratios
 
     
        X        
                  Margin on sales -25.8%          Investment turnover 1.6      
         
 
  -25.8%  
 
  1.6      
           
        %     -/-          
     Net income (1,040)        Sales 4,027                 Sales 4,027       Total assets 2,513      
   
 
 before taxes (1,040)   4,027   4,027  
 
  2,513      
           
      __   +   +      
        Sales 4,027         Total costs 5,068              Net fixed 1,269   Net Intang 10   Current 1,235    
    4,027     5,068                  assets 1,269        assets 10     assets 1,235    
    =   =     =     =    
  Group1 1,435 = Volume 1,435 X      Price 1.0   Cost of sales 2,754   Land, buildings  584   Cash 161    
    1,435     1,435     1.0   2,754   584   161    
    +         +     +     +    
  Group2 1,043 = Volume 1,043 X      Price 1.0   Overhead 2,354   Plant & machiner 341   Inventory 438    
    1,043     1,043     1.0   expenses 2,354   341   438    
    +         +     +     +    
  Group3 522 = Volume 522 X      Price 1.0   Net interest 17   Computers & equi 236   Accounts 570    
    522     522     1.0   expense 17   236   receivable 570    
    +         +     +   +    
  Group4 120 = Volume 120 X      Price 1.0   Depreciation 191   Automobiles, veh 107   Other 65    
    120     120     1.0   191   107   65    
    +         +        
  Group5 240 = Volume 240 X      Price 1.0   Other items (249)      
    240     240     1.0   (249)      
    +              
  Group6 667 = Volume 667 X      Price 1.0                          
    667     667     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 cell) 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 receivables and possible reduction in sales volumes.  
           - A substantial increase in sales volumes will require higher cost of sales and might also need additional fixed   
             assets, higher receivables & inventories.  
  4. Press Recalculate Ratios button to update the profitability projection in the yellow cells.