Blair&Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $50,000 to invest. B&R's investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a Blue Chip fund. The Internet fund has a projected annual return of 12 percent, and the Blue Chip fund has a projected annual return of 9 percent. The investment advisor requires that at most $35,000 of the client's funds should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 6 per $1,000 invested. The Blue Chip fund has a risk rating of 4 per $1,000 invested. For example, if $10,000 is invested in each of the two investment funds, B&R's risk rating for the portfolio would be 6(10) 1 4(10) 5 100. Finally, B&R developed a questionnaire to measure each client's V risk tolerance. Based on the responses, each client is classified as a conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a maximum risk rating of 240. a. Formulate a linear programming model to find the best investment strategy for this client. b. Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client? What is the annual return for the portfolio? c. Suppose that a second client with $50,000 to invest has been classified as an aggressive investor. B&R recommends that the maximum portfolio risk rating for an aggressive investor is 320. What is the recommended investment portfolio for this aggressive investor? d. Suppose that a third client with $50,000 to invest has been classified as a conservative investor. B&R recommends that the maximum portfolio risk rating for a conservative investor is 160. Develop the recommended investment portfolio for the conservative investor.
Blair&Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $50,000 to invest. B&R's investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a Blue Chip fund. The Internet fund has a projected annual return of 12 percent, and the Blue Chip fund has a projected annual return of 9 percent. The investment advisor requires that at most $35,000 of the client's funds should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 6 per $1,000 invested. The Blue Chip fund has a risk rating of 4 per $1,000 invested. For example, if $10,000 is invested in each of the two investment funds, B&R's risk rating for the portfolio would be 6(10) 1 4(10) 5 100. Finally, B&R developed a questionnaire to measure each client's V risk tolerance. Based on the responses, each client is classified as a conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a maximum risk rating of 240. a. Formulate a linear programming model to find the best investment strategy for this client. b. Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client? What is the annual return for the portfolio? c. Suppose that a second client with $50,000 to invest has been classified as an aggressive investor. B&R recommends that the maximum portfolio risk rating for an aggressive investor is 320. What is the recommended investment portfolio for this aggressive investor? d. Suppose that a third client with $50,000 to invest has been classified as a conservative investor. B&R recommends that the maximum portfolio risk rating for a conservative investor is 160. Develop the recommended investment portfolio for the conservative investor.
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
![A
1 B & R, Inc.
2
3
4
5 Budget ($1,000)
6
Max Risk Rating
7
8
9 Annual Return%
10 Risk Rating per ($1,000)
11 Max Investment ($1,000)
12
Parameters
13
14
15
16 Amount to Invest ($1,000)
17 Max amount in Internet fun
18
19 Total Return ($1,000)
Model
20
21 Total Invested ($1,000)
22 Total Risk Rating
23
24
25
26
27
28
29
30
31
32
33
B
$50.00
240
Internet Fund
Internet Fund
12%
6
35
$35.00
C
Blue Chip Fund
9%
4
Blue Chip Fund
$50.00
240.00
D
E](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F689da776-992e-422f-a8da-b36ae9edc1eb%2Fd8bb554c-5bc8-4705-90a1-2d0a0416ba40%2Fpx9ojl_processed.png&w=3840&q=75)
Transcribed Image Text:A
1 B & R, Inc.
2
3
4
5 Budget ($1,000)
6
Max Risk Rating
7
8
9 Annual Return%
10 Risk Rating per ($1,000)
11 Max Investment ($1,000)
12
Parameters
13
14
15
16 Amount to Invest ($1,000)
17 Max amount in Internet fun
18
19 Total Return ($1,000)
Model
20
21 Total Invested ($1,000)
22 Total Risk Rating
23
24
25
26
27
28
29
30
31
32
33
B
$50.00
240
Internet Fund
Internet Fund
12%
6
35
$35.00
C
Blue Chip Fund
9%
4
Blue Chip Fund
$50.00
240.00
D
E
![Problem 3P
Blair&Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific
risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $50,000 to invest. B&R's
investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a
Blue Chip fund. The Internet fund has a projected annual return of 12 percent, and the Blue Chip fund has a
projected annual return of 9 percent. The investment advisor requires that at most $35,000 of the client's funds
should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The
Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 6 per $1,000 invested.
The Blue Chip fund has a risk rating of 4 per $1,000 invested. For example, if $10,000 is invested in each of the
two investment funds, B&R's risk rating for the portfolio would be 6(10) 1 4(10) 5 100. Finally, B&R developed a
questionnaire to measure each client's V risk tolerance. Based on the responses, each client is classified as a
conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client
as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a
maximum risk rating of 240.
a. Formulate a linear programming model to find the best investment strategy for this client.
b. Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio
for this client? What is the annual return for the portfolio?
c. Suppose that a second client with $50,000 to invest has been classified as an aggressive investor. B&R
recommends that the maximum portfolio risk rating for an aggressive investor is 320. What is the recommended
investment portfolio for this aggressive investor?
d. Suppose that a third client with $50,000 to invest has been classified as a conservative investor. B&R
recommends that the maximum portfolio risk rating for a conservative investor is 160. Develop the recommended
investment portfolio for the conservative investor.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F689da776-992e-422f-a8da-b36ae9edc1eb%2Fd8bb554c-5bc8-4705-90a1-2d0a0416ba40%2F738hfyq_processed.png&w=3840&q=75)
Transcribed Image Text:Problem 3P
Blair&Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific
risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $50,000 to invest. B&R's
investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a
Blue Chip fund. The Internet fund has a projected annual return of 12 percent, and the Blue Chip fund has a
projected annual return of 9 percent. The investment advisor requires that at most $35,000 of the client's funds
should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The
Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 6 per $1,000 invested.
The Blue Chip fund has a risk rating of 4 per $1,000 invested. For example, if $10,000 is invested in each of the
two investment funds, B&R's risk rating for the portfolio would be 6(10) 1 4(10) 5 100. Finally, B&R developed a
questionnaire to measure each client's V risk tolerance. Based on the responses, each client is classified as a
conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client
as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a
maximum risk rating of 240.
a. Formulate a linear programming model to find the best investment strategy for this client.
b. Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio
for this client? What is the annual return for the portfolio?
c. Suppose that a second client with $50,000 to invest has been classified as an aggressive investor. B&R
recommends that the maximum portfolio risk rating for an aggressive investor is 320. What is the recommended
investment portfolio for this aggressive investor?
d. Suppose that a third client with $50,000 to invest has been classified as a conservative investor. B&R
recommends that the maximum portfolio risk rating for a conservative investor is 160. Develop the recommended
investment portfolio for the conservative investor.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: What is a Linear Programming model
VIEWStep 2: a) Formulate a Linear Programming model to find the best investment strategy.
VIEWStep 3: b) Use Excel Solver to suggest an appropriate investment portfolio for a moderate investor.
VIEWStep 4: c) Use Excel Solver to suggest an appropriate investment portfolio for an aggressive investor.
VIEWStep 5: d) Use Excel Solver to suggest an appropriate investment portfolio for a conservative investor.
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 6 steps with 15 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education