What is the total risk and total return, Financial Accounting

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?

Posted Date: 3/29/2013 2:34:40 AM | Location : United States







Related Discussions:- What is the total risk and total return, Assignment Help, Ask Question on What is the total risk and total return, Get Answer, Expert's Help, What is the total risk and total return Discussions

Write discussion on What is the total risk and total return
Your posts are moderated
Related Questions
Q. A prior period adjustment that corrects income of a prior period requires that an entry be made to a. an income statement account. b. a current year revenue or expense account.

Conversion of members' to creditors' winding up If the liquidator in a members' winding up forms the opinion that the company will not be able to pay its debts in full within t

Limited Liability Company (LLC) - Form of doing business combining limited liability for all owners (known as members) with taxation as a PARTNERSHIP. An LLC is formed by filing AR

Question : i) Show the interdependence of business strategy and Information Systems in an organization. ii) Distinguish using suitable examples between decision-support syst

I have a case study due in one of my classes. There are 3 pages of information about the company in the case, and there are 12 questions I must complete. Each question is basically

SAMPLES PITCH FOR AN ACCOUNTING ASSIGNMENTS

Potential advantages to BNM Narrative reporting will enable BNM to provide information about social, economic and environmental policies. Many users are influenced by an entit

WILL SOMEONE PLEASE ASSIST ME WITH THIS ASSISGNMENT Preview Company, a diversified manufacturer, has five divisions that operate throughout the United States and Mexico. Preview ha

The Caltor Company gathered the following condensed data for the Year Ended December 31, 2010. Cost of goods sold $ 710,000 Net sales 1,279,000 Administrative expenses 239,000 I

Jim owns and manages a small business, which provides an office design service, as well as buying and selling office furniture. Jim is a sole trader who manages all aspects of the