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

Define current liability, The following items represent liabilities on a fi...

The following items represent liabilities on a firm's balance sheet: a. An amount of money owed to a supplier based on the terms 2/20, n/40, for which no note was executed. b. An a

Finacial management, There are two projects A and B. The initial capital ou...

There are two projects A and B. The initial capital outlay of A and B are Rs.1,35,000 and Rs.2,40,000 respectively. There will be no scrap value at the end of the life of both the

the current stock price of great pumpkins farms, Great Pumpkin Farms just ...

Great Pumpkin Farms just paid a dividend of $3.50 on its stock.  The growth rate in dividends is expected to be a constant 5 percent per year indefinitely.  Investors need a 16 per

Accounting information system, REA diagram for (1) PEGASUS PAPER PRODUCTS a...

REA diagram for (1) PEGASUS PAPER PRODUCTS and (2)PIECES BOUTIQUE

FNSD, Example of FNSD Inventory

Example of FNSD Inventory

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

Quantitative performance measure, The managerial performance measure must b...

The managerial performance measure must be quantitative and the manner in which it is to be calculated should be specified. The managerial performance measure must ideally be linke

Ias1 contents of financial statements, IAS 1 contents of financial statemen...

IAS 1 contents of financial statements IAS 1 prescribes the contents of published financial statements. The major reports that are included as part of the published financial sta

Derivatives, On April 10, ABC inc. Enters in a swap contract for 10 years w...

On April 10, ABC inc. Enters in a swap contract for 10 years with a chartered bank to turn a fixed rate on liability of $150 million to floating rate. ABC wants to receive interest

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