Microsoft, Inc. is considering constructing a new state$-$of$-$the$-$art data center to support its growing cloud services and enhance its infrastructure. The project requires an initial investment of $$100$ million for land acquisition, construction, and setup. Microsoft expects the time one cash flow will be $$20$ million, but they are not certain how they will grow after that. Microsoft uses a discount rate of $10\%.$

Using the inputs listed above, modify the timeline so that it responds dynamically to changing the inputs. Limit the max project duration to $10$ years. If a year has no cash flow then the cell should be blank.

Create a Data Table showing how the projected cash flows react to changing the input for the CF in year $1$ and the CF Growth Rate.

Create a Data Table showing how the NPV and IRR react to changing the input for the CF Growth Rate.

Create a Data Table showing a variety of scenarios how the NPV reacts to changing the input for the duration of the project and the CF Growth Rate.