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

Assume the debt financing would cost 15 percent, Seattle Health Plans curre...

Seattle Health Plans currently uses zero debt financing.  Its operating income (EBIT) $1 million, and it pays taxes at a 40 percent rate.  It has $5 million in assests and because

Credit control, Once credit has been extended it is vital to ensure that cu...

Once credit has been extended it is vital to ensure that customers abide by agreed terms of trade. Regular checks on customer accounts for instance using an aged receivables analys

Need help completing self assessment return, I am an AAT student studying l...

I am an AAT student studying lvl 3 AAT at college. I wish to learn how to complete self assessment end of year tax return forms for other people. That is because I have already bee

Control deficiency, Significant Deficiency -Control deficiency or combinat...

Significant Deficiency -Control deficiency or combination of control deficiencies, which adversely affects company's ability to authorize, initiate, process, record or report exte

American institute of certified public accountants, American Institute of C...

American Institute of Certified Public Accountants (AICPA) - National professionalmembership organization which represents practicing CERTIFIED PUBLIC ACCOUNTANTS(CPAs). AICPA esta

Great adventures problem 5-1, Tony and Suzie are ready to expand Great Adve...

Tony and Suzie are ready to expand Great Adventures even further in 2019. Tony believes that many groups in the community (for example, Boy Scouts, church groups, civic groups, and

Managing organisations with multiple objectives, The difficulties associate...

The difficulties associated with managing organisations with multiple objectives To the level that an organisation faces a range of stakeholders then they also face multiple ob

Determine mutually exclusive projects - profitability index, 1. What is the...

1. What is the internal rate of return for a project that has a net investment of $150,000 and net cash flows of $40,000 for 5 years? 2. Using the profitability index, which of

Depreciation, what are methods of calculating depreciation?

what are methods of calculating depreciation?

Rules of intestacy-leaves several wives, Rules of intestacy:leaves several ...

Rules of intestacy:leaves several wives The intestate leaves several wives, married under any system of law which permits polygamy. His personal and household effects and the r

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