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 $25,200. The budgeted expenses for the next three months are as follows: Salaries Utilities Other operating expenses Total January February March $58,000 $70,600 $78,100 4,800 5,300 6,300 44,700 48,700 53,600 $107,500 $124,600 $138,000 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% 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 Total cash payments

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 $25,200. The budgeted expenses for the next three months are as follows: Salaries Utilities Other operating expenses Total January February March $58,000 $70,600 $78,100 4,800 5,300 6,300 44,700 48,700 53,600 $107,500 $124,600 $138,000 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% 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 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

The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $836. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. Inventory purchases average 66% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner. Rent is $5,100 per month. Taxes to be paid in June are $6,780. The owner also tells you that he…
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, $24,500, rent, $17,000; utilities, $4,300; depreciation, $4,900; and miscellaneous, $1,800. 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. Budgeted cash payments Utilities payable a b. С Depreciation expense
Newman Medical Clinic has budgeted the following cash flows. January February March $101,000 $107,000 $127,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Cash Budget Beginning cash balance Add: Cash receipt Cash available Less: Cash payments 90,500 31,500 Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) For inventory purchases For S&A expenses Interest expense per month…
Warshaw Company budgets payroll at $3,500 per month plus a percentage of monthly sales. The June operating expenses budget includes total payroll of $12,000 with budgeted sales of $170,000. Sales for July are budgeted at $130,000 while purchases of inventory for July are budgeted at $970,000. Depreciation and insurance for July are estimated at $1,300 and $800, respectively. Office and administrative expenses related to purchasing inventory are budgeted at 55% of purchases for the month. The purchase of $2,200in equipment and $2,000 furniture is expected in July. If the percentage of monthly sales used in budgeting payroll increases 30%, what would the total payroll budgeted for July be?
Zisk Company purchases direct materials on credit. Budgeted purchases are April, $85,000; May, $115,000; and June, $125,000. Cash payments for purchases are: 75% in the month of purchase and 25% in the first month after purchase. Purchases for March are $75,000. Prepare a schedule of cash payments for direct materials for April, May, and June. Schedule of Cash Payments for Direct Materials April May Materials purchases Cash payments for: ZISK COMPANY Total cash payments June
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 408,000 457,000 $ 467,800 354,800 522,000 Kayak requires a minimum cash balance of $50,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 $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,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.)
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 $25,600. The budgeted expenses for the next three months are as follows: January February March Salaries $58,900 $71,700 $79,400 Utilities 4,900 5,400 6,400 Other operating expenses 44,800 48,800 53,800 Total $108,600 $125,900 $139,600 Other operating expenses include $3,200 of monthly depreciation expense and $700 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.
Ivanhoe Design provided the following budgeted information for April through July: April May June July Projected sales $112320 $132840 $124200 $142560 Projected merchandise purchases $88560 $99360 $84240 $71280 The cash balance on June 1 is $12960. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $33480 per month of which depreciation is $3240 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $4320 per month of which $648 is interest and the remainder is principal. How much are budgeted cash disbursements for June? $111024. $127872. $93312. $68256.
a) $18,400 b) $101,600 c) $19,600 d) $16,800
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,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 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, 80% 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…
Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…
The treasurer of Calico Dreams Company has accumulated the following budget information for the first two months of the coming fiscal year: March April Sales $450,000 $520,000 Manufacturing costs 290,000 350,000 Selling and administrative expenses 41,400 46,400 Capital additions 250,000 - The company expects to sell about 35% of its merchandise for cash. Of sales on account, 80% are collected in full in the month of the sale and the remainder in the month following the sale. One-fourth of the manufacturing costs are paid in the month in which they are incurred and the other three-fourths in the following month. Depreciation, insurance, and property taxes represent $6,400 of the monthly selling and administrative expenses. Insurance is paid in February, and property taxes are paid yearly in September. A $40,000 installment on income taxes is to be paid in April. Of the remainder of the selling and administrative expenses, one-half is to be…