subject
Business, 24.12.2019 17:31 danielzgame

Jennifer just had her 4th birthday and her parents have decided to save money to pay for her college education. they will invest $27,000 right now, and $10,000 each year on her future birthdays for the next 13 years (i. e. $10,000 when she turns 5, 6, 7, … 16, 17). they are bullish on america and have a 70% stock / 30% bond asset allocation strategy. (i. e. 70% of each investment is in a tax exempt stock fund and 30% is in a tax exempt bond fund.) the principal and returns of each fund are allowed to accumulate (i. e. are reinvested) in the same fund and no redistribution will be done before jennifer starts college. assume that the returns of each fund are normally distributed and are independent of each other and past years. see the table; required - jennifer is planning to go to college starting on her 18th birthday; hence it is important for the parents to know how much money will have accumulated in her college fund at that time (call this the accumulation of the college fund).

allocation mean standard deviation
stock fund 70% 8% 10%
bond fund 30% 4% 4%
jennifer is planning to go to college starting on her 18th birthday; hence it is important for the parents to know how much money will have accumulated in her college fund at that time (call this the accumulation of the college fund). construct a monte-carlo simulation model in excel or crystal ball (excel add-on) to model the problem. run the simulation for at least 1,000 trials to answer the following questions:

a. what is the mean and the standard deviation of the accumulation?

b. what is the probability that the accumulation is over $240,000? over $270,000? over $300,000?

c. what is the accumulation if the standard deviations are both zero. (fixed return)

d. can you compute a 95% confidence interval estimate of accumulation? if so, what is it? if not, why not?

e. can this problem be solved without using simulation? if so, how?

ansver
Answers: 2

Other questions on the subject: Business

image
Business, 21.06.2019 23:30, rbriezz
The uno company was formed on january 2, year 1, to sell a single product. over a 2-year period, uno’s acquisition costs have increased steadily. physical quantities held in inventory were equal to 3 months’ sales at december 31, year 1, and zero at december 31, year 2. assuming the periodic inventory system, the inventory cost method which reports the highest amount for each of the following is inventory december 31, year 1/ cost of sales year 2 a: lifo fifo b: lifo lifo c: fifo fifo d: fifo lifo
Answers: 3
image
Business, 22.06.2019 11:30, glowbaby123
Consider derek's budget information: materials to be used totals $64,750; direct labor totals $198,400; factory overhead totals $394,800; work in process inventory january 1, $189,100; and work in progress inventory on december 31, $197,600. what is the budgeted cost of goods manufactured for the year? a. $1,044,650 b. $649,450 c. $657,950 d. $197,600
Answers: 3
image
Business, 22.06.2019 12:50, iamhayls
In june 2009, at the trough of the great recession, the bureau of labor statistics announced that of all adult americans, 140,196,000 were employed, 14,729,000 were unemployed and 80,729,000 were not in the labor force. use this information to calculate: a. the adult population b. the labor force c. the labor-force participation rate d. the unemployment rate
Answers: 3
image
Business, 22.06.2019 20:20, saurav76
Faldo corp sells on terms that allow customers 45 days to pay for merchandise. its sales last year were $325,000, and its year-end receivables were $60,000. if its dso is less than the 45-day credit period, then customers are paying on time. otherwise, they are paying late. by how much are customers paying early or late? base your answer on this equation: dso - credit period = days early or late, and use a 365-day year when calculating the dso. a positive answer indicates late payments, while a negative answer indicates early payments. a. 21.27b. 22.38c. 23.50d. 24.68e. 25.91b
Answers: 2
You know the right answer?
Jennifer just had her 4th birthday and her parents have decided to save money to pay for her college...

Questions in other subjects: