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

Trustees duties in administering the d of a, Trustee's duties in administer...

Trustee's duties in administering the D of A 1) To carry out the trusts of the D of A and to distribute the property assigned to him in accordance with the provisions of the D of

Balance sheet and income statement, 1) The detailed information is on the s...

1) The detailed information is on the second tab marked "Financials". Enter summarized Balance Sheet and Income Statement information for Cummins into the template on the "Summary

Accounting date-trusts accounts-trusts laws and accounts, Accounting Date ...

Accounting Date In determining the accounting date of the trust, the trustees will consider the following: Date of death (accounts to anniversary of death); Fiscal y

Market risk premium, A stock is about to pay a dividend of $2.00. The divid...

A stock is about to pay a dividend of $2.00. The dividend is expected to grow at 15% for the next 7 years, 10% for the following 3 years, 8% for the next 2 years and then return to

Prepare consolidated financial statements, Chambers plc imports household e...

Chambers plc imports household equipment from Germany. On 1 July 2011, the company acquired 60% of the ordinary shares of Court Ltd, which owns a chain of retail shops selling hous

Resolution for voluntary winding up-liquidation of companies, Resolution Fo...

Resolution For Voluntary Winding Up A company may be put into voluntary liquidation: 1) By ordinary resolution: where any period fixed for the duration of the company has ex

Effect of additional debt finance on financial position, Q. Effect of Addit...

Q. Effect of Additional Debt Finance on Financial Position? Debt finance of $3·2m would raise gearing on a book value basis from 54% to 203% ((1167 + 3200)/2150) which is five

Determine the present value of the bonds payable, Mason Co. issued $860,000...

Mason Co. issued $860,000 of 5 year, 13% with interest payable semiannually, at a market (efffective) interest rate of 12% Determine the present value of the bonds payable, using t

Illustration of pre-aquisition, Illustration of Pre-Aquisition H Ltd.. ...

Illustration of Pre-Aquisition H Ltd.. Acquired 80% of S Ltd. during the year ended 31/12/04.  S Ltd. paid an interim dividend of  40,000 on 30th September and as at 31/12/04 h

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