PLEASE explain to me how you get the begin cash, collections, payments, ending cash. Show me step by step on how you did it so I can have a better understanding. Thank you!!

Nov 325,000 Dec 360,000 Jan 400,000 15,000 Feb 430,000 March 485,000 Sales Taxes Dividends 10,000 Collections 50% of sales are expected to be cash sales 30% of sales are expected to be credit sales and collected in the month after sale 20% of sales are expected to be credit sales and collected in the second month after sale . Payments . Selling and administrative expenses are expected to be 70% of sales 25% of selling and administrative expenses are expected to be paid in the month of the expense 75% of selling and administrative expenses are expected to be paid in the month after the expense . The cash balance on January 1 is $50,000 Required Complete the following chart by calculating cash collections, cash payments and the ending cash balance for January, February and March. February March January 50,000 Begin Cash Collections Payments Ending Cash