Life-time value financial processing in a relational database management system

• US 7,835,958 B1
• Filed: 08/20/2003
• Issued: 11/16/2010
• Est. Priority Date: 08/20/2003
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Redweik, Peter Hans
• Primary Examiner(s): Karmis; Stefanos
• Assistant Examiner(s): LEMIEUX, JESSICA
• Application Number:
  US10/644,131
• Time in Patent Office: 2,645 Days
• Field of Search: 705/36, 705/35
• US Class Current: 705/35
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A Life-Time Value (LTV) system is a data-driven computer-facilitated financial model that provides accurate and consistent profitability projections using current period account level profitability data stored in a Relational Database Management System (RDBMS). The Life-Time Value system performs Net Present Value (NPV) and Future Value (FV) processing using business-rule and data-driven applications that embrace the current period profit components, defines forecast periods, parameters and methodologies, and applies appropriate growth values, attrition values and propensity values to an object of future value interest.

Claims

1. A method of performing financial processing, comprising:

(a) selecting, in one or more computers, accounts, forecast amounts, attrition rates and propensity rates from data stored in a database using selection criteria specified by one or more rules; and

(b) performing, in one or more computers, one or more Net Present Value (NPV) and one or more Future Value (FV) calculations on the selected accounts for one or more forecast periods according to the rules using the selected forecast amounts, the attrition rates and the propensity rates, wherein;

(1) performing the NPV calculations comprises calculating forecast amounts for each forecast period for the selected accounts, applying attrition rates to the calculated forecast amounts to arrive at NPV expected values, and calculating an NPV amount by combining the NPV expected values for each forecast period and discounting the combined NPV expected values; and

(2) performing the FV calculations comprises calculating propensity amounts for each forecast period for the selected accounts using the propensity rates, applying the attrition rates to the calculated propensity amounts to arrive at FV expected values, and calculating an FV amount by discounting the FV expected values for each forecast period and summing the discounted FV expected values;

(c) wherein the NPV and FV amounts are combined to provide a Life-Time Value (LTV) for the selected accounts for presentation by one or more computers to a user for financial analysis of the LTV.

2. The method of claim 1, wherein the NPV is a net present profitability value.

3. The method of claim 1, wherein the FV is a possible future profitability value.

4. The method of claim 1, wherein the selected accounts contain current profitability values.

5. The method of claim 1, wherein the rules are defined by a user.

6. The method of claim 1, wherein the selected attrition rates are NPV attrition rates.

7. The method of claim 1, wherein the selected propensity rates are FV propensity rates.

8. The method of claim 1, wherein the selected attrition rates are FV attrition rates.

9. The method of claim 1, wherein the current profitability data is aggregated to provide an initial amount for the NPV and FV calculations.

10. The method of claim 1, wherein a user specifies the one or more forecast periods over which the NPV and FV calculations are performed.

11. The method of claim 1, wherein a user specifies one or more rates for the forecast periods.

12. The method of claim 1, wherein the forecast amounts are based on the selected accounts'"'"' contractual data.

13. The method of claim 1, wherein the forecast amounts are based on forecast assumptions applied to the selected accounts.

14. The method of claim 1, wherein the step of calculating the NPV amount comprises:

15. The method of claim 1, wherein the step of calculating the FV amount comprises:

16. The method of claim 1, wherein the results from the NVP and FV calculations are integrated by:

summing the FV amounts across the forecast periods to arrive at a single FV amount;

aggregating the FV amounts to arrive at a final FV amount; and

adding the final FV amount to an NPV amount to arrive at an LTV amount.

17. A system for performing financial processing, comprising:

one or more computers;

means, performed by the computers, for;

(a) selecting accounts, forecast amounts, attrition rates and propensity rates from data stored in a database using selection criteria specified by one or more rules; and

(b) performing one or more Net Present Value (NPV) and one or more Future Value (FV) calculations on the selected accounts for one or more forecast periods according to the rules using the selected forecast amounts, the attrition rates and the propensity rates, wherein;

(1) performing the NPV calculations comprises calculating forecast amounts for each forecast period for the selected accounts, applying attrition rates to the calculated forecast amounts to arrive at NPV expected values, and calculating an NPV amount by combining the NPV expected values for each forecast period and discounting the combined NPV expected values; and

(2) performing the FV calculations comprises calculating propensity amounts for each forecast period for the selected accounts using the propensity rates, applying the attrition rates to the calculated propensity amounts to arrive at FV expected values, and calculating an FV amount by discounting the FV expected values for each forecast period and summing the discounted FV expected values;

(c) wherein the NPV and FV amounts are combined to provide a Life-Time Value (LTV) for the selected accounts for presentation by one or more computers to a user for financial analysis of the LTV.

18. The system of claim 17, wherein the NPV is a net present profitability value.

19. The system of claim 17, wherein the FV is a possible future profitability value.

20. The system of claim 17, wherein the selected accounts contain current profitability values.

21. The system of claim 17, wherein the rules are defined by a user.

22. The system of claim 17, wherein the selected attrition rates are NPV attrition rates.

23. The system of claim 17, wherein the selected propensity rates are FV propensity rates.

24. The system of claim 17, wherein the selected attrition rates are FV attrition rates.

25. The system of claim 17, wherein the current profitability data is aggregated to provide an initial amount for the NPV and FV calculations.

26. The system of claim 17, wherein a user specifies the one or more forecast periods over which the NPV and FV calculations are performed.

27. The system of claim 17, wherein a user specifies one or more rates for the forecast periods.

28. The system of claim 17, wherein the forecast amounts are based on the selected accounts'"'"' contractual data.

29. The system of claim 17, wherein the forecast amounts are based on forecast assumptions applied to the selected accounts.

30. The system of claim 17, wherein the logic for calculating the NPV amount comprises:

31. The system of claim 17, wherein the logic for calculating the FV amount comprises:

32. The system of claim 17, wherein the results from the NVP and FV calculations are integrated by:

summing the FV amounts across the forecast periods to arrive at a single FV amount;

aggregating the FV amounts to arrive at a final FV amount; and

adding the final FV amount to an NPV amount to arrive at an LTV amount.

33. An article of manufacture comprising a storage device embodying instructions that, when read and executed by one or more computers, results in the computers performing a method of financial processing, the method comprising:

(a) selecting, in one or more computers, accounts, forecast amounts, attrition rates and propensity rates from data stored in a database using selection criteria specified by one or more rules; and

(b) performing, in one or more computers, one or more Net Present Value (NPV) and one or more Future Value (FV) calculations on the selected accounts for one or more forecast periods according to the rules using the selected forecast amounts, the attrition rates and the propensity rates, wherein;

(1) performing the NPV calculations comprises calculating forecast amounts for each forecast period for the selected accounts, applying attrition rates to the calculated forecast amounts to arrive at NPV expected values, and calculating an NPV amount by combining the NPV expected values for each forecast period and discounting the combined NPV expected values; and

(2) performing the FV calculations comprises calculating propensity amounts for each forecast period for the selected accounts using the propensity rates, applying the attrition rates to the calculated propensity amounts to arrive at FV expected values, and calculating an FV amount by discounting the FV expected values for each forecast period and summing the discounted FV expected values;

(c) wherein the NPV and FV amounts are combined to provide a Life-Time Value (LTV) for the selected accounts for presentation by one or more computers to a user for financial analysis of the LTV.

34. The article of claim 33, wherein the NPV is a net present profitability value.

35. The article of claim 33, wherein the FV is a possible future profitability value.

36. The article of claim 33, wherein the selected accounts contain current profitability values.

37. The article of claim 33, wherein the rules are defined by a user.

38. The article of claim 33, wherein the selected attrition rates are NPV attrition rates.

39. The article of claim 33, wherein the selected propensity rates are FV propensity rates.

40. The article of claim 33, wherein the selected attrition rates are FV attrition rates.

41. The article of claim 33, wherein the current profitability data is aggregated to provide an initial amount for the NPV and FV calculations.

42. The article of claim 33, wherein a user specifies the one or more forecast periods over which the NPV and FV calculations are performed.

43. The article of claim 33, wherein a user specifies one or more rates for the forecast periods.

44. The article of claim 33, wherein the forecast amounts are based on the selected accounts'"'"' contractual data.

45. The article of claim 33, wherein the forecast amounts are based on forecast assumptions applied to the selected accounts.

46. The article of claim 33, wherein the step of calculating the NPV amount comprises:

47. The article of claim 33, wherein the step of calculating the FV amount comprises:

48. The article of claim 33, wherein the results from the NVP and FV calculations are integrated by:

summing the FV amounts across the forecast periods to arrive at a single FV amount;

aggregating the FV amounts to arrive at a final FV amount; and

adding the final FV amount to an NPV amount to arrive at an LTV amount.