Question: Please show me how to run this optimization in excel 1 . 3 Portfolio Analysis Alumni Affairs invests in three different funds to maintain diversity:

Please show me how to run this optimization in excel
1.3 Portfolio Analysis
Alumni Affairs invests in three different funds to maintain diversity: a growth stock fund,
a money market fund and an income fund. Guidelines from the University Board of Directors
require that at least 20% and no more than 40% be invested in the growth fund, at least 20% and
no more than 50% be invested in the income fund and no less than 30% be in the money market
fund.
The University Alumni Endowment has $800,000 to invest and it has assigned the
following risks of losing money to each dollar invested in the funds: 10% for growth; 7% for
income and 1% for money market. The University's risk tolerance is a maximum of 5% on its
portfolio. The Bank of Charles Town Investment Service is forecasting annual yields of 18% for
growth, 12.5% for income and 7.5% for money market. Your task is to create a linear
programming model that will maximize the return for the University subject to the constraints.
1.4 Business Plan
Please show me how to run this optimization in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!