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

Cumulative and substitutional legacies and devises, Cumulative and substitu...

Cumulative and substitutional legacies and devises Where a will makes two gifts of unequal amounts to the same person, they are assumed, in the absence of a contrary indication

Financial accounting theory, accountability through conceptual framework in...

accountability through conceptual framework in australia eassy on this topic with research

Calculate a volatility smile, I am taking  finance class. Our books is John...

I am taking  finance class. Our books is John C. Hull 2nd edition Risk Management and Financial Institutions.  Our HW  are from this book. I have four questions I need help with.

Distribution of assets-liquidation of companies, Distribution of Assets 1...

Distribution of Assets 1. Proof of debts : If the company is insolvent, the rules in bankruptcy as to provable debts, secured creditors, interests, mutual dealings, annuiti

What factors in preview company''s control environment, WILL SOMEONE PLEASE...

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

Major qualitative characteristics of accounting information, Four major qua...

Four major qualitative characteristics of accounting information There are four major qualitative characteristics which influence usefulness of accounting information. Additio

Discuss the advantages, Discuss the advantages and disadvantages of differe...

Discuss the advantages and disadvantages of different types of financing: 1. Issuing bonds 2. Borrowing from Bank 3. Equity financing

Accounting equation, Prove that accounting equation is satisfied in all the...

Prove that accounting equation is satisfied in all the following transactions of Mr.X 1.    Commenced business with cash - Rs.80,000                                    2.    Pu

Various types of accounting changes can affect the financial, Various types...

Various types of accounting changes can affect the financial statements of a business enterprise differently. Assume that the following list describes changes that have a material

Report on financial statements, At one time, Circle K was the second-larges...

At one time, Circle K was the second-largest convenience store chain in the United States. At its peak, Circle K operated 4,685 stores in 32 states. Circle K's rapid expansion was

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