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

Safety stock, Safety Stock What must be the level of safety stock? In a...

Safety Stock What must be the level of safety stock? In a simple condition where merely the usage rate is variable and the maximum usage rate can be given, the safety stock nee

Financial ratios, Financial ratios have been categorized in a variety of ma...

Financial ratios have been categorized in a variety of manners. You may determine the subsequent broad bases having been utilized in current literature:  Primacy Criterion: Th

One period rate - equilibrium, Suppose that the one-period rate is 4%. Expl...

Suppose that the one-period rate is 4%. Explain why a two-period rate of 6% cannot be an equilibrium when individuals expect the one-period rate to remain constant.

Trade sources of information, Trade Sources of Information Within for i...

Trade Sources of Information Within for instance the credit card industry it isn't uncommon for information on an individual's credit rating to be shared. In a alike vein withi

Prepare the appropriate entry, LCI Cable Company grants 1.4 million perform...

LCI Cable Company grants 1.4 million performance stock options to key executives at January 1, 2013. The options entitle executives to receive 1.4 million of LCI $1 par common shar

Illustration: holding company with direct share holding, Illustration: Hold...

Illustration: Holding company with direct share holding Rain Ltd., Storm Ltd. and Thunder Ltd. are in the business of manufacturing tents. Their balance sheets as at 30 September

Define about sme finance, Q. Define about SME FINANCE? SMEs contribute ...

Q. Define about SME FINANCE? SMEs contribute in a significant way to many economies in the world. Moreover generating income, in often large proportions in relation to GNP acro

AS-10.., WHAT IS dEPRECIATION?

WHAT IS dEPRECIATION?

Cash flow statement, does closing balance of cash flow statement equals to ...

does closing balance of cash flow statement equals to cash in balance sheet

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