Formula required - What is the rate of return : ?

[N SHIVKUMAR]

Formula required - What is the rate of return after 15 years.
Thanking you in advance for the help rendered

 

[Peter Bartholomew]

Have you tried the XIRR function?
The year numbers would need to be turned into date serial numbers and I suspect the final return you quote is out by a factor of 10.

 

[N SHIVKUMAR]

Have you tried the XIRR function?
The year numbers would need to be turned into date serial numbers and I suspect the final return you quote is out by a factor of 10.

Sir, I tried but failed in my attempt

 

[Peter Bartholomew]

Maybe this will help?

 

[N SHIVKUMAR]

Thanx a lot Sir Any logic for (-) ve amount in the year 2035 !

 

[Peter Bartholomew]

Not being an accountant, I do not know what the convention is but one sign represents in-flows of money and the other out-flows.

 

[N SHIVKUMAR]

Not being an accountant, I do not know what the convention is but one sign represents in-flows of money and the other out-flows.

Thanx a lot : The rationale is similar to lending where IRR Rule helps companies /lenders decide whether or not to proceed / extend credit with a project