Please Fill out this question in an excel table please including the formulas as to how you derived at that equation. Using this information and Table 2.

Assume that inflation is expected to average 8% over the next 4 years and that this expectation is reflected in the WACC. Moreover, inflation is expected to increase revenues and variable costs by this same 8%. Does it appear that inflation has been dealt with properly in the initial analysis to this point? If not, what should be done and how would the required adjustment affect the decision?

Table 2: