Question $3$ Description:

You are presented with a financial analysis task focusing on three specific stocks: PGR$,$ MSFT$,$ and AMZN.

The objective is to conduct an optimization analysis considering various factors related to these stocks.

You are required to determine the amount invested in each of the three stocks and maximize the total

value of dividend yield, ensuring that the total investment, one$-$year return, and beta volatility meet

certain criteria. Refer to the data table below for your calculations. Your optimization model should

possess the following characteristics:

Investment Determination $($i$.$e$.,$ decision variables$)$:

Calculate the $ amount invested in each stock: PGR$,$ MSFT$,$ and AMZN.

Objective:

Maximize the overall value of dividend yield for the three stocks. The value of dividend yield for

a stock is obtained by multiplying the Dividend Yield by the amount invested in the stock.

Constraints:

The total investment across the three stocks should be equal to $$148,320,000.$

Ensure that the total value of one$-$year return for all three stocks combined is greater than

$$34,066,137\mathrm{.}60.$ The value of one$-$year return for a stock is calculated by multiplying the $1-$year

return by the amount invested in the stock.

The total value of beta volatility for the three stocks combined should be less than

$$119,842,560\mathrm{.}00.$ The value of beta volatility for a stock is calculated by multiplying the Beta by

the amount invested in the stock.

Total amount invested in MSFT should be at most two times more than the amount invested in

AMZN.