Projected 10 or 20 year ROI Calculator

[David VanWert]

Hi All,

Is anyone aware of a calculator or spreadsheet that allows you to plug in an initial investment, a CoC percentage, and IRR to generate an overall projected ROI over a number of years? It would be great to have a calculator that allows an LP to see projected profit over say a 10 year period and adding 1 to 2 more investments per year (and rolling over existing projects) to project passive income over a 10, 15, or 20 year period.

Any help would be appreciated, thanks!