need done in 30 mins and send me a excel
We have $80,000 to invest over a four-month period. The investment options available are two-month government bonds with a 3% return, three-month government bills offering a 6.5% return, and bank deposits with a 1% return per month. We can invest multiple times into these options during the four months, but each individual investment in two-month or three-month bonds is capped at $32,000, whether invested in a single transaction or in multiple transactions. By the beginning of the fifth month, we must have $80,000 readily available for other purposes, and any returns generated during the fourth month cannot be reinvested within the same period. Given these constraints, what is the optimal strategy for investing this money over the four-month period?
Hint: Think about the amount of money available for investment each month. If you have already invested in certain options, you’ll receive your cash + returns only at the end of the investment period. Note that you cannot invest your returns.