You can calculate this with the RATE function by filling its five fields — Nper (number of periods - 12), Pmt (periodic investment – 5000 with a minus sign), Pv (present value – 0), Fv ...

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

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.