Question 4, Sensitivity Analysis (15 marks) Kathleen Allen has up to $70,000 to divide among several...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 4, Sensitivity Analysis (15 marks) Kathleen Allen has up to $70,000 to divide among several investments. The alternative investments are municipal bonds (MB) with an 8.5% annual return, certificates of deposits (CD) with a 5% return, treasury bills (TB) with a 6.5% return and a growth stock (GS) fund with a 13% annual return. The investments are all evaluated after one year. However, each investment has a different perceived risk to the investor; thus, it is advisable to diversify and maybe leave some amount un-invested. Kathleen wants to know how much to invest in each alternative in order to maximize return. The following guidelines for diversification have been established so that the risk is minimized. No more than 20% of total amount available should be in municipal bonds. The amount invested in certificates of deposit should not exceed the amount invested in the other 3 alternatives. At least 30% of the available amount for investment should be in treasury bills and certificates of deposit. To be safe, more should be invested in CDs and treasury bills than in municipal bonds and growth stock fund by a ratio of at least 1.2 to 1. The following table is the sensitivity report for this problem. Adjustable Cells. Nome $B$11 $ amount in MB $C$11 $ amount in CD $D$11 $ amount. in TB $E$11 $ amount in GS Constraints. Nome $B$18 Fund LHS $B$ 19 MB LHS $B$20 CD & others LHS $B$21 CD & TB LHS $B$22 Ratio LHS Find Val ue ? 0 38181. 82 31818. 18 Find Val ue Reduced Cost -0.045 -70000 38181. 82 ? ? 0 Shadow Price ?0. 094545 ? 0 ? ? ? -0. 02955 Objective Coeffi di ent 0.085 0.05 0. 13 Constraint R. H. Si de 70000 14000 0 21000 Allowable I nor eas e ? 0.015 0. 065 1E+30 Allowable I nor eas e 1E+30 ? 2 ? 70000 Allowable Decr eos e 1E+30 0.015 Allowable Decr eas e 31500 14000 ? ? 37800 f) Final value of FUND (constraint). (1 marks) g) Final value of MB (constraint). (1 marks) h) Allowable Increase of MB (constraint). (1 marks) k) Shadow Price of CD& others (constraint). (1 marks) i) Allowable Increase of CD& others (constraint). (1 marks) j) Allowable Decrease of CD& others (constraint). (1 marks) k) Shadow price of CD& TB (constraint). (1 marks) 1) Allowable Increase of CD& TB (constraint). (1 marks) m) Allowable Decrease of CD& TB (constraint). (1 marks) n) Final value of Ratio (constraint). (1 marks) Question 4, Sensitivity Analysis (15 marks) Kathleen Allen has up to $70,000 to divide among several investments. The alternative investments are municipal bonds (MB) with an 8.5% annual return, certificates of deposits (CD) with a 5% return, treasury bills (TB) with a 6.5% return and a growth stock (GS) fund with a 13% annual return. The investments are all evaluated after one year. However, each investment has a different perceived risk to the investor; thus, it is advisable to diversify and maybe leave some amount un-invested. Kathleen wants to know how much to invest in each alternative in order to maximize return. The following guidelines for diversification have been established so that the risk is minimized. No more than 20% of total amount available should be in municipal bonds. The amount invested in certificates of deposit should not exceed the amount invested in the other 3 alternatives. At least 30% of the available amount for investment should be in treasury bills and certificates of deposit. To be safe, more should be invested in CDs and treasury bills than in municipal bonds and growth stock fund by a ratio of at least 1.2 to 1. The following table is the sensitivity report for this problem. Adjustable Cells. Nome $B$11 $ amount in MB $C$11 $ amount in CD $D$11 $ amount. in TB $E$11 $ amount in GS Constraints. Nome $B$18 Fund LHS $B$ 19 MB LHS $B$20 CD & others LHS $B$21 CD & TB LHS $B$22 Ratio LHS Find Val ue ? 0 38181. 82 31818. 18 Find Val ue Reduced Cost -0.045 -70000 38181. 82 ? ? 0 Shadow Price ?0. 094545 ? 0 ? ? ? -0. 02955 Objective Coeffi di ent 0.085 0.05 0. 13 Constraint R. H. Si de 70000 14000 0 21000 Allowable I nor eas e ? 0.015 0. 065 1E+30 Allowable I nor eas e 1E+30 ? 2 ? 70000 Allowable Decr eos e 1E+30 0.015 Allowable Decr eas e 31500 14000 ? ? 37800 f) Final value of FUND (constraint). (1 marks) g) Final value of MB (constraint). (1 marks) h) Allowable Increase of MB (constraint). (1 marks) k) Shadow Price of CD& others (constraint). (1 marks) i) Allowable Increase of CD& others (constraint). (1 marks) j) Allowable Decrease of CD& others (constraint). (1 marks) k) Shadow price of CD& TB (constraint). (1 marks) 1) Allowable Increase of CD& TB (constraint). (1 marks) m) Allowable Decrease of CD& TB (constraint). (1 marks) n) Final value of Ratio (constraint). (1 marks)
Expert Answer:
Answer rating: 100% (QA)
Decision Variables Four decision variables represent the monetary amount invested in each investment alternative x 1 amount invested in municipal bonds x 2 amount invested in certificates of deposit x ... View the full answer
Related Book For
An Introduction to Statistical Methods and Data Analysis
ISBN: 978-1305269477
7th edition
Authors: R. Lyman Ott, Micheal T. Longnecker
Posted Date:
Students also viewed these economics questions
-
You are offered the opportunity to invest $95,000 in a business which will yield an animal net cash inflow of $18,000 set a period of 8 years. what is the net present value of your investment?
-
Luis wants to know how much he will have available to spend on his trip to Belize in three years if he deposits $ 3,000 today at an interest rate of 9%.
-
Earl wants to know how much he will have available to spend on his trip to Belize in three years if he deposits $3000 today at an interest rate of 9 percent compounded quarterly. (FV)
-
Since the introduction of enhanced security measures by the U.S. Department of Homeland Security in 2017, flights bound for the U.S. from Canada are subject to additional screening by airline...
-
Does aggregating the five components of pension cost always results in a reduction in income? Explain.
-
The following data represent the percentage of 18- to 24-year-olds enrolled in college. Construct a time-series plot and comment on any trends. Year Percent Enrolled Year Percent Enrolled 1998 36.5...
-
An \(R L C\) circuit with a \(10 \mu \mathrm{F}\) capacitor is connected to a variable-frequency power supply with an rms output voltage of \(6.0 \mathrm{~V}\). The rms current in the circuit as a...
-
A manufacturer of game controllers is concerned that their controller may be difficult for left-handed users. They set out to find lefties to test. About 13 % of the population is left-handed. If...
-
2 1 1 4 7 + 14 5 4 The solution is x = . (Type an integer or a simplified fraction.)
-
1. (4) A blood pressure of 110 mm Hg is measured using a cuff over the wrist which is positioned 30 cm above heart level. According to Bernoulli's equation(given below), what is the blood pressure at...
-
Discuss the connection between effective leadership and adept communication in navigating crisis situations. Analyze how leadership qualities come into play during challenging times, focusing on how...
-
What are three abilities in negotiation? Which one is the most important ability to apply during the negotiation full of hoax? Please provide reasons as well as examples to support
-
The type of pricing policy that takes the amount it cost you to make the product and increments that amount by a set percentage to determine the final price,what is this called and how is it working?
-
Why is it important for childcare workers and administrators at every level to participate in ongoing professional development/training. Explain
-
List at six (6) instruction styles for providing clear instructions to students
-
A long-time customer scheduled work to be done on her vehicle. Swifty Auto Repairs, recorded the work on job cost sheet #140 The following cost information was recorded on this customer's job. Direct...
-
Conclusion Labor law The Brunow Hair Saloon receives a set of proposals for collective bargaining from the Brunow Barbers Union, composed of the eight (8) barbers in the establishment. The owner...
-
Data 9.2 on page 540 introduces the dataset Cereal, which includes information on the number of grams of fiber in a serving for 30 different breakfast cereals. The cereals come from three different...
-
Refer to Exercise 15.24. Based on the residuals from the fitted model, do the model conditions appear to be satisfied? Attitude Type of Workshop 2 38 37 42 5 Mean 42 47 42 52 54 50 55 62 42.8...
-
The study of concentrations of atmospheric trace metals in isolated areas of the world has received considerable attention because of the concern that humans might somehow alter the climate of the...
-
Refer to Exercise 11.76. a. Obtain the regression line with the one unusual town removed from the data set. b. Estimate the expenditure on public safety for a town of 37,000 people. Compare this...
-
Explain how the portable estate exemption, resulting from the 2010 Tax Relief Act, altered estate planning using family trusts.
-
Following his death in 2012, Zane Wulster's gross taxable estate was valued at $3,300,000. He has made a total of $200,000 of gifts that exceeded the annual gift tax exclusion. a. What is the amount...
-
May Yee had a $950,000 net worth at the time of her death in 2012. In addition, she owned a $250,000 whole life policy with $40,000 of accumulated cash value; her niece was designated as the...
Study smarter with the SolutionInn App