Please using excell

The initial cost for a project to be invested is assumed to be $ 500,000 and six consecutive years of cash flow. Cash flow for the first year is $ 100,000 and annual cash flows between 2-6 years are increasing at a 20% growth rate. Assume that the interest rate for the project is 11%. 1) Calculate the net present value and the internal rate of return of the project. 2) Considering that the growth rate in annual cash flows can be {10%, 15%, 20%, and 25%}, determine the net present value and internal rate of return. Growth Rate Interest Rate 20,00% 11,00% 2 3 st 5 6 Years Cash Flows 0 1 $-500.000,00 $ 100.000,00 The initial cost for a project to be invested is assumed to be $ 500,000 and six consecutive years of cash flow. Cash flow for the first year is $ 100,000 and annual cash flows between 2-6 years are increasing at a 20% growth rate. Assume that the interest rate for the project is 11%. 1) Calculate the net present value and the internal rate of return of the project. 2) Considering that the growth rate in annual cash flows can be {10%, 15%, 20%, and 25%}, determine the net present value and internal rate of return. Growth Rate Interest Rate 20,00% 11,00% 2 3 st 5 6 Years Cash Flows 0 1 $-500.000,00 $ 100.000,00