Hey Jonathan--
This page has an excellent description of what the IRR is and how it's
calculated.
http://invest-faq.com/articles/analy-int-rate-return.html
I'd love to help more than this, but this is quite a bit of work and
without the actual spreadsheet I'm not sure that I'd be able to give
I received an Excel Spread sheet with built in calculations for
creating our rate sheets that we pass out to our branches and so on.
In this rate sheet to calculate our APR the spread sheet calls built in
Finance Functions
IRR Internal Rate of Return
PMT Calculates a Payment
PV Calculates Prese
2 matches
Mail list logo
