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/enus/excelhelp/npvHP005209199.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/enus/excelhelp/irrfunctionHP010342631.aspx)  
IRR _{B} = ???  
D) MIRR  
Cost of principal =  12%  Cost of principal =  18%  
MIRR _{A} = ???  MIRR _{A} = ???  (See http://office.microsoft.com/enus/excelhelp/mirrfunctionHP010342696.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: ???  