Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

How to Calculate Annuities Using Excel. Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off.

Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

Excel can accomplish both using the SLN function to calculate the straight line -- a standard rate of depreciation -- and the DDB function to calculate double declining balance in which ...

Reviewed by Ebony Howard Fact checked by Ryan Eichler Your effective tax rate can be calculated using Microsoft Excel through a few standard functions and an accurate breakdown of your income by ...