What is the total risk and total return, Financial Accounting

Assignment Help:

Financials Investments, a group of financial advisors and retirement planners, has been requested to provide advice on how to invest $200,000 for one of its clients. The client has stipulated that the money must be put into either stocks fund or a money market fund, and the annual return should be at least $14,000. Other conditions related to risk have also been specified, and the following linear program was developed to help with this investment decision:

Minimize Risk = 12S + 5M

Subject to:

                             S + M = 200,000 (total invest is $200,000)

               0.10S + 0.05M ≥ 14,000 (return must be at least $14,000)

                                    M ≥ 40,000 (at least $40,000 must be in money market)

                                 S, M ≥0

Where

S = dollars invested in stock fund

M = dollars invested in money market fund

1) Solve this problem graphically (As done in the class).

2) Then set it up in Excel and solve it.

3) Email the excel model which has the sum product formula to the instructor.

a)       How much money should be invested in stock fund and in money market fund?

b)       What is the Total Risk?

c)       What is the total return? What rate of return is this?

d)      Would solution change if risk measure for each dollar in the stock fund were 14 instead of 12?

e)       For each additional dollar that is available, how much does the risk change?

f)        Would solution change if the amount that must be invested in the money market fund were changed from $40,000 to $50,000?


Related Discussions:- What is the total risk and total return

Macrs depreciation system, Real estate depreciated under MACRS rules is sub...

Real estate depreciated under MACRS rules is subject to cost recovery using a mid-year convention. Mike converted his personal residence (acquired in 2001) to rental property th

Provisions of the partnership act, Provisions of the Partnership Act In...

Provisions of the Partnership Act In the event of absence of a partnership agreement/deed or in the event of ambiguity therein, the provisions to the partnership Act will apply

Disclaimer-liquidation of companies, Disclaimer The liquidator may disc...

Disclaimer The liquidator may disclaim onerous property consisting of: 1.    Land burdened with onerous covenants; 2.    Stocks and shares; 3.    Unprofitable contracts, or 4.

Explain the theoretical impact on the risk discount rate, Question: A p...

Question: A proprietary life company issues only non-profit guaranteed growth bonds. The company invests only in equities with an expected return of 10% p.a, the risk free rate

Calculate the amount that should be capitalised as property, The following ...

The following costs were incurred in 2010 in the design and construction of a new office building over a nine-month period during 2010: Requirement Calculate the amount

Prepare a direct materials purchases budget, Question: Mosman Ltd produ...

Question: Mosman Ltd produces a single product. The projected sales for the first month of the coming year and the beginning and ending inventory data are as follows:

Maturity risk premiums , Suppose that the real risk-free rate, r*, is 4% an...

Suppose that the real risk-free rate, r*, is 4% and that inflation is usual to be 8% in Year 1, 5% in Year 2, and 4% thereafter. Suppose also that all Treasury securities are highl

Statutory Merger, On January 1, 2013, NewTune Company exchanges 15,000 shar...

On January 1, 2013, NewTune Company exchanges 15,000 shares of its common stock for all of the outstanding shares of On-the-Go, Inc. Each NewTune''s shares has a $4 par value and a

State the types of business organizations, State the types of business orga...

State the types of business organizations There are numerous types of business organizations: Service business-doctors, lawyers, barber shop etc. Merchandising busin

Write Your Message!

Captcha
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