Please do in excel :)

The Rich Company needs to estimate cash collections from sales for the three months of February, March and April, 2015. Thirty percent of the company's customers pay in cash and the rest are credit customers. The collection pattern for the credit customers is 40% in the month of sale and 58% in the following month. They have a 2% uncollectible rate. Estimated total sales for January through April follow: January $115,000 February $125,000 March $150,000 April $155,000