Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals 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 .

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present ...