Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please need help! use excel to put answers and for calculations Jason Smith is a part-time business student who would like to optimize his financial
please need help! use excel to put answers and for calculations
Jason Smith 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, books, etc. The following table summarizes his estimates: Income Expenses Month January $3.400 $3.360 February $3.400 $2.900 March $3.400 $6.500 April $9.500 $2.750 May $3.400 $2,800 June $5,000 $6.800 July $4.600 $3.200 August $3.400 $3.600 September $3.400 $6.550 October $3.400 52 800 November $3.400 $2.900 December $5.000 56.650 Jason has identified several short-term investment opportunities. There are no limits (minimums or maximums) on any of the short-term investments. A three-month certificate of deposit (CD) yielding 0.60% at maturity. He can purchase a three-month CD in January, February, March, April, May, June, July, August, and/or September A six-month certificate of deposit (CD) yielding 1.42% at maturity. He can purchase a six-month CD in January February March April, May, and/or June. - An eleven-month certificate of deposit (CD) yielding 3.08% at maturity. He can purchase an eleven-month CD in January Any monies not invested in a CD will be invested in his savings account yielding 0.0375% per month. To ensure enough cash for emergencies, he would like to maintain at least $2,000 every month in the savings account. Assume that any money not invested in CDs will be invested in the savings account. Formulate as a linear program to maximize Jason's cash balance at the end of the year 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