| | Enter values in blue cells to complete the CLV table | | | | | | Year # |
| Segment 1 | | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Annual Margin | | | | | | Margin Earned | $0 |
| Retention Rate | | | | | | Cumulative Retention Rate | 1 | 0.00 |
| Discount Rate | | | | | | Cumulative Discount Rate | 1.00 | 1.00 |
| | | | | | | Present Value in Year | $0.00 | | | | | | | | | | | Check with CLV formula: |
| | | | | | | Cumulative NPV | $0.00 | $0.00 | | | | | | | | | | $0.00 |
| | | | | | | | Year # |
| Segment 2 | | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Annual Margin | | | | | | Margin Earned | $0 |
| Retention Rate | | | | | | Cumulative Retention Rate | 1 | 0.00 |
| Discount Rate | | | | | | Cumulative Discount Rate | 1.00 | 1.00 |
| | | | | | | Present Value in Year | $0.00 | | | | | | | | | | | Check with CLV formula: |
| | | | | | | Cumulative NPV | $0.00 | $0.00 | | | | | | | | | | $0.00 |
| | | | | | | | Year # |
| Segment 3 | | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Annual Margin | | | | | | Margin Earned | $0 |
| Retention Rate | | | | | | Cumulative Retention Rate | 1 | 0.00 |
| Discount Rate | | | | | | Cumulative Discount Rate | 1.00 | 1.00 |
| | | | | | | Present Value in Year | $0.00 | | | | | | | | | | | Check with CLV formula: |
| | | | | | | Cumulative NPV | $0.00 | $0.00 | | | | | | | | | | $0.00 |
lineage9527
MR2.xlsx
