Plot the value of each strategy over time

Reference no: EM13187585

The file investing for college.xlsx contains 261 monthly returns of the S&P 500 and Treasury bills from January 1970 through September 1991. (If you can find more recent data on the Web, feel free to use it.) Suppose that in each of the next 72 months (six years), it is equally likely that any of the historical returns will occur. Develop a spreadsheet model to simulate the two suggested investment strategies over the six-year period. Plot the value of each strategy over time for a single interaction of the simulation. What is the total value of each strategy after six years? Do either of the strategies reach the target?

Reference no: EM13187585

Questions Cloud

What are the names of other firms in the industry : a firm that you have done business with recently. What industry does this firm belong to For example, McDonald's is a firm in the fast food industry. What market structure would this industry fall under What are the names of other firms in this in..

State how many grams of acetic acid will you need to prepare : How many grams of acetic acid will you need to prepare the 500 mL buffer? Note that the given concentration of acetate refers to the concentration of all acetate species in solution.

What is the size of the welfare loss triangle : the equation of the supply curve is Ps=1+0.1*Qs and the equation for the demand curve is Pd=6-0.15*Qd. This results in an equilibrium price (Pe) of 3. This figure shows a regulated price (Pr) of 2, which results in the welfare loss triangle b + d,..

Which of the two strategies would you recommend : Simulate 1000 interactions of the two strategies over the six-year period. Create a histogram of the final fund values. Based on your simulation results, which of the two strategies would you recommend? Why?

Plot the value of each strategy over time : Plot the value of each strategy over time for a single interaction of the simulation. What is the total value of each strategy after six years? Do either of the strategies reach the target?

Compute number of moles of anhydrous compound recovered : calculate number of moles of anhydrous compound recovered. c- calculate number of moles of water lost from the hydrated compound.d- what is the formula of the hydrate?

What is the need to supply this power plant : Assume that an electric power plant could be built in the Upper Peninsula using wood as the fuel and would produce 621 megawatts of electricity. Assume that it would have an efficiency of converting wood energy into electricity of 0.29. Let's assu..

State mercury chlorate is allowed to react completely : If a solution containing 30.87 g of mercury(II) chlorate is allowed to react completely with a solution containing 5.102 g of sodium sulfide,

Find the speed of the plane in still air : a plane flies 435 miles with the wind and 375 against the wind in the same length of time. if the speed of the wind is 10 mph. find the speed of the plane in still air?

User Account

All Pages