Question

Schedule of cash payments for a service company Horizon 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 $160,800
April 152,800
May 139,000
Depreciation, insurance, and property taxes represent $35,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. 73% 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 of cash payments for selling and administrative expenses for March, April, and May.

Answer 1

Answer:

Total Cash Payments are as follows:

For March = $91,834

For April = $119,960

For May = $107,726

Explanation:

Note: See the attached Excel file for the schedule of cash payments

The expenses paid in each month are estimated as follows:

a. March Expenses

Paid in March = (Total projected selling and administrative expenses for March - Depreciation, insurance, and property taxes for March) * Percentage of reminder paid = ($160,800 - $35,000) * 73% = $91,834

Paid in April = (Total projected selling and administrative expenses for March - Depreciation, insurance, and property taxes for March) * Percentage of balance paid = ($160,800 - $35,000) * (100% - 73%) = $33,966

b. April Expenses

Paid in April = (Total projected selling and administrative expenses for April - Depreciation, insurance, and property taxes for April) * Percentage of reminder paid = ($152,800 - $35,000) * 73% = $85,994

Paid in May = (Total projected selling and administrative expenses for April - Depreciation, insurance, and property taxes for April) * Percentage of balance paid = ($152,800 - $35,000) * (100% - 73%) = $31,806

c. May Expenses

Paid in May = (Total projected selling and administrative expenses for May - Depreciation, insurance, and property taxes for May) * Percentage of reminder paid = ($139,000 - $35,000) * 73% = $75,920

Download xlsx