Calculators     Interest FAQ     Directory     Excel templates     

 irr calculation
    
Spreadsheet versions of the calculations for Excel® or OpenOffice®
Internal Rate of Return
 

Excel® und Openoffice® templates


  • You are working on your computer or laptop.
  • The data input is much easier.
  • You can generate graphs from the result.
  • You can paste the computation into your reports and presentations.
  • The generally recognized built-in functions of the spreadsheets are used.


internal rate of return, IRR , aperiodic payments

Excel®template for the computation of the yield (IRR).


Offers the same functionality as the online calculator. Simply enter all payments with their accurate date. Return and finish. Calculates the net yield according to the internal rate of return from arbitrary payments.

The calculation of the IRR takes place with three different methods. Once with the function "IRR" for periodic payments and alternatively with two more complicated functions for aperiodic payments. Works with Excel® and OpenOffice®.

No macros, no VBA programming and without password protection.
Therefore you can adapt the spreadsheet template easily to your needs and your design. I offer you the template for $12.-.


Screen 1     Screen 2     Screen 3

Download




repayment plan with excel, effectiv interest charges

Template for Excel® or OpenOffice® for the calculation of a repayment plan.


It offers the same functionality as the online repayment plan calculator. You enter the credit sum, conclusion costs, the rate amount and the duration of the credit. The repayment plan and the effective interest are calculated immediately after each input. Changes of interest and extra payments can be entered directly into the table.

The calculation of the effective interest takes place with two different methods. Once with the function "IRR" for periodic payments and alternatively with a more complicated function for aperiodic payments (with Excel®). So the effective interest can be calculated with additional repayments.

No macros, no VBA programming and without password protection. Therefore you can adapt the spreadsheet template easily to your needs and your design.


Screen 1     Screen 2     Screen 3


Download







Excel® ist ein Warenzeichen der Microsoft Corp.




Performance of the system    about IRRQ    Contact form    Disclaimer


Mistakes? Help to improve this page.

Valid HTML 4.01 Transitional