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

Financial Management, QUESTION 4: Spanking Clean (Ltd) operate a number of...

QUESTION 4: Spanking Clean (Ltd) operate a number of car washes and auto valet services. The company has experienced a reasonable trading year. They are deciding whether to pay ou

Hedge and a cash flow hedge, PC Bank has $100,000 in fixed rate loans payin...

PC Bank has $100,000 in fixed rate loans paying an annual interest rate of 10 percent, payable semiannually. PC Bank also has $100,000 in certificates of deposit. Their depositor

Prepare financial statements for non reporting entities, THDS Brewery is pr...

THDS Brewery is priavet limited company(plc) established according to the Ethiopian commercial code.it is engaged in brewery business

U.s savings bonds, Natalie cashes in her U.S savings Bonds and receives % 5...

Natalie cashes in her U.S savings Bonds and receives % 520, which she deposits in her personal bank account. Journalize it

Basic interest rate and maximum interest rate, Suppose a risk neutral agent...

Suppose a risk neutral agent has $100,000 today that he wants to save for one year. Compare the following two savings plans. Bank A offers a standard savings account with 4% p.a

The income statement-financial statement, THE INCOME STATEMENT It shows t...

THE INCOME STATEMENT It shows the financial performance of the company during the given financial period. It discloses the income and expenses and thus the net profit for the per

Application of discharge-discharge of bankrupt, Application of discharge ...

Application of discharge Application may be made at any time after adjudication, but cannot be heard until the conclusion of the public examination. Notice of the hearing must

Antitrust laws, Antitrust Laws - Assignment Help One of the foundations...

Antitrust Laws - Assignment Help One of the foundations of business within the United States is the freedom to compete in the marketplace; however, certain laws have been creat

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