Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Jennifer just had her 4th birthday and her parents have decided to save money to pay for her college education. They will invest $16,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 80% Stock / 20% Bond Asset Allocation strategy. (i.e. 80% of each investment is in a tax exempt Stock Fund and 20% 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;
allocation mean standard deviationstuck fund 80% 8% 10%bond fund 20% 2% 2%
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). 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: What is the mean and the standard deviation of the ACCUMULATION? What is the probability that the ACCUMULATION is over $200,000? over $240,000? over $280,000? What is the ACCUMULATION if the standard deviations are both zero. (Fixed return) Can you compute a 95% confidence interval estimate of ACCUMULATION? If so, what is it? If not, why not? Can this problem be solved without using simulation? If so, how?
volworld communications inc. a large telecommunications company is evaluating the possible acquisition of bulldog
Assume that Froogle, Inc. is a corporation with its principal place of business in California. Mary, a proprietor of a small business in Vermont that specializes in the manufacture and sale of ski equipment to Vermont ski resorts, signs a contract wi..
Determine the continuously compounded rate of interest which is equivalent to 5.00% per year compounded quarterly.
Problem- Analyze And Interpret A Listed Company's Financial Information. It is often assumed by unsophisticated readers of financial statements that the data included isprepared on a purely objective basis
Hayleys theatrial supply in the process of negotiating a line of credit with two local banks. the prime rate is currently 8 percent.
(Annualizing a monthly rate) You credit card statement says which you will be charged 1.05% interest a month on unpaid balances. What is the Effective Annual Rate (EAR) being charged?
Determine how much the FRA is worth and who pays who- the buyer pays the seller or the seller pays the buyer. Should the bank buy or sell the FRA?
chris spear invested 15000 today in a fund that earns 8 compounded annually. to what amount will the investment grow in
There is no way to directly observe the cost of equity as a component of the weighted average cost of capital. Let's discuss two methods that may be used to estimate the cost of equity.
as the prevalence of social media continues to rise consumers are recognizing ways in which social media can direct
What is your estimate of the cost of equity capital for XYZ
while after retirement you can earn 10% on your money. What annual contributes to the retirement fund will allow you to recieve the $12,000 annuity?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd