Implement the Buy Till you Die Model, BG/BB, BG/NBD and Pareto/NBD models, which capture/project customer purchase patterns in a typical non-contractual setting.

You can implement this in excel using the instructions in the link http://brucehardie.com/notes/010/bgbb_spreadsheet_2011-01-20...