Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

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

Accounting Principles

Authors: Jerry J. Weygandt, Valerie A. Kinnear, Donald E. Kieso, Paul D. Kimmel, Barbara A. Trenholm, Joan E. Barlow

6th Canadian Edition

1118557301, 978-1118557303

More Books

Students also viewed these Accounting questions

Question

5. Explain how ERISA protects employees pension rights.

Answered: 1 week ago