Question: Here is the data. I need to redesign the spreadsheet with random variability of the annual salary growth rate and the annual portfolio growth rate
Here is the data. I need to redesign the spreadsheet with random variability of the annual salary growth rate and the annual portfolio growth rate with 1,000 trials. I need to find the mean and standard deviation of the 20-year result.

Four_Corners Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me 83 Queries & Connections Get Data (Power Data from tes 24 72 Refresh Query) Picture All Stocks Currencies Geography 2 1 Sort 19 fx B C D E F G H Four Corners 3 Age 40 Salary Growth (Uniform Dist.) Current Salary Portfolio Gr $85,000 Lower Bound Current Portfolio Mean $50,000 6 Upper Bound Annual Investment Rate Standard Dev 9.13% 7 Salary Growth Rate 5% Portfolio Growth Rate 10% Year Beginning Balance Salary New Investment Earnings Ending Balance $50,000 Age $85,000 $7,756 $5,388 $63,144 41 N $63,144 $89,250 $8,144 $6,722 $78,010 42 $78,010 $93,713 $8,551 $8,229 $94,790 43 $94,790 $98,398 $8,979 $9,928 $113,697 44 $113,697 $103,318 $9,428 $11,841 $134,966 45 6 $134,966 $108,484 $9,899 $13,992 $158,857 46 $158,857 $113,908 $10,394 $16,405 $185,657 47 $185,657 $119,604 $10,914 $19,111 $215,682 48 $215,682 $125,584 $11,460 $22,141 $249,283 49 10 $249,283 NN $131,863 $12,033 $25,530 $286,846 50 11 $286,846 $138,456 $ 12,634 $29,316 $328,797 $1 12 $328,797 $145,379 $13,266 $33,543 $375,606 52 13 $375,606 $152,648 $13,929 $38,257 $427,792 53 14 $427,792 $160,280 $14,626 $43,511 $485,929 54 $485,929 $168,294 $15,357 $49,361 $550,647 55 16 $550,647 $176,709 $16,125 $55,871 $622,642 56 17 $622,642 $185,544 $16,931 $63,111 $702,685 57 18 $702,685 $ 194,822 $17,778 $71,157 $791,620 58 19 $791,620 $204,563 $18,667 $80,095 $890,382 59 20 $890,382 $214,791 $19,600 $90,018 $1,000,000 60 21 61 22 62 23 63 24 64 25 65 Data + Ready Accessibility: Good to go NOV 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
