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

Bond Valuation, FV of Bond 20000, CR 0.045, MR 0.059, Remaining payments 32...

FV of Bond 20000, CR 0.045, MR 0.059, Remaining payments 32. Answer

Objectives of time value of money, After going through this section, you mu...

After going through this section, you must be capable to: -          Identify the time value of money; -          Know what gives money its time value; -          Identify

accounting, what organizations are responsible for governing financial rep...

what organizations are responsible for governing financial reporting? what is the role of each organiztion? how have the roles changed in the last 20 years? how might their roles c

Financial ratios, Financial ratios have been categorized in a variety of ma...

Financial ratios have been categorized in a variety of manners. You may determine the subsequent broad bases having been utilized in current literature:  Primacy Criterion: Th

Risk and return - issue of debt, Q. Risk and Return - issue of debt? Ra...

Q. Risk and Return - issue of debt? Raising debt finance will raise the gearing and the financial risk of the company while raising equity finance will lower gearing and financ

Bond''s amortization, On January 1, 2010, Solis Co. issued its 10% bonds in...

On January 1, 2010, Solis Co. issued its 10% bonds in the face amount of $3,000,000, which mature on January 1, 2020. The bonds were issued for $3,405,000 to yield 8%, resulting in

Adjustment entry, 1) A sales discount correctly taken by the charge custome...

1) A sales discount correctly taken by the charge customer was debited to Sales at the time the entry was recorded. This error will cause. A) the net income for the period to be un

Determine the npv and annual savings, Joe has two children, Sydney age 5 a...

Joe has two children, Sydney age 5 and William age 2, that he wants to provide for their education funding.  Currently, tuition is $10,000 per year and tuition inflation is 6%.  Jo

Alternative dispute resolutions, Question 1 a. Contractual liability m...

Question 1 a. Contractual liability may be discharged in certain circumstances. Discuss. b. "An aggrieved party in a breach of contract is entitled to claim for damages"

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