Problem
Schedule of Cash Payments
Excel Learning Systems Inc. was organized on September 30, 20Y7. Projected selling and administrative expenses for each of the first three months of operations are as follows:
October $114,700
November 109,000
December 99,200
Depreciation, insurance, and property taxes represent $25,000 of the estimated monthly expenses. The annual insurance premium was paid on September 30, and property taxes for the year will be paid in June. The company expects that 58% of the remainder of the expenses will 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 October, November, and December. Enter amounts as positive numbers.