Barbara Roberts recently received $30,000 as a small inheritance from a distant relative. She wants to invest
Question:
Barbara Roberts recently received $30,000 as a small inheritance from a distant relative. She wants to invest the money so as to earn $900 to buy a notebook computer next year when she enters graduate school one year from now. (Barbara plans to use her inheritance to pay the tuition for her graduate studies.) She wants to create a portfolio using three stocks, whose annual percentage returns are summarized in the following table:
Barbara wants to diversify her potential holdings by investing at least $500, but no more than $20,000, in any one stock. Barbara wants to minimize the total variance (which also involves the covariance between the various pairs of stock) of the portfolio.
a. Formulate and solve a nonlinear programming model to determine how much money Barbara should invest in each stock to meet her financial goals. What is the optimal solution?
b. Will Barbara have enough money to buy a notebook computer nextyear?
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...
Step by Step Answer:
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 1233
8th Edition
Authors: Cliff T. Ragsdale