3. own a property development firm. You consider investing in three development projects, each of which...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. own a property development firm. You consider investing in three development projects, each of which will take 1.5 years, or six quarters, to complete. For each project, each quarter marks a completion milestone, which may incur costs (e.g., from buying building materials and paying wages) or generate income (e.g., if completed parts of the project are sold to buyers). The table below shows the projected cash flow stream for each project across the six Semester 1 S682 Fa2406 47 You Q4 Q5 820 -1.8 0.4 1.8 1.8 Q6 1.5 1.5 1.5 -1.8 column shows the amount that must be paid (negative numb 92406 1 2023 Leto2 s numbers) for each project at the start of the corresponding quarter, in units of millions of dollars. The last column shows the estimated value of the projects at the end of quarter 6. (Note: project B has negative value at the end since it is a condition to demolish the development at the end of the 1.5 years. Therefore for an initial investment of $2.5 million over two quarters, the project will earn $4.7 million over four cost $1 million to demolish at the end.) S6 but arters, S680 QBarters. A S6820, (b) 139 B th023 m (6 Q2 Q3 -1 -0.5 -2 This means that cash flows are reduced proportionally. For example, if you were to invest 40% into project A, the cash flow would be -1.2, -0.4, It is possible to invest a fractional amount into each project 6820 Se-0.72, 0.16, 0.72, 0.72, 2.2. However, once y the end of the projects. firm has certain amounts to invest at the start of each quarter, gir 2 action, it stays the same until 479240ou decide on your investment 0230 023 in the following table (in millions). Se which increase in value by 3% per quarter; also paid each quarter. me Make s end 5.5 -1 Q1 Q2 Q3 Q4 Q5 Q6 end 0.5 0.4 0.38 0.36 0.34 0.3 2 can supplement these amounts by borrowing money each quarter at an interest rate of 3.5% per quarter. You have borrowing capacity of $2 million each quarter. Any loan taken out at the start of a quarter must be paid back (including interest) at the end of the quarter. You can also choose to invest money in bonds, onds. Bond investments are 23 Sper in 2406ere is no limit for i ho23 Sesting i 470 our goal is to choose how much to invest in the projects, how much to borrow each quarter, and how much to invest in bonds each quarter in order maximize the net worth of your portfolio at the end of Q6. (a) (14 points) Formulate a linear program to find the optimal investment plan. Solve your linear program (using code from part (b)) and interpret the solution. 6. let Cij Hint: it may help you write the model cleanly if you define constants for the input data. For example, be the income stream from project i = {A, B, C} at the start of quarter je [n], where points) = 6. QBUS6820 2023 Semeste 1924 or the amount earned (positive n Please refer to the Jupyter Notebook for this question. Implement the model in Gurobi. sure that the model can take into account data of different sizes. meste 3. own a property development firm. You consider investing in three development projects, each of which will take 1.5 years, or six quarters, to complete. For each project, each quarter marks a completion milestone, which may incur costs (e.g., from buying building materials and paying wages) or generate income (e.g., if completed parts of the project are sold to buyers). The table below shows the projected cash flow stream for each project across the six Semester 1 S682 Fa2406 47 You Q4 Q5 820 -1.8 0.4 1.8 1.8 Q6 1.5 1.5 1.5 -1.8 column shows the amount that must be paid (negative numb 92406 1 2023 Leto2 s numbers) for each project at the start of the corresponding quarter, in units of millions of dollars. The last column shows the estimated value of the projects at the end of quarter 6. (Note: project B has negative value at the end since it is a condition to demolish the development at the end of the 1.5 years. Therefore for an initial investment of $2.5 million over two quarters, the project will earn $4.7 million over four cost $1 million to demolish at the end.) S6 but arters, S680 QBarters. A S6820, (b) 139 B th023 m (6 Q2 Q3 -1 -0.5 -2 This means that cash flows are reduced proportionally. For example, if you were to invest 40% into project A, the cash flow would be -1.2, -0.4, It is possible to invest a fractional amount into each project 6820 Se-0.72, 0.16, 0.72, 0.72, 2.2. However, once y the end of the projects. firm has certain amounts to invest at the start of each quarter, gir 2 action, it stays the same until 479240ou decide on your investment 0230 023 in the following table (in millions). Se which increase in value by 3% per quarter; also paid each quarter. me Make s end 5.5 -1 Q1 Q2 Q3 Q4 Q5 Q6 end 0.5 0.4 0.38 0.36 0.34 0.3 2 can supplement these amounts by borrowing money each quarter at an interest rate of 3.5% per quarter. You have borrowing capacity of $2 million each quarter. Any loan taken out at the start of a quarter must be paid back (including interest) at the end of the quarter. You can also choose to invest money in bonds, onds. Bond investments are 23 Sper in 2406ere is no limit for i ho23 Sesting i 470 our goal is to choose how much to invest in the projects, how much to borrow each quarter, and how much to invest in bonds each quarter in order maximize the net worth of your portfolio at the end of Q6. (a) (14 points) Formulate a linear program to find the optimal investment plan. Solve your linear program (using code from part (b)) and interpret the solution. 6. let Cij Hint: it may help you write the model cleanly if you define constants for the input data. For example, be the income stream from project i = {A, B, C} at the start of quarter je [n], where points) = 6. QBUS6820 2023 Semeste 1924 or the amount earned (positive n Please refer to the Jupyter Notebook for this question. Implement the model in Gurobi. sure that the model can take into account data of different sizes. meste
Expert Answer:
Answer rating: 100% (QA)
To formulate a linear program for finding the optimal investment plan in this scenario lets define t... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these programming questions
-
Professors of ethics (Eth), professors of philosophy (Phil), and professors in fields other than philosophy or ethics (Other) were asked what percentage of their income professors should donate to...
-
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...
-
An application program is executed on a nine-computer cluster. A benchmark program took time T on this cluster. Further, it was found that 25% of T was time in which the application was running...
-
It's the Tooth Dental works to provide high quality pediatric dental services in a fun-loving environment for children. During December, It's the Tooth Dental employees earned $90,000 in wages....
-
A national catalog and Internet retailer has three warehouses and three major distribution centers located around the country. Normally, items are shipped directly from the warehouses to the...
-
As can be easily verified by means of the formula for the binomial distribution, the probabilities of getting 0 , 1,2 , or 3 heads in 3 flips of a coin whose probability of heads is 0.4 are...
-
XY Limited commenced trading on 1 February with fully paid issued share capital of 500 000, Fixed Assets of 275 000 and Cash at Bank of 225 000. By the end of April, the following transactions had...
-
Find all subsets of set S if S is empty: then return a set containing an empty set else Let s be the first element of S Let R be the set S - {s} Find all subsets of set R (recursive step) Let So be...
-
Harry Jamison, CPA, is planning to set up a business to prepare tax returns. Harry is the only person in the business, at least for now. Can he delegate any work? Should he? Explain.
-
Find the slope of the secant line between the values 1 and 2 for the function given below. f(x) = x 1; x = 1080, x2 = 5 The slope is -1; x1 Use the palette at the right side of the screen to enter...
-
One advantage of balanced three-phase systems over separate singlephase systems is reduced capital and operating costs of transmission and distribution. (a) True (b) False
-
A small economy starts the year with $1 million in capital. During the course of the year, gross investment is $150,000 and depreciation is $50,000. What is the economys capital stock at the end of...
-
While the instantaneous electric power delivered by a single-phase generator under balanced steady-state conditions is a function of time having two components of a constant and a double-frequency...
-
The total instantaneous power delivered by a three-phase generator under balanced operating conditions is (a) A function of time (b) A constant
-
Suppose that in 1994 the total output in a single-good economy was 7,000 buckets of chicken. Also suppose that in 1994 each bucket of chicken was priced at $10. Finally, assume that in 2015 the price...
-
Which of the following is included in the costs transferred out of the second process of a three-step production process? A. Costs incurred in the current process B. Costs incurred in the previous...
-
If someone's Z-score for a variable was 0.67. Their score is a significant extreme score. Their score is not significant. O Their score is slightly above average. O Their score is an outlier.
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 7.5. Briefly describe how mixed BIP was applied in this...
-
Marsha operates an espresso stand. Customers arrive randomly at a mean rate of 30 per hour. The time needed by Marsha to serve a customer has an exponential distribution with a mean of 75 seconds. a....
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 6.4. Briefly describe how network optimization models...
-
Based on the photographs in Figure 26.13, in which segment(s) is the Antp gene normally expressed? Figure 26.13: (a) Normal fly (b) Antennapedia mutant
-
The bush baby, a small African mammal, is a remarkable jumper. Although only about 8 inches long, it can jump, from a standing start, straight up to a height of over 7 feet! Use the particle model to...
-
Your friend Travis claims to have set the new world speed record for riding a unicycle. His top speed, he says, was 55 m/s. Do you believe him? Explain.
Study smarter with the SolutionInn App