Colter is considering investing $2,000,000 today in a new factory. The factory will produce it first monthly cash flow of $75,000 eleven months from today. After this initial cash flow, the factory will produce cash flows that grow by 1% each through the final cash flow that will occur three years and one month from today. Three years and one month from today Colter will also salvage the factory for $200,000. What is the net present value of the factory if the cost of capital for the factory is 11% per year?

Please show the formula and use Excel