Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 1 - Investment Over Time Jason Smith is a part-time business student who would like to optimize his financial decisions. Currently, he has $17,000

image text in transcribed
image text in transcribed
Problem 1 - Investment Over Time Jason Smith is a part-time business student who would like to optimize his financial decisions. Currently, he has $17,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: Month Income Expenses January $4,500 $4,600 February $4,500 $3,700 March $4,200 $6,600 April $11,500 $3,800 May $4,500 $4,800 June $7,000 $5,600 July $5,200 $4,100 August $5,400 $4,800 September $4,300 $4,400 October $4,700 $4,800 November $4,600 $3,700 December $6,200 $2,400 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.50% 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.63% 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 4.12% 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.0446% per month. To ensure enough cash for emergencies, he would like to maintain at least $1,200 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 Enter your formulation into the template downloaded from Carmen and use Solver to find the optimum solution. Do not type in "O" for those coefficients that are zero; leave these cells blank

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Equity And Trusts Text Cases And Materials

Authors: Paul S. Davies, Graham Virgo

3rd Edition

0198821832, 978-0198821830

More Books

Students also viewed these Law questions

Question

1. Too understand personal motivation.

Answered: 1 week ago