The following information is from Tejas WindowTint's financial records.MonthAprilMayJuneJulySales$ 72,00071,00066,00088,000Purchases$ 61,00060,00048,00066,000Collections from customers are normally 69 percent in the month of sale, 19 percent in the month following the sale, and 10 percent inthe second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takesfull advantage of the 1 percent discount allowed on purchases paid for by the tenth of the following month. Purchases for August arebudgeted at $67,000, and sales for August are forecasted at $73,000. Cash disbursements for expenses are expected to be $16,000for the month of August. The company's cash balance on August 1 was $29,000.Required:1. Prepare the expected cash collections during August.2. Prepare the expected cash disbursements during August.3. Calculate the expected cash balance on August 31.Complete this question by entering your answers in the tabs below.Required 1Required 2 Required 3Prepare the expected cash collections during August.TEJAS WINDOW TINTExpected Cash CollectionsAugustMonthSalesPercentExpectedCollections%%%$0TotalRequired 1Required 2 >

Cash budget :A cash budget is a financial tool used by businesses to forecast and manage their cash…

Answered: 1. Prepare the expected cash…

1. Prepare the expected cash collections during August. 2. Prepare the expected cash disbursements during August. 3. Calculate the expected cash balance on August 31.

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: Listed below are four interbank cash transfers, indicated by the letters a, b, c and d, of a client…

A: Introduction:- The question asks to determine whether each transfer understates, unaffected, or…

Q: Post the differences between the cash count and the cash register tape to the Cash Short and Over T…

A: A ledger is a log or list of accounts that keeps track of account transfers. This is generally on…

Q: The purpose of a petty cash fund is toa. Provide a convenient form of payment for the company’s…

A: Petty cash fund: Petty cash fund is a fund established to pay insignificant amounts like postage,…

Q: Jeremiah Restoration Company completed the following selected transactions during January: Jan.…

A: Petty Cash Petty cash is refer as the small amount of money which are used for an expenditure, where…

Q: a. The October 31 cash balance in the general ledger is $796. b. The October 31 balance shown on the…

A: Introduction: Bank Reconciliation statement: To reconcile the difference between the Pass book and…

Q: Required: 1.Complete the bank reconciliation at December 31, 2019.…

A: Please fallow the answer below: Answer 1) Computation of Bank Reconciliation at December 31, 2019.…

Q: Suppose there was a third transfer on the interbank transfer schedule for $16,500. Assume that the…

A: The possible concern that I would have for this transfer is regarding on the possible reason as to…

Q: a. Analyzing details of large cash deposits around year end. b. Comparing customer remittance…

A: In a kiting scheme, cash is created using the lag between the time a check is deposited and the time…

Q: Cedar Springs Company completed the following selected transactions during June: June 1.…

A: Date General Journal Debit Credit 1-Jun Petty cash 1,310…

Q: Journalize the entries to record the following: Required: a. On March 1, check is issued to…

A: Petty cash funds are those funds which are maintained for small petty expenses of the business.…

Q: w much is left in the petty cash fund at the end of the month? Round your answer to the neareset…

A: Petty cash is a small amount of cash that a business keeps on hand to pay for small expenses that…

Q: a) From the following information, update the cash book and prepare a bank reconciliation statement…

A: Step 1: Compare the Bank Statement and Cash Book BalancesStart by comparing the ending balance of…

Q: Given the following data: a. Determine the cash receipts for April based on the following data: Cash…

A: T-account:— It is the general ledger account which is prepared to post journal entries. It is the…

Q: ournalize the entries to record the following: Required: a. On March 1, check is issued to establish…

A: Petty cash fund: Petty cash fund is a fund established to pay insignificant amounts like postage,…

Q: The actual cash received from the day’s cash sales was $27,214, and the amount indicated by the cash…

A: Cash register record the amount of cash received in a given day and it should match with cash in…

Q: cash balance shown in the check register.

A: A check register is a personal accounting tool used to record and track financial transactions. It…

Q: Journalize the entries to record the following: June 1 Established a petty cash fund of $200.…

A: Please find the answer to the above questions below:

Q: The treasurer preparing the October bank reconciliation identified the following items: Cash balance…

A: A bank reconciliation statement is prepared by almost every organization at a particular time. It is…

Q: The total on the "Cash Receipts" report generated by QuickBooks® software at January 31 would be…

A: Step 1 Cash receipts journal also refers to the main entry book, the purpose of which is the…

Q: Record the transactions in the cash receipts journal. Use two lines for December 7 and December 14…

A: Cash Receipts Journal: The cash receipts journal will include the cash sales and bank credit card…

Q: Month of July Results Balance July 31 July deposits July checks July note collected (not included in…

A: The bank reconciliation statement is prepared to equate the balance of the cash book and pass book…

Q: of the is a concern and have been given the task of preparing the cash budget for the business for…

A: Budget is the estimation of revenue and expense prior to start the operation. To manage the working…

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

The following information is from Tejas WindowTint's financial records.
Month
April
May
June
July
Sales
$ 72,000
71,000
66,000
88,000
Purchases
$ 61,000
60,000
48,000
66,000
Collections from customers are normally 69 percent in the month of sale, 19 percent in the month following the sale, and 10 percent in
the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes
full advantage of the 1 percent discount allowed on purchases paid for by the tenth of the following month. Purchases for August are
budgeted at $67,000, and sales for August are forecasted at $73,000. Cash disbursements for expenses are expected to be $16,000
for the month of August. The company's cash balance on August 1 was $29,000.
Required:
1. Prepare the expected cash collections during August.
2. Prepare the expected cash disbursements during August.
3. Calculate the expected cash balance on August 31.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2 Required 3
Prepare the expected cash collections during August.
TEJAS WINDOW TINT
Expected Cash Collections
August
Month
Sales
Percent
Expected
Collections
%
%
%
$
0
Total
Required 1
Required 2 >

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Meaning of Cash Budget :

VIEW

Step 2: Expected cash collection during August :

VIEW

Step 3: Expected cash disbursement during August :

VIEW

Step 4: Expected cash balance on August 31 :

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 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

Wyoming Restoration Company completed the following selected transactions during July 20Y1: July 1. Established a petty cash fund of $1,100. 12. The cash sales for the day, according to the cash register records, totaled $8,192. The actual cash received from cash sales was $8,220. 31. Petty cash on hand was $47. Replenished the petty cash fund for the following disbursements, each evidenced by a petty cash receipt: July 3. Store supplies, $580. 7. Express charges on merchandise sold, $90 (Delivery Expense). 9. Office supplies, $30. 13. Office supplies, $35. 19. Postage stamps, $50 (Office Supplies). 21. Repair to office file cabinet lock, $60 (Miscellaneous Administrative Expense). 22. Postage due on special delivery letter, $28 (Miscellaneous Administrative Expense). 24. Express charges on merchandise sold, $135 (Delivery Expense). 30. Office supplies, $25. July 31. The cash sales for the day, according to the cash register records,…
Which of the following can be considered as an effective control of cash?A. One person handles the receipts and disbursements of cash.B. Cash is deposited monthly into a bank.C. There is approval of cash payments.D. A reconciliation of the bank balance with the cash balance is prepared twice a year.
Given the following information, determine the adjusted cash balance per books from the following information: a. Balance per books as of June 30, $8,600. b. Outstanding checks, $820. с NSF check returned with bank statement, $130. d. Deposit mailed the afternoon of June 30, $300. e Check printing charges, $30. Interest earned on checking account, $12. Adjusted cash balance per books $
Post the differences between the cash count and the cash register tape to the Cash Short and Over T account. Assume a change fund of $100. Date Cash Register Tape Cash Count March 3 $1,495.89 $1,601.89 4 1,878.55 1,986.55 5 741.76 843.76 6 1,646.62 1,744.62 7 1,714.13 1,814.13 When required, enter amounts in dollars and cents.
Based on the following information, prepare the weekly entries for cash receipts from service fees and cash short and over. A change fund of $100 is maintained. Date Change Fund Cash Register Receipt Amount Actual Cash Counted General Journal June 1 $100 $330.00 $433.00 GENERAL JOURNAL 8 100 297.00 400.00 DATE ACCOUNT TITLE POST. REF. DEBIT CREDIT 15 100 233.00 331.00 22 100 302.00 396.50 2 29 100 316.00 412.00 3 Required: Prepare the weekly entries for cash receipts from service fees and cash short and over. 5 6 7 8 1,
Indicate the impact each transaction had on net income.Prepare the journal entries for each of the petty cash transactions.This is a 2 part question. Clark Company set up a petty cash fund for payments of small amounts. The following transactions involving the petty cash fund occurred in May. May 1 Prepared a company check for $450 to establish the petty cash fund. May 15 Prepared a company check to replenish the fund for the following expenditures made since May 1. May 15 a. Paid $160 for janitorial services. May 15 b. Paid $120 for miscellaneous expenses. May 15 c. Paid postage expenses of $80. May 15 d. Paid $ 41 to Facebook for advertising expense. May 15 e. Counted $63 remaining in the petty cash box. May 16 Prepared a company check for $150 to increase the fund to $600. May 31 The petty cashier reports that $ 240 cash remains in the fund. A company check is drawn to replenish the fund for the following expenditures made since May 15. May 31 f. Paid postage expenses of $205. May…
The actual cash received from cash sales was $39,114, and the amount indicated by the cash register total was $39,129. Journalize the entry to record the cash receipts and cash sales. Refer to the Chart of Accounts for exact wording of account titles. Journal Journalize the entry to record the cash receipts and cash sales on December 31. Refer to the Chart of Accounts for exact wording of account titles. 1 2 3 DATE Dec. 31 Dec. 31 DESCRIPTION JOURNAL POST. REF. DEBIT CREDIT ACCOUNTING FOLIATION ASSETS PAGE 1 LIABILITIES EQUITY
Required:1. Prepare a bank reconciliation as of February 28.2. Prepare adjusting entries for Valentine based on the information developed in the bank reconciliation.3. What is the amount of cash that should be reported on the February 28 balance sheet?
Sparks Fly Company provided the following data concerning the cash records for the months of July and August. What is the correct answer to questions #1, 2, 3 and 4?
Wyoming Restoration Company completed the following selected transactions during July 20Y1: July 1. 12. 31. July 3. 7. 9. 13. 19. 21. 22. 24. 30. July 31. 31. Established a petty cash fund of $1,100. The cash sales for the day, according to the cash register records, totaled $8,192. The actual cash received from cash sales was $8,220. Petty cash on hand was $47. Replenished the petty cash fund for the following disbursements, each evidenced by a petty cash receipt: Store supplies, $580. Express charges on merchandise sold, $90 (Delivery Expense). Office supplies, $30. Office supplies, $35. Postage stamps, $50 (Office Supplies). Repair to office file cabinet lock, $60 (Miscellaneous Administrative Expense). Postage due on special delivery letter, $28 (Miscellaneous Administrative Expense). Express charges on merchandise sold, $135 (Delivery Expense). Office supplies, $25. The cash sales for the day, according to the cash register records, totaled $10,241. The actual cash received from…
Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Cash (A) Debit June 1 Checks $ 19,900 Deposits Other $ 18,800 Credit Balance 7,360 June Deposits 20,600 20,200 Checks written June June 30 Balance 7,760 $31 Balance $ 7,360 26,160 6,260 6,229 6,229 1. In addition to the balance in its bank account, Hills Company also has $420 of petty cash on hand. This amount is recorded in a separate account called Petty Cash on Hand. What is the total amount of cash that should be reported on the balance sheet at June 30?
A company established a petty cash fund in April of the current year and experienced the following transactions affecting the fund during April. Prepare journal entries to establish the fund on April 1, to replenish it on April 25, and to record the increase in the fund on April 25. April 1 Prepared a company check for $300.00 to establish the petty cash fund. April 25 Prepared a company check to replenish the fund for the following expenditures made since April 1. Paid $84.50 for cleaning services. Paid $84.00 for postage expense. Paid $103.15 for office supplies. Counted $23.35 remaining in the petty cash box. April 25 The company decides to increase the fund by $100.