# Calculating NPV, IRR and MIRR of given project

Project A has a WACC of 10% and the following cash flows:

Project A

Year Cash Flow

0 -$300

1 100

2 150

3 200

4 50

2. What is Project A's NPV?

a. $ 21.32

b. $ 66.26

c. $ 83.00

d. $ 99.29

e. $112.31

3. What is Project A's IRR?

a. 13.44%

b. 16.16%

c. 18.92%

d. 24.79%

e. 26.54%

4. What is Project A's MIRR?

a. 7.40%

b. 12.15%

c. 14.49%

d. 15.54%

e. 18.15%.

https://brainmass.com/business/modified-internal-rate-of-return/calculating-npv-irr-mirr-project-286448

#### Solution Preview

Please refer attached file for better clarity of formulas in Ms Excel.

Solution:

Project's NPV?

Year End(n) Cash flow (C) PV=C/(1+10^)^n

0 -300 -300.00

1 100 90.91

2 150 123.97

3 ...

#### Solution Summary

Solution describes the steps to calculate NPV, IRR and MIRR of given project.

$2.19