Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

If, for example, you wanted to calculate your returns after taxes, you could input the amount of taxes due in the table as a negative number to recalculate an after-tax return.

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier. You may be investing through SIP or making lump sum investments ...