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 $158,100 145,500 132,400 Depreciation, insurance, and property taxes represent $33,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. Of the remainder of the expenses, 58% 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 Line Item Description March March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments April Q O May 000

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 $158,100 145,500 132,400 Depreciation, insurance, and property taxes represent $33,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. Of the remainder of the expenses, 58% 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 Line Item Description March March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments April Q O May 000

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 19E: Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28....

See similar textbooks

Similar questions

Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
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 $102,200 April 96,100 May 87,500 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. 59% 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 $fill in the blank 1 Paid in April $fill in the blank 2 April expenses: Paid in April fill in the…
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 $171,100 April 157,400 May 143,200 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. 58% 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 ExpensesFor the Three Months Ending May 31 March April May March expenses: Paid in March $fill in the blank 1 Paid in April $fill in the blank 2 April expenses: Paid in April fill in the blank 3 Paid…
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 $129,300 April 119,000 May 108,300 Depreciation, insurance, and property taxes represent $27,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.
Oakwood 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 $107,200 April 99,700 May 90,700 Depreciation, insurance, and property taxes represent $23,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 indicating cash payments for selling and administrative expenses for March, April, and May. Oakwood 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
Swifty Corporation expects to purchase $140,000 of materials in July.... Please provide correct solution for this general accounting question
Tadpole Learning Systems Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $171,300 April $161,000 May $146,500 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 November. 58% 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.
ABC Company has a cash balance of $75,000 at the beginning of March and having regard to the following information: Creditors give l-month credit ii. Salaries are paid in the current month iii. Fixed overheads are paid one month in arrears and include a charge for depreciation of $5,000 per month iv. Variable overheads are paid two months in arrears v. Credit sales are settled as follows: 40% in the month of sale, 45% in the next month and 12% in the following month. The balance represents bad debts. i. Month Cash Sales Credit Sales Purchases $ $ 74,000 82,000 80,000 $ 55,200 January February March 20,000 22,000 25,000 61,200 60,000 69,000 75,000 April Мay 90,00 0 100,000 Salaries Fixed Overheads Variable Overhead 進推調 January February March 9,000 9,000 9,500 30,000 30,000 30,000 45,000 50,000 55,000 April Мay 9,500 10 ,000 32,000 32,000 60,000 70,000 АССТ3603 Required: А. Prepare the Debtors Collection Schedule for ABC company for March to May. В. Prepare the Cash Budget for April…
Al Bahr Corporation, a wholesaler, provided the following informationMonthSalesJanuary64000February59000March42000April48000Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale.Required: Determine the expected cash collection during March.
Melody Inc. had a November ending cash balance of $15,000. As well, it had sales of $10,000 in November, $20,000 in December, and projects sales of $25,000 for January, $30,000 for February, and $35,000 for March. The firm collects its receivables in the month after the sale. Given this information, calculate its cash balance at the end of March. Assume that every month has 30 days. $75,000 $80,000 $90,000 $100,000 $110,000
At the end of September a company has cash balance of $800, trade receivables of $12000 and trade payables of $5000. The company can sell goods costing $9000 for $17100 in October. 50% of all sales are collected in the month of sale and the remainder in the following month. All purchases are made on credit and paid during the following month. Inventory levels will remain constant during the month. General cash expenses will be $600 during October. What is the cash balance at the end of October?