Capital Budgeting

BioMed Engineering 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 ($405) ($705)

1 ($285) $200

2 ($205) $205

3 ($105) $210

4 $605 $215

5 $650 $220

6 $925 $225

7 ($200) $230

In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions.

Part 3: Payback and PI

G. Calculate the cumulative cash flows and the payback for project A. (7 points)

H. Calculate the cumulative cash flows and the payback for project B. (7 points)

I. Calculate the profitability index for project A. Note to exclude the initial cost from the NPV of future cash flows. (7 points)

J. Calculate the profitability index for project B. Note to exclude the initial cost from the NPV of future cash flows. (7 points)

Part 3:

G) Payback Project A

Time period	0	1	2	3	4	5	6	7
Cash flow	-$405.00	-$285.00	-$205.00	-$105.00	$605.00	$650.00	$925.00	-$200.00
Cumulative cash flow
Payback

H) Payback Project B

Time period	0	1	2	3	4	5	6	7
Cash flow	-$705.00	$200.00	$205.00	$210.00	$215.00	$220.00	$225.00	$230.00
Cumulative cash flow
Payback

I) Profitability Index Project A

Cost of capital =	12%
NPV of future cash flows:
Initial cost for A:
PI of A:

J) Profitability Index Project B

Cost of capital =	12%
NPV of future cash flows:
Initial cost for A:
PI of B: