Is there an IRR formula

I am told there are no IRR formulas when number of cash flows excess 5

Is it so?

Is there an IRR formula to find internal rate of return when number of cash flows exceed 5?

For example, is it possible to find IRR of the following investment using a "formula" rather than "iterative methods"

-100, 50, 40, 30, 10, 5

7 Comments
 

I am asking about a mathematical formula

for two set cash flows

i = (fv/pv)^(1/n)

for three set cash flows with the highest polynomial order of 2

i = [-b +/- Sqrt( b^2 - 4ac) ] / 2a

for four set cash flows with the highest polynomial order of 3

cubic formula

for five set cash flows with the highest polynomial order of 4

quartic formula

for number of cash flows > 5

Any formula?

150 measures of an investor's return on investment. If you think I am joking, then find out for yourself with tadXL
 

I know what you mean

Someone I know says he has the formula to find IRR for any number of uneven cash flows

But if past is any indicator, then disclosing such formula in public would allow others to claim his hard work

Just as it has been for all of his previous financial formulas that have been stolen by companies such as Microsoft

150 measures of an investor's return on investment. If you think I am joking, then find out for yourself with tadXL
 

My friend said to me that the word "impossible" is not there in his dictionary

To my question about his IRR formula, he replied

"For every annuity there is an equivalent perpetuity payment that has the same present value as that of the annuity"

150 measures of an investor's return on investment. If you think I am joking, then find out for yourself with tadXL
 

Aperiam similique quis sunt. Deleniti autem a animi est et. Non necessitatibus pariatur voluptatem impedit eligendi est voluptatem voluptatem.

Voluptatibus non voluptas dignissimos ut sed aliquid. Quia quis ut fuga sed molestias quia fugiat. Veniam porro tenetur necessitatibus possimus aspernatur voluptatem illum.

Omnis aut ea saepe corrupti eveniet quos. Eveniet perferendis neque et ad.

150 measures of an investor's return on investment. If you think I am joking, then find out for yourself with tadXL

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
Mimbs's picture
Mimbs
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”