Question
The following information is from Tejas WindowTints financial records. Month Sales Purchases April $ 79,000 $ 51,000 May 74,000 42,000 June 73,000 30,000 July 75,000
The following information is from Tejas WindowTints financial records.
Month | Sales | Purchases | ||||
April | $ | 79,000 | $ | 51,000 | ||
May | 74,000 | 42,000 | ||||
June | 73,000 | 30,000 | ||||
July | 75,000 | 48,000 | ||||
Collections from customers are normally 70 percent in the month of sale, 19 percent in the month following the sale, and 9 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 3 percent discount allowed on purchases paid for by the tenth of the following month. Purchases for August are budgeted at $69,000, and sales for August are forecasted at $75,000. Cash disbursements for expenses are expected to be $15,800 for the month of August. The companys cash balance on August 1 was $32,000.
Required:
-
Prepare the expected cash collections during August.
-
Prepare the expected cash disbursements during August.
-
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 disbursements during August. TEJAS WINDOW TINT Expected Cash Disbursements August July purchases to be paid in August Net Cash disbursements for expenses Total $ 0 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the expected cash balance on August 31. TEJAS WINDOW TINT Expected Cash Balance August 31 Balance, August 1 Expected balance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started