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

For This or a Similar Paper Click Here To Order Now

Instructions
For the Midterm case: All yields or rate terms should be for 1 year.
Using the company WALT DISNEY:
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
Using the 40 data points you have already collected in the mid-term project:
Estimate the 4-quarter moving average for the entire period
Estimate the 4-quarter weighted moving average. Consider the weights 40% (more recent), 30%, 20%, 10%.
Estimate the linear trend line for the entire period of 40 quarters
Estimate the linear trend line for the more recent 20 quarters
Using the information on the four methods above, estimate the forecast for the next quarter;
For each method estimate the MAD = Median Absolute Deviation and indicate which model presents the best fit
Using the best model identified previously, develop a forecast for the next four quarters [show the forecast for each time period]
For this final project, you are required to submit two files, submit here just the spreadsheet:
Identify any cycles or seasonal behavior and explain how they affect the forecasting [answer should be at least one paragraph long and include a graph to illustrate the explanation]
you collected
The expected return on investment
Submit a single spreadsheet with your data and analysis
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.
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

For This or a Similar Paper Click Here To Order Now