Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The first item on Pierre's agenda is to devise a five-year investment plan. He has set aside $5 million to initially place into this
The first item on Pierre's agenda is to devise a five-year investment plan. He has set aside $5 million to initially place into this portfolio, and will not add any other funds later. Any investment proceeds realized during the five-year window will be reinvested. The goal is to generate as much money as possible by the end of the fifth year. The proceeds will go towards his senate campaign. For brevity, we will call the investments A, B, C, D, and E. The below table shows the years that each investment can be invested in, the duration of time until the investments mature, and the maximum amount that can be invested in each investment (per period). For example, investment C can be invested in up to two times: at the beginning of year 1 or at the beginning of year 3. Each time the maximum investment amount is $3 million (so, in total, $6 million could be placed in this investment). Year 1 2 3 4 5 A 2.0% 4.0% 4.0% Investment Duration 1 2 3.0% 2.0% ABCD E B 8% 23 8% 4 Available Years The returns from the investments are shown below. These returns are realized when an investment matures (i.e., they are not all annual returns). Some investments have variable returns that are based on the year in which the investment was made, while others return the same amount no matter when the investment was made. Also, we should note that there is an option to invest in cash every year. There is no maximum amount for cash investments. 1,2,4,5 2,4 1,3 1,2,3 2 C 5% Max Amount per Investment 6% 2 3 315 5 D 9% 9% 9% E 12% Cash 1.5% 1.5% 1.5% 1.5% 1.5% For example, if $1 million is invested in C at the beginning of year 1, Pierre will realize a 5% return at the end of year 2/beginning of year 3 (because the duration of investment C is 2 years). In addition, Pierre would receive his $1 million principle back, so in total he would have $1 million +0.05*$1 million = $1.05 Million available for reinvestment at the beginning of year 3. Question 1: Determine the optimal amount for Pierre to invest in each option each year. Question 2: What percentage return should Pierre expected to make on his initial investment? Question 3: Create a sensitivity report and use it to determine what will happen if the maximum investment in investment A in year 1 is changed to $4 million. Question 4: Create a sensitivity report and use it to determine what will happen if the maximum investment in investment E is changed to $2 million.
Step by Step Solution
★★★★★
3.42 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
Answer 1 Year 1 A 2 million B 2 million C 3 million D 2 million E 0 mill...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started