Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A part time student would like to optimize his financial decisions. Currently, he has $15,700 in his savings account. He has estimated his income and
A part time student would like to optimize his financial decisions. Currently, he has $15,700 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. x Monthly Income and Expenses Data three-month CD six-month CD 11-month CD $0 $ 0 $0 January February March $0 $0 $ 11047.85 $0 $0 $0 April May $ SO June SO SO 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 3068.22 July August September $0 $0 October $0 Final balance = $ 16500.67 (Type integers or decimals rounded to the nearest cent as needed.) Print Done Enter your answer in the edit fields and then click Check Answer. All parts showing Car AL Check Answer A part time student would like to optimize his financial decisions. Currently, he has $15,700 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. x Monthly Income and Expenses Data three-month CD six-month CD 11-month CD $0 $ 0 $0 January February March $0 $0 $ 11047.85 $0 $0 $0 April May $ SO June SO SO 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 3068.22 July August September $0 $0 October $0 Final balance = $ 16500.67 (Type integers or decimals rounded to the nearest cent as needed.) Print Done Enter your answer in the edit fields and then click Check Answer. All parts showing Car AL Check
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started