NPV is essential to corporate budgeting. Excel can find the internal rate of return (IRR) and use that as the discount rate for an NPV of zero.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .