IRR Analysis Excel Model: Years Invested vs. Return Multiple

Excel template for constructing an IRR analysis to manage rate of return for each investment.

investmentirr analysisreturn multiplevc

IRR Analysis Excel template that allows users to visualize their investments and prospective returns.

Entrepreneurs often don’t know what their investment opportunity means on a return basis to angels or VCs. VC’s often shoot for a 30%+ IRR (4x return) as a minimum for their portfolio over a 5 year period, and often seek a higher IRR on each individual investment (knowing some dilution will occur with future capital raises). See the chart above – IRR Analysis: Years Invested vs. Return Multiple. If you’d like to download this chart as an excel file and play with it, please do so.

- J. Skyler Fernandes

This business tool includes
1 Excel Template

J. Skyler Fernandes offers you this business tool for free!

Download for free

Ask a question


  • No review yet!

Any questions on IRR Analysis Excel Model: Years Invested Vs. Return Multiple?

The user community and author are here to help. Go ahead!

please wait...