Purchase Solution

Calculating NPV and BEP for cash inflows in the given cases

Not what you're looking for?

Ask Custom Question

Break-even cash inflows and risk Pueblo Enterprises is considering investing in either of two mutually exclusive projects, X and Y. Project X requires an initial investment of $30,000; project Y requires $40,000. Each project's cash inflows are 5-year annuities: Project X's inflows are $10,000 per year; project Y's are $15,000. The firm has unlimited funds and, in the absence of risk differences, accepts the project with the highest NPV. The cost of capital is 15%.

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 Project X Project Y
$0 to $5,000 0% 5%
$5,000 to $7,500 10 10
$7,500 to $10,000 60 15
$10,000 to $12,500 25 25
$12,500 to $15,000 5 20
$15,000 to $20,000 0 15
Above $20,000

d. Which project is more risky? Which project has the potentially higher NPV? Discuss the risk-return tradeoffs 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 was achieving a higher NPV?

Purchase this Solution
Solution Summary

Solution describes the steps to calculate NPV and break even cash inflow for the given projects. It also discusses riskiness of the projects.

Solution Preview

a. Find the NPV for each project. Are the projects acceptable?

Project X
Initial cash flow= Io=-$30,000
Number of periods=n=5
Cost of capital=r=15%
Annual cash inflow=C=$10,000

NPV=Io+C/r*(1-1/(1+r)^n)
Plug in the various values
NPV = -30000+10000/15%*(1-1/(1+15%)^5)=$3521.55
Since NPV is positive, project is acceptable if considered independently.

Project Y
Initial cash flow= Io=-$40,000
Number of periods=n=5
Cost of capital=r=15%
Annual cash inflow=C=$15,000

NPV=Io+C/r*(1-1/(1+r)^n)
Plug in the various values
NPV = -40000+15000/15%*(1-1/(1+15%)^5)=$10,282.33

Since NPV is positive, project is acceptable if considered independently.

Since X and Y are mutually exclusive projects, Project Y should be selected because of higher NPV.

b. Find the break even cash inflow for each project.
Let break Even cash ...

Solution provided by:
Lokesh Jain, MSc
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Introduction to Finance

This quiz test introductory finance topics.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

View More Free Quizzes
Related BrainMass Solutions

  • Financial Management Concepts

    AS NOTHING IS MENTIONED I AM CALCULATING FOR ALL THE FOUR PROJECTS 5.

  • Investment Proposal: Calculating NPV for Varying Costs of Capital

    The cost of capital is 10% 1. For calculating NPV, let us calculate PV of cash inflows. In this case cash flows are the same in each year.

  • Calculating NPV and IRR for Investments

    The solution depicts the steps to calculate NPV and IRR values in the given cases with step-by-step calculations and all formulas shown.

  • Calculating Payback period and NPV

    *PV ordinary annuity factor for n=8 and rate=10%=52000*5.3349=277416 NPV=-142000+277416+10263=145679 c) NPV is a positive number, product should be accepted Solution describes the steps for calculating payback period and NPV for

  • Calculating the NPV in the given case

    591171 Calculating the NPV in the given case A project has annual cashflows of $10,500 for the next three years and then $20,000 each year for the following 12 years. The IRR for this project is 11%. It's WACC is 9%. What is the project NPV?

  • Five Finance Problems

    Determine the NVP for the project NPV is calculated by finding the present value of each cash flow, including both inflows and outflows, discounted at the project's cost of capital.

  • Capital Budgeting Models Statements

    PV of cash inflows=30000/(1+7%)^1+30000/(1+7%)^2+30000/(1+7%)^3+30000/(1+7%)^4+30000/(1+7%)^5=$123005.92 NPV=-105000+123005.92=18005.92 Answer "$18,006 " Solution determines the most appropriate option in the given cases.

  • NPV, Payback Period, IRR, Profitibility Index & Project NPV

    Calculating internal rate of return (IRR) for cash flows: Calculate the internal rate of return for the cash flows of the two projects in the table below. Problem 3.

  • Calculating Net Value Present and IRR

    381448 Calculating Net Value Present and IRR You will compare three projects. The following table lists each projects initial outlay (price of the project) in year 0 (zero). The following years are the cash inflows.

  • Calculating IRR and YTM

    The formula to use for calculating NPV is use the NPV function to get the discounted sum of cash inflows and add the initial investment to get the NPV. Using this formula the NPV profile has been made.

View More Related Solutions