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?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter10: Capital Budgeting: Decision Criteria And Real Option
Section: Chapter Questions
Problem 15P
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
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage