The following table should automatically update when any variable is changed, i.e. it should not require any manual input or adjustments when changes are made. Hint: this will require use of the IF function

For example, if your retirement age changes from 65 to 60, then all cash flows should be automatically shifted up to reflect the change.

If you are not in retirement (year is less than or equal to years to retirement) then you are making contributions to your retirement plan and there arent any outflows.

If you are in retirement (year is greater than years to retirement) then you arent saving anymore and instead you are spending.

Here is the sample output:

Here are my numbers: (Please rely on my numbers thanks)

Year Savings (Begin) Annual Savings Annual Outflows Cash Flow Cumulative Step 1: How many years until retirement? \begin{tabular}{|l|l|} \hline Inputs: & Birthday \\ \hline & Retirement Age \\ \hline \end{tabular} \begin{tabular}{|l|r|r|} \hline Output & Age & 46.34 \\ & Retirement Date & 11/12/2041 \\ & Days to retirement & 6,811 \\ \hline & Years to retirement & 19 \\ \hline \end{tabular} Step 2: How much do you anticipate spending each year in retirement? \begin{tabular}{l|l|l} Output Annual budget (FV) & $79,932.51 \\ \hline \end{tabular} Step 3: How much do you need when you retire? Inputs Years in retirement 30.00 Output "Your Number" (PV) $1,166,272.94 Step 4: How much do you need to save each year (month)? Inputs Savings (current) $25,000.00 Output Save annual (PMT) $30,476.87 Save (monthly) $2,556.57 Year Savings (Begin) Annual Savings Annual Outflows Cash Flow Cumulative Step 1: How many years until retirement? \begin{tabular}{|l|l|} \hline Inputs: & Birthday \\ \hline & Retirement Age \\ \hline \end{tabular} \begin{tabular}{|l|r|r|} \hline Output & Age & 46.34 \\ & Retirement Date & 11/12/2041 \\ & Days to retirement & 6,811 \\ \hline & Years to retirement & 19 \\ \hline \end{tabular} Step 2: How much do you anticipate spending each year in retirement? \begin{tabular}{l|l|l} Output Annual budget (FV) & $79,932.51 \\ \hline \end{tabular} Step 3: How much do you need when you retire? Inputs Years in retirement 30.00 Output "Your Number" (PV) $1,166,272.94 Step 4: How much do you need to save each year (month)? Inputs Savings (current) $25,000.00 Output Save annual (PMT) $30,476.87 Save (monthly) $2,556.57