b) A construction company has identified the following two mutually exclusive projects. The company used 10% discount rate Cash flows (Project A) ($100,000) 50,000 40,000 30,000 30,000 Cash flows (Project B) ($100,000) Year 1 40,000 40,000 40,000 40,000 3 4 Calculate Net Present Value and Actual Rate of return for both the projects. How will you evaluate each project using these project evaluation methods?

Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter12: Capital Budgeting: Decision Criteria
Section: Chapter Questions
Problem 10P: Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year...
icon
Related questions
Question
b) A construction company has identified the following two mutually exclusive projects. The
company used 10% discount rate
Cash flows (Project A)
($100,000)
50,000
40,000
30,000
30,000
Cash flows (Project B)
($100,000)
Year
1
40,000
40,000
40,000
40,000
3
4
Calculate Net Present Value and Actual Rate of return for both the projects. How will you evaluate each
project using these project evaluation methods?
Transcribed Image Text:b) A construction company has identified the following two mutually exclusive projects. The company used 10% discount rate Cash flows (Project A) ($100,000) 50,000 40,000 30,000 30,000 Cash flows (Project B) ($100,000) Year 1 40,000 40,000 40,000 40,000 3 4 Calculate Net Present Value and Actual Rate of return for both the projects. How will you evaluate each project using these project evaluation methods?
Expert Solution
Step 1

Calculation of Net present value and IRR:

Excel spreadsheet:

Finance homework question answer, step 1, image 1

Step 2

Excel workings:

Finance homework question answer, step 2, image 1

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning