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 cost of equity in Microsoft Excel using the capital asset pricing model, or CAPM, including brief definitions of each component.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

Net Present Value Formula There are two formulas you might use to calculate net present value. The one that you choose can depend on the number of cash flows the investment has.

The easiest way to calculate the net present value of an investment is using an online NPV calculator. You can also make these calculations in Excel.