Modified IRR

The discounting approach

The reinvestment approach

The combination approach

Use MS Excel functions $($PV$,$ FV$,$ NPV$,$ and IRR$)$ in your spreadsheet.

Show us the workings in Excel, there are $15$ answers on this questions, none of them done in Excel.