Carryover Earnings and Current Earnings

[rammarthi]

Hi,

Can any one please help me with this problem as described in the attached excel sheet. All the data in Table 1 is in columnar form rather than in row form. Represented in two column each one for date and one for earnings.

Thanks in advance.

Regards

Ram Marthi