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 $173,900 April 163,500 May 148,800 Depreciation, insurance, and property taxes represent $37,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. Required:Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May. Horizon Financial Inc.

Total Cash Payments are as follows:

For March = $95,830

For April = $129,620

For May = $116,210

Explanation:

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

The expenses paid in each month can be calculated 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 = ($173,900 - $37,000) * 70% = $95,830

Paid in April = (Total projected selling and administrative expenses for March - Depreciation, insurance, and property taxes for March) * Percentage of balance paid = ($173,900 - $37,000) * (100% - 70%) = $41,070

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 = ($163,500 - $37,000) * 70% = $88,550

Paid in May = (Total projected selling and administrative expenses for April - Depreciation, insurance, and property taxes for April) * Percentage of balance paid = ($173,900 - $37,000) * (100% - 70%) = $37,950

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 = ($148,800 - $37,000) * 70% = $78,260

the new gas bill will be 0