You have the following projects available. Please fill in the missing space. You
ID: 2707363 • Letter: Y
Question
You have the following projects available. Please fill in the missing space. You can copy and paste the table onto a spreadsheet in Excel, and use Excel functions to solve the problem.
Project Cash Flows
Time Period
A
B
0
-$11,000
-$500,000
1
$7,000
$60,000
2
-$1,500
$90,000
3
$2,300
$170,000
4
$1,000
$230,000
5
$1,000
$205,000
6
-$300
$140,000
7
-$300
$110,000
8
-$300
$70,000
9
$400
$80,000
10
$400
Discount Rate
7.50%
8.00%
Payback Period
Discounted Payback
Profitability Index
NPV
IRR
Project Cash Flows
Time Period
A
B
0
-$11,000
-$500,000
1
$7,000
$60,000
2
-$1,500
$90,000
3
$2,300
$170,000
4
$1,000
$230,000
5
$1,000
$205,000
6
-$300
$140,000
7
-$300
$110,000
8
-$300
$70,000
9
$400
$80,000
10
$400
Discount Rate
7.50%
8.00%
Payback Period
Discounted Payback
Profitability Index
NPV
IRR