Collection of bonds to maximize the annual return

Assignment Help Operation Management
Reference no: EM131126828

A trust officer at the BN bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total annual return should be tax free. a.Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. c.What the optimal solution?

Reference no: EM131126828

Questions Cloud

Some of the ethical issues that arise : What are some of the unethical issues that may arise from a firm's procurement activities? Are you aware of any of these issues from your personal experience or businesses you are familiar with?
What was turning point that ultimately led american colonist : What was the turning point that ultimately led the American colonists to sever their ties and bonds to the British North American Empire?
Discuss where access to abortion is easier : Based on the world map below, discuss where access to abortion is easier? Where is it more difficult? Discuss why abortion laws are stricter in certain nations. (Please define the terms used in your discussion). Be sure to write two to three paragrap..
What is lacking compared to a single : The Very Large Array is a radio interferometer observatory in New Mexico with twenty-seven 25-meter telescopes. What is lacking compared to a single 36-kilometer dish
Collection of bonds to maximize the annual return : A trust officer at the BN bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0%..
What power is consumed by the motor : Given the voltage source is 120 V, the wire resistance R1 is 0.400 omegacap.gif, and the bulb is nominally 70.0 W, what power will the bulb dissipate if a total of 32.0 A passes through the wires when the motor comes on? Assume negligible change i..
Is marketing ethics an oxymoron : Marketing is integral to product sales in the U.S. What is marketing? Define "Marketing" and explain its function in the U.S. Further explain the concept of "Caveat Emptor." What are the public interest concerns detailed by Philip Kotler in his essay..
How did colonists ideas about government differ : How did colonists' ideas about government differ from those of the British in the 1760s? This is a short essay paper. Set your margins at one inch all around.
A couple seeking to buy a home decides : A couple seeking to buy a home decides that a monthly payment of $800 fits their budget. Their bank's interest rate is 7.5%. The amount they can borrow, A, is a function of the time t, in years, it will take to repay the debt. If we denote this fu..

Reviews

Write a Review

Operation Management Questions & Answers

  Diversification into international markets

How would you describe Wal-Mart’s international strategy leading up to its acquisition of Massmart in Africa? What has Wal-Mart learned from its experiences in Germany, Japan, and South Korea? What grade would you give Wal-Mart for its performance to..

  What is a cost-benefit analysis

What is a cost-benefit analysis? What are the advantages and disadvantages? Should it be a required step in the regulatory process?

  What are some examples of behavior controls

What are some examples of behavior controls? Output controls? Input controls? Is benchmarking just another fad or is it really useful for all firms? Why?

  Organizations tend to more ethical than decentralized ones

Why do centralized organizations tend to be more ethical than decentralized ones? Can you think of a situation or example in which a decentralized organization might be more ethical than a centralized one?

  Contains only safe assets and pays certain gross return

A bank can invest in 2 portfolios. Each requires $100 million to be raised either through debt or equity. One portfolio contains only safe assets and pays a certain gross return of $118 million. Which portfolio makes the most sense from society's sta..

  Impact on other human resource management practices

According to the Chapters 1 and 2, staffing has an impact on other human resource management practices. Based on the reading, discuss the functional areas of human resource management and how staffing impacts each area.

  Main contribution to the fundamentals of organizing

What was Graicunas' main contribution to the fundamentals of organizing? The central concern of span of management is to: One of Henri Fayol's guidelines for organizing resources is to avoid red tape, regulations, and paperwork. After a manager has d..

  Business intelligence

Business Intelligence'? Can some people view business concepts better then others and make 'better' business decisions then others

  What can hr managers do to help facilitate flexible work

what can HR managers do to help facilitate flexible work schedules in their organizations?

  Identify the domain of the relation

Determine each of the following based on the relation {(-5, -3), (-2, 1), (2, 2), (-5, 8)}. 1. Is the relation {(-5, -3), (-2, 1), (2, 2), (-5, 8)} a function? 2. Identify the domain of the relation {(-5, -3), (-2, 1), (2, 2), (-5, 8)}.

  Out patients of a large urban health care facility

You are the manager of a department that provides hands on service to both inpatient and out patients of a large urban health care facility. One of your employees, a senior therapist named William, has been taking an increasing amount of your time an..

  Maximum number of advertisements per media type

Westport sponsors an annual fundraising drive to support its police department. Westport has budgeted $5,000 for advertising. Audience reached per advertisement, the cost of each advertisement and the maximum number of advertisements per media type a..

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