Can someone show me how to do this problem using Excel formulas?

Input area: Year 0 1 2 3 4 5 6 7 8 9 $ $ $ $ $ $ $ $ $ Cash flow (950,000,000) 190,000,000 215,000,000 225,000,000 285,000,000 275,000,000 235,000,000 205,000,000 165,000,000 (75,000,000) Required return 12% Output area: Q1. Construct the following spreadsheet to calculate the payback period, internal rate of return, profitability index, and net present value of the proposed mine. Payback period IRR IRR Profitability index NPV Q2. Based on your analysis, should the company open the mine? Please explain the reason. Ch 5 mini case +