Question: How do I solve this problem in excel? I started working on it, but I'm a bit stuck. Please show me how to do it,
How do I solve this problem in excel? I started working on it, but I'm a bit stuck. Please show me how to do it, your help is greatly appreciated. Thumbs up guaranteed for best answer :)

You now have $10,000 and need to make annual investment decisions to maximize your cash on hand at the end of the third year. At the beginning of each year, you can invest up to $5,000 in any of the plans. Plan A: Every dollar yields $0.10 a year from now and $1.30 three years from now. Plan B: Every dollar invested yields $0.20 a year from now and $1.10 two years from now. Plan C: Every dollar invested yields $1.50 three years from now. During each year, you can place univested cash in money market funds that yield 6% interest per year. Use a Network Model to determine your investment plan for the next three years. (Hint: model each year as between four nodes 0, 1, 2, 3, and 4 where year one begins at node 0 and ends at node 1 and year three ends at node 4). You now have $10,000 and need to make annual investment decisions to maximize your cash on hand at the end of the third year. At the beginning of each year, you can invest up to $5,000 in any of the plans. Plan A: Every dollar yields $0.10 a year from now and $1.30 three years from now. Plan B: Every dollar invested yields $0.20 a year from now and $1.10 two years from now. Plan C: Every dollar invested yields $1.50 three years from now. During each year, you can place univested cash in money market funds that yield 6% interest per year. Use a Network Model to determine your investment plan for the next three years. (Hint: model each year as between four nodes 0, 1, 2, 3, and 4 where year one begins at node 0 and ends at node 1 and year three ends at node 4)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
