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 ...

If 20 people received one interest rate but just 10 received another, for example, the rate 20 people received gets double "weight" in the calculation. Launch Excel.

The RATE function cannot handle this calculation, but IRR can. Annual investment, same amount The IRR function gives the result (annual return) as 2.92 per cent.