x Your answer is incorrect. Using SOLVER for sensitivity analysis: Determine the optimum portfolio and its PW using (1) the current limit on investment capital, (2) plus 20% to the year O limit, and (3) minus 20% to the year O limit. (1) PW: $ 130503 (2) PW: $ 184868 (3) PW: $ 181596 Rex Electric has decided to move into low-rise (2 to 8 floors) commercial building electrical wiring. After great success in upscale residential and small commercial wiring, they have identified four independent and indivisible investments, any or all of which will help make the move to the next level. Rex Electric's MARR is 10%, and $500,000 is available for investment immediately, with $175,000 available for follow-up investment the next year. The cash flows are shown below. ΕΟΥ CF(1) CF(2) CF(3) CF(4) 0 -$50,000 $125,000 $200,000 -$250,000 1 -$100,000 -$75,000 $50,000 $75,000 2 $50,000 $70,000 $50,000 $75,000 3 $50,000 $70,000 $50,000 $75,000 4 $50,000 $70,000 $50,000 $75,000 5 $50,000 $70,000 $75.000 $75,000 6 $50,000 $70,000 $75,000 $85.000 7 $50,000 $75,000 $70,000 $85,000 8. $50,000 $70.000 $75,000 $85,000 9 $50,000 $70,000 $75,000 $85,000 10 $75,000 $100,000 $75,000 $100,000

x Your answer is incorrect. Using SOLVER for sensitivity analysis: Determine the optimum portfolio and its PW using (1) the current limit on investment capital, (2) plus 20% to the year O limit, and (3) minus 20% to the year O limit. (1) PW: $ 130503 (2) PW: $ 184868 (3) PW: $ 181596 Rex Electric has decided to move into low-rise (2 to 8 floors) commercial building electrical wiring. After great success in upscale residential and small commercial wiring, they have identified four independent and indivisible investments, any or all of which will help make the move to the next level. Rex Electric's MARR is 10%, and $500,000 is available for investment immediately, with $175,000 available for follow-up investment the next year. The cash flows are shown below. ΕΟΥ CF(1) CF(2) CF(3) CF(4) 0 -$50,000 $125,000 $200,000 -$250,000 1 -$100,000 -$75,000 $50,000 $75,000 2 $50,000 $70,000 $50,000 $75,000 3 $50,000 $70,000 $50,000 $75,000 4 $50,000 $70,000 $50,000 $75,000 5 $50,000 $70,000 $75.000 $75,000 6 $50,000 $70,000 $75,000 $85.000 7 $50,000 $75,000 $70,000 $85,000 8. $50,000 $70.000 $75,000 $85,000 9 $50,000 $70,000 $75,000 $85,000 10 $75,000 $100,000 $75,000 $100,000

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 30P

See similar textbooks

Similar questions

Kabelo and Hendrik are joint owners of Fitness Gym. They are currently investigating the option of investing in cryotherapy, a cold therapy that may reduce inflammation in tendons or joints. Their investment would provide Fitness Gym members with equipment which may be used to reduce post-exercise recovery times, at an additional cost. The addition of cryotherapy to the gym represents a strategic service for Fitness Gym. Which one of the following statements reflect the importance of capital-investment projects such as the example above. a. The relative magnitude of the amounts involved. b. The short-term nature of capital-investment decisions. c. The operational nature of capital-investment projects. d. The direct effect of the time value of money on capital-investment projects.
what is the expected payoff $____
Answer please with correct option
Year 1 2 3 4 5 6 7 8 9 10 11 12 Costs (BWP million) +100 110 120 115 150 170 200 250 200 180 150 120 100 Benefits (BWP million) -100 80 100 120 150 165 180 200 210 250 200 150 100 Compute the Profitability Index and make an investment recommendation
Stanley and Mar are a married couple who bought their primary residence four years ago for $250,000. Their closing costs when they bought the house were $3,000, and they spent $10,000 on capital improvements. They now sell the house for $450,000. The cost of the sale was $12,000. What is their capital gain? $263,000 $438,000 $175.000 $89.000
Calculate the Macaulay convexity of a 10-year 6.9% $1000 bond having annual coupons and a redemption of $1,200.00 if the yield to maturity is 6.7%
If the contract annual interest rate on a $2,880,000 fixed rate loan that is fully amortizing over 20 years with equal monthly payments is 6.25%, what is the effective yield to the lender if the lender charges 1.5% as an origination fee, $288 for a credit report and $3,080 for an appraisal fee and the loan is repaid after ten years? a. 6.25% b. 6.51% c. 6.46% d. 6.49%
8.5 Morningside Nursing Home, a not-for-profit corporation, is estimating its corporate cost of capital. Its tax-exempt debt currently requires an interest rate of 6.2 percent, and its target capital structure calls for 60 percent debt financing and 40 percent tnequity (fund capital) financing. Its estimated cost of equity is 15.4 percent. What is Morningside’s corporate cost of capital?
I need to solve the following excercise including the whole process and rationale behind the solution. Do not use Ai.
What is the ROE for a firm with a times interest earned ratio of 2, a tax liability of $1 million, and interest expense of $1.5 million if equity equals $1.5 million? A. 26.67% B. 30.00% C. 33.33% D. 50.00% Wizard Co. is considering a project that will require $650,000 in assets. The project will be financed with 100% equity. The company faces a tax rate of 40%. What will be the ROE (return on equity) for this project if it produces an EBIT of -$40,000? When calculating the tax effects, assume that Wizard Co. as a whole will have a large, positive income this year. O - 3.0% O-3.7% O-4.4% 0 -3.1%
You have been appointed as a financial consultant by the directors of Sizonke Holdings. They require you to determine the cost of capital of the company. The following information is available on the capital structure of the company:✓1 500 000 ordinary shares, with a market price of R3 per share. The latest dividend declared was 85 cents per share. A dividend growth of 14% was maintained for the past 5 years.✓1 000 000 11%, R1 preference shares, with a market value of R2 per share.✓R1 000 000 9%, debentures due in 7 years and the current yield-to-maturity is 10%.✓R700 000 14%, bank loan, due in December 2019.Additional information:- The company has a tax rate of 28%.- The beta of the company is 1.6, a risk free rate of 6% and the return on the market is 15%.Required:2.1 Calculate the weighted average cost of capital. Use the Gordon Growth Model to calculate the cost of equity. (22 marks)2.2 Calculate the cost of equity, using the Capital Asset Pricing Model. (
As a result of an increase in demand for a town’s car parking facilities, the owners ofa car park are reviewing their business operations. A decision has to be made nowto select one of the following three options for the next year:Option 1 : Make no change. Annual profit is RM150, 000. There is littlelikelihood that this will provoke new competition this year.Option 2 : Raise prices by 50%. If this occurs there is a 75% chance that anentrepreneur will set up in competition this year. The Board’sestimate of its annual profit in this situation would be as follows:2A WITH new competitor 2B WITHOUT new competitorProbability Profit (RM) Probability Profit (RM)0.3 200, 000 0.5 250, 0000.4 170, 000 0.3 200, 0000.3 130, 000 0.2 150, 000Option 3 : Expand the car park quickly, at a cost of RM50, 000, keeping pricesthe same. The profits are then estimated to be like 2B, above, exceptthat the probabilities would be 0.6, 0.3 and 0.1 respectively.Requireda) Draw a decision tree for this problem,…