Complete the one-variable data table in cells G2:H7 to calculate the total investor payout for varying percentage rates. The formula has been entered for you in cell H2. It references the original investor payout percentage in cell B9. The substitute values have been entered for you in cells G3:G7.

On theDatatab, in theForecastgroup, click theWhat-If Analysisbutton, and clickData Table...EnterB9in theColumn input cellbox. C 28
Complete the two-variable data table in cells H3:K8. The formula has been entered for you in cell H3.
The substitute values in cells I3:K3 reference the total expenses value in cell E5, and the substitute values in cells H4:H8 reference the original investor percentage in cell B9.

Q&A Education