Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, can you look over my work please. Something is wrong but I don't know what? Final balance = $ 17,878.12 (Type integers or decimals

image text in transcribedimage text in transcribedimage text in transcribed

Hello, can you look over my work please. Something is wrong but I don't know what?

image text in transcribedimage text in transcribedimage text in transcribed
Final balance = $ 17,878.12 (Type integers or decimals rounded to the nearest cent as needed.) A part time student would like to optimize his financial decisions. Currently, he has $15,900 in his savings account. He has estimated his income and monthly expenses for each month over the next year. This data is summarized in the accompanying table. He has identified several short-term investment opportunities: a three-month CD yielding 0.60% at maturity, a six-month CD yielding 1.42% at maturity, an 11-month CD yielding 3.08% at maturity, and a savings account yielding 0.0375% per month. He would like to maintain at least $2,000 in his savings account. His objective is to maximize his cash balance at the end of the year. Develop a linear optimization model to find the best investment strategy. Assume that all cash flows take place at the beginning of each month and that interest has been added to the savings account for January. Click here to view the monthly income and expenses data. Complete the table below to indicate the amount that should be invested each month to optimize the cash balance, and then give the final balance. three-month CD six-month CD 11-month CD January $ 0.00 $ 0.00 $ 12,343.71 February $ 0.00 $ 0.00 $ 0.00 March $ 0.00 $ 0.00 April $ 1,933.71 $ 3,619.66 May $ 0.00 $ 0.00 June $ 0.00 $ 0.00 July $ 0.00 $ 0.00 August $ 0.00 September $ 0.00 October $ 4,271.81

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

Fundamentals of Financial Management

Authors: Eugene F. Brigham, ‎ Joel F. Houston

11th edition

324422870, 324422873, 978-0324302691

More Books

Students also viewed these Finance questions

Question

Describe Hobbess position on epistemology.

Answered: 1 week ago

Question

distinguish between compounding and discounting; LO1

Answered: 1 week ago

Question

explain the opportunity cost of an investment; LO1

Answered: 1 week ago