Question: I know it's wrong. help me solve it, very detail thank you THE QUESTION ITS COMPLETE, DATA ABOVE ^USE THAT! A part time student would
I know it's wrong. help me solve it, very detail thank you


THE QUESTION ITS COMPLETE, DATA ABOVE ^USE THAT!
A part time student would like to optimize his financial decisions. Currently, he has $16,500 in his savings account. He has estimated his income and monthly expenses for each month over the next year. This data is summarized in the accompanying table. He has identified several short-term investment opportunities: a three-month CD yielding 0.60% at maturity, a six-month CD yielding 1.42% at maturity, an 11-month CD yielding 3.08% at maturity, and a savings account yielding 0.0375% per month. He would like to maintain at least $2,000 in his savings account. His objective is to maximize his cash balance at the end of the year. Develop a linear optimization model to find the best investment strategy. Assume that all cash flows take place at the beginning of each month and that interest has been added to the savings account for January. Click here to view the monthly income and expenses data. Complete the table below to indicate the amount that should be invested each month to optimize the cash balance, and then give the final balance. (Make sure Use Automatic Scaling is checked in the Solver Options.) six-month CD $0 11-month CD $ 12,243.71 $0 $0 $07 $3619.66 three-month CD January $0 February $0 March 0 April $ 1933.71 May June July $0 August September 0 October $4271.81 so 50 $0 $0 Final balance = $ 17775 Month 1. January 2. February 3. March 4. April 5. May 6. June 7. July 8. August 9. September 10. October 11. November 12. December Income $3,400 $3,400 $3,400 $9,500 $3,400 $5,000 $4,600 $3,400 $3,400 $3,400 $3,400 $5,000 Expenses $3,360 $2,900 $6,600 $2,750 $2,800 $6,800 $3,200 $3,600 $6,550 $2,800 $2,900 $6,650
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
