Hello,
I have inherited a spreadsheet (pictured attached) that I am trying to check and modify.
I have an IRR calc in Cell C53=(IRR(U4:U365,0.001)+1)^12-1 This formula returns an IRR of 9.4%.
I am not sure I understand what they did here since the IRR formula builder returns a 0.74% IRR with this formula: = IRR (U4:U365)
Can anyone explain?
Thanks
Patrick
I have inherited a spreadsheet (pictured attached) that I am trying to check and modify.
I have an IRR calc in Cell C53=(IRR(U4:U365,0.001)+1)^12-1 This formula returns an IRR of 9.4%.
I am not sure I understand what they did here since the IRR formula builder returns a 0.74% IRR with this formula: = IRR (U4:U365)
Can anyone explain?
Thanks
Patrick