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

International financial reporting standards and gaap, Alta Velocidad Espera...

Alta Velocidad Esperanza de L'Argentina, Sociedad Anónima (AVE), a high-speed railway operator domiciled in Rio Norte, Argentina, is a Foreign Private Issuer as defined by the U.S.

Calculate the marginal tax-rate and average tax rate, Thomas Crown expects ...

Thomas Crown expects to earn the following stream of annual income for the next four years:- $41,000; $45,000; $38,000 and $50,000. Although he has adopted the ‘Pay Yourself Firs

The partnership deed, The Partnership Deed It is the agreement that reg...

The Partnership Deed It is the agreement that regulates the partner’s actions in undertaking the partnership business. This may or may not have been drawn up.  It usually conta

Fast - slow and non moving analysis, FSN Analysis: In this method inven...

FSN Analysis: In this method inventory items are classified as per the usage/consumption pattern. They are categorizing as: Fast Moving (F) items are stored in huge quant

Objective type question, 1 The entry establishing a $175 petty cash fund wo...

1 The entry establishing a $175 petty cash fund would include a: a) debit to cash for $175 b) credit to Petty cash for $175 c) debit to petty cash for $175 d) debit to miscellaneou

Calculate liquidity and balance sheet, Jaedan Industries has the following ...

Jaedan Industries has the following account balances as of December 31, 2010.  The firm's dividend payout ratio is 25% and the tax rate is 34%.  The firm's stock price on December

Accounting equation, Can anyone here help me in this question ?? Kindly tel...

Can anyone here help me in this question ?? Kindly tell how can we solve it Mr. “A” starts a new business. Before to start the business operation, he has purchased vehicle Rs. 1,

Resulting trusts-trusts laws and accounts, Resulting trusts Resulting t...

Resulting trusts Resulting trusts occur where equity regards the property which is held by a trustee as belonging in equity to the person who transferred it to, or caused it to

Investors advantage from financial intermediation, Q. Investors advantage f...

Q. Investors advantage from financial intermediation? Investors advantage substantially from financial intermediation because: (a) By investing in a market or bank investors

Partnership amalgamation, how to prepare the accounts when goodwill is not ...

how to prepare the accounts when goodwill is not to be maintained in the books

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