Details:
Complete the following problems from chapter 12 in the textbook:
P12-3
P12-4
P12-8
P12-12
P12-14
P12-18
Follow these instructions for completing and submitting your assignment:
Do all work in Excel. Do not submit Word files or *.pdf files.
Submit a single spreadsheet file for this assignment. Do not submit multiple files.
Place each problem on a separate spreadsheet tab.
Label all inputs and outputs and highlight your final answer.
Follow the directions in “Guidelines for Developing Spreadsheets.”
P12–3 Breakeven cash inflows and risk Blair Gasses 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 5 years. 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 emerging
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 at least the breakeven cash inflow found in part b?
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 < $0), which project would you recommend? Which would you recommend if the goal were to achieve a higher NPV?
P12–4 Basic scenario analysis Murdock Paints is in the process of evaluating two mutually
exclusive additions to its processing capacity. The firm’s financial analysts have developed
pessimistic, most likely, and optimistic estimates of the annual cash inflows
associated with each project. These estimates are shown in the following table.
a. Determine the range of annual cash inflows for each of the two projects.
b. Assume that the firm’s cost of capital is 10% and that both projects have 20-year lives. Construct a table similar to this one for the NPVs for each project. Include the range of NPVs for each project.
c. Do parts a and b provide consistent views of the two projects? Explain.
d. Which project do you recommend? Why?
P12–8 Risk-adjusted discount rates: Basic Country Wallpapers is considering investing in
one of three mutually exclusive projects, E, F, and G. The firm’s cost of capital, r, is
15%, and the risk-free rate, Rғ, is 10%. The firm has gathered the basic cash flow
and risk index data for each project as shown in the following table.
a. Find the net present value (NPV) of each project using the firm’s cost of capital.
Which project is preferred in this situation?
b. The firm uses the following equation to determine the risk-adjusted discount
rate, RADRj, for each project j:
RADRј= Rғ + [Riј X (r – Rғ)]
where
Rғ = risk = free rate of return
RIj = risk index for project j
r = cost of capital
Substitute each project’s risk index into this equation to determine its RADR.
c. Use the RADR for each project to determine its risk-adjusted NPV. Which project
is preferable in this situation?
d. Compare and discuss your findings in parts a and c. Which project do you recommend
that the firm accept?
P12–12 Risk classes and RADR Moses Manufacturing is attempting to select the best of
three mutually exclusive projects, X, Y, and Z. Although all the projects have 5-year
lives, they possess differing degrees of risk. Project X is in class V, the highest-risk
class; project Y is in class II, the below-average-risk class; and project Z is in class
III, the average-risk class. The basic cash flow data for each project and the risk
classes and risk-adjusted discount rates (RADRs) used by the firm are shown in the
following tables.
a. Find the risk-adjusted NPV for each project.
b. Which project, if any, would you recommend that the firm undertake?
P12–14 Unequal lives: ANPV approach Portland Products is considering the purchase of
one of three mutually exclusive projects for increasing production efficiency. The
firm plans to use a 14% cost of capital to evaluate these equal-risk projects. The initial
investment and annual cash inflows over the life of each project are shown in the
following table.
a. Calculate the NPV for each project over its life. Rank the projects in descending
order on the basis of NPV.
b. Use the annualized net present value (ANPV) approach to evaluate and rank the
projects in descending order on the basis of ANPV.
c. Compare and contrast your findings in parts a and b. Which project would you
recommend that the firm purchase? Why?
P12–18 Capital rationing: IRR and NPV approaches Valley Corporation is attempting to select
the best of a group of independent projects competing for the firm’s fixed capital
budget of $4.5 million. The firm recognizes that any unused portion of this budget
will earn less than its 15% cost of capital, thereby resulting in a present value of inflows
that is less than the initial investment. The firm has summarized, in the following
table, the key data to be used in selecting the best group of projects.
a. Use the internal rate of return (IRR) approach to select the best group of projects.
P12–18 Capital rationing: IRR and NPV approaches Valley Corporation is attempting to select
the best of a group of independent projects competing for the firm’s fixed capital
budget of $4.5 million. The firm recognizes that any unused portion of this budget
will earn less than its 15% cost of capital, thereby resulting in a present value of inflows
that is less than the initial investment. The firm has summarized, in the following
table, the key data to be used in selecting the best group of projects.
a. Use the internal rate of return (IRR) approach to select the best group of projects.
b. Use the net present value (NPV) approach to select the best group of projects.
c. Compare, contrast, and discuss your findings in parts a and b.
d. Which projects should the firm implement? Why?
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Custom Writings Help is a Quality-Oriented Company in Online Writing as a result of hiring exceptional professionals to execute clients' tasks.
Essays
At Custom Writings Help,We understand the struggle of research paper writing, and that is why at Custom WritingS Help, we are all out to help you. We pride ourselves on having a team of clinical writers. The stringent and rigorous vetting process ensures that only the 'BEST' Writers are chosen for the job. We have highly qualified Ph.D. and MA writers working with us; we equally offer these experienced writers specific bonuses and incentives to make them deliver highly original, unique, and informative content at reasonably low prices.
Admissions
Thesis Writing Service
Worlwide, Many Masters Students are struggling with Thesis Completion. A thesis is likely to be the longest and most challenging piece of work a student has ever completed. However, unlike essays and other assignments, a student can pick a particular interest topic and work on their initiative. Fortunately, we are there for you. At Custom Writings Help, you are assured of an authentic, imaginative, informative, linguistically great, and advantageous thesis that adheres to all your needs. So, why continue considering different writers when you have discovered the best in the field?
Editing
Custom Papers
Not a single student can avoid writing custom papers. However, a total lack of experience, skills, and time makes it very hard to produce a superb writing piece. Therefore, if you are seeking professional help, turn to us. Our specialized and experienced writers compose a variety of model papers, including custom essays, college term papers, research papers, book reports, MBA essays, executive summaries, dissertations, Ph.D. theses, admission essays, and research proposals for college and university students at any level.
Coursework
Essay Writing
Most of the students disregard the critical principles of essay writing and compose papers below sensible guidelines. Therefore, with Custom Writings Help, one should not worry about his/her essay. Our Writers compose informative and engaging content on all complexities and topics. We write meaningful and smart essays while prioritizing all aspects that bring about a good grade, such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines.
Coursework
Coourse Work Writing
Don't let the seemingly never-ending onslaught of writing assignments get you down. If you are looking where to get course work assistance online, the writers at Custom Writings Help are here to assist you with all of your writing needs. We undertake to unique delivery of papers that meet the professor's requirements. The content is proofread, edited, and checked plagiarism before submission to customers. No matter how big or small your work is, we will deliver on time. Try US Now! !
Coursework
Dissertation Writing Service
High-Quality Dissertation Writing Services are rare. They require Ph.D. academicians – not easily found. However, are an exception. The years, time, and resources we have invested in the dissertation world has given us a competitive advantage over others. Choose to come to Custom Writings Help; You will find perfect Ph.D. consultants who have written hundreds of dissertations theses ready to help you. Let our dissertation-writing services help you craft your dissertation, for you are assured we will give you the results.