IRR calculation for the given example

[Geeky]

Can anyone please give me the formula and explain how IRR is calculated in below example?

Cost Plans 1: License Cost

 

Cost Plan 2: Resource Plan

Benefit Plan :

System calculated values;

[Sandeep V1]

Hi,

I took the data set you posted on other thread and this is how I calculated on excel. You need to list out cash outflows and cash inflows for each fiscal year and calculate total cash flows as shown below. Apply the IRR formula in the excel with values being the total cashflows for all fiscals. You can see the number is matching with the system. Let me know if this is what you are looking for.

[Geeky]

Thanks Sandeep, Its matching but is there a manual way to show this?

[Geeky]

Also can you please explain what that 655% means in this calculation? Does it mean company is going to get that much profile overall or per year or what does it expectantly mean?

What does 655% indicate?