Match

When you want to analyse the break-even or payback period number in Excel use Match. = MATCH(lookup_value,lookup_array,match_type).

When you have a table of investment cash flows, create a row or column that sums cumulative cash flows including the investment.

Use Match to locate the period when cash flows payback the starting investment.

For example = Match(0, cell range,1) will locate the largest period number that is less than or equal to zero (the cumulative payback period).

Reference Pages

Name