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.