In: Accounting
Schedule of 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 $33,100. The budgeted expenses for the next three months are as follows:
January | February | March | ||||
Salaries | $76,100 | $92,700 | $102,600 | |||
Utilities | 6,300 | 7,000 | 8,300 | |||
Other operating expenses | 57,800 | 63,000 | 69,400 | |||
Total | $140,200 | $162,700 | $180,300 |
Other operating expenses include $4,200 of monthly depreciation expense and $900 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 65% 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 30 | |||
January | February | March | |
Payments of prior month's expense | $ | $ | $ |
Payments of current month's expense | |||
Total payments | $ | $ | $ |