Schedule of Cash Payments for a Service CompanyEastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accruedbalance on January 1 is $34,600. The budgeted expenses for the next three months are as follows:February$96,9007,30065,900$170,100SalariesUtilitiesOther operating expensesTotalJanuary$79,6006,60060,500$146,700March$107,3008,70072,600$188,600Other operating expenses include $4,400 of monthly depreciation expense and $1,000 of monthly insurance expense that was pron May 1 of the previous year. Of the remaining expenses, 65% are paid in the month in which they are incurred, with the remaifollowing 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.

The cash collection schedule is prepared to estimate the requirements for the period.The cash…

Answered: Prepare a schedule of cash payments for…

Business

Accounting

Prepare a schedule of cash payments for operations for January February, and March.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash…

A: Introduction: Cash Budget is a budget plan for expected cash inflows and cash outflows during the…

Q: Amina borrowed 60,000 SR on January 1, 2020, from the local bank to expand its building. The funds…

A: These are the accounting transactions that are having a monetary impact on the financial statement…

Q: Assets $ 12,000 77,500 42,000 225,000 $ 356,500 Cash Accounts receivable Inventory Buildings and…

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Q: Prepare a master budget for the three-month period ending June 30. Include the following detailed…

A: Budgeting is a method of estimating expected future outcomes based on past events. Budgeting…

Q: B. Comment on the cash balance for August and September. C. Explain two (2) ways budgets are useful…

A: Cash budget is the budget, which is used for forecasting about the future cash inflows and cash…

Q: Required: 1. Prepare a schedule of expected cash collections for July, August, and September. Also,…

A: 1. Expected Cash CollectionsThis involves forecasting how much money your business expects to…

Q: Capital expenditures include $37,000 for new manufacturing equipment to be a. purchased and paid in…

A: Cash receipt from sales = $ 215000 * 75% = $ 161250 Cash payment for purchases = $ 40900 * 50% =$…

Q: Beech Corporation is a merchandising company that is preparing a master budget for the third quarter…

A: Solution 1: Schedule of expected cash collection - Beech Corporation Particulars July…

Q: crane company management wants to maintain a minimum monthly cash balance of $26,500. At the…

A: The cash budget is an estimate of cash receipts and their payment during a future period of time.

Q: Produce a flexed budget statement for Caltex for November

A: Flexible budget is a budget which adjusts or flexes with changes according to volume or activity of…

Q: her sales reports and records for the months of January through August of the current year.

A: 1. sales calculation Jan = 60000+10%=60000+60000=66000 Feb =50000+10%=50000+5000=55000…

Q: Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget…

A: Cash Budget is the estimates of total cash inflows and total cash outflows during a future specific…

Q: Prepare a master budget for the three-month period ending June 30 that includes a schedule of…

A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…

Q: Schedule of Cash Payments for a Service Company Oakwood Financial Inc. was organized on February 28.…

A: The cash payment schedule is prepared to estimate the amount of cash paid during the period. The…

Q: The budget director for Adams Cleaning Services prepared the following list of expected selling and…

A: Schedule of Payment of S&A Expense -S&A Expense includes selling and administration related…

Q: A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed…

A: Sales BudgetParticularsApril MayJuneTotalBudgeted Units Sales6640010140051400219200Selling Price per…

Q: [The following information applies to the Beech Corporation is a merchandising company that is…

A: "Since you have posted a question with multiple sub parts, we will solve first three sub parts for…

Q: Lavage Rapide is a Canadian company that owns and operates a large automat provides estimates…

A: Answer) Lavage Rapide Planning Budget For the Month Ended August 31 Number of cars…

Concept explainers

Cash Book

So, before coming to the topic of cash books, I will let you briefly explain about the cash so that you all can be familiar with the word cash. Cash comes under the category of the current asset which is used as a medium of exchange for all the financial transactions in the firm. Cash is something that is universally accepted as a mode of payment. So, now comes to the topic i.e., cash book.

Question

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
balance on January 1 is $34,600. The budgeted expenses for the next three months are as follows:
February
$96,900
7,300
65,900
$170,100
Salaries
Utilities
Other operating expenses
Total
January
$79,600
6,600
60,500
$146,700
March
$107,300
8,700
72,600
$188,600
Other operating expenses include $4,400 of monthly depreciation expense and $1,000 of monthly insurance expense that was pr
on May 1 of the previous year. Of the remaining expenses, 65% are paid in the month in which they are incurred, with the remai
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.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Cash expenses to be incurred:

VIEW

Step 3: Schedule of Cash Payments for operations

VIEW

Solution

VIEW

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Accounting for Cash and cash equivalents

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

Preparing a financial budget—budgeted income statement and balance sheet Ball Company has the following post-closing trial balance on December 31, 2018 The company’s accounting department has gathered the following budgeting information for the first quarter of 2019: Additional information: Rent and income tax expenses are paid as incurred. Insurance expense is an expense is an expiration of the prepaid amount. Requirements Prepare a budgeted income statement for the quarter ended March 31, 2019. Prepare a budgeted balance sheet as of March 31, 2019.
You are preparing a cash budget for the month of September. how would you use information about sales in the preceding July?
Prepare a direct materials budget for the first quarter of the financial year ending 30 September 2022. Prepare a cash budget for the first quarter of the financial year ending 30 September 2022 including any necessary schedules. Prepare a budgeted income statement for the first quarter of the financial year ending 30 September 2022.
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month May June July August Sales $ 99,000 118,000 135,000 132,000 Purchases $ 63,000 89,000 115,000 72,000 Required 1 Required 2 The majority of Martin's sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin's purchases are on account with 55 percent paid in the month of purchase and 45 percent paid the following month. Required: 1. Determine budgeted cash collections for July and August. 2. Determine budgeted cash payments for July and August. Cash Expenses Paid $ 22,000 Complete this question by entering your…
Garden Sales, Incorporated, usually has to borrow money during the second quarter to support peak sales of lawn care equipment during May. It gathered the following information to prepare a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income. *Includes $30,000 of depreciation each mon. April $ 700,000 490,000 210,000 88,000 49,000 137,000 $ 73,000 May $ 870,000 609,000 261,000 107,000 66,400 173,400 $ 87,600 June $ 580,000 406,000 174,000 69,000 42,800 111,800 $ 62,200 July $ 480,000 336,000 144,000 48,000 46,000 94,000 $ 50,000 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10% collected in the month of sale, 70% collected in the first month following the month of sale, and the remaining 20%…
Using the same above information, what would it look like to complete the following? Schedule of cash payments for direct materials.Cash budget.Budgeted income statement for entire second quarter (not monthly).
What about preparing a schedule of expected cash disbursement for merchandise purchases, by month and the total and budgeted income statement for the three-month period ending June 30.
Prepare a production budget for January and February 2017.
3. The Uthred Company, a merchandising firm, has planned the following sales for the next four months: March $50,000 Аpril $70,000 Мay $90,000 June July $90,000 Total budgeted Sales $60,000 Sales are made 60% on account and 40% cash. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 60% • First month following month of sale . • Second month following month of sale • Uncollectible 28% 10% 2% Uthred has a building that is not used in the business operation; they rented it out and receive $10,080 rent every month. The company requires a minimum cash balance of $14,000 to start a month.
The budget director for Rundle Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations, accordingly, there are no beginning account balances. Required a. Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. b. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. c. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. Complete this question by entering your answers in the tabs below. Req A Complete the schedule of cash payments for S&A expenses by filling in the missing amounts.…
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 Depreciation, insurance, and property taxes represent $19,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. 61% 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. $88,600 82,400 75,000 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 March April March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments May
Prepare a production budget for the months of April, May, and June.