An investor seeks to establish an investment portfolio using the lowest possible initial investment that will...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An investor seeks to establish an investment portfolio using the lowest possible initial investment that will generate specific amounts of capital at specific time periods in the future. We call this type of problem the 'sinking fund' problem. Marcel Lapierre is trying to plan for his daughter Chantal's university expenses. Based on current projections (it is now the start of year 1), Marcel anticipates that his financial need at the start of each of the following years is as follows (shown below left): Year 3 $20,000 Year 4 $22,000 Year 5 $24,000 Year 6 $26,000 Choice ROI Maturity A 5% 1 year B 13% 2 years C 28% 3 years D 40% 4 years Marcel has several investment choices (assume these are tax free if used for education) at the present time, as also shown above (right). Each choice has a fixed known return on investment and a specified maturity date. Assume that each choice is available for investment at the start of every year. Marcel wants to establish a sinking fund to meet his requirements. Note that at the start of year 1, the entire initial investment is available for investing in the choices. However, in subsequent years, only the amount maturing from a prior investment is available for investment. Remember that this is a multi-year investment problem. Use the following decision variables - you do not need to introduce any additional decision variables. Let A; be the amount (in $) invested in Choice A at the beginning of year i; i=1,2,3,4,5; B; be the amount (in $) invested in Choice B at the beginning of year i; i=1,2,3,4; C; be the amount (in $) invested in Choice C at the beginning of year i; i=1,2,3; D; be the amount (in $) invested in Choice D at the beginning of year i; i=1,2; (a) Formulate an analytical LP model for this problem which should be shown on Excel Worksheet An investor seeks to establish an investment portfolio using the lowest possible initial investment that will generate specific amounts of capital at specific time periods in the future. We call this type of problem the 'sinking fund' problem. Marcel Lapierre is trying to plan for his daughter Chantal's university expenses. Based on current projections (it is now the start of year 1), Marcel anticipates that his financial need at the start of each of the following years is as follows (shown below left): Year 3 $20,000 Year 4 $22,000 Year 5 $24,000 Year 6 $26,000 Choice ROI Maturity A 5% 1 year B 13% 2 years C 28% 3 years D 40% 4 years Marcel has several investment choices (assume these are tax free if used for education) at the present time, as also shown above (right). Each choice has a fixed known return on investment and a specified maturity date. Assume that each choice is available for investment at the start of every year. Marcel wants to establish a sinking fund to meet his requirements. Note that at the start of year 1, the entire initial investment is available for investing in the choices. However, in subsequent years, only the amount maturing from a prior investment is available for investment. Remember that this is a multi-year investment problem. Use the following decision variables - you do not need to introduce any additional decision variables. Let A; be the amount (in $) invested in Choice A at the beginning of year i; i=1,2,3,4,5; B; be the amount (in $) invested in Choice B at the beginning of year i; i=1,2,3,4; C; be the amount (in $) invested in Choice C at the beginning of year i; i=1,2,3; D; be the amount (in $) invested in Choice D at the beginning of year i; i=1,2; (a) Formulate an analytical LP model for this problem which should be shown on Excel Worksheet
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
5.In a nut shell, when you look back over time, the power of image has always been there. Even in the prehistoric era, they used imagery to communicate, and what's even more incredible is that we are...
-
Solve Problem for the indicated variable. C = 5/9 (F - 32); For F
-
Draw an E-R diagram to represent the sample customer order in Figure 8-4. Figure 8-4. PVF CUSTOMER ORDER ORDER NO: 61384 CUSTOMER NO: 1273 NAME: Contemporary Designs 123 Oak St. Austin, TX 28384...
-
Describe whys the medical record is important in legal proceedings.
-
The Quick Manufacturing Company, a large profitable corporation, is considering the replacement of a production machine tool. A new machine would cost $3700, have a 4-year useful and depreciable...
-
A 7 5 kg cliff - diver is falls from a height through the air head, diving towards the water. The drag coefficient for the diver is 0 . 8 3 and the area of the descending diver is 0 . 2 1 m ^ 2 ....
-
A recommendation on the best compensation strategy to address the issue of working with other countries that are or were underdeveloped but are now experiencing economic trade and standard of living...
-
A \(3.50-\mathrm{kg}\) block of iron initially at \(8.00 \times 10^{2} \mathrm{~K}\) is placed on top of a \(6.25 \mathrm{~kg}\) block of copper initially at \(4.00 \times 10^{2} \mathrm{~K}\). How...
-
How can the changes be incorporated into an organization in the best possible manner?
-
How did your group perform (B) perform relative to yourself (A)?
-
Use the following information to answer question. Assume an investor has the utility function W 1/3 , where W is wealth. The state government issues a lottery ticket that pays the winner $300. The...
-
A quality control engineer at the National Bullet Company wants to test for the number of defective bullets (duds) in a case of 1,000. From past experience, he knows that population standard...
-
Evaluate the Coca Cola companys current media strategies including which media is being used, why do you think that the media is being employed by the company, do you think that the current media...
-
Reconsider Prob. 1474. In order to drain the tank faster, a pump is installed near the tank exit as in Fig. P1475. Determine how much pump power input is necessary to establish an average water...
-
Define internal combustion engine and explain how it is different from external combustion engines?
-
In an air standard Otto cycle, the pressure and temperature at the start of compression stroke are 1 bar and \(30^{\circ} \mathrm{C}\), respectively. The temperature at the end of compression is...
-
In I.C. engines, power developed inside the cylinder is known as: (a) Brake horse power (b) Indicated horse power (c) Pumping power (d) None of the above
Study smarter with the SolutionInn App