Answered Essay: A portfolio manager for a bank has $10 million to invest. The securities available for purchase, as well as their respective quality ratings, maturities, and yi

A portfolio manager for a bank has $10 million to invest. The securities available for purchase, as wel as their respective quality ratings, maturities, and yields are shown in the following table: Bond Bond name Type A Municipal 9 Banks Years to After-tax Rating Maturity Yield 4.3% 2.7 2.5 2.2 4.5 15 Agency Government 1 Government 1 Municipal 5 E The bank places the following policy limitations on the portfolio managers actions: 1. Government and agency bonds must total at least $4 million. 2. The average quality of a portfolio cannot exceed 1.4 on the banks quality scale. (A low number on this scale means a high-quailty bond.) 3. The average years to maturity of the portfolio must not exceed 5 years. (a) Write a linear program to maximize after-tax earnings. The optimal solution of the LP should indicate to the portfolio manager how any dollars to invest in each bond. Do not solve your LP yet. Hint: You should have a linear objective function corresponding to the yield of a portfolio and constraints enforcing the policy limitiations (and budget, nonnegativity, etc.). Your initial intuition for two constraints corresponding to the average-related limitations may not seem linear, but these conditions can be modeled as linear inequalities. For example, average quality is total quality divided by the total invested, which is a ratio of linear functions; the corresponding restriction can be made linear using some algebra. (b) Solve your LP from Part a using AMPL. Specifically, write model and data files for the portfolio management linear program obtained in Part a and solve. What bonds should the portfolio manager purchase? from Part a to include this option. What should the portfolio manager do? constraint functions accordingly (c) Suppose that it became possible to borrow up to $1 million at 2.75% after taxes. Modify your LP Hint: introduce a new variable to model how much is borrowed and modify the objective and

A portfolio manager for a bank has $10 million to invest. The securities available for purchase, as well as their respective quality ratings, maturities, and yields are shown in the following table: The bank places the following policy limitations on the portfolio manager’s actions: 1. Government and agency bonds must total at least $4 million. 2. The average quality of a portfolio cannot exceed 1.4 on the bank’s quality scale. (A low number on this scale means a high-quality bond.) 3. The average years to maturity of the portfolio must not exceed 5 years. (a) Write a linear program to maximize after-tax earnings. The optimal solution of the LP should indicate to the portfolio manager how any dollars to invest in each bond. Do not solve your LP yet. (b) Solve your LP from Part a using AMPL. Specifically, write model and data files for the portfolio management linear program obtained in Part a and solve. What bonds should the portfolio manager purchase? (c) Suppose that it became possible to borrow up to $1 million at 2.75% after taxes. Modify your LP from Part a to include this option. What should the portfolio manager do?

Expert Answer

 

Expecting that the goal of the portfolio chief is to expand after-assess income and that the duty rate is 50 percent, what securities would it be a good idea for him to buy? On the off chance that it ended up noticeably conceivable to get up to $1 million at 5.5 percent

before charges, in what capacity should his determination be changed?

Leaving the subject of acquired subsidizes aside for the occasion, the choice factors for this issue are basically the dollar measure of every security to be obtained:

x A = Amount to be put resources into bond An; in a large number of dollars.

xB = Amount to be put resources into bond B; in a large number of dollars.

xC = Amount to be put resources into bond C; in a large number of dollars.

xD = Amount to be put resources into bond D; in a large number of dollars.

xE = Amount to be put resources into bond E; in a large number of dollars.

We should now decide the type of the goal work. Accepting that all securities are obtained at standard (confront esteem) and held to development and that the salary on city bonds is impose excluded, the after-charge profit are given by:

z = 0.043xA + 0.027xB + 0.025xC + 0.022xD + 0.045xE.

Presently let us consider each of the confinements of the issue. The portfolio director has just an aggregate of ten million dollars to contribute, and in this manner:

xA + xB + xC + xD + xE ≤ 10.

Further, of this sum in any event $4 million must be put resources into government and office bonds. Thus,

xB + xC + xD ≥ 4.

The normal nature of the portfolio, which is given by the proportion of the aggregate quality to the aggregate estimation of the portfolio, must not surpass 1.4:

2xA + 2xB + xC + xD + 5xE

——————————————- ≤ 1.4.

xA + xB + xC + xD + xE

Note that the imbalance is not exactly or-break even with to, since a low number on the bank’s quality scale implies an amazing bond. By clearing the denominator and re-masterminding terms, we find that this disparity is unmistakably equal to the straight requirement:

0.6xA + 0.6xB − 0.4xC − 0.4xD + 3.6xE ≤ 0.

The imperative on the normal development of the portfolio is a comparable proportion. The normal development must not surpass five years:

9xA + 15xB + 4xC + 3xD + 2xE

——————————————– ≤ 5,

xA + xB + xC + xD + xE

which is proportional to the straight limitation:

4xA + 10xB − xC − 2xD − 3xE ≤ 0.

Note that the two proportion imperatives are, truth be told, nonlinear limitations, which would require refined computational techniques if incorporated into this frame. In any case, essentially increasing the two sides of every proportion requirement by its denominator (which must be nonnegative since it is the aggregate of nonnegative factors) changes this nonlinear limitation into a basic direct imperative. We can condense our definition in scene shape, as takes after:

xA xB xC xD xE Relation Limits

Money 1 ≤ 10

Governments 1 ≥ 4

Quality 0.6 −0.4 3.6 ≤ 0

Development 4 10 −1 −2 −3 ≤ 0

Objective 0.043 0.027 0.025 0.022 0.045 = z (max)

(Ideal arrangement) 3.36 0 6.48 0.16 0.294

The estimations of the choice factors and the ideal estimation of the target work are again given in the last line of the scene.

Presently consider the extra plausibility of having the capacity to get up to $1 million at 5.5 percent some time recently charges. Basically, we can expand our money supply over ten million by acquiring at an after-charge rate of 2.75 percent. We can characterize another choice variable as takes after:

y = sum obtained in a huge number of dollars.

There is an upper bound on the measure of assets that can be obtained, and henceforth

y ≤ 1.

The money requirement is then altered to mirror that the aggregate sum acquired must be not exactly or equivalent to the money that can be made accessible including getting:

xA + xB + xC + xD + xE ≤ 10 + y.

Presently, since the acquired cash costs 2.75 percent after assessments, the new after-charge profit are:

z = 0.043xA + 0.027xB + 0.025xC + 0.022xD + 0.045xE − 0.0275y.

We abridge the plan when getting is permitted and give the arrangement in scene frame as takes after:

xA xB xC xD xE y Relation Limits

Money 1 −1 ≤ 10

Obtaining 1 ≤ 1

Governments 1 ≥ 4

Quality 0.6 −0.4 3.6 ≤ 0

Development 4 10 −1 −2 −3 ≤ 0

Objective 0.043 0.027 0.025 0.022 0.045 −0.0275 = z (max)

(Ideal arrangement) 3.70 0 7.13 0.18 1 0.296

Buy Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Help Me Write My Essay - Reasons:

Best Online Essay Writing Service

We strive to give our customers the best online essay writing experience. We Make sure essays are submitted on time and all the instructions are followed.

Our Writers are Experienced and Professional

Our essay writing service is founded on professional writers who are on stand by to help you any time.

Free Revision Fo all Essays

Sometimes you may require our writers to add on a point to make your essay as customised as possible, we will give you unlimited times to do this. And we will do it for free.

Timely Essay(s)

We understand the frustrations that comes with late essays and our writers are extra careful to not violate this term. Our support team is always engauging our writers to help you have your essay ahead of time.

Customised Essays &100% Confidential

Our Online writing Service has zero torelance for plagiarised papers. We have plagiarism checking tool that generate plagiarism reports just to make sure you are satisfied.

24/7 Customer Support

Our agents are ready to help you around the clock. Please feel free to reach out and enquire about anything.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

HOW OUR ONLINE ESSAY WRITING SERVICE WORKS

Let us write that nagging essay.

STEP 1

Submit Your Essay/Homework Instructions

By clicking on the "PLACE ORDER" button, tell us your requires. Be precise for an accurate customised essay. You may also upload any reading materials where applicable.

STEP 2

Pick A & Writer

Our ordering form will provide you with a list of writers and their feedbacks. At step 2, its time select a writer. Our online agents are on stand by to help you just in case.

STEP 3

Editing (OUR PART)

At this stage, our editor will go through your essay and make sure your writer did meet all the instructions.

STEP 4

Receive your Paper

After Editing, your paper will be sent to you via email.

× How can I help you?