Please fill all required fields

               
  Cemetery Break Even Calculator  
   
     
               
  Input Cell      
  Automatic Calculation        
        Step 1   Step 2  
  Annual Volume   Enter Actual Results   ProForma Adjustments  
      increase/-decrease  
  AtNeed Interments      
  Preneed Conversions      
  Total Annual Interment Rights          
               
  Annual Interment Revenue      
  At Need Interment Rights      
  Revenue from preneed conversions      
  Opening and closing fees      
  Merchandise sales      
  Miscellaneous income      
  Total At Need Interment Revenue      
  Less:      
  Commissions paid on at need sales      
  Endowment cost      
  Total:      
  Net Revenue From At Need Sales      
  Average At Need Net Revenue per interment      
               
  Other Non-Interment Related Revenue      
  Preneed sales      
  Less:        
  Commissions on preneed      
  Trust reserve      
  Variable sales and Reserve Costs          
  Net Income From Preneed Sales        
  Endowment Income        
  Miscellaneous income        
             
  Total Non-interment Related Revenue      
         
  Fixed Overhead          
               
  Net Fixed Overhead    
         
  Net Profit From Operations    
               
  Break Even       Current Actual Target  
         
  Interment Rights      
         
  Target Interment Rights    
         
  At Need Interment Revenue      
         
  Target At Need Interment Revenue          
 
    Powered By SpreadsheetConverter
Actual > Pro Forma