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.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

How to Excel at calculating the Internal Rate of Return A blonde wanting to earn some money decided to hire herself out as a handyman-type and started canvassing a wealthy neighbourhood.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

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 .

One simple but powerful method investors can use to assess the risk and reward of a stock portfolio is using the Capital Asset Pricing Model, or CAPM, model for expected returns.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.