The formula for calculating savings account interest uses the initial deposit, the annual interest rate and the years of growth. Compound interest earns the account holder more than simple interest ...
IRR measures the rate needed to break even on an investment. Calculate IRR by setting NPV to zero and solving for the discount rate. Use Excel's IRR function by inputting initial cost and cash inflow.