I have the following set of data

Trust Account Number SI date (SDA booking date) Principal Amount TF
Rate RESULTING VALUES
01 0500247 22-Sep-08 12,000,000.00 0.25% 01 0500247_0001
01 0500324 20-Oct-08 5,000,000.00 0.25% 01 0500324_0001
01 0500340 05-Sep-08 1,000,000.00 0.55% 01 0500340_0001
01 0500340 10-Sep-08 1,000,000.00 0.55% 01 0500340_0002
01 0500340 19-Sep-08 4,000,000.00 0.35% 01 0500340_0003
01 0500340 22-Sep-08 5,000,000.00 0.35% 01 0500340_0004
01 0500340 22-Sep-08 5,000,000.00 0.35% 01 0500340_0005

Can anyone help me in coming up with a code that will generate the resulting
values? Note that columns a-e are inputted manually while column F should be
automatically generated.

THANKS!