1. 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 | $172,200 |
April | 158,400 |
May | 144,100 |
Depreciation, insurance, and property taxes represent $36,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. 74% 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.
Horizon Financial Inc. | |||
Schedule of Cash Payments for Selling and Administrative
Expenses |
|||
For the Three Months Ending May 31, 2016 | |||
March | April | May | |
March expenses: | |||
Paid in March | 100788 | ||
Paid in April | 35412 | ||
April expenses: | |||
Paid in April | 90576 | ||
Paid in May | 31824 | ||
May expenses: | |||
Paid in May | 79994 | ||
Total cash payments | 100788 | 125988 | 111818 |
Workings: | |||
March | April | May | |
March expenses: | |||
Paid in March | =(172200-36000)*74% | ||
Paid in April | =(172200-36000)*26% | ||
April expenses: | |||
Paid in April | =(158400-36000)*74% | ||
Paid in May | =(158400-36000)*26% | ||
May expenses: | |||
Paid in May | =(144100-36000)*74% |
1. Schedule of cash payments for a service company Horizon Financial Inc. was organized on February...
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 $177,900 April 165,400 May 150,500 Depreciation, insurance, and property taxes represent $38,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. 75% of the remainder of the expenses are expected...
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 $102,500 April 95,300 86,700 May Depreciation, insurance, and property taxes represent $22,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. 69% of the remainder of the expenses are expected...
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 $87,500 April 80,500 May 73,300 Depreciation, insurance, and property taxes represent $18,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. 61% of the remainder of the expenses are expected...
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 $135,300 April 125,400 May 114,100 Depreciation, Insurance, and property taxes represent $29,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...
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 $123,500 April 116,100 May 105,700 Depreciation, insurance, and property taxes represent $26,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...
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 $145,800 April 138,500 May 126,000 Depreciation, insurance, and property taxes represent $32,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...
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 $82,200 April 77,300 May 70,300 Depreciation, insurance, and property taxes represent $18,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. 72% of the remainder of the expenses are expected...
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 April May Depreciation, insurance, and property taxes represent $25,000 of the estimated monthly expenses. The annual insurance premium was paid on February $116,400 110,600 100,600 expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June....
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 $135,300 April 125,400 May 114,100 Depreciation, Insurance, and property taxes represent $29,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...
DOOR Calculator 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: May March $181.100 April 165,400 153,200 Depreciation, insurance, and property taxes represent $35,000 of the estimated monthly expenses. The annual insurance premium was paid on February 20, and prope taxes for the year will be paid in June. 63% of the remainder of the expenses...