Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

3. Select a function from a group (Formulas tab) Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example. =TODAY () Inserts today’s date.

Q. When I’m working in Excel, I sometimes have trouble remembering a formula. Is there an instant crib sheet I can refer to? I know I can look it up in Help , but that’s such a slow process. A. Yes, ...

The discount factor is used by Excel to shed added light on the NPV formula and the impact that discounting can have. Here’s a comparison of the discount rate and the discount factor.