How to find irr in excel using trial-error


How to find IRR in excel using trial-error method?

Cash flows for each year are following:

Y0 = -55

Y1 = -30.62

Y2 = 4.14

Y3 = 6.68

Y4 = 8.74

Y5 = 9.54

Y6: tricky part is after Y5, cash flow growth is 3% indefinitly rate of return = 11%

Request for Solution File

Ask an Expert for Answer!!
Financial Management: How to find irr in excel using trial-error
Reference No:- TGS02813187

Expected delivery within 24 Hours