Learn how to calculate your effective tax rate using Microsoft Excel, what income tax rates to apply to your earned income, and what tax percentage applies to each span.

Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

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.

Understanding the Excel PMT Function At its core, the PMT function calculates the payment amount for a loan based on a series of constant payments and a fixed interest rate.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.