Question

Year 0 1 2 3 4 5 6 Project A CF -350 -250 175 225 375...

Year

0

1

2

3

4

5

6

Project A CF

-350

-250

175

225

375

450

125

Project B CF

-1000

125

250

300

550

500

200

WACC = 12%

a. Calculate the NPV of Project A.?

b. Calculate the IRR of Project A.?

c. Calculate the MIRR of Project A.?

d. Calculate the Payback Period for Project B.?

e. Calculate the Discounted Payback Period for Project B.?

f. Calculate the EAA for Project B.?

g. Calculate the crossover rate for Projects A and B.?

Homework Answers

Answer #1
Year A B DCF A DCF B A - B
0 -350 -1000 -350 -1000 650
1 -250 125 -223 112 -375
2 175 250 140 199 -75
3 225 300 160 214 -75
4 375 550 238 350 -175
5 450 500 255 284 -50
6 125 200 63 101 -75
NPV $283.44 $259.01
IRR 25.73% 19.47%
MIRR 19.76% 16.38%
Payback 3.53 3.59
Dis. PBP 4.14 4.44
EAA $68.94 $63.00
Crossover 10.16%

NPV and IRR can be calculated using the same function in excel or calculator

Payback Period is the no. of years it takes to recover the initial investment.

Discounted Payback Period (Dis. PBP) is similar to the payback period but with discounted cash flows (DCF) of the project. DCF = CF / (1 + r)^n

EAA can be calculated using PMT function in excel or calculator.

Crossover rate is the IRR of difference in cash flows of A and B.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
QUESTION 1 Year Cash flow 0 -1075 1 350 2 450 3 375 4 300 A...
QUESTION 1 Year Cash flow 0 -1075 1 350 2 450 3 375 4 300 A firm is evaluating a potential capital expenditure project. The project will last for 4 years and has the above expected cash flows. The firm has a WACC of 15%. What is the project's NPV? If NPV is negative, enter the number with a minus sign. Use 2 decimal places Year Cash flow 0 -1075 1 350 2 450 3 375 4 300 The firm...
ABC Corporation is considering a project that provides the following cash flows steam: Year 0 1...
ABC Corporation is considering a project that provides the following cash flows steam: Year 0 1 2 3 4 5 Cash flows -$1,000 $375 $425 $250 $110 $100 If WACC is 10%, what is NPV and should the company accept the project? Find IRR, MIRR, payback, and discounted payback period. Considering the following projects. Project Year 0 1 2 3 4 A Cash flows -$100 $35 $35 $35 $35 B Cash flows -$100 $60 $50 $40 $30 Project A has...
ABC Corporation is considering a project that provides the following cash flows steam: Year 0 1...
ABC Corporation is considering a project that provides the following cash flows steam: Year 0 1 2 3 4 5 Cash flows -$1,000 $375 $425 $250 $110 $100 If WACC is 10%, what is NPV, and should the company accept the project? Find IRR, MIRR, payback, and discounted payback period.
A project has the following annual net cash flows: Year 0: -19,000 Year 1: 8,000 Year...
A project has the following annual net cash flows: Year 0: -19,000 Year 1: 8,000 Year 2: 11,000 Year 3: 6,000 Year 4: 4,500 1.The firm's WACC is 14%. Calculate IRR. 2. Calculate MIRR for the project in the previous problem. 3. Calculate the project's NPV. (Round to the nearest cent) 4. Calculate the project's EAA. 5. Calculate the project's payback period. 6. Calculate the project's discounted payback period. (Round to two decimal places)
Consider the following two projects: Project Year 0 CF Year 1 CF Year 2 CF Year...
Consider the following two projects: Project Year 0 CF Year 1 CF Year 2 CF Year 3 CF Year 4 CF Cost of capital A -100 40 50 60 10 15% B -73 30 30 30 30 15% The IRR of project A =? maybe round this one to the closest? A) 7.7% B) 21.6% C) 23.3% D) 42.9% The IRR of project B =? A) 21.6% B) 23.3% C) 42.9% D) 7.7% Which of the following statements is correct?...
11-1 If Company XYZ plans to invest in a project with initial capital outlay $52,125, annual...
11-1 If Company XYZ plans to invest in a project with initial capital outlay $52,125, annual net cash inflow $12,000 for 8 years, and discount rate 12%, what is the Company XYZ’s NPA? 11-2 For the Company XYZ’s same project as in 11-1, what is the IRR for the project? There are two projects: Project A and Project B Project A: CF0 = -6000; CF1-5 = 2000; I/YR = 14. Calculate NPV, IRR, MIRR, Payback period, and discounted payback period...
Given: Year 0 1 2 3 4 Project A $-350 $50 $100 $150 $200 Project B...
Given: Year 0 1 2 3 4 Project A $-350 $50 $100 $150 $200 Project B $-250 $125 $100 $75 $50 Hurdle rate = 10%, Use incremental IRR analysis to decide whether you should take project A instead of project B.
1. tapley dental is considering a project that has the following cash/WACC data. what is the...
1. tapley dental is considering a project that has the following cash/WACC data. what is the npv? wacc-8 percent year 0: -1000 yr 1- 300 yr 2-300 yr 3-300 yr 4-300 yr 5-300 2. blanchford enterprises is considering a project that has the following cash flow data. what is the project’s irr? year 0: -1099.67 year 1: 450 year 2: 450 year 3: 450 3. Reynolds bikes is considering a project with the following cash flow and wacc data. wacc-10...
Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows Time Project A Project B 0 ($375) ($575) 1 ($300) $190 2 ($200) $190 3 ($100) $190 4 $600 $190 5 $600 $190 6 $926 $190 7 ($200) $0 a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? @ 12% cost...
0 1 2 3 4 CFS ($1,025) $650 $450 $250 $50 CFL ($1,025) $100 $300 $500...
0 1 2 3 4 CFS ($1,025) $650 $450 $250 $50 CFL ($1,025) $100 $300 $500 $700 What is the crossover rate that makes NPV of CFs and CFL equalized?