IRR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a series of cash flows I want to query and then calculate
the IRR in a report.

How do you assign the cash flows to the =irr function? Each cash flow is
identified in the table as a field (ie: year 0, year 1, year 2, etc.).

Appreciate any help with this.
 
Hi Dudley,
Do a google search on this, you will find good information.
The method cited is to load the IRR function with array of values. You can
build the array by:

- using GetRows method
- looping through a recordset

You might also want to check with Access help regarding the above options.
I'm sorry I can't be more specific, but this may get you started.


HTH,
Immanuel Sibero
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
IRR the same for very different cash flows 3
IRR, with cash flows in non-adjacent cells 6
Access Access IRR Function on a Form 0
IRR Lookback and Solver 7
IRR showed #NUM! 16
IRR Calculation Frustrations 2
Working with arrays as arguments 6

Back
Top