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
If I may barge in...
The IRR represents the actual return of an investment over an arbitrary
period of time (usually annualized).
Say, for example, that you invest $100 and, after two years, you have
$120. Your overall return is 20%. If your interest rate was constant
over the two-year period and
On Mon, 17 Feb 2003, Jonathan Pitcher wrote:
>This process involves an IRR Calculation. Or Internal Rate of Return.
Sorry, I don't think there are any accountants lurking on the list, so
please explain what the actual calculation for an IRR should be.
--
Greg Donald
http://destiney.com
--
On Mon, 2003-02-17 at 16:44, Jonathan Pitcher wrote:
> We are getting ready to automate a process that was currently done in
> Excel to a Web page.
>
> This process involves an IRR Calculation. Or Internal Rate of Return.
>
> I have looked at PHP.net and spent the last couple hours searching for
We are getting ready to automate a process that was currently done in
Excel to a Web page.
This process involves an IRR Calculation. Or Internal Rate of Return.
I have looked at PHP.net and spent the last couple hours searching for
a pre-built function to handle this but have come up blank.
Ha
6 matches
Mail list logo
