Find the IRR and use it as the discount rate that causes NPV to equal zero. Alternatively, you can use the What-If analysis tool, a built-in calculator in Excel, to solve for the discount rate ...

That’s a massive 96 percent discount from its normal $1,380 price tag. ... you should be able to take all those numbers in Excel and use them to help you make sound business decisions.