Estimate the ending balance

Assignment Help Business Management
Reference no: EM133034753

An investor wants to invest $300,000 in a portfolio of three mutual funds. The annual fund returns are normally distributed with a mean of 2.00% and standard deviation of 0.30% for the short-term investment fund, a mean of 5.00% and standard deviation of 2.50% for the intermediate-term fund, and a mean of 6.25% and standard deviation of 5.50% for the long-term fund. An initial plan for the investment allocation is 45% in the short-term fund, 35% in the intermediate-term fund, and 20% in the long-term fund.

a. Use Analysis ToolPak or R, both with a seed of 1, to simulate 100 trials to estimate the mean ending balance after the first year and assess the risk of this investment.

b. If the alocation is changed to 30% short-term, 55% intermediate-term, and 15% long-term, estimate the ending balance after the first year and the risk of the investment.

Reference no: EM133034753

Questions Cloud

Describe the lloyd insurance market : 1. Describe the Lloyd's insurance market. 2. Outline how stock insurance companies use shareholder capital.
Application of roi in the stock valuation : What is your take-away of this part of reading; in particular, what's the building blocks of ROI?
Function of historical correctional system : Compare and contrast at least one function of a historical correctional system with at least one function of a contemporary correctional system.
Determine the balance of allowance for doubtful debts : Using the Aging Method, determine the balance of allowance for doubtful debts as at the end of the year
Estimate the ending balance : If the alocation is changed to 30% short-term, 55% intermediate-term, and 15% long-term, estimate the ending balance after the first year and the risk of the in
Implications for international companies of aging population : What are the implications for international companies of aging populations in many developed countries?
Accordance with trade usage : Discuss how parties to a commercial contract can avoid the possibility that a court will interpret the contract terms in accordance with trade usage.
Design a smart goal for the organisational change : Select an organisation of your choice. This may be a profit or non-profit organisation such as a supermarket, club or society, education provider or small busin
Differentiate eye sight and natural light : 1. What is the difference between ambient light and task light? 2. Differentiate eye sight and natural light?

Reviews

Write a Review

Business Management Questions & Answers

  Payment stream assuming your required rate of return

Suppose you wish to receive payments of $1589.4 in one year's time, $794.7 in two years' time, and $7947 in three years' time. What is the cost today of the payment stream assuming your required rate of return is 4.50% p.a.?

  Explain the case facts against the laws you have identified

Explain the case facts against the laws you have identified, and then give a conclusion as to what the result should be and which party should win the case.

  What is universal design and multi-modal system

What is Universal design and Multi-modal system? And how does the self driving cars relate or meet the Universal design and Multi-modal design requirement.

  What is the purpose of setting an agenda

Why does a business banker consider the total customer-bank relationship when pricing the loan?

  How could walmart monitor its operation very closely

How does Walmart establish the relationships with suppliers? Do you agree with the Walmart's practices on the supplier relationship? Why? Do you think that Walmart's globalization will work in China? Why?

  Assignment on statistic comparison task

Choose ONE developed country and ONE developing country to compare to Canada.

  What is an example of a grouping

What is an example of a grouping and what are the two characteristics that distinguish these groups from each other?

  Determine the difficulties facing organisation

Determine the difficulties facing organisation and determine the challenges you face in this leadership role

  Research and discuss permanent income hypotheses model

Research and discuss Permanent Income Hypotheses Model (175-200 words) What this economic model tries to accomplish? (175-200 words) Provide a minimum of three (3) references

  Ethical standards and responsibilities of organisations

Discuss with a corperate government theory, should be discussing issues relating to the ethical standards and responsibilities of organisations.

  Pricing structure for the products you are selling

How would you research and decide upon your pricing structure for the products you are selling?

  Write a brief overview of the organization or leader

Write a brief overview of the organization or leader (approx. 1 page) describing what happened that was or is unethical and/or ineffective.

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd