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 $15,000. The budgeted expenses for the next three months are as follows:   January February March Salaries $56,900   $ 68,100   $ 72,200   Utilities 2,400   2,600   2,500   Other operating expenses 32,300   41,500   44,700   Total $91,600   $112

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

I only need the Unpaid Expenses x Percent to Pay help. Thank you. 

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 $15,000. The budgeted expenses for the next three months are as follows:

  January February March
Salaries $56,900   $ 68,100   $ 72,200  
Utilities 2,400   2,600   2,500  
Other operating expenses 32,300   41,500   44,700  
Total $91,600   $112,200   $119,400  

Other operating expenses include $3,000 of monthly depreciation expense and $500 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
  $fill in the blank 2 $fill in the blank 3 $fill in the blank 4
  fill in the blank 6 fill in the blank 7 fill in the blank 8
Total cash payments $fill in the blank 9 $fill in the blank 10 $fill in the blank 11
G
H.
K.
M
th non-gray backgrounds are protected and cannot be edited.
EASTGATE PHYSICAL THERAPY INC.
Schedule of Cash Payments for Operations
For the Three Months Ending March 31
January
February
March
Budgeted expenses
117.000
136,400
150,200
Percent
Payment of prior month's expense
Unpaid
Expenses
to Pay
Pay in January
15,000
Pay in February
26,430
Pay in March
32,610
Payment of current month's expense
Pay in January
Pay in February
61.670
76,090
Pay in March
81.130
Total payment
76,670
iS.
102.520
113 740
Transcribed Image Text:G H. K. M th non-gray backgrounds are protected and cannot be edited. EASTGATE PHYSICAL THERAPY INC. Schedule of Cash Payments for Operations For the Three Months Ending March 31 January February March Budgeted expenses 117.000 136,400 150,200 Percent Payment of prior month's expense Unpaid Expenses to Pay Pay in January 15,000 Pay in February 26,430 Pay in March 32,610 Payment of current month's expense Pay in January Pay in February 61.670 76,090 Pay in March 81.130 Total payment 76,670 iS. 102.520 113 740
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education