Jason Wright is a part-time MBA student who would like to optimize his financial decisions. Currently, he
Question:
Jason Wright is a part-time MBA student who would like to optimize his financial decisions. Currently, he has $16,000 in his savings account. Based on an analysis of his take-home pay, expected bonuses, and anticipated tax refund, he has estimated his income for each month over the next year. In addition, he has estimated his monthly expenses, which vary because of scheduled payments for insurance, utilities, tuition and books, and so on. The table below summarizes his estimates:
Month | Income | Expenses |
Jan | $3,400 | $ 3,360 |
Feb | $3,400 | $ 2,900 |
Mar | $3,400 | $ 6,600 |
Apr | $9,500 | $ 2,750 |
May | $3,400 | $ 2,800 |
Jun | $5,000 | $ 6,800 |
Jul | $4,600 | $ 3,200 |
Aug | $3,400 | $ 3,600 |
Sep | $3,400 | $ 6,550 |
Oct | $3,400 | $ 2,800 |
Nov | $3,400 | $ 2,900 |
Dec | $5,000 | $ 6,650 |
Jason has identified several short-term investment opportunities:
• A 3-month CD yielding 0.60% at maturity
• A 6-month CD yielding 1.42% at maturity
• An 11-month CD yielding 3.08% at maturity
• His savings account yields 0.0375% per month
To ensure enough cash for emergencies, he would like to maintain at least $2,000 in the savings account. Jason’s objective is to maximize his cash balance at the end of the year. Develop a linear optimization model to find the best investment strategy.
MaturityMaturity is the date on which the life of a transaction or financial instrument ends, after which it must either be renewed, or it will cease to exist. The term is commonly used for deposits, foreign exchange spot, and forward transactions, interest...
Step by Step Answer:
Statistics Data Analysis And Decision Modeling
ISBN: 9780132744287
5th Edition
Authors: James R. Evans