In: Accounting
Schedule of Cash Payments for a Service Company
SafeMark Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows:
| March | $157,300 | 
| April | 144,700 | 
| May | 131,700 | 
Depreciation, insurance, and property taxes represent $33,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 60% of the remainder of the expenses 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 March, April, and May.
| SafeMark Financial Inc. | |||
| Schedule of Cash Payments for Selling and Administrative Expenses | |||
| For the Three Months Ending May 31 | |||
| March | April | May | |
| March expenses: | |||
| Paid in March | $ | ||
| Paid in April | $ | ||
| April expenses: | |||
| Paid in April | |||
| Paid in May | $ | ||
| May expenses: | |||
| Paid in May | |||
| Total cash payments | $ | $ | $ | 
| SafeMark Financial Inc. | |||
| Schedule of Cash Payments for Selling and Administrative Expenses | |||
| For the Three Months Ending May 31 | |||
| March | April | May | |
| March expenses: | |||
| Paid in March | 74,580 | ||
| Paid in April | 49,720 | ||
| April expenses: | |||
| Paid in April | 67,020 | ||
| Paid in May | 44,680 | ||
| May expenses: | |||
| Paid in May | 59,220 | ||
| Total cash payments | 74,580 | 116,740 | 103,900 | 
| Working | |||
| March | April | May | |
| March expenses: | |||
| Paid in March | (157,300 - 33,000)*60% | ||
| Paid in April | (157,300 - 33,000)*40% | ||
| April expenses: | |||
| Paid in April | (144,700 - 33,000)*60% | ||
| Paid in May | (144,700 - 33,000)*40% | ||
| May expenses: | |||
| Paid in May | (131,700 - 33,000)*60% | ||
| Total cash payments | - | ||