Help with IRR CAGR

[Benny1]

I am having a little trouble inserting an IRR calc into a spreadsheet.

Column A has the year numbers 1,2,3,4,5

Column B1 shows money going in

Column D1,2,3,4,5, shows the value at the end of the year at an assumed rate of return after fees, etc.

I thought I could do something simple like IRR(-B1,D1) or for year 3 0 IRR(-B1,0,0,D3) but this cannot get anywhere close.

Is there a simple solution to this?

Sorry if the question is too simple. In the past, I have just made a separate sheet to show the data differently so that it can make the calc.

Thanks for any help!

Benny

 

[Benny1]

I am guessing there is no simple solution to this? I will keep researching and post if I find one.

Thanks.