Question

Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28....

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 $117,900
April 112,000
May 101,900

Depreciation, insurance, and property taxes represent $25,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. 67% 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.

Excel Learning Systems 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 $ $ $

Homework Answers

Answer #1
Horizon 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 ( 117900-25000)*67% $62,243
Paid in April ( 117900-25000)*(1-67%) $30,657
April expenses:
Paid in April ( 112000-25000)*67% $58,290
Paid in May ( 112000-25000)*(1-67%) $28,710
May expenses:
Paid in May ( 101900-25000)*67% $51,523
Total cash payments $62,243 $88,947 $80,233
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February 28....
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 $178,000 April 167,300 May 152,200 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. 69% of the remainder of the expenses are expected...
Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of...
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 $170,800 April 162,300 May 147,700 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. 74% of the remainder of the expenses are expected to be paid in the month in which...
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March)....
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $26,800. The budgeted expenses for the next three months are as follows: January February March Salaries $61,600 $75,000 $83,100 Utilities 5,100 5,600 6,700 Other operating expenses 46,800 51,000 56,200 Total $113,500 $131,600 $146,000 Other operating expenses include $3,400 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $240,000 February 310,000 March 470,000 All sales are on account. 59% of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for January, February, and...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $280,000 June 410,000 July 570,000 All sales are on account. Of sales on account, 55% are expected to be collected in the month of the sale, 40% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $330,000 June 470,000 July 660,000 All sales are on account. 56 percent of sales are expected to be collected in the month of the sale, 33% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050   February 1,350 June 2,200   March 1,300 July 1,900   April 1,800 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 1,950 units, which is consistent with this policy. Materials cost $10 per unit and are paid for in the month after production. Labour cost is $3 per unit and...
Wildhorse Company expects to have a cash balance of $59,100 on January 1, 2022. These are...
Wildhorse Company expects to have a cash balance of $59,100 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $80,400, February $136,000 2. Payments to suppliers: January $46,400, February $52,100 3. Wages: January $36,100, February $42,100. Wages are paid in the month they are incurred. 4. Administrative expenses: January $26,100, February $31,600. These costs include depreciation of $3,000 per month. All other costs are paid as...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 521,000 $ 468,900 February 405,500 353,400 March 478,000 523,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 517,000 $ 461,600 February 405,500 350,100 March 476,000 532,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can...