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:

Jason Wright is a part time business student who would


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

1 Expert Approved Answer
Step: 1 Unlock

Jason Wright Investment Strategy Starting Balance in Savings 1600000 Savings ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

607-B-B-C-B-M (969).xlsx

300 KBs Excel File

Students Have Also Explored These Related Business Communication Questions!