Notes on IRR Calculation:
In order for an internal rate of return (IRR) to be calculated, the cash flow in at least one period studied must be negative. The IRR is the interest rate at which the sum of all net cash flows sums to zero over the given study period. If all of the cash flows are positive, the function never converges in Excel and instead returns the error, "#NUM!", effectively meaning an infinite IRR results.
Example: If the consolidation ratio (the number of virtual servers per physical server) is changed with all other inputs held constant and an initial guess of 1 for the IRR function, we can see that the IRR is calculating for certain cases:
Note that these results were obtained using the default input values:
Start a discussion about ECM - Network server virtualization
Talk pages are where people discuss how to make content on Appropedia the best that it can be. You can use this page to start a discussion with others about how to improve ECM - Network server virtualization.
