Skip to main content

Formulas

Note

For PBP,NPV,PI,IRR, Cash flows are considered after tax but before depreciation.

For ARR, Cash flows are considered after tax and after depreciation.

ParticularAmount
Cash FlowXXX
(-) DepreciationXXX
Cash Flow after DepreciationXXX
(-) TaxXXX
Cash Flow after TaxXXX (for ARR)
(+) DepreciationXXX
Cash Flow after Tax and DepreciationXXX (for PBP , NPV , PI , IRR)

Payback Period

Uniform Cash Flows

Payback period is the time required to recover the Original investment in a project. It is calculated as follows:

[ \text{Payback Period} = \frac{\text{Original Investment}}{\text{Annual Cash Flow}} ]

Non-Uniform Cash Flows

When the cash flows are not uniform, the payback period is calculated as follows:

YearsCash InflowsCumulative Cash Flow
1A1A1
2A2A1 + A2
3A3A1 + A2 + A3
4A4A1 + A2 + A3 + A4
5A5A1 + A2 + A3 + A4 + A5

[\text{Payback Period} = \text{Year before full recovery} + \left(\frac{\text{Unrecovered cost at the beginning of the year}}{\text{Cash flow during the year}}\right)]


Net Present Value (NPV)

YearCash InflowP/v FactorPresent Value of Cash Inflow
1A11/(1+r)A1/(1+r)
2A21/(1+r)2A2/(1+r)2
3A31/(1+r)3A3/(1+r)3
4A41/(1+r)4A4/(1+r)4
5A51/(1+r)5A5/(1+r)5

NPV = Sum of Present Value of Cash Inflows - Original Investment


Profitability Index (PI)

Similar to NPV, but it is expressed as a ratio of present value of cash inflows to the original investment.

PI = Sum of Present Value of Cash Inflows / Original Investment


Internal Rate of Return (IRR)

Discount Factor = Original Investment / Sum of Present Value of Cash Inflows

\text{IRR} = A + \frac{cC-O}{C-D} \cdot (B - A)

Where:

A = Lower discount rate

B = Higher discount rate

C = Sum of Present Value of Cash Inflows at A

D = Sum of Present Value of Cash Inflows at B

O = Original Investment