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?

Answers: 2

Show answers

Other questions on the subject: Business

Business, 21.06.2019 16:00, krissy452

b) a student tests 100 students to determine whether other students on her campus prefer soda brand a or soda brand b and finds no evidence that preference for brand a is not 0.5. later, a marketing company tests all students on campus and finds no difference. choose the correct answer below.

Answers: 1

continue

Business, 21.06.2019 21:30, Jbutler15

The following cost data pertain to the operations of montgomery department stores, inc., for the month of july. corporate legal office salaries $ 75,300apparel department cost of sales"evendale store $ 97,200corporate headquarters building lease $ 50,300store manager's salary"evendale store $ 12,900apparel department sales commission"evendale store $ 11,550store utilities"evendale store $ 12,800apparel department manager's salary"evendale store $ 10,450central warehouse lease cost $ 18,600janitorial costs"evendale store $ 11,800 the evendale store is just one of many stores owned and operated by the company. the apparel department is one of many departments at the evendale store. the central warehouse serves all of the company's stores. required: 1. what is the total amount of the costs listed above that are direct costs of the apparel department? 2. what is the total amount of the costs listed above that are direct costs of the evendale store? 3. what is the total amount of the apparel department's direct costs that are also variable costs with respect to total departmental sales?

Answers: 1

continue

Business, 22.06.2019 01:50, emm3456

Atlas manufacturing produces a unique valve, and has the capacity to produce 50,000 valves annually. currently atlas produces 40,000 valves and is thinking about increasing production to 45,000 valves next year. what is the most likely behavior of total manufacturing costs and unit manufacturing costs given this change? a. total manufacturing costs will increase and unit manufacturing costs will also increase. b. total manufacturing costs will stay the same and unit manufacturing costs will stay the same. c. total manufacturing costs will increase and unit manufacturing costs will decrease. d. total manufacturing costs will increase and unit manufacturing costs will stay the same.

Answers: 1

continue

Business, 22.06.2019 11:10, takaralocklear

An insurance company estimates the probability of an earthquake in the next year to be 0.0015. the average damage done to a house by an earthquake it estimates to be $90,000. if the company offers earthquake insurance for $150, what is company`s expected value of the policy? hint: think, is it profitable for the insurance company or not? will they gain (positive expected value) or lose (negative expected value)? if the expected value is negative, remember to show "-" sign. no "+" sign needed for the positive expected value

Answers: 2

continue

You know the right answer?

Jennifer just had her 4th birthday and her parents have decided to save money to pay for her college...