please answer all question using excel with formula shown. Thank you so much

1. Suppose Palmer Properties is considering investing $10 million today (i.e., C0= 10,000,000) on a new project that is expected to last for 10 years. The project is expected to generate annual cash flows of C1=700,000;C2=1,500,000,C3=2,000,000 and then $2,500,000 for period C4 through C10. If the discount rate is 9% and management's payback period cutoff is 6 years: (a) What is the payback period for the project? Show your work (b) What is the net present value of the project? Show your work (c) What is the internal rate of return on the project? Show your work (d) Under which method(s) above should the company accept the project (applying the acceptance rules)? Explain