Pleaes provide excel functions to fill missing cells ( ??? ): Flower Engineering is considering two


Pleaes furnish exceed employments to expand damage cells ( ??? ):

Flower Engineering is because two mutually odious investments. The projects' expected net coin flows are as follows:
Expected Net Coin Flows
Time Project A Project B
0 ($375) ($575)
1 ($300) $200
2 ($200) $200
3 ($100) $200
4 $600 $200
5 $600 $200
6 $975 $200
7 ($200) $0
Part 1:
A) Net Present Value
Cost of principal = 12% Cost of principal = 18%
NPV A = ??? NPV A = ??? (See specimen 2 at http://office.microsoft.com/en-us/excel-help/npv-HP005209199.aspx)
NPV B = ??? NPV B = ???
B) NPV Profiles and Graph
WACC Project A Project B
0% ??? ???
2% ??? ???
4% ??? ???
6% ??? ???
8% ??? ???
10% ??? ???
12% ??? ???
14% ??? ???
16% ??? ???
18% ??? ???
20% ??? ???
22% ??? ???
24% ??? ???
26% ??? ???
28% ??? ???
30% ??? ???
Part 2:
C) IRR
IRR A = ??? (See http://office.microsoft.com/en-us/excel-help/irr-function-HP010342631.aspx)
IRR B = ???
D) MIRR
Cost of principal = 12% Cost of principal = 18%
MIRR A = ??? MIRR A = ??? (See http://office.microsoft.com/en-us/excel-help/mirr-function-HP010342696.aspx)
MIRR B = ??? MIRR B = ???
Part 3:
E) Regular Payback
Project A
Time period 0 1 2 3 4 5 6 7
Cash flow (375) (300) (200) (100) 600 $600 $975 ($200)
Cumulative coin flow ??? ??? ??? ??? ??? ??? ??? ???
Payback ???
Project B
Time period 0 1 2 3 4 5 6 7
Cash flow (575) 200 200 200 200 $200 $200 $0
Cumulative coin flow ??? ??? ??? ??? ??? ??? ??? ???
Payback ???
F) Discounted Payback
Cost of principal = 12%
Project A
Time period 0 1 2 3 4 5 6 7
Cash flow (375) (300) (200) (100) 600 $600 $975 ($200)
Disc. coin flow ??? ??? ??? ??? ??? ??? ??? ???
Disc. cum. coin flow ??? ??? ??? ??? ??? ??? ??? ???
Discounted Payback ???
Project B
Time period 0 1 2 3 4 5 6 7
Cash flow (575) 200 200 200 200 $200 $200 $0
Disc. coin flow ??? ??? ??? ??? ??? ??? ??? ???
Disc. cum. coin flow ??? ??? ??? ??? ??? ??? ??? ???
Discounted Payback ???
G) Profitability Index
Cost of principal = 12%
NPV of advenient coin flows for A: ??? Hint: Use the NPV employment for all coin flows excluding the judicious consume
Initial consume for A: ???
PI of A: ??? Hint: Use the NPV of advenient coin flows / Initial cost
PV of advenient coin flows for B: ???
Initial consume for A: ???
PI of B: ???