Belgravia Petroleum Inc. is trying to evaluate a generation project with the following cash flows:$$Year Cashflow $0-$$$300,000,0001$$$63,000,0002$$$85,000,0003-$$$50,000,0004$$$145,000,0005$$$175,000,0006-$$$50,000,0007$$$70,000,0008$$$72,000,000*$

Construct a spreadsheet and calculate the following $($the required rate of return is $12\%)$:$$

$*$ Payback period$*$ Discounted payback period$*$ Internal rate of return $($IRR$)*$ Modified$$IRR$*$ The discounting approach$*$ The reinvestment approach$*$ The combination approach$*$ Net present value $($NPV$)$

$*$ Based on your analysis, should the company take the project? Why?$*$

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