Loan Simulation Method And System

• US 20070288357A1
• Filed: 05/06/2005
• Published: 12/13/2007
• Est. Priority Date: 05/07/2004
• Status: Abandoned Application

• Current Assignee: Go Figure Calculators Pty Limited
• Original Assignee: Etracka Pty Limited
• Inventors: Holman, Peter, Reiach, Craig, Wood, Brian, Veitch, Gary, Brieger, Geoffrey
• Application Number:
  US11/568,800
• Publication Number:
  US 20070288357A1
• Time in Patent Office: Days
• US Class Current: 705/38
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof

Abstract

A method (300) of simulating for a borrower the performance of a loan, which loan contains a plurality of loan portions wherein each loan portion has different loan parameters, which borrower may verify their identity (302) and enter/update borrower details (304) as required. The method includes the steps of: inputting income information (306) about income of the borrower; inputting asset information and liability information (308) about assets and liabilities of the borrower; inputting expenditure information (310) about expenditure of the borrower; inputting loan parameter information (314) about the amount, interest rate, repayment mode and term of each of said plurality of portions of the loan; providing assumptions about future market conditions effecting the loan; calculating a flow of funds (318) available for repayment of each portion of the loan according to the borrower income, the borrower expenditure, the borrower assets and liabilities, and the loan parameter information and producing a simulation of loan balance according to the flow of funds and the assumptions about future market conditions, for display and/or printing (320). An on-line subscriber system (100) and application software (200) enabling users to conduct assessment and ongoing management of loans and similar finance products according to the method are also disclosed.

Claims

1. A method of simulating for a borrower the performance of a loan, which loan contains a plurality of loan portions wherein each loan portion has different loan parameters, the method comprising:

inputting income information about income of the borrower;

inputting expenditure information about expenditure of the borrower;

inputting asset information and liability information about assets and liabilities of the borrower;

inputting loan parameter information about the amount, interest rate, repayment mode and term of each of said plurality of portions of the loan;

providing assumptions about future market conditions affecting the loan;

calculating a flow of funds available for repayment of each portion of the loan according to the borrower income, the borrower expenditure, the borrower assets and liabilities, and the loan parameter information; and

producing a simulation of loan balance according to the flow of funds and the assumptions about future market conditions.

2. The simulation method of claim 1 wherein each loan portion comprises a plurality of loan segments relating to the temporal sequence of the loan portion, which portion comprises a portion of the amount of said loan.

3. The simulation method of claim 1 wherein inputting income information includes inputting at least one of wage or salary income, rental income, dividend income, tax refunds and the frequency of each income category.

4. The simulation method of claim 1 wherein inputting asset information and liability information includes information about pre-existing loans and repayments relating to the liabilities of the borrower.

5. The simulation method of claim 1 wherein inputting asset information and liability information further includes inputting security information about security provided for the loan.

6. The simulation method of claim 5 wherein the security information includes a valuation of the security over which a mortgage or charge is held to secure the loan.

7. The simulation method of claim 1 wherein inputting loan information includes inputting a lender, type of loan product, the interest rate of the loan product and the maximum loan-to-value (LTV) ratio.

8. The simulation method of claim 7 wherein the type of loan product includes at least one of an interest only/fixed credit limit type and an amortizing credit limit type of loan.

9. The simulation method of claim 1 wherein inputting loan information includes inputting information about a proposed transactional loan for the purposes of comparison.

10. The simulation method of claim 1 wherein inputting loan information comprises a precedent step of setting up portions of the loan and the temporal segments of the loan portions with respective loan parameters.

11. The simulation method of claim 10 wherein setting up said loan portions suitably includes inputting the loan portion amounts, the debt to be allocated to each loan portion and the tax-deductibility treatment of each loan portion.

12. The simulation method of claim 10 wherein setting up the segments of the portions suitably includes inputting the interest rates, indicating whether said interest rates are at least one of fixed and variable interest rates, and inputting the term of each segment of the portion.

13. The simulation method of claim 1 further including calculating the maximum available loan amount on the basis of the total value of security to be used multiplied by the maximum loan-to-value ratio, and displaying said maximum available loan amount to the borrower.

14. The simulation method of claim 1 wherein inputting assumptions about future market conditions affecting the loan includes inputting variations in interest rates applicable to said variable interest rate portions or segments of the loan.

15. The simulation method of claim 1 wherein calculating the flow of funds includes:

a) nominating a desired loan portion as the primary account;

b) nominating the next loan portion in sequence as the primary account if the desired loan portion has a nil redraw capacity;

c) crediting income and revenue to the primary account;

d) debiting expenses from the primary account;

e) redrawing funds from the primary account and crediting other specified loan accounts; and

f) repeating steps b) to e) for next credit/debit period unless all other specified loan accounts have nil balance.

16. The simulation method of claim 15 wherein step c) includes crediting any interest earned on funds held as a cash accrual account which account holds any accumulating surplus cash.

17. The simulation method of claim 1 wherein producing a simulation of the loan balance according to the flow of funds includes displaying to the borrower at least one of:

a graph depicting the loan balance at intervals throughout the term of the loan; and

a table demonstrating the loan balance of the loan per year or per transaction until a loan balance of nil is attained.

18. The simulation method of claim 1 wherein simulating the loan balance includes calculation of loan credit and available loan credit potential.

19. The simulation method of claim 1 for a transactional loan, wherein the simulation includes producing available loan credit according to the flow of funds, which further includes producing a table comparing the loan credit and the loan credit potential available per year for the transactional loan.

37. A computer readable medium carrying instructions for executing the loan simulation method as claimed in claim 1.

38. An on-line subscriber system enabling users to conduct assessment and ongoing management of loans or similar finance products, said system including:

a service centre accessible via a public communications network, the service centre including processor means for executing a service software application, storage means for storing the service software application and client data, and communications interface means;

and at least one client software application for execution by a remote client device for accessing the service centre via the public communications network;

whereby upon verification of the identity of a Customer Member by the service centre, the client software application and the service centre software application interoperate to implement the method as claimed in claim 1 for simulating for the Customer Member the performance of a loan which contains a plurality of portions having different parameters.

39. A service software application for a service centre of an on-line subscriber system enabling users to conduct assessment and ongoing management of loans or similar finance products, said software application including:

a master control module for administering records of subscribers and for configuration of member interfaces and a customer interface to a customer web site;

a loan-writer member control module for controlling a loan-writer interface in a loan-writer/lender web site;

a lender member control module for controlling a lender interface in the loan-writer/lender web site and a member information store, the lender interface providing access to information in a loan products information store; and

a simulator module for executing a loan simulation method as claimed in claim 1, utilizing loan parameters entered via the member or customer interfaces.

20. A method of simulating for a borrower or borrowers the performance of a transactional loan in accordance with a predetermined strategy, which transactional loan comprises multiple fixed interest rate portions and variable interest rate portions and each portion comprises multiple temporal loan segments, the method comprising:

inputting income information about income of the borrower;

inputting expenditure information about expenditure of the borrower;

inputting asset and liability information about assets and liabilities of the borrower, including existing loans and associated repayments relating to the liabilities of the borrower;

inputting transactional loan information proposed for refinancing of existing loans, including amount, interest rate, repayment mode and term of each portion or segment of said transactional loan;

providing assumptions about future market conditions affecting the loans;

calculating a flow of funds available for repayment of each portion of the transactional loan according to the borrower income, the borrower expenditure, the borrower assets and liabilities, and the transactional loan information; and

producing a simulation of interest and years saved by said refinancing including available loan credit and available loan credit potential according to the flow of funds and the assumptions about future market conditions.

21. The simulation method of claim 20 wherein each loan portion comprises a plurality of loan segments relating to the temporal sequence of the loan portion, which portion comprises a portion of the amount of said loan.

22. The simulation method of claim 20 wherein inputting income information includes inputting at least one of wage or salary income, rental income, dividend income, tax refunds and the frequency of each income category.

23. The simulation method of claim 20 wherein inputting asset information and liability information includes information about pre-existing loans and repayments relating to the liabilities of the borrower.

24. The simulation method of claim 20 wherein inputting asset information and liability information further includes inputting security information about security provided for the loan.

25. The simulation method of claim 24 wherein the security information includes a valuation of the security over which a mortgage or charge is held to secure the loan.

26. The simulation method of claim 20 wherein inputting loan information includes inputting a lender, type of loan product, the interest rate of the loan product and the maximum loan-to-value (LTV) ratio.

27. The simulation method of claim 26 wherein the type of loan product includes at least one of an interest only/fixed credit limit type and an amortizing credit limit type of loan.

28. The simulation method of claim 20 wherein inputting loan information includes inputting information about a proposed transactional loan for the purposes of comparison.

29. The simulation method of claim 20 wherein inputting loan information comprises a precedent step of setting up portions of the loan and the temporal segments of the loan portions with respective loan parameters.

30. The simulation method of claim 29 wherein setting up said loan portions suitably includes inputting the loan portion amounts, the debt to be allocated to each loan portion and the tax-deductibility treatment of each loan portion.

31. The simulation method of claim 29 wherein setting up the segments of the portions suitably includes inputting the interest rates, indicating whether said interest rates are at least one of fixed and variable interest rates, and inputting the term of each segment of the portion.

32. The simulation method of claim 20 further including calculating the maximum available loan amount on the basis of the total value of security to be used multiplied by the maximum loan-to-value ratio, and displaying said maximum available loan amount to the borrower.

33. The simulation method of claim 20 wherein inputting assumptions about future market conditions affecting the loan includes inputting variations in interest rates applicable to said variable interest rate portions or segments of the loan.

34. The simulation method of claim 20 wherein calculating the flow of funds includes:

a) nominating a desired loan portion as the primary account;

b) nominating the next loan portion in sequence as the primary account if the desired loan portion has a nil redraw capacity;

c) crediting income and revenue to the primary account;

d) debiting expenses from the primary account;

e) redrawing funds from the primary account and crediting other specified loan accounts; and

f) repeating steps b) to e) for next credit/debit period unless all other specified loan accounts have nil balance.

35. The simulation method of claim 34 wherein step c) includes crediting any interest earned on funds held as a cash accrual account which account holds any accumulating surplus cash.

36. The simulation method of claim 20 wherein producing a simulation of the loan balance according to the flow of funds includes displaying to the borrower at least one of:

a graph depicting the loan balance at intervals throughout the term of the loan; and

a table demonstrating the loan balance of the loan per year or per transaction until a loan balance of nil is attained.