Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An investor seeks to establish an investment portfolio using the lowest possible initial investment that will generate specific amounts of capital at specific time

 

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

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_2

Step: 3

blur-text-image_3

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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions

Question

Solve Problem for the indicated variable. C = 5/9 (F - 32); For F

Answered: 1 week ago