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

Communication skills assignment, I have one assignment of this course (dip...

I have one assignment of this course (diploma Financial Planning), can you help me in doing my assignment

Responding to various stakeholder groups, Q. Responding to various stakehol...

Q. Responding to various stakeholder groups? If a company has a solitary objective in terms of maximising profitability then it is only responding to one stakeholder group name

Inventory turnover, During 2014, Victoria’s Fashion had beginning inventory...

During 2014, Victoria’s Fashion had beginning inventory of $480,000, ending inventory of $560,000, and cost of goods sold of $2,200,000. Compute the inventory turnover and days’ in

Calculate the gross profit margin and net profit margin, Assets            ...

Assets                                                       2011                                                                        2010 Non Current Assets

Example of sinking fund factor, How much must you save annually in order to...

How much must you save annually in order to accumulate Rs. 20, 00,000 by the ending of 10 years, whether the saving earns an interest of 12%?             Solution : A = [k/(

Determine the basis of the ultimate cost of the payment, Given information:...

Given information: Offered a $20 million commercial loan priced using a 3month LIBOR index+100bp. After some preliminary research, using a money center bank's swap trading desk

LO9-1, Adger corporation is a service company that measures its output base...

Adger corporation is a service company that measures its output base on the number of customers serviced. The company provided the following fixed and variable cost estimates that

AS-10.., WHAT IS dEPRECIATION?

WHAT IS dEPRECIATION?

Statement of cash flows, I am trying to prepare a statement of cash flows f...

I am trying to prepare a statement of cash flows for my accounting class. My professor didn''t give me a sales price for the equipment that was sold. I have that it originally cost

Red herring, Red Herring -‘Pre-release' PROSPECTUS offering. An announcemen...

Red Herring -‘Pre-release' PROSPECTUS offering. An announcement of a future issuance of SECURITIES, given restricted circulation during waiting period of 20 days or other specified

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