As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 185 225 290 310 360 450 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4.25% annually) and government securities, at prices and rates currently quoted in The Wall Street Journal. Hoxworth wants to develop a plan for making the annual payments by investing in the following securities (par value = $1000). Funds not invested in these securities will be placed in savings. Security Current Price Rate (%) Years to Maturity 1. $1035 6.75 3 2 $1000 5.425 4 Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth will be required to pay a trustee the amount that will be required to fund the plan. a. Use linear programming to find the minimum cash settlement necessary to fund the annual payments. Do not round your answers. If required, only round your decision variables to a whole dollar amount. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Let F = total funds required to meet the six years of payments G1 = units of government security 1 G2 = units of government security 2 Si = investment in savings at the beginning of year i Note: All decision variables are expressed in thousands of dollars. Min F s.t. 1) 1 VF + X G1 + G2 + -1 V s1 = 185 V -1 2) .0675 V G1 + X G2 + X s1 + -1 v s2= 225 V 3) .0675 V G1+ X G2 + X s2 + V S3 = -1 290 v 4) 1.0675 V G1+ X G2 + X s3 - -1 V S4 310 v 5) X G2 + X S4 + -1 S5 = 360 V 6) X S5+ -1 V S6 = 450 V >xx xxx + + + Current investment required $ Investment in government security 1$ Investment in government security 2 $ Investment in savings for year 1 $4 Investment in savings for year 2 $4 Investment in savings for year 3 $ Investment in savings for year 4 $ Investment in savings for year 5 $ Investment in savings for year 6 %$4 b. Use the shadow price to determine how much more Hoxworth should be willing to pay now to reduce the payment at the beginning of year 6 to $400,000. c. Use the shadow price to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000. Hoxworth should be willing to pay anything less than $ d. Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. Do not round your answers. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Note: All decision variables are expressed in thousands of dollars. Min s.t. 1) F G1|- G2 + s1 2) G1 S1 S2 3) G1 G2 S3 4) G2 S3 + S4 5) G2+ S5 = 6) S5 + S6 = 7) S6|+ S7 = How much would Hoxworth save if this change could be negotiated? If required, round your answer to a whole dollar amount. ++ + + + + 8||8|8|あ|8|& ++ + + + + + + As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 185 225 290 310 360 450 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4.25% annually) and government securities, at prices and rates currently quoted in The Wall Street Journal. Hoxworth wants to develop a plan for making the annual payments by investing in the following securities (par value = $1000). Funds not invested in these securities will be placed in savings. Security Current Price Rate (%) Years to Maturity 1. $1035 6.75 3 2 $1000 5.425 4 Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth will be required to pay a trustee the amount that will be required to fund the plan. a. Use linear programming to find the minimum cash settlement necessary to fund the annual payments. Do not round your answers. If required, only round your decision variables to a whole dollar amount. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Let F = total funds required to meet the six years of payments G1 = units of government security 1 G2 = units of government security 2 Si = investment in savings at the beginning of year i Note: All decision variables are expressed in thousands of dollars. Min F s.t. 1) 1 VF + X G1 + G2 + -1 V s1 = 185 V -1 2) .0675 V G1 + X G2 + X s1 + -1 v s2= 225 V 3) .0675 V G1+ X G2 + X s2 + V S3 = -1 290 v 4) 1.0675 V G1+ X G2 + X s3 - -1 V S4 310 v 5) X G2 + X S4 + -1 S5 = 360 V 6) X S5+ -1 V S6 = 450 V >xx xxx + + + Current investment required $ Investment in government security 1$ Investment in government security 2 $ Investment in savings for year 1 $4 Investment in savings for year 2 $4 Investment in savings for year 3 $ Investment in savings for year 4 $ Investment in savings for year 5 $ Investment in savings for year 6 %$4 b. Use the shadow price to determine how much more Hoxworth should be willing to pay now to reduce the payment at the beginning of year 6 to $400,000. c. Use the shadow price to determine how much more Hoxworth should be willing to pay to reduce the year 1 payment to $150,000. Hoxworth should be willing to pay anything less than $ d. Suppose that the annual payments are to be made at the end of each year. Reformulate the model to accommodate this change. Do not round your answers. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Note: All decision variables are expressed in thousands of dollars. Min s.t. 1) F G1|- G2 + s1 2) G1 S1 S2 3) G1 G2 S3 4) G2 S3 + S4 5) G2+ S5 = 6) S5 + S6 = 7) S6|+ S7 = How much would Hoxworth save if this change could be negotiated? If required, round your answer to a whole dollar amount. ++ + + + + 8||8|8|あ|8|& ++ + + + + + +
Expert Answer:
Answer rating: 100% (QA)
a First we are going to setup the constraints and linear programming problem in Excel Carefully put the values from matching column name into the answer box provided for this part For example there is ... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these mathematics questions
-
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): The annual payments must be...
-
In 2009, several freelance writers filed a class action lawsuit against publishers, claiming that the publishers had, without permission, reproduced certain works. In other words, the publishers had...
-
In mid-2009, a class action lawsuit was launched against Babies R Us, a division of Toys R Us, as well as five manufacturers from whom Babies R Us purchased baby products for resale in its stores....
-
According to the 2020 Global Study on Occupational Fraud and Abuse, a tip is the most common way to report fraud. What should be the ethical considerations for employees before deciding whether to...
-
Jayden did a two-sample t test of the hypotheses H0:1 = 2 versus HA: 1 2, using samples sizes of n1 = n2 = 12. The P-value for the test was 0.12, and was 0.10. Suppose that everything except the...
-
Some first-order DEs have periodic solutions or solutions that tend toward an oscillation. For the DEs in Problems, use isoclines to sketch a direction field and describe whatever sort of periodicity...
-
Consider a situation where \(r\) and \(\lambda\) are constant. A zero-coupon bond has face value \(F\) and maturity \(T\). In the case of default at \(t\), there is partial recovery equal to...
-
A He-Xe mixture containing 0.75 mole fraction of helium is used for cooling of electronics in an avionics application. At a temperature of 300 K and atmospheric pressure, calculate the mass fraction...
-
Assume the following excerpts from a company s balance sheet: Beginning Balance Ending Balance Bonds payable $ 5 0 0 , 0 0 0 $ 6 5 0 , 0 0 0 Common stock $ 9 5 0 , 0 0 0 $ 9 5 0 , 0 0 0 Retained...
-
1. As part of your college experience, do you think you would benefit from participating in a campus ambassador or campus rep program? Why or why not? 2. In what ways would participating in a campus...
-
Which of the following is never an acceptable outcome of the sering a. No further level of EIA is required b. El consideration is not required c . A more limited EIA is required O d. A full and...
-
An all - equity company has the following year - end market value balance sheet: Excess Cash $ 2 0 0 , 0 0 0 Debt $ 0 Other Assets $ 8 0 0 , 0 0 0 Equity $ 1 , 0 0 0 , 0 0 0 ( 1 0 , 0 0 0 shares at $...
-
Suppose you buy a $ 7 0 0 , 0 0 0 house with ' no money down' with a 3 0 year, fixed - rate 7 % mortgage paid month starting TODAY. After 3 0 years you've finally paid off your mortgage. How much...
-
Your plan is to buy a home with a 7 5 % loan to value mortgage. The price you ve negotiated is $ 4 9 5 , 0 0 0 and interest rates for 3 0 year loans ( paid monthly ) are 6 . 7 9 % . What is your...
-
A manufacturing company is considering taking out a loan to expand its production line. To finance this expansion, the company plans to make equal annual payments over the term of the loan. The terms...
-
If you have $ 7 2 0 , 0 0 0 in an account earning 4 percent annually, what constant amount could you withdraw at the end of each month and have nothing remaining at the end of 2 0 years?
-
5. Part 2: Torsion testing The aim of the torsion test is to find the shear modulus, yield and ultimate shear strength for the specimen material. Use the supplied dataset that matches with the LAST...
-
Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...
-
The manager of the Fore and Aft Marina in Problem 16 wants to investigate the possibility of enlarging the docking facility so that two boats can stop for gas and servicing simultaneously. Assume...
-
EL Computer produces its multimedia notebook computer on a production line that has an annual capacity of 16,000 units. EL Computer estimates the annual demand for this model at 6000 units. The cost...
-
For the Pittsburgh Development Corporation problem in Section 4.3, the decision alternative to build the large condominium complex was found to be optimal using the expected value approach. In...
-
Following up on question number 3, assume the school conducts a manifestation determination meeting. Tim attends the meeting with his parents. At the meeting, Tim tells the team that smoking helps...
-
Which is an advantage to an employee who participates in a profit-sharing plan? A. Employee does not have to make investment decisions. B. Graded vesting schedule. C. Older employees receive the...
-
Which of the following is not a characteristic of a defined benefit plan? A. A guaranteed retirement benefit. B. Risk of preretirement inflation assumed by employer. C. Benefits based upon the...
Study smarter with the SolutionInn App