Michael has decided to invest 40000 in three types of funds, Ask an Expert

Finance

Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return of 8 percent, Fund B has projected an annual return of 10 percent, and Fund C has projected an annual return of 9 percent. He has decided to invest no more than 30 percent of the total amount in Fund B and no more than 40 percent of the total amount in Fund C. (Please show the screenshot of all the work in excel including the constraints)

(A) Formulate a linear programming model that can be used to determine the amount of investments Michael should allocate to each type of fund to maximize the total annual return.

(B) How much should be allocated to each type of fund? What is the total annual return? Provide solver screenshot.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92165212

Have any Question?Write your Review or question?

Related Questions in Financial Management

Questions 1 when can there arise a conflict between

Questions 1. When can there arise a conflict between shareholders and managers goals? How does wealth maximization goal take care of this conflict? 2. A company has just tested the market for a new product. The test indi ...

Assignment for pogo managing government finances -the

Assignment for POGO Managing Government Finances - The assignment questions are drawn from topics that may ask you to integrate the topics covered across the entire course - or certainly link different topics together in ...

Assignment1before the truth in lending act auto dealers

Assignment 1. Before the Truth in Lending Act, auto dealers used to use a trick called add on interest. Suppose you bought a $30,000 car and financed it over 5 years at 6% interest. To calculate your payment, they'd take ...

Nbspassignmentchapter 4 mini-case - samps air long term

Assignment Chapter 4 mini-case - S&S Air long term financial planning Note: data is based on the S&S Air financial statements S&S Air, INC. 2009 Income Statement Sales $30,499,420 Cost of goods sold $22,224,580 Other ...

Please use referencescase home healthbackgroundthe patient

Please use references, Case : Home HealthBACKGROUND The Patient Protection and Affordable Care Act (ACA) requires that physicians (or certain practitioners working with them) who certify beneficiaries as eligible for Med ...

1 a explain what is meant by the term intermediation and

1. a. Explain what is meant by the term intermediation and identify and explain two types of intermediation provided by financial institutions. b. Give an example of a security issued by a financial institution and of a ...

Part ibullrequirement 1 using these two dashboards describe

Part I • Requirement 1: Using these two Dashboards, describe Sales and Cost of Goods Sold (COGS) in a short memo • Requirement 2: Using Tableau, recreate the first Dashboard (Sales by Store). The Summary box is optional. ...

Assignmentdirections answer the following questions on a

Assignment Directions: Answer the following questions on a separate document. Explain how you reached the answer, or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assig ...

Assignment introduction to businessdirections be sure to

ASSIGNMENT : Introduction to Business Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure ...

As we learned about in our lecture there are three types of

As we learned about in our lecture, there are three types of exercise: Aerobic exercises, e.g. running, cycling, walking, and skiing, are performed for longer intervals and require oxygen. Aerobic exercise primarily uses ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert