Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients. The cash flows for the five investments

Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients. The cash flows for the five investments under consideration are summarized in the following table: For example, if Dan invests $1 in investment A at the beginning of year 1, he will receive $0.45 at the beginning of year 2 and another $1.05 at the beginning of year 3. Alternatively, he can invest $1 in investment B at the beginning of year 2 and receive $1.30 at the beginning of year 4. Entries of "0.00" in the preceding table indicate times when no cash in-flows or out-flows can occur. The minimum required investment for each of the possible investments is $50,000. Also, at the beginning of each year, Dan may also place any or all of the available money in a money market account that is expected to yield 5% per year. How should Dan plan his investments if he wants to maximize the amount of money available to his client at the end of year 4? a. Select the correct ILP model for this problem. Let A represent Amount to invest in investment A. Let B represent Amount to invest in investment B. Let C represent Amount to invest in investment C. Let D represent Amount to invest in investment D. Let E represent Amount to invest in investment E. Let M1 represent Amount to invest in the money market in 2001. Let M2 represent Amount to invest in the money market in 2002. Let M3 represent Amount to invest in the money market in 2003. I MAX 1.3 B + 1.65 C + 1.3 D + 1.05 M3 ST A + C + E + M1 = 1,000,000 0.45 A + 1.05 M1 - B - M2 = 0 1.05 A + 1.25 E + 1.05 M2 - D - M3 = 0 A - M YA 0 B - M YB 0 C - M YC 0 D - M YD 0 E - M YE 0 A - 50,000 YA 0 B - 50,000 YB 0 C - 50,000 YC 0 D - 50,000 YD 0 E - 50,000 YE 0 A, B, C, D, E, M1, M2, M3 0 II MIN 1.3 B + 1.65 C + 1.3 D + 1.05 M3 ST A + C + E + M1 = 1,000,000 0.45 A + 1.05 M1 - B - M2 = 0 1.05 A + 1.25 E + 1.05 M2 - D - M3 = 0 A - M YA 0 B - M YB 0 C - M YC 0 D - M YD 0 E - M YE 0 A - 50,000 YA 0 B - 50,000 YB 0 C - 50,000 YC 0 D - 50,000 YD 0 E - 50,000 YE 0 A, B, C, D, E, M1, M2, M3 0 III MAX 1.3 B + 1.65 C + 1.3 D + 1.05 M3 ST A + C + E + M1 = 1,000,000 0.45 A + 1.05 M1 - B - M2 = 0 1.05 A + 1.25 E + 1.05 M2 - D - M3 = 0 A - M YA 0 B - M YB 0 C - M YC 0 D - M YD 0 E - M YE 0 A - 50,000 YA 0 B - 50,000 YB 0 C - 50,000 YC 0 D - 50,000 YD 0 E - 50,000 YE 0 A, B, C, D, E, M1, M2, M3 0 IV MIN 1.3 B + 1.65 C + 1.3 D + 1.05 M3 ST A + C + E + M1 = 1,000,000 0.45 A + 1.05 M1 - B - M2 = 0 1.05 A + 1.25 E + 1.05 M2 - D - M3 = 0 A - M YA 0 B - M YB 0 C - M YC 0 D - M YD 0 E - M YE 0 A - 50,000 YA 0 B - 50,000 YB 0 C - 50,000 YC 0 D - 50,000 YD 0 E - 50,000 YE 0 A, B, C, D, E, M1, M2, M3 0 b. Create a spreadsheet model for this problem and solve it using Solver. How much should Dan Boyd invest on each of the five investments and three money market accounts? If your answer is zero, enter "0". Investment Amount Invested ($) A 100000 B 0 C 0 D 13000 E 0 M1 0 M2 45000 M3 0 c. What is the maximum amount of money available at the beginning of 2004? $ 197925

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

Economics Of Money Banking And Financial Markets

Authors: Frederic Mishkin

10th Global Edition

0273765736, 978-0273765738

More Books

Students also viewed these Finance questions

Question

What is the relationship between humans and nature?

Answered: 1 week ago