Problem 2: Simulation Modeling Table A Mean Standard Deviation Table B Model Year 1 Year 2...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 2: Simulation Modeling Table A Mean Standard Deviation Table B Model Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Option 1 2 Option Stocks Investment 12.00% 25.00% Stocks 70% 30% 2 5000 1 2 3 4 5 6 7 8 9 10 Tbills 6.00% 3.00% Tbills 30% 70% Stock Return Tbill Return Total Return Balance Option1 Option 2 Table C: Analysis of Results Option 1 Option 2 Average StDev Min Max Monte Carlo Simulation Tom has $5,000 he would like to invest for his son's first year of college. His son is now 8, so Tom has 10 years before he'll need to use the money. Tom wants to invest the money and any gains, but won't be contributing any additional funds out of pocket. He's exploring the stock market and treasury bills. The returns for stocks and T-bills are normally distributed. Mean and standard deviation of annual returns for each option are shown in Table A. He thinks a mix of these investments will yield the best outcome. He wants to choose between two options shown in Table B. (These are the only options to be explored for this problem.) Build a model to track Tom's returns on this investment over 10 years. (Annual gains should be reinvested, meaning any gains from Year 1 should be added to the investment amount for Year 2). Build a 2-variable Data Table to show 1000 iterations of the model to compare the results of these two options. After completing the data table, use statistical analysis to evaluate the results required in Table C below. Problem 2: Simulation Modeling Table A Mean Standard Deviation Table B Model Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Option 1 2 Option Stocks Investment 12.00% 25.00% Stocks 70% 30% 2 5000 1 2 3 4 5 6 7 8 9 10 Tbills 6.00% 3.00% Tbills 30% 70% Stock Return Tbill Return Total Return Balance Option1 Option 2 Table C: Analysis of Results Option 1 Option 2 Average StDev Min Max Monte Carlo Simulation Tom has $5,000 he would like to invest for his son's first year of college. His son is now 8, so Tom has 10 years before he'll need to use the money. Tom wants to invest the money and any gains, but won't be contributing any additional funds out of pocket. He's exploring the stock market and treasury bills. The returns for stocks and T-bills are normally distributed. Mean and standard deviation of annual returns for each option are shown in Table A. He thinks a mix of these investments will yield the best outcome. He wants to choose between two options shown in Table B. (These are the only options to be explored for this problem.) Build a model to track Tom's returns on this investment over 10 years. (Annual gains should be reinvested, meaning any gains from Year 1 should be added to the investment amount for Year 2). Build a 2-variable Data Table to show 1000 iterations of the model to compare the results of these two options. After completing the data table, use statistical analysis to evaluate the results required in Table C below.
Expert Answer:
Answer rating: 100% (QA)
1 Set up the model equations Stock Return NORMINVRAND 012 025 Tbill Return NORMINVRA... View the full answer
Related Book For
Accounting for Governmental and Nonprofit Entities
ISBN: ?978-0073379609
15th Edition
Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus
Posted Date:
Students also viewed these accounting questions
-
A rather wealthy man decided he would like to arrange for his descendants to be well educated. He would like each child to have $60,000 for his or her education. He plans to set up a perpetual trust...
-
A rather wealthy man decided he would like to arrange for his descendants to be well educated. He would like each child to have $60,000 for his or her education. He plans to set up a perpetual trust...
-
A 60 years old man would like to invest his retirement account funds in different investment opportunities such that after 15 years when he withdraws the funds, he gets maximum profit. Assume that he...
-
Suppose you buy Bond A at time=0. It is a 2-year, risk-free bond with coupon rate of 7% that compounds annually, and it has a face value of $1,000. (3 points) a) At time = 0, suppose you buy Bond A...
-
Intuit provides some of the leading accounting software packages. Information related to its products are found at its website. Address: quickbooks.intuit.com, or go to www.wiley.com/college/weygandt...
-
Suppose country A has a central bank with full credibility, and country B has a central bank with no credibility. How does the credibility of each country affect the speed of adjustment of the...
-
What measures of location are commonly computed for frequencies?
-
Data for the North, South, East and West divisions of McGonigel Company are as follows: a. Determine the missing items, identifying each by the letters (a) through (l). Round whole percents to one...
-
vj An drop of ink, with m = 1.25x10-8 g enters the nozzle region, with a uniform electric field as shown in the figure, with v; = 17 m/s and E = 6.9x10 N/C. The vertical length of the nozzle plates...
-
New Horizons Co. is a high-tech firm whose owner does not have the required management expertise to run the firm. The owner wants to hire a manager with the required expertise. The continued success...
-
1. What impact does a minimum wage increase have on the price of products? 2. What impact does an increase in minimum wages have on unemployment?
-
Suppose you are out by the lake on a sunny day, wearing sunglasses. Each lens of the sunglasses is a polarizer with a vertical transmission axis. The intensity of the (unpolarized) ambient light...
-
The specialty of an athlete on the women's track team is the pole vault. She has a mass of 4 0 kg and her approach speed is 8 m / s . When she is directly above the bar, her speed is 1 . 7 m / s ....
-
Mr. B's local paper is delivered by someone throwing it sideways out their car window so that it always lands in the middle of the driveway. If the car is travelling at 30 km/h and the paper is...
-
A block of mass m slides along a frictionless table at initial speed v0, as shown at right. It then starts sliding along a surface with which it has coefficient of kinetic friction k . After moving a...
-
A car motor starts from rest. After turning through 3 0 0 revolutions it is going at 1 5 revs / sec . How long does it take for the angular speed to rise from 1 5 revs / sec to 3 0 revs / sec if the...
-
Data for Cannot be Reach Trading Company are given below: Revenue Cost of Goods Sold Gross Profit Selling and General Expenses Other Expenses Net Income Revenue Cost of Goods Sold Gross Profit...
-
Find i 0 (t) for t > 0 in the circuit in Fig. 16.72 . 2 + Vo 1 7.5e-2t u(t) V ( +) 4.5[1 u(t)]V 0.5v. 1H
-
Investment Trust Fund. The Albertville City Council decided to pool the investments of its General Fund with Albertville Schools and Richwood Township in an investment pool to be managed by the city....
-
In the current fiscal year, St. George County issued $3,000,000 in general obligation term bonds for 102. The county is required to use any accrued interest or premiums for servicing the debt issue....
-
A local not-for-profit organization that provides shelter for the homeless favors proposed legislation in the state that would facilitate converting an old hotel into a transitional living facility....
-
What do you understand by mechanical and thermal efficiency? A steam plant uses 3 tonne of \(\mathrm{coal} / \mathrm{h}\). The steam is fed to turbine the output of which is \(4 \mathrm{MW}\). The...
-
How much heat is to be added to convert \(4 \mathrm{~kg}\) of water at \(20^{\circ} \mathrm{C}\) in to steam at 8 bar and \(200^{\circ} \mathrm{C}\). Take \(C_{p}\) of superheated steam as \(2.1...
-
Determine the specific volume and density of I kg steam at a pressure of \(7 \times 105 \mathrm{~Pa}\), when the condition of steam is: (i) Wet, having dryness fraction 0.9, (ii) Dry, and (iii)...
Study smarter with the SolutionInn App