Please fill all required fields
      Please note that this is a simple calculation and the author will not be held responsible for any claims that result out of the use    
      of the calculator. Contact a financial advisor if you need assistance.  
     
      You can get a full working copy in Excel with additional features from  
      http://www.auditexcel.com/pIRR_CALCULATOR/A-IRR-Calculator---Premium.aspx  
     
      IRR Calculator  
      Fill in all the blue cells and then look at/ print the summary at the bottom        
             
                   
        Guess an IRR (helps the process)        
                   
      We have left some sample numbers in the cells to show you what to do. Delete them and put in your own dates and cash flows      
        Resultant IRR=  
        Name=  
     
    Date of Cash Flow
    Outflow (negative number)
    Inflow (positive number)
    Net Cash Flow
    Cumulative IRR
    Cumulative Cash Flows
     
    0
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    Calendar
    Calendar
     
    END END END END END END END  
     
       
                   
      Cash Outflows      
      Cash Inlows      
      Net Cash Position      
                   
      Start Date      
      End Date      
                   
      Number of years      
                   
      Resultant IRR      
     
       
    Powered By SpreadsheetConverter