How to use PMT function In Excel
Nov 04, 2020
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.
How to use NPV formula In Excel
Nov 01, 2020
The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment.
How to Use Investment or Annuity In Excel
Oct 31, 2020
This example teaches you how to calculate the future value of an investment or the present value of an annuity.
How to Use Loans with Different Durations In Excel
Oct 31, 2020
This example teaches you how to compare loans with different durations in Excel.
How to Use the IRR function in Excel
Oct 31, 2020
Use the IRR function in Excel to calculate a project's internal rate of return.
How to calculate depreciation in Excel
Oct 30, 2020
Excel offers five different depreciation functions.
How to use Compound interest formula In Excel
Oct 29, 2020
What's compound interest and what's the formula for compound interest in Excel?