How Do I find the first sensitivity analysis? The Answer is there, but I do not know how they got that answer. If someone can so me in excel or a easy to read how to would be great.

Teaching Note NWC/Sales 0.2020.1950.1690.1690.1690.1690.1690.1690.1690.169 NPV Analysis IRR Analysis Cash Flows IRR Payback Analysis \begin{tabular}{|rrrrrrrrrrr|} \hline 2010 & 2011 & 2012 & 2013 & 2014 & 2015 & 2016 & 2017 & 2018 & 2019 & 2020 \\ \hline(3,020) & (557) & 169 & 682 & 541 & 583 & 630 & 680 & 735 & 793 & 17,202 \\ 7.6% & & & & & & & & & & \end{tabular} Cash flows Cumulative cash flow Payback period 5-year Cumulative EBITDA \begin{tabular}{|rrrrrrrrrrrr} \hline 2010 & 2011 & 2012 & 2013 & 2014 & 2015 & 2016 & 2017 & 2018 & 2019 & 2020 \\ \hline(3,020) & (557) & 169 & 682 & 541 & 583 & 630 & 680 & 735 & 793 & 17,202 \\ (3,020) & (3,577) & (3,408) & (2,726) & (2,185) & (1,602) & (972) & (291) & 443 & & \\ & & & & & & & & 7.40 years & \end{tabular} Profitability Index NPV/Initial Investment 1.35 New Heritage Doll Company: Capital Budgeting Teaching Note TN Exhibit 3 NPV Sensitivity Analyses NPV of Match My Doll Clothing Line Extension NPV of Design Your Own Doll Teaching Note NWC/Sales 0.2020.1950.1690.1690.1690.1690.1690.1690.1690.169 NPV Analysis IRR Analysis Cash Flows IRR Payback Analysis \begin{tabular}{|rrrrrrrrrrr|} \hline 2010 & 2011 & 2012 & 2013 & 2014 & 2015 & 2016 & 2017 & 2018 & 2019 & 2020 \\ \hline(3,020) & (557) & 169 & 682 & 541 & 583 & 630 & 680 & 735 & 793 & 17,202 \\ 7.6% & & & & & & & & & & \end{tabular} Cash flows Cumulative cash flow Payback period 5-year Cumulative EBITDA \begin{tabular}{|rrrrrrrrrrrr} \hline 2010 & 2011 & 2012 & 2013 & 2014 & 2015 & 2016 & 2017 & 2018 & 2019 & 2020 \\ \hline(3,020) & (557) & 169 & 682 & 541 & 583 & 630 & 680 & 735 & 793 & 17,202 \\ (3,020) & (3,577) & (3,408) & (2,726) & (2,185) & (1,602) & (972) & (291) & 443 & & \\ & & & & & & & & 7.40 years & \end{tabular} Profitability Index NPV/Initial Investment 1.35 New Heritage Doll Company: Capital Budgeting Teaching Note TN Exhibit 3 NPV Sensitivity Analyses NPV of Match My Doll Clothing Line Extension NPV of Design Your Own Doll