HOW WOULD I COMPLETE THIS?

In Excel, build a monthly Revenue Recognition Forecast, using the following data: January Current AR: 50k Net 30 terms $10,000 in Sales, Due Upon Receipt $5,000 Net 15 $16,000 Net 60 February $1,000 in Sales, Due Upon Receipt $12,000 Net 15 $8,000 Net 60 $8,000 Net 90 March $4,000 in Sales, Due Upon Receipt $11,000 Net 15 $10,000 Net 60 $15,000 Net 90