Future value propensity for life-time value financial processing in a relational database management system

• US 7,844,516 B1
• Filed: 08/20/2003
• Issued: 11/30/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): Kramer; James A
• Assistant Examiner(s): LEMIEUX, JESSICA
• Application Number:
  US10/644,171
• Time in Patent Office: 2,659 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, amounts and rates from account 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 Future Value (FV) calculations on the selected accounts by applying one or more FV propensity rules to the selected accounts and applying one or more FV attrition rules to results of the FV propensity rules using the selected amounts and rates, wherein the FV calculations determine a possible future profitability value of products that may be purchased in the future;

(c) wherein applying the FV propensity rules comprises matching the FV propensity rule against the selected accounts;

determining an initial propensity rate for the matched accounts;

calculating a rate change for the matched account;

calculating an effective propensity rate for each forecast period by applying the rate change to each initial propensity rate for each forecast period;

performing the FV propensity rule to calculate an FV amount from FV expected values and the effective propensity rates for each forecast period; and

storing the FV amount; and

(d) wherein the FV propensity rule is selected from a plurality of methods comprising Constant (no compounding), Constant (with compounding), Additive (no compounding), Additive (with compounding), Manual (no compounding), Manual (with compounding), Constant and Negative Compounding methods.

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

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

4. The method of claim 3, wherein the current profitability data is aggregated to provide an initial amount for the FV calculations.

5. The method of claim 1, wherein the selected amounts are forecast amounts.

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

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

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

9. The method of claim 1, wherein the FV propensity rule comprises a Constant (no compounding) method according to:

Amount_i=Amount₀*(1+R₀)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R₀=initial rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

10. The method of claim 1, wherein the FV propensity rule comprises a Constant (with compounding) method according to:

Amount_i=Amount₀*(1+R_m)ⁱ*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R_m=monthly rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

11. The method of claim 1, wherein the FV propensity rule comprises an Additive (no compounding) method according to:

Amount_i=Amount₀*(1+i*(R₀/12))*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R₀=initial rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

12. The method of claim 1, wherein the FV propensity rule comprises an Additive (with compounding) method according to:

Amount_i=Amount₀*(1+Compounded_Rate)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period,

j=first month in a forecast period,

k=last month in a forecast period, and

Compounded_Rate=Rate₁*Rate₂* . . . *Rate_i.

13. The method of claim 1, wherein the FV propensity rule comprises a Manual (no compounding) method according to:

Amount_i=Amount₀*(1+R_man)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R_man=manual rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

14. The method of claim 1, wherein the FV propensity rule comprises a Manual (with compounding) method according to:

Amount₁=Amount₀*(1+Compounded_Rate)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period,

j=first month in a forecast period,

k=last month in a forecast period, and

Compounded_Rate=Rate₁*Rate₂* . . . *Rate_i.

15. The method of claim 1, wherein the FV propensity rule comprises a Constant method according to:

Amount_i=Amount₀

Amount_i=calculated amount by forecast period,

Amount₀=initial amount, and

i=forecast period.

16. The method of claim 1, wherein the FV propensity rule comprises a Negative Compounding method according to:

Amount_i=Initial Forecast Amount*(Attrition Rate*(1−

Attrition Rate)ⁿ)

Amount_i=calculated amount by forecast period,

Amount₀°

=initial amount,

i=forecast period, and

n=amortization term.

17. A system for performing financial processing, comprising:

one or more computers;

logic, performed by the computers, for;

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

(b) performing one or more Future Value (FV) calculations on the selected accounts by applying one or more FV propensity rules to the selected accounts and applying one or more FV attrition rules to results of the FV propensity rules using the selected amounts and rates, wherein the FV calculations determine a possible future profitability value of products that may be purchased in the future;

(c) wherein applying the FV propensity rules comprises matching the FV propensity rule against the selected accounts;

determining an initial propensity rate for the matched accounts;

calculating a rate change for the matched account;

calculating an effective propensity rate for each forecast period by applying the rate change to each initial propensity rate for each forecast period;

performing the FV propensity rule to calculate an FV amount from FV expected values and the effective propensity rates for each forecast period; and

storing the FV amount; and

(d) wherein the FV propensity rule is selected from a plurality of methods comprising Constant (no compounding), Constant (with compounding), Additive (no compounding), Additive (with compounding), Manual (no compounding), Manual (with compounding), Constant and Negative Compounding methods.

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

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

20. The system of claim 19, wherein the current profitability data is aggregated to provide an initial amount for the FV calculations.

21. The system of claim 17, wherein the selected amounts are forecast amounts.

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

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

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

25. The system of claim 17, wherein the FV propensity rule comprises a Constant (no compounding) method according to:

Amount_i=Amount₀*(1+R₀)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R₀=initial rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

26. The system of claim 17, wherein the FV propensity rule comprises a Constant (with compounding) method according to:

Amount_i=Amount₀*(1+R_m)ⁱ*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R_m=monthly rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

27. The system of claim 17, wherein the FV propensity rule comprises an Additive (no compounding) method according to:

Amount_i=Amount₀*(1+i*(R₀/12))*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R₀=initial rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

28. The system of claim 17, wherein the FV propensity rule comprises an Additive (with compounding) method according to:

Amount_i=Amount₀*(1+Compounded_Rate)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period,

j=first month in a forecast period,

k=last month in a forecast period, and

Compounded_Rate=Rate₁*Rate₂* . . . *Rate_i.

29. The system of claim 17, wherein the FV propensity rule comprises a Manual (no compounding) method according to:

Amount_i=Amount₀*(1+R_man)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R_man=manual rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

30. The system of claim 17, wherein the FV propensity rule comprises a Manual (with compounding) method according to:

Amount_i=Amount₀*(1+Compounded_Rate)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period,

j=first month in a forecast period,

k=last month in a forecast period, and

Compounded_Rate=Rate₁*Rate₂* . . . *Rate_i.

31. The system of claim 17, wherein the FV propensity rule comprises a Constant method according to:

Amount_i=Amount₀

Amount_i=calculated amount by forecast period,

Amount₀=initial amount, and

i=forecast period.

32. The system of claim 17, wherein the FV propensity rule comprises a Negative Compounding method according to:

Amount_i=Initial Forecast Amount*(Attrition Rate*(1−

Attrition Rate)ⁿ)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period, and

n=amortization term.

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

(a) selecting, in one or more computers, accounts, amounts and rates from account 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 Future Value (FV) calculations on the selected accounts by applying one or more FV propensity rules to the selected accounts and applying one or more FV attrition rules to results of the FV propensity rules using the selected amounts and rates, wherein the FV calculations determine a possible future profitability value of products that may be purchased in the future;

(c) wherein the step of applying the FV propensity rules comprises matching the FV propensity rule against the selected accounts;

determining an initial propensity rate for the matched accounts;

calculating a rate change for the matched account;

calculating an effective propensity rate for each forecast period by applying the rate change to each initial propensity rate for each forecast period;

performing the FV propensity rule to calculate an FV amount from FV expected values and the effective propensity rates for each forecast period; and

storing the FV amount; and

(d) wherein the FV propensity rule is selected from a plurality of methods comprising Constant (no compounding), Constant (with compounding), Additive (no compounding), Additive (with compounding), Manual (no compounding), Manual (with compounding), Constant and Negative Compounding methods.

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

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

36. The article of claim 35, wherein the current profitability data is aggregated to provide an initial amount for the FV calculations.

37. The article of claim 33, wherein the selected amounts are forecast amounts.

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

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

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

41. The article of claim 33, wherein the FV propensity rule comprises a Constant (no compounding) method according to:

Amount_i=Amount₀*(1+R₀)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R₀=initial rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

42. The article of claim 33, wherein the FV propensity rule comprises a Constant (with compounding) method according to:

Amount_i=Amount₀*(1+R_m)ⁱ*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R_m=monthly rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

43. The article of claim 33, wherein the FV propensity rule comprises an Additive (no compounding) method according to:

Amount_i=Amount₀*(1+i*(R₀/12))*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R₀=initial rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

44. The article of claim 33, wherein the FV propensity rule comprises an Additive (with compounding) method according to:

Amount_i=Amount₀*(1+Compounded_Rate)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period,

j=first month in a forecast period,

k=last month in a forecast period, and

Compounded_Rate=Rate₁*Rate₂* . . . *Rate_i.

45. The article of claim 33, wherein the FV propensity rule comprises a Manual (no compounding) method according to:

Amount_i=Amount₀*(1+R_man)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

R_man=manual rate,

i=forecast period,

j=first month in a forecast period, and

k=last month in a forecast period.

46. The article of claim 33, wherein the FV propensity rule comprises a Manual (with compounding) method according to:

Amount_i=Amount₀*(1+Compounded_Rate)*((k−

j+1)/12)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period,

j=first month in a forecast period,

k=last month in a forecast period, and

Compounded_Rate=Rate₁*Rate₂* . . . *Rate_i.

47. The article of claim 33, wherein the FV propensity rule comprises a Constant method according to:

Amount_i=Amount₀

Amount_i=calculated amount by forecast period,

Amount₀=initial amount, and

i=forecast period.

48. The article of claim 33, wherein the FV propensity rule comprises a Negative Compounding method according to:

Amount_i=Initial Forecast Amount*(Attrition Rate*(1−

Attrition Rate)ⁿ)

Amount_i=calculated amount by forecast period,

Amount₀=initial amount,

i=forecast period, and

n=amortization term.