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 ...

Company owners can compare pricing strategies with break-even analysis and calculate how many units sold will lead to profitability. They'll have to sell more units to help make up for the lower ...

Your effective tax rate is different from your tax bracket. It’s the percentage of your taxable income you pay in taxes. To calculate your effective tax rate, find your total tax on your income ...

Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero. Take our NPV/IRR ...