Question

In: Finance

You are on a project selection committee and you have been tasked to find the NPV...

  1. You are on a project selection committee and you have been tasked to find the NPV of two potential projects, Project A and Project B. The cash flows and discount rates are as shown below.

Project A

Year

r

Cash Flow

Year 0

-$8,000

Year 1

5%

$5,000

Year 2

5%

$5,000

Project B

Year

r

Cash Flow

Year 0

-$1,000

Year 1

5%

$2,411.90

          

  You find that the NPV of both projects is $1,297.

  1. a. Can you make a decision based on the NPVs? Why or why not? (2 points)

  1. What is the projected ROI of Project A? (Hint: NPV is considered Net Income right?!) (2 points)

  1. What is the projected ROI of Project B? (2 points)

  1. Based on ROI which project would you choose and why? (3 points)

Solutions

Expert Solution

a) NPV calculations :

i (rate) = 5% or 0.05, n = no. Of year

Project A

Year Cash flow Present value (P V) factor (1/(1+i)^n) P.V. of cash flow (P.V. factor * Cash flow)
0 (-$8,000) 1 (-$8,000)
1 $5,000 (1/(1+0.05)^1) = 0.9524 $4,762
2 $5,000 (1/(1+0.05)^2) = 0.9070 $4,535
NPV $1,297

Project B

Year Cash flow P.V. factor (1/(1+i)^n) P.V. of cash flow (P.V. factor * Cash flow)
0 (-$1,000) 1 (-$1,000)
1 $2,411.90 (1/(1+0.05)^1) = 0.9524 $2,297
NPV $1,297

Decision : Based on NPV, decision can not be made. As both projects have same NPV. In this case we can use other methods for the purpose of decision making such as ROI method, Profitability index method or Payback period method.

b) ROI of project A = ( Net income or NPV / Cost of investment) * 100

Here,

NPV (calculated above) = $1,297

Cost of project A (given) = $8,000

Now,

ROI of project A = ($1,297 / $8,000) * 100

ROI of project A = 16.21%

c) ROI of project B = (Net income or NPV / Cost of investment) * 100

Here,

NPV (calculated above) = $1,297

Cost of project B (given) = $1,000

Now,

ROI of project B =( $1,297 / $1,000) * 100

ROI of project B = 129.70%

d) Based on ROI project B is to be choosen. As project B's ROI is much greater than project A.


Related Solutions

You are tasked with a process selection project. There are two processes (A and B) that...
You are tasked with a process selection project. There are two processes (A and B) that could potentially work for your application (cutting tubing to a specified length). Sample data is provided by the two companies. Out of the 16 samples from process A, you find an average of 17.92 inches and a standard deviation of 1.98 inches. Thirteen samples were taken from process B improvement and had an average length of 16.58 inches and a standard deviation of 1.30...
a committee of nurses have been tasked with reviewing an increase in central line infections on...
a committee of nurses have been tasked with reviewing an increase in central line infections on their unit. Explain the process that they should follow.
Implementation Committee: You have been assigned as the project manager of an EHR implementation at your...
Implementation Committee: You have been assigned as the project manager of an EHR implementation at your facility. Your first order of business is to select members for the implementation committee. At your first meeting, you will also be required to describe the importance of an implementation committee and provide an overview of key health information system concepts as they relate to successful system planning and implementation. In a document, write out your notes for the presentation you will give at...
Case Project Your represents the capital budgeting committee of a successful firm. You have been invited...
Case Project Your represents the capital budgeting committee of a successful firm. You have been invited to the next Board of Directors meeting to present your analysis and recommendation on a new capital project. Your presentation should contain the following: 1. Brief description of the proposed capital project 2. Estimation of the incremental cash flows related to the project 3. Estimation of the weighted average cost of capital 4. Financial evaluation of capital budget project (using NPV or IRR) 5....
Below is the data for the spreadsheet for a project selection model: Project              NPV (return)       cash...
Below is the data for the spreadsheet for a project selection model: Project              NPV (return)       cash investment personnel requirements 1              75,000                 30,000                          10 2              50,000                 45,000                          5 3              25,000                 75,000                          10 4              85,000                 30,000                          4 5              50,000                 45,000                          8 6              25,000                 75,000                          7 7              95,000                 45,000                          6 8              25,000                 60,000                          1 9              75,000                 30,000                          2 10            65,000                 45,000                          2 You have $250,000 to invest and 36 people. Maximize NPV by approving/rejecting projects. Multiple Choice #8: How many projects of the...
Congratulations! You have been appointed as a new product manager with Samsung and have been tasked...
Congratulations! You have been appointed as a new product manager with Samsung and have been tasked to introduce the latest smartphone in a new country. Choose and research a country other than the United States and India, and then formulate a plan to effectively integrate this product from a global and social standpoint. Speculate on the major challenges and opportunities you anticipate facing in this role. Provide a reference source.
imagine, or maybe you have been, that you are on an Ethics Committee at a large...
imagine, or maybe you have been, that you are on an Ethics Committee at a large hospital. “Your committee must make a very important decision. Seven patients (A. - G.) need a heart transplant. There is only one heart donor at this time. All of the patients are eligible to receive this heart. All are physically able. And all have compatible tissue and blood typing.” Patient Waiting List: A. 31 year old male; African American, brain surgeon at the height...
You are the HR manager for a new company and you have been tasked with developing...
You are the HR manager for a new company and you have been tasked with developing a concise employee manual for your new middle managers. This manual must help the managers understand certain HR initiatives so that they can recruit, select, and manager their staff effectively. The manual will consist of explaining and providing guidelines for best practices in the areas below. Explain the importance of a job description and briefly describe the necessary components Describe an effective recruiting process...
A new warehouse is to be constructed and you have been tasked to provide the initial...
A new warehouse is to be constructed and you have been tasked to provide the initial design. The warehouse is primarily used for pick/pack of grocery items with a small amount of frozen goods and some pharmaceuticals. Incoming goods are palletized and outgoing orders are as per the customers’ orders. The warehouse will contain some 8000 SKU’s with the majority considered, 80%, to be C class items. The building is only framed right now and is waiting on your design...
you are to find a business for sale, project the cash flows, and calculate the NPV...
you are to find a business for sale, project the cash flows, and calculate the NPV to determine whether the business is worth buying based on NPV and your overall evaluation. You may wish to visit a business broker website as they list businesses for sale, usually provide latest year cash flow and the price of the business. You need to: 1. Qualitatively assess the business. Why is it viable in the long run? If it’s not then choose another...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT