In: Finance
a) Paybck Period of the project Formula :
= Initial Investment / Annual Cash Flow
| Y0 | Y1 | Y2 | Y3 | Y4 | Y5 | |
| Intial Investment | -70000 | |||||
| Cash Flow | 15,500 | 15,500 | 15,500 | 15,500 | 15,500 | 
Intial Investment = -70,000
Annual Cash Flow = 15,500
Payback Period of the project = 70,000 / 15,500
= 4.52 Years.
b)
NPV = Cash flow / (1 + i)^t - Initial Investment.
I = 5.5% , T = Number of years
Please see the below table
| Y0 | Y1 | Y2 | Y3 | Y4 | Y5 | |
| Intial Investment | -70000 | |||||
| NPV | 14691.94 | 13926.01 | 13200.01 | 12511.86 | 11859.58 | |
| Cash Flow | 15,500 | 15,500 | 15,500 | 15,500 | 15,500 | 
NPV = 66,189.40
Intial Investment = 70,000
NPV = 66,189.40 - 70,000
= - 3810. / - 5.44%
NPV is negative, project gives negative return
c)
IRR = IRR is the rate in which NPV becomes zero, here it is 3%.
| Cash Flow | -70000 | 15,500 | 15,500 | 15,500 | 15,500 | 15,500 | 
| IRR | 3% | 
Based on the excel formula.
D) Based on the NPV, IRR and Payback period project can't be accepted.