IRR Analysis Excel Model: Years Invested vs. Return Multiple
Originally published: 04/07/2017 08:42
Last version published: 04/07/2017 08:45
Publication number: ELQ-35924-2
View all versions & Certificate

IRR Analysis Excel Model: Years Invested vs. Return Multiple

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

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 Best Practice includes
1 Excel Template

J. Skyler Fernandes offers you this Best Practice for free!

download for free

Add to bookmarks


4.7 / 5 (47 votes)

please wait...