In: Finance
| a | ||||||||
| Present Value (PV)of Cash flow= | ||||||||
| (Cash flow0/((1+i)^N) | ||||||||
| i= discount rate =15%=0.15 | ||||||||
| N= Year of cash flow | ||||||||
| Payback Preriod =Period when Cumulative Cash Flow=NIL | ||||||||
| Discounted Payback Preriod =Period when Cumulative Present Value of Cash Flow=NIL | ||||||||
| N | A | B | C=A/(1.15^N) | D | ||||
| ($ Million) | ||||||||
| Year | Cash Flow | Cumulative Cash Flow | PV of Cash Flow | CumulativePV of Cash Flow | ||||
| 0 | ($10) | ($10) | ($10) | ($10) | ||||
| 1 | $1 | ($9) | $0.87 | ($9.13) | ||||
| 2 | $4 | ($5) | $3.02 | ($6.11) | ||||
| 3 | $6 | $1 | $3.95 | ($2.16) | ||||
| 4 | $2 | $3 | $1.14 | ($1.02) | ||||
| 5 | $1 | $4 | $0.50 | ($0.52) | ||||
| Payback Preriod =2+(5/6)= | 2.83 | YEARS | ||||||
| Total of Discounted Cash Inflow | $9.84 | (0.87+3.02+3.95+1.14+0.50) | ||||||
| Hence , Discounted Payback is higher 5 years | ||||||||
| (b) | ADJUSTMENT TO PAYBACK AND DISCOUNTED PAYBACK | |||||||
| Discount Rate=2%=0.02 | ||||||||
| N | A | B | C=A/(1.02^N) | D | ||||
| ($ Million) | ||||||||
| Year | Cash Flow | Cumulative Cash Flow | PV of Cash Flow | CumulativePV of Cash Flow | ||||
| 0 | ($10) | ($10) | ($10) | ($10) | ||||
| 1 | $1 | ($9) | $0.98 | ($9.02) | ||||
| 2 | $4 | ($5) | $3.84 | ($5.17) | ||||
| 3 | $6 | $1 | $5.65 | $0.48 | ||||
| 4 | $2 | $3 | $1.85 | $2.33 | ||||
| 5 | $1 | $4 | $0.91 | $3.23 | ||||
| PAYBACK PERIOD: NO ADJUSTMENT | ||||||||
| DISCOUNTED PAYBACK=(2+(5.17/5.65) | 2.92 | Years | ||||||