You are investing in a project that requires an initial
investment of $500,000. The project will last for 10 years with the
following additional cash flows (CF) at the end of each year:
If the discount rate is 10%, calculate the payback periods in
Excel for both the methods below;
Years
1
2
3
4
5
6
7
8
9
10
CF
-500,000
80,000
100,000
100,000
120,000
140,000
150,000
150,000
150,000
150,000
a) Payback Method [10]
b) Discounted Payback Method...