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 | $147,500 |
| April | 137,200 |
| May | 124,900 |
Depreciation, insurance, and property taxes represent $31,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. 70% 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 | ($147,500-$31,000)*70% = $81,550 | ||
| Paid in April | ($147,500-$31,000)*30% = $34,950 | ||
| April Expenses | |||
| Paid inApril | ($137,200-$31,000)*70% = $74,340 | ||
| Paid in May | ($137,200-$31,000)*30% = $31,860 | ||
| May Expenses | |||
| Paid May | ($124,900-$31,000)*70% = $65,730 | ||
| Total cash payments | $ 81,550 | $ 109,290 | $ 97,590 |
You can reach me over comment box if you have any doubts. Please
rate this answer