Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

generate a 40 year simulation and modify the simulation to add 1000 to the balance each year. please show how to do this in sheets.

image text in transcribed

image text in transcribed

generate a 40 year simulation and modify the simulation to add 1000 to the balance each year. please show how to do this in sheets. thank you!

fx Stock Market B 1 K M 2 3 A Stock Market Mean Return Standard Deviation Beginning Balance 11.88 19.76 $10,000.00 4 5 S&P Stock Market Index Historical Returns (1926-2018) 25 20 Max Min Mean 8 9 $1,323 719 43 $39,887 33 $289,721 15 15 10 10 D E Year Random Return Balance 1 11 106 $11,110 57 2 18 759 $13,194 81 3 40.183 $18,496.92 4 28.466 $23,762 31 5 29.006 $30,654 71 6 6.464 10 0.000 $28,673 28 7 12.520 $32.263.22 04.2004 8 23.355 $39,798.40 9 11.074 1,200.00 $14.205.84 10 1 13.841 $50,324,50 11 5.761 BO $53,223.86 12 36 245 $72,514.73 13 25 333 $90,885.03 14 10.049 DIO.DOD $100 018,51 15 19.880 $119.902.63 16 15 14 145 $136,863.99 17 $140,654 02 18 2904 $144,738 46 19 60.297 $232,010.98 20 5.495 $244.750.57 H Ending Balances $1,323,71943 $67,608.09 $607,928.90 539,887 33 53 $167.140.83 569,435.87 $964,247.61 $71,537 06 5715975 $769,604.00 $250,918 02 $634 444 99 36. $742,940.89 $87,553.18 $102,598 89 5213,74258 $158.408.84 S147,744 30 $315,845.90 $116,279 57 $156,850.30 11 5 12 2 0.795865901 33 45.00 35.00 25.00-15.00 5.00 5.00 15.00 25.00 35.00 45.00 55.00 14 Annual Return 15 16 17 18 Go 2.769 19 20 21 100% View only - x Stock Market A B C D E F G H M 12 2 0.795865901 11 12 13 0 45.00 35.00 25.00 15.00 5.00 5.00 15.00 25.00 3500 45.00 55.00 14 13 15 Annual Return (2) 16 17 18 Go 19 20 21 14 15 16 17 18 19 20 21 22 23 24 25 5.761 553 223 86 35 245 S72,514.73 25.333 $90 885 03 10 049 $100,018.51 19.880 $119,902 63 14 146 $136,863.99 2.769 $140,554 02 2.904 $144,738.46 60.297 $232,010.98 5.495 $244.760.57 22.09 32.032 $323,162.45 17 123 $378,498 85 9.716 $115,275.37 14.045 31.375 $622, 191.59 27 182 $791,313.81 12.699 $891 805 45 -3.715 $858,672.60 9 169 $779,944.44 18.339 51 156,959.96 $634.444.99 $742,940 89 $87.553.18 $102,598.89 $213.742 58 $158.408.84 $147,744.30 $315 845 90 $116 279,57 $155,850:30 $108,153.68 $121 740 57 $148,237.96 $112, 126.30 $67,827:23 $293 188 96 $88,819.62 $174.950.49 $138,298.99 $129,344.00 23 24 25 26 $473,600 86 29 26 27 28 29 30 fx Stock Market B 1 K M 2 3 A Stock Market Mean Return Standard Deviation Beginning Balance 11.88 19.76 $10,000.00 4 5 S&P Stock Market Index Historical Returns (1926-2018) 25 20 Max Min Mean 8 9 $1,323 719 43 $39,887 33 $289,721 15 15 10 10 D E Year Random Return Balance 1 11 106 $11,110 57 2 18 759 $13,194 81 3 40.183 $18,496.92 4 28.466 $23,762 31 5 29.006 $30,654 71 6 6.464 10 0.000 $28,673 28 7 12.520 $32.263.22 04.2004 8 23.355 $39,798.40 9 11.074 1,200.00 $14.205.84 10 1 13.841 $50,324,50 11 5.761 BO $53,223.86 12 36 245 $72,514.73 13 25 333 $90,885.03 14 10.049 DIO.DOD $100 018,51 15 19.880 $119.902.63 16 15 14 145 $136,863.99 17 $140,654 02 18 2904 $144,738 46 19 60.297 $232,010.98 20 5.495 $244.750.57 H Ending Balances $1,323,71943 $67,608.09 $607,928.90 539,887 33 53 $167.140.83 569,435.87 $964,247.61 $71,537 06 5715975 $769,604.00 $250,918 02 $634 444 99 36. $742,940.89 $87,553.18 $102,598 89 5213,74258 $158.408.84 S147,744 30 $315,845.90 $116,279 57 $156,850.30 11 5 12 2 0.795865901 33 45.00 35.00 25.00-15.00 5.00 5.00 15.00 25.00 35.00 45.00 55.00 14 Annual Return 15 16 17 18 Go 2.769 19 20 21 100% View only - x Stock Market A B C D E F G H M 12 2 0.795865901 11 12 13 0 45.00 35.00 25.00 15.00 5.00 5.00 15.00 25.00 3500 45.00 55.00 14 13 15 Annual Return (2) 16 17 18 Go 19 20 21 14 15 16 17 18 19 20 21 22 23 24 25 5.761 553 223 86 35 245 S72,514.73 25.333 $90 885 03 10 049 $100,018.51 19.880 $119,902 63 14 146 $136,863.99 2.769 $140,554 02 2.904 $144,738.46 60.297 $232,010.98 5.495 $244.760.57 22.09 32.032 $323,162.45 17 123 $378,498 85 9.716 $115,275.37 14.045 31.375 $622, 191.59 27 182 $791,313.81 12.699 $891 805 45 -3.715 $858,672.60 9 169 $779,944.44 18.339 51 156,959.96 $634.444.99 $742,940 89 $87.553.18 $102,598.89 $213.742 58 $158.408.84 $147,744.30 $315 845 90 $116 279,57 $155,850:30 $108,153.68 $121 740 57 $148,237.96 $112, 126.30 $67,827:23 $293 188 96 $88,819.62 $174.950.49 $138,298.99 $129,344.00 23 24 25 26 $473,600 86 29 26 27 28 29 30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Futures Markets

Authors: Robert Kolb, James Overdahl

6th Edition

1405134038, 9781405134033

More Books

Students also viewed these Finance questions