Select Page

Step 1. Place your order

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

Step 2. Make Payment

Choose the payment system that suits you most.

Step 3. Receive your paper

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

Instructions For the Midterm case: All yields or rate terms should be for 1 yea

by | Apr 27, 2022 | Business and Management

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Instructions
For the Midterm case: All yields or rate terms should be for 1 year.
Using the Disney Corporation :
find the average net income for the last ten years company
take 5% as the investment amount for your Case
find the Municipal bond rate in the city or state that the company has its home office
find the current best rate on a CD and Treasury Bill.
Complete the linear programming model and solver solution for those amounts, i.e.:
X1 – Percentage of investment in Municipal bonds
X2 – Percentage of investment in Treasury Bills
X3 – Percentage of investment in CD
The return of the investment is the weighted average of all components.
Constraints:
Municipal bonds should make up at least 25% of the investment.
Treasury Bills should be less than 45% of the investment
CD’s should be at least 13% of the investment
You must invest all the amount.
Prepare the Linear programming model to maximize the return and solver solution and upload it here.
Be sure to write a recommendation in the Excel spreadsheet that your management would understand.
Please make sure to inform:
the amount to be invested
The portfolio composition, i.e., how much to invest in each of the three options
The source of the information you collected
The expected return on investment
Submit a single spreadsheet with your data and analysis.

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Treat Yourself to Much Needed Assistance