Earlier, we had seen how the RATE function can be used to calculate the return on investments, whether lump-sum or periodic. This can come in handy in the calculation of SIP returns, too.

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas.

For that, we'll need to use a special function in Excel. Plugging the data into a spreadsheet, we'll use the XIRR function to calculate the internal rate of return for each project.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.