prepare a cash budget for march April may

January February March April May Purchases 17,100 19,700 29,300 20,400 24,500 Sales 25,200 15,300 25,400 30,500 26,600 MAR JAN 6300 cash FEB 3825 11475 credit sale 18900 6350 19050 7458.75 6615 APR 7625 22875 12382.5 4016.25 24023.75 MAY 6650 19950 14868.75 6667.5 total cash receipts 20423.75 28186.25 MAR APR MAY Cash receipts Cash payments Net cash flow Beginning cash balance Cumulative cash balance Monthly loan or (repayment) Cumulative loan balance Ending cash balance January February March April May Purchases 17,100 19,700 29,300 20,400 24,500 Sales 25,200 15,300 25,400 30,500 26,600 MAR JAN 6300 cash FEB 3825 11475 credit sale 18900 6350 19050 7458.75 6615 APR 7625 22875 12382.5 4016.25 24023.75 MAY 6650 19950 14868.75 6667.5 total cash receipts 20423.75 28186.25 MAR APR MAY Cash receipts Cash payments Net cash flow Beginning cash balance Cumulative cash balance Monthly loan or (repayment) Cumulative loan balance Ending cash balance