Schedule of Cash Payments for a Service Company 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,700. The budgeted expenses for the next three months are as follows: January February March Salaries $61,400 $74,800 $82,800 Utilities 5,100 5,600 6,700 Other operating expenses 47,300 51,600 56,800 Total $113,800 $132,000 $146,300 Other operating expenses include $3,400 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months Ending March 31 January February March Payments of prior month's expense Payments of current month's expense Total cash payments

Schedule of Cash Payments for a Service Company 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,700. The budgeted expenses for the next three months are as follows: January February March Salaries $61,400 $74,800 $82,800 Utilities 5,100 5,600 6,700 Other operating expenses 47,300 51,600 56,800 Total $113,800 $132,000 $146,300 Other operating expenses include $3,400 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months Ending March 31 January February March Payments of prior month's expense Payments of current month's expense Total cash payments

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The August 31st balance sheet (Actual): cash accounts receivable inventory building and equipment (net) $25,000 133,000 32,813 203,500 e. accounts payable August-Actual September-Projected October-Projected November-Projected capital stock retained earnings b. Actual sales for August and budgeted sales for September, October, and November are given below: $62,016 $190,000 375,000 405,000 310,000 295,372 36,925 C. Sales are 30% for cash and 70% on credit. All credit sales are collected in the month following the sale. There are no bad debts. d. The gross margin percentage is 65% of sales. The desired ending inventory is equal to 25% of the following month's COGS. One fourth of the purchases are paid for in the month of the purchase and the remaining 75% are purchased on account and paid in full the following month. The monthly operating…
January budgeted selling and administrative expenses for the retail shoe store that Craig Shea plans to open on January 1, year 1, are as follows: sales commissions, $21,000; rent, $19,500; utilities, $5,400; depreciation, $4,300; and miscellaneous, $2,600. Utilities are paid in the month after they are incurred. Other expenses are expected to be paid in cash in the month in which they are incurred. Required a. Determine the amount of budgeted cash payments for January selling and administrative expenses. b. Determine the amount of utilities payable the store will report on the January 31 pro forma balance sheet. c. Determine the amount of depreciation expense the store will report on the income statement for year 1, assuming that monthly depreciation remains the same for the entire year. a. b. C Budgeted cash payments Utilities payable Depreciation expense
Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
H1.
Administrative Expense Budget Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $9,300 Insurance 2,300 Depreciation 3,400 Accounting services 900 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months June July August Total Salaries $fill in the blank ccb859013031fd8_1 $fill in the blank ccb859013031fd8_2 $fill in the blank ccb859013031fd8_3 $fill in the blank ccb859013031fd8_4 Insurance fill in the blank ccb859013031fd8_5 fill in the blank ccb859013031fd8_6 fill in the blank ccb859013031fd8_7…
None
2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignmentS... A Estimated cash payments budget Grow Inc. was organized on February 28. Budgeted selling and administrative expenses for each of the first three months of operations are as follows: March April May $101,500 93,400 85,000 Depreciation, insurance, and property taxes represent $21,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. The remainder of the expenses are expected to be paid 71% 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. Enter all amounts as positive numbers. 4 0 GROW 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…
Cash budgetThe following cash budget is for the third quarter of this year. Solve for the missing numbers on the cash budget, assuming that the accountant has requested a minimum cash balance of $7,000 at the start of each month. All borrowings, repayments, and investments are made in even $1,000 amounts. No borrowings or investments exist at the beginning of July. July August September Total Beginning cash balance $7,400 Cash receipts 16,400 20,200 Total cash available $41,000 $77,800 Cash disbursements Payments on account $7,800 $11,400 Wages expense 10,000 12,400 34,600 Overhead costs 8,000 9,200 26,000 Total disbursements $20,600 $32,600 Cash excess (deficiency) Minimum cash balance (7,000) (7,000) Cash available (needed) $(8,800) $(11,600) Financing Borrowings (repayments) $4,000 $(1,000) Acquire (sell) investments - - Receive…
Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: — June July August Sales $160,000 $185,000 $200,000 Manufacturing costs $66,000 $82,000 $105,000 Selling and administrative expenses $40,000 $46,000 $51,000 Capital expenditures — — $120,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the…
I need help solve
Book Hint Print Exer Kayak Company 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. January February March Cash Receipts Cash payments $ 521,000 $ 465,600 405,000 478,000 349,600 522,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
None