The Sloan Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is 10 percent, what is the profitability index for each project? What is the NPV for each project? Complete the following analysis. Do not hard code values in your calculations. You must use the built-in excel function to answer this question. Annual Cash Flows I II 0 $ (51,000.00) $ (14,000.00) 1 $ 24,800.00 $ 7,800.00 2 $ 24,800.00 $ 7,800.00 3 $ 24,800.00 $ 7,800.00 Required Return 10% Profitability index (I)_________________ Profitability index(II)_________________ NPV (I) ______________ NPV (II) ______________

The Sloan Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is 10 percent, what is the profitability index for each project? What is the NPV for each project? Complete the following analysis. Do not hard code values in your calculations. You must use the built-in excel function to answer this question. Annual Cash Flows I II 0 $ (51,000.00) $ (14,000.00) 1 $ 24,800.00 $ 7,800.00 2 $ 24,800.00 $ 7,800.00 3 $ 24,800.00 $ 7,800.00 Required Return 10% Profitability index (I)_________ Profitability index(II)_ NPV (I) NPV (II) ________

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section9.5: Multistage Decision Problems

Problem 17P

See similar textbooks

Similar questions

It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
BADLY NEED YOUR HELP PLEASE. 1.) True or false? Briefly explain. _____ Your firm has the opportunity to invest $20 million in a new project. The interest rate on the firm’s debt is 7% and the cost of equity is 14%. The cost of capital for the project depends on whether the firm finances the project with new debt or new equity. _____ You are thinking about investing in either stock A or stock B. Both stocks have an expected return of 12%, but stock A has a standard deviation of 25% annually and stock B has a standard deviation of 35% annually. You should invest in stock A since it is less risky. _____ Your firm currently has a debt-to-equity ratio of 10%: debt = $50 million and equity = $500 million (market values). The interest rate on the firm’s debt (rD) is 8% and the cost of equity (rE) is 13%. Since the cost of debt rD is lower than the cost of equity rE, the firm can lower its overall cost of capital by borrowing more. Ignore taxes.
You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as follows: Year 1 = $235,678, Year 2 = $267,854, Year 3 = $298,054, Year 4 = $314,567, and Year 5 = $325,678. Assume that the required rate of return is 5.25%. Compute the NPV by using Microsoft Excel's NPV function. Be sure to show your work. Should the project be pursued? Why or why not?
Consider a public project with the cost of 500. There are three individuals with the following benefits for the public good: v1=400, v2=200 and v3=0. Which of the following statement is false about the VCG (Vickrey-Clarke-Groves) mechanism? None of the options The budget deficit is 200 VCG mechanism is strategy-proof The tax for individual 3 is equal to 0 The tax for individual 1 is equal to 300
The book isn't in your list. but here's the question: Perry Enterprises is considering a number of investment possibilities. Specifically, each investment under consideration will draw on the capital account during each of its first three years, but in the long run, each is predicted to achieve a positive net present value (NPV). Listed are the investment alternatives, their net present values, and their capital requirements, and all figures are in thousands of dollars. In addition, the amount of capital available to the investments in each of the next three years is predicted to be $9.5 million, $7.5 million, and $8.8 million, respectively. (It shows a chart that I attached in the images) For the model, I am unsure of how the constraints are supposed to be applied. Do I have to purchase the investment for all three years if I choose to invest in that investment or can I choose to only invest in it one or two years? If I invest in it more than one year, do I still only recieve the NPV…
You estimate that your cattle farm will generate $1 million of profits on sales of $5.4 million under normal economic conditions and that the degree of operating leverage is 8. What will profits be if sales turn out to be $4.7 million? Note: Negative amount should be indicated by a minus sign. Round your answer to 1 decimal place. What if they are $6.1 million? Note: Round your answer to 1 decimal place.
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
I have a restaurant, but I don't know what demand will be next year. I need to decide whether to expand or not. Regardless of whether I expand or not, there's a 20% chance that I'll have high demand and a 80% chance I'll have low demand.If I expand and I have high demand, I'll get $1M. If I expand and get low demand, I'll make $0. If I don't expand and get high demand, I'll get $200K. If I don't expend and get lo demand, I'll make $100K. What is the expected value of expanding. Answer roudned to the nearest thousand of dollars, so if your asnwer is 434,300, answer 434000. I have a restaurant, but I don't know what demand will be next year. I need to decide whether to expand or not. Regardless of whether I expand or not, there's a 20% chance that I'll have high demand and a 80% chance I'll have low demand.If I expand and I have high demand, I'll get $1M. If I expand and get low demand, I'll make $0. If I don't expand and get high demand, I'll get $200K. If I don't expend and get lo…
The graphs shows the amount being paid in Social Security benefits and the amount going into the system. In 2004, the system’s income was $575 billion, projected to increase at an average rate of $43 billion per year. In which year will the system’s income be $1177 billion?The data for the system’s outflow can be modeled by the formulaB = 0.07x2 + 47.4x + 500,where B represents the amount paid in benefits, in billions of dollars, x years after 2004. According to this model, when willthe amount paid in benefits be $1177 billion? Round to the nearest year. How well do your answers model the data shown by the graphs?