Question: Jason Wright is a part time business student who would like to optimize his financial decisions. Currently, he has $ 16,000 in his savings account.
Jason Wright is a part time business 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 following table summarizes his estimates:
.png)
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
- A savings account yielding 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.
Month 1. January 2. February 3. March 4. April 5. May 6. June 7. July 8. August 9. September Income Expenses $3,400 $3,400 $3,400 $9,500 $3,400 $5,000 $4,600 $3,400 $3,400 $3,400 $3,400 $5,000 $3,360 $2,900 $6,600 $2,750 $2,800 $6,800 $3,200 $3,600 $6,550 $2,800 $2,900 $6,650 10. October 11. November 12. December
Step by Step Solution
3.15 Rating (165 Votes )
There are 3 Steps involved in it
Jason Wright Investment Strategy Starting Balance in Savings 1600000 Savings ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
607-B-B-C-B-M (969).xlsx
300 KBs Excel File
