Purchase Solution

Project cash flow, NPV, IRR

Not what you're looking for?

Ask Custom Question

A not for profit business is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000, has an expected life of five years and an estimated salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year for each year of the projects life. On average, each procedure is expected to generate $80 in cash collections during the first year of use. Thus, revenues for Year 1 are estimated at 15 x 250 x $80 = $300,000.
Labor and maintenance costs are expected to be $100,000 during the first year of operation, while utilities will cost another $10,000 and cash overhead will increase by $5000 in Year 1. The cost for expendable supplies is expected to average $5 per procedure during the first year. All costs and revenues are expected to increase at a 5% inflation rate after the first year.
The center's corporate cost of capital is 10%.
a. Estimate the project's net cash flows over its five-year estimated life. Use the following as a guide:

Year
0 1 2 3 4 5

Equipment cost
Net revenues
Less: Labor/maint. Costs
Utilities costs
Supplies
Incremental overhead
Operating income
Equipment salvage value
Net cash flow

b. What are the project's NPV and IRR (assume average risk for the project)?
c. Assume the project is assessed to have high risk and the institution subtracts 3% points to adjust for project risk. Now, what is the project's NPV? Does the risk assessment change how the project's IRR is interpreted?

Purchase this Solution
Solution Summary

Your tutorial computes NPV and IRR for the project (ignoring taxes because it is a non-profit organization). The NPV is computed using two different discount rates. NPV and IRR are computed using the functions in Excel. Click in cells to see formula.

Solution Preview

What are the project's NPV and IRR (assume average risk for the project)?

See excel for computations (attached). Click in cells to see formula.

Assume the project is assessed to have high risk and the institution subtracts 3% points to adjust for project risk. Now, what is the project's NPV?

See NPV using the discount rate that includes risk premium above cost of ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

IPOs

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

Operations Management

This quiz tests a student's knowledge about Operations Management

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

View More Free Quizzes
Related BrainMass Solutions

  • NPV and IRR

    208763 NPV and IRR A project has the following cash flows: Year Cash Flow 0 $65,200 1 -31,200 2 -49,100 Required: (a)What is the IRR for this project? (Do not include the percent sign (%).

  • Capital Budgeting - Payback, NPV, PI, IRR

    3: Suppose the cash flow for a project is as follows: Initial investment = $10,000 Year 1-5 cash inflows: Year Cash flow 1 $2,000 2 $2,500 3 $3,000 4 $3,500 5 $4,000 Calculate the NPV.

  • Discounted Payback, IRR

    ) IRR is the discount rate at which NPV is ZERO Project A IRR (Internal rate of return) is calculated using Excel function IRR Year Cash flow

  • NPV & IRR

    Project B because of higher NPV b. Project A because of higher NPV c. Project A because of higher IRR d. Project B because of higher IRR e. Neither, because both projects have IRRs less than the cost of capital Please show all work.

  • NPV & IRR - Anderson International Limited

    175524 NPV & IRR - Anderson International Limited NPV and IRR Anderson International Limited is evaluating a project in Erewhon.

  • Projected IRR can be less than the WACC

    The projects IRR increases as the WACC declines. Question 2 1. Blanchford Enterprises is considering a project that has the following cash flow data. What is the project's IRR?

  • ABC Widgets

    NPV = sum of CFt where CF is the cash flow (1 + IRR)t IRR is the internal rate of return t is the period.

  • NPV and IRR

    =-6750*1 1 $4,500 0.5 2,250 =4500*0.5 2 $18,000 0.25 4,500 =18000*0.25 NPV= $0 NPV = $0 Answer: $0 B) IRR = 100% as at this discount rate, NPV=0 Calculates NPV and IRR of the project.

  • Walker Landscaping Company end of year cash flows

    NPV = sum of CFt where CF is the cash flow (1 + IRR)t IRR is the internal rate of return t is the period.

  • Calculating Payback, NPV and IRR

    Since the cash flow is constant, the payback period is simply the total cost divided by the cash flow. That is 52125/12000 = 4.34 (years) b. What is the project's NPV? Its IRR?

View More Related Solutions