Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero. Take our NPV/IRR example. We’ve calculated an NPV of $472,169 with an IRR of 57% using a ...

the discount rate, the series of cash flows and the range of dates when the cash flows are received in time. Using Excel can make calculating NPV quick and (relatively) easy.

You have three ways to calculate ... "Price." Click the "Autosum" button and press "Enter" on the keyboard. This will automatically add the cost and markup values using the formula "=SUM(B2:C2 ...

The next time you cover this topic, consider teaching students how to calculate the issue price by using the net present value function (NPV) in Excel. Here’s an example: Suppose a company issues a $1 ...

Trend lines are... How to Do Percent Increases in Excel. Using Excel to track percentage increases can be an... How to Figure the Discount Rate From a Cash Flow Statement How to Figure the ...

Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero. Take our NPV/IRR example. We’ve calculated an NPV of $472,169 with an IRR of 57% using a ...