Suppose you're a financial analyst at a company, and you are recommending whether the companyshould invest in Project A or Project B.Each of the two projects has been proposed by a lead engineer, but the company can only invest increating one of them this year, and so your manager wants you to give her advice on which one toinvest in. Your company's WACC is 9%.Project AProject 8YearCash FlowYearCash Flow$3 ilio, ntialinvestment$2 milion proft$4 ilion pofit$A milion proft$2 milion proft$0, projet loseout$3 ilion, ntia ivestment$0$0$0$0$14 milion poit1122334455Calculate the net present value (NPV) of and decide which one is better.S 유

WE ARE GIVEN THE CASH FLOWS OF 5 YEARS OF 2 PROJECTS. WE NEED TO FIND THE NET PRESENT VALUE OF BOTH…

Answered: Calculate the net present value (NPV)…

Business

Operations Management

Calculate the net present value (NPV) of and decide which one is better.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a 3-year moving average to forecast demand. Forecast demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the…
A manufacturing company must decide whether to manufacture a component part at its Milan, Michigan, plant or purchase the component part from a supplier. The resulting profit is dependent upon the demand for the product. The following payoff table shows the projected profit (in thousands of dollars). State of Nature Decision Low Alternative Demand $1 Medium Demand $2 High Demand 53 Manufacture, d -5 55 115 Purchase, d₂ 60 85 The state-of-nature probabilities are P(s₁) = 0.35, P(52) = 0.35, and P(53) = 0.30. (a) Use a decision tree to recommend a decision. The best decision is to purchase the component part. (b) Use EVPI to determine whether the company should attempt to obtain a better estimate of demand, assuming the estimate would come at no further cost. EVPI = 9 The EVPI suggests that the company should consider an attempt to obtain a better estimate of demand. (c) A test market study of the potential demand for the product is expected to report either a favorable (F) or…
Given the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are: Regular output $20 Overtime $30 Subcontract $25 Average Inventory $10 Backlog $18 Month 1 2 3 4 5 6 Forecast 540 540 570 590 650 680
Garfield Industries is expanding its operations throughout the Southeast United States. Garfield anticipates that the expansion will increase sales by $1,000,000 and increase operating costs (excluding depreciation and amortization) by $700,000. Depreciation and amortization expenses will rise by $50,000, interest expense will increase by $150,000, and the company’s tax rate will remain at 40 percent. If the company’s forecast is correct, how much will net income increase or decrease, as a result of the expansion?
List and briefly describe the highlights of your simulation decisions exercise strategic plan, and how the plan was executed.
Congratulations, the design options for the two mobile phone lines have been specified. You will now have to predict the total demand for each product line. Your forecasting team members have come up with a consensus for what they believe demand will be for the mobile phone lines. However, the board of your company is interested in your personal estimates as well. The numbers you will forecast after entering the forecasting room will not affect your production schedule, but they will help you later as you determine where and how to source your products. Model A: Monthly Estimated Demand May–December in thousands per month Average:59Standard Dev:2 AndreiAyaLorenzoClaireByronRuthConsensus020406080 Model B: Monthly Estimated Demand May–December in thousands per month Average:29Standard Dev:6 AndreiAyaLorenzoClaireByronRuthConsensus020406080 Unit Data with Options as Chosen costs are an estimate from the lowest-cost contract manufacturer Model A Model B Unit Price…
See image for details
Answer questions using EXCEL , include formulas Myrtle Air Express decided to offer direct service from Cleveland to Mrytle Beach. Management must decided between a full-price service using the company's new fleet of jet aircraft and a discount service using smaller capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based upon two possible levels of demand for service to Mrytle Beach: strong and weak. The following table shows the estimated quarterly profits (in thousands of dollars): Service Strong Weak Full Price $960 -$490 Discount $670 $320 a. What is the decision to be made, what is the chance event, and what is the consequence for this problem? How many decision alternatives are there? How many outcomes are there for the chance event? b. If nothing is known about the probabilities of the chance outcomes,…
Da
1
What would be the best way to estimate whether a piece of land could be used to manage an existing (at a profit) in the relatively short- and long-run? Explain what information you would need to make the decision what would be a “Second best” alternative to the criteria you picked first?
A rock concert producer has scheduled an outdoor concert. The producer estimates the attendance will depend on the weather according to the following table. Weather Attendance Probability wet, cold 4000 0.1 wet, warm 25000 0.1 dry, cold 30000 0.1 dry, warm 45000 0.7 (a) What is the expected attendance? (b) If tickets cost $ 30 each, the band will cost $ 250,000, plus $ 55,000 for administration. What is the expected profit?