Reviewed by Thomas J. Catalano Fact checked by Vikki Velasquez The discount rate refers to the interest rate used when ...

The future value (FV) represents the worth of a sum of money at a specific point ... this by trying out a compound interest calculator in Excel. FV is one of the core financial functions in ...

The sum of all these discounted cash flows ... Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero. Take our NPV/IRR example.