Use Excel in your rate card formulas to calculate discounts, ... Functions include the RATE() function, which calculates the interest rate, and the PRODUCT() function, ...

Here’s where the RATE function in MS Excel can be useful — it gives the answer in a jiffy. The RATE function has five arguments or fields (Screenshot 1). Nper is the number of periods.

2. Excel’s XIRR function. Excel’s XIRR function calculates a more accurate internal rate of return because it takes into consideration different-size time periods. To use this function, you must ...