IRR calculations (1 Viewer)

[g-richardson]

Very new to the IRR function and don't know if I can do what I think I need to do.

Have data something like this:

Prem____TermPrem____TermDropYrs____PremDropYrs____TtlYrs
1000______158__________7______________20__________30
1437______281_________15______________12__________35
2762______267_________14______________20__________50

Want to calculate IRR based on value(0)= [Prem]+[TermPrem] for the period until the [TermDropYrs] at which point the value(1)=[Prem] for the period until the [PremDropYrs] at which point the value(2)=0 for the period until [TtlYrs]

I'm not even sure if there are other values I need for my calculation, but is this concept even possible?

Any direction will (as always) be so much appreciated.

 

[ted.martin]

Have you looked here?

http://office.microsoft.com/en-us/access-help/irr-function-HA001228861.aspx

 

[g-richardson]

Thanks Ted, yes, I had found that instruction. I think my lack of familiarity with the financial world calculation as well as my limited abilities in VBA have restricted me. I can't figure out how to use the value from the PremDropYrs field to pass the change in formula to the IRR calculation.

Thanks again though for the help.