This is the question, Based on the above answers give an elaborate and descriptive answer on whether the company should take the project and discuss why?

Belgravia Petroleum Inc. is trying to evaluate a generation project with the following cash flows: - 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) Payback Period, discounted payback period, Internal Rate of Return and Net Present Value. Initial investment value is the negative cash flow in year zero Present Value (PV)of cash flow =( Cash Flow )/((1+i)N) i= discount rate = required rate of return =12%=0.12 N= Year of Cash Flow Net Present Value (NPV)=Sum of PV Internal Rate of Return = Rate of Return at which NPV=Zero Internal Rate of Return is calculated using IRR function of Excel Payback period=Period at which Initial investment is recovered=Period at which cumulative cash flow=NIL Modified IRR-Reinvestment Approach Modified IRR=19.27\% In this approach all positive and negative cash flows (except the first one) are compounded to the terminal year Payback Period =4.33 YEARS Discounted Payback period =7.47 YEARS INTERNAL RATE OF RETURN 13.42% NET PRESENT VALUE $15,284,770 MIRR- discounted approach=19.15\% MIRR-Reinvestment approach=19.27\% - Based on your analysis, should the company take the project? Why