Purchase Solution

# Project cash flow, NPV, IRR

Not what you're looking for?

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
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?

##### 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:
###### 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"

##### Change and Resistance within Organizations

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

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.