Chris Gallant, CFA, is a senior manager of interest rate risk for ATB Financial with 10 years of experience in the financial markets. Suzanne is a content marketer, writer, and fact-checker. She holds ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Charlene Rhinehart is a CPA , CFE, chair of ...

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.

The PMT function is an Excel Financial function that returns the periodic payment for an annuity. The formula for the PMT function is PMT(rate,nper,pv, [fv], [type]). The NPV function returns the net ...

Forbes contributors publish independent expert analyses and insights. Bernie Kent, J.D., CPA, PFS covers taxes and investments. This article is more than 3 years old. Time weighted rate of return and ...

Companies may lease assets to optimize financial terms and manage balance sheets. Capital lease interest can be computed using the IRR function in a spreadsheet. Adjust IRR formula for payment ...