YearCashflow0-$380,000,000.001$79,000,000.002$82,000,000.003$53,000,000.004$175,000,000.005$195,000,000.006$40,000,000.007$188,000,000.008$71,000,000.00

t Agape Mining Inc. is evaluating a project with the following ,see table above

Construct a spreadsheet and calculate the following (the required rate of return is 11%): o Payback period o Discounted payback period o Internal rate of return (IRR) o Modified IRR The discounting approach The reinvestment approach The combination approach o Net present value (NPV) - Based on your analysis, should the company take the project? Why?