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 you
meaningful help!
Cheers,
Marco
On Mon, 2003-02-17 at 17:08, Jonathan Pitcher wrote:
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 Present Value
My goal is to turn the excel sheet into a DB Driven Rate management
system for our Internal and External websites. With all input and
export going through a web based system.
I have all the information I need but I can't seem to find the right
formulas to make the calculations.
Thanks again,
Jonathan
--
Marco Tabini
President
Marco Tabini Associates, Inc.
28 Bombay Ave.
Toronto, ON M3H 1B7
Canada
Phone: (416) 630-6202
Fax: (416) 630-5057
Weblog: http://blogs.phparch.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php