Question - Schedule of cash payments

Excel Learning Systems Inc. was organized on May 31, 2010. Projected selling and administrative expenses for each of the first three months of operations are as follows:

June      $145,600

July        138,300

August  125,900

Depreciation, insurance, and property taxes represent $31,000 of the estimated monthly expenses. The annual insurance premium was paid on May 31, and property taxes for the year will be paid in December. Of the remainder of the expenses, 67% are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month.

Prepare a schedule indicating cash payments for selling and administrative expenses for June, July, and August. Enter all amounts as positive numbers.