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
