Search Born Korigan T Sharc Comments Auraamo ESO HINC 3330 Assignment JA Question 1A (') - Lace Fle H Insert Page Layout Formula Data Review View Developer Hep KE:": Fit 1 From Test: csv De Been Sources Cucties & Connections TIT From Web Inicing Connections LE Betresh Properties Stocks Date - from Tablefarge Currencies Lot Links Geography Get randon Mata Connections DataTypes tech il 4 Clear Reapply Advanced Data Analysis 2. Solver 3 Filter Automat El Consolidate Remove Duplicates Helationships Test he Columns Date Wicion Manage Dale Model Down Tony What Forecast Analys - She Group Ungroup Subtots Tinti Fore! Cutine Anale R19 B E H L M 1 Create 3 data tables in the range (H3:0121 that separately demonstrate the impact on 2 the anticipated periodic distribution (output cell) by changing: 3 (al number of years contributing (1) (1) anticipated interest earned pre-retirement APR (DE) 5 c) number of years withdrawing (D121 * Change A Years Contributing 1 D Retirement Analysis of Projected Distributions INPUT AREA Pre-retirement Current retirement account balance $100,000 Number of years contributing 30 Anticipated interest earned PRE-retirement (APRI 7.50% Periodic contribution amount $400 Contribution frequency (Select 1 for monthly, enter 2 for semi-mority, and 3 for weekly) 0% 096 A Pre-Retirement APR: 7 Use the change method to create the data table (NOT the substitution method). Modify the 3 input cells in column D, changing their contents from a discrete 9 value i.e. 30) to a formula (ie. - 30x (1 change )) 10 Use the three worksheet cells designated in Column Fto hold the charge growth rate). 11 LEAVE THE CHANGE RATE SET TO 0% 12 13 For each data table! 14 * Use percent changes (row inpuls) ol -20% through +20% in increments of 5% 13 In each data table, use custom formatting to provide the row label Anticipated 16 Periodic Distribution for the reference to the output cell of Years Withdrawing $4.114 06 20% 15% 10% 5% 0% ] ($307,472) ($410,424 ($616,329($1,234,045 #NUM! S1 Post-retirement: Number of years withdrawing 25 Anticipated interest Parned post-retirement (APR) 4.50% Distribution frequency 2 (Select i for monthly, enter 2 for semi-monthly; and 3 for weekly) Place the sensitivity diagram here: Slopc Years contribut APR Years withdraw CALCULATIONS AREA Pre-retirement Periodic rate earned Number of periods Total account value at retirement Create a sensitivity diagram near Dell H15) demonstrating all 3 innut variables 19 - add dynamic chart title (link to cell C1), legend (placed at the bottom of the start), 20 and label both axes and all data series. The vertical axis values should have a minimum 21 of $2,000, and the horizontal axis valucs should range from 20% to 20%. $ 0.63% 360 $1,481,132 Which variable 23 Find the impact of each variable (slope on projected periodic distribution (017.019) 24 and identity which variable has the greatest impact on the anticipated periodic 25 distributions (M22). Complete the sentence in cell M29. Past-retirement: Periodic rate earned Number of periods 0.19% 6001 - knowny's ** Known x's al OUTPUT AREA Anticipated periodic distribution lice, payment) Hased on the cl increases, then $4,114 30 31 Do NOT change any of the values in the retirement analysis 32 33 36 1A Ready 10% Type here to search O G 60F Sunny A " 314 PM 11/5/2021 Search Born Korigan T Sharc Comments Auraamo ESO HINC 3330 Assignment JA Question 1A (') - Lace Fle H Insert Page Layout Formula Data Review View Developer Hep KE:": Fit 1 From Test: csv De Been Sources Cucties & Connections TIT From Web Inicing Connections LE Betresh Properties Stocks Date - from Tablefarge Currencies Lot Links Geography Get randon Mata Connections DataTypes tech il 4 Clear Reapply Advanced Data Analysis 2. Solver 3 Filter Automat El Consolidate Remove Duplicates Helationships Test he Columns Date Wicion Manage Dale Model Down Tony What Forecast Analys - She Group Ungroup Subtots Tinti Fore! Cutine Anale R19 B E H L M 1 Create 3 data tables in the range (H3:0121 that separately demonstrate the impact on 2 the anticipated periodic distribution (output cell) by changing: 3 (al number of years contributing (1) (1) anticipated interest earned pre-retirement APR (DE) 5 c) number of years withdrawing (D121 * Change A Years Contributing 1 D Retirement Analysis of Projected Distributions INPUT AREA Pre-retirement Current retirement account balance $100,000 Number of years contributing 30 Anticipated interest earned PRE-retirement (APRI 7.50% Periodic contribution amount $400 Contribution frequency (Select 1 for monthly, enter 2 for semi-mority, and 3 for weekly) 0% 096 A Pre-Retirement APR: 7 Use the change method to create the data table (NOT the substitution method). Modify the 3 input cells in column D, changing their contents from a discrete 9 value i.e. 30) to a formula (ie. - 30x (1 change )) 10 Use the three worksheet cells designated in Column Fto hold the charge growth rate). 11 LEAVE THE CHANGE RATE SET TO 0% 12 13 For each data table! 14 * Use percent changes (row inpuls) ol -20% through +20% in increments of 5% 13 In each data table, use custom formatting to provide the row label Anticipated 16 Periodic Distribution for the reference to the output cell of Years Withdrawing $4.114 06 20% 15% 10% 5% 0% ] ($307,472) ($410,424 ($616,329($1,234,045 #NUM! S1 Post-retirement: Number of years withdrawing 25 Anticipated interest Parned post-retirement (APR) 4.50% Distribution frequency 2 (Select i for monthly, enter 2 for semi-monthly; and 3 for weekly) Place the sensitivity diagram here: Slopc Years contribut APR Years withdraw CALCULATIONS AREA Pre-retirement Periodic rate earned Number of periods Total account value at retirement Create a sensitivity diagram near Dell H15) demonstrating all 3 innut variables 19 - add dynamic chart title (link to cell C1), legend (placed at the bottom of the start), 20 and label both axes and all data series. The vertical axis values should have a minimum 21 of $2,000, and the horizontal axis valucs should range from 20% to 20%. $ 0.63% 360 $1,481,132 Which variable 23 Find the impact of each variable (slope on projected periodic distribution (017.019) 24 and identity which variable has the greatest impact on the anticipated periodic 25 distributions (M22). Complete the sentence in cell M29. Past-retirement: Periodic rate earned Number of periods 0.19% 6001 - knowny's ** Known x's al OUTPUT AREA Anticipated periodic distribution lice, payment) Hased on the cl increases, then $4,114 30 31 Do NOT change any of the values in the retirement analysis 32 33 36 1A Ready 10% Type here to search O G 60F Sunny A " 314 PM 11/5/2021