Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Breakeven cash inflows and risk Blair Gases and Chemicals is a supplier of highly purified gases to semiconductor manufacturers. A large chip producer has asked

Breakeven cash inflows and risk Blair Gases and Chemicals is a supplier of highly purified gases to semiconductor manufacturers. A large chip producer has asked Blair to build a new gas production facility close to an existing semiconductor plant. Once the new gas plant is in? place, Blair will be the exclusive supplier for that semiconductor fabrication plant for the subsequent 5years. Blair is considering one of two plant designs. The first is? Blair's "standard" plant which will cost ?$30 million to build. The second is for a? "custom" plant which will cost ?$40 million to build. The custom plant will allow Blair to produce the highly specialized gases that are required for an emergency semiconductor manufacturing process. Blair estimates that its client will order ?$10 million of product per year if the traditional plant is? constructed, but if the customized design is put in? place, Blair expects to sell ?$15 million worth of product annually to its client. Blair has enough money to build either type of? plant, and, in the absence of risk? differences, accepts the project with the highest NPV. The cost of capital is 12?%. a.??Find the NPV for each project. Are the projects? acceptable? b.??Find the breakeven cash inflow for each project. c.??The firm has estimated the probabilities of achieving various ranges of cash inflows for the two? projects, as shown in the following table. What is the probability that each project will achieve the breakeven cash inflow found in part ?(b?)?? Probability of achieving cash inflow in given range Range of cash inflow ($ millions) Standard Plan Custom Plant $0 to $5 0% 5% $5 to $8 10 10 $8 to $11 60 15 $11 to $14 25 25 $14 to $17 5 20 $17 to $20 0 15 Above $20 0 15 d. Which project is more? risky? Which project has the potentially higher? NPV? Discuss the? risk-return trade-offs of the two projects. e. If the firm wished to minimize losses? (that is, NPV less than $ 0NPV

Which formula can I use to plug in these numbers or how can I submit into excel? (I keep getting #### error when in excel)

image text in transcribed

Probability of achieving cash inflow in given range Range of cash inflow (s millions Standard Plant Custom Plant $0 to $5 0% 5% $5 to $8 10 10 $8 to $11 60 15 2.5 $11 to $14 25 20 $14 to $17 $17 to $20 Above $20 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance An International Perspective

Authors: Joshua E. Greene

1st Edition

9814365041, 978-9814365048

More Books

Students also viewed these Finance questions