Cash Collections for Belcher Motors found that 35% of its sales were cash and the remaining 65% are credit sales. Of the credit sales, the company collected 55% in the month of sale, 40% collected the month after the sale, and 5% collected the second month after the sale. May Sales were $100 000, April Sales were $115,000, and June Sales were 136,000. How much will be collected in the 3rd quarter if July sales are $180,000, August sales are 167,000, and September sales are $152,000, and include a total column for the 3rd quarter total.

Cash Collections for Belcher Motors found that 35% of its sales were cash and the remaining 65% are credit sales. Of the credit sales, the company collected 55% in the month of sale, 40% collected the month after the sale, and 5% collected the second month after the sale. May Sales were $100 000, April Sales were $115,000, and June Sales were 136,000. How much will be collected in the 3rd quarter if July sales are $180,000, August sales are 167,000, and September sales are $152,000, and include a total column for the 3rd quarter total.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The beginning cash balance is $20,600. Sales are forecasted at $715,000 of which 70% will be on account. The remainder are cash sales. Sixty percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $465,000. Accounts receivable from previous accounting periods totaling $11,000 will be collected in the current year. The company is required to make a $21,500 loan payment and an annual interest payment on the last day of the year. The loan balance as of the beginning of the year is $145,000, and the annual interest rate is 10%. What will be reported as 'cash' on the budgeted balance sheet?
Need help with this
Vertical Ladder Company (VLC) forecasts its sales for January through April will be $40,000, $60,000, $100,000, and $90,000, respectively. All sales are made on credit, and it is expected that 40 percent of sales will be collected in the month of the sale and the remainder will be collected the month following the sale. Customers who pay in the month of the sale will take the 2 percent cash discount VLC offers for paying early. VLC normally purchases and pays for raw materials, which cost 45 percent of sales, one month prior to selling the finished products. Employees' wages represent 20 percent of sales and rent is $6,000 per month. At the beginning of February, VLC expects to have $4,000 in cash, which is $1,000 greater than its target cash balance. Using the information provided, construct VLC's cash budget for February and March. Round your answers to the nearest dollar. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". February March…
Brooklyn Studio's sales are all made on account. The firm's collection experience has been that 27% of a month's sales are collected in the month the sale is made, 52% are collected in the month following the sale, and 19% are collected in the second month following the sale. The sales forecast for the months of September through December is as follows: September October November December $ 238,000 293,000 307,000 360,000 Required: Calculate the cash collections that would be included in the cash budgets for November and December. November December Cash Collections
Shalom Company expects credit sales for April, May, and June to be P200,000, P260,000, and P300,000, respectively. It is expected that 75% of the sales will be collected in the month of sale, and 25% will be collected in the following month. Amounts must be in whole numbers. Example: 88,000 or (88,000) Calculate cash collections from customers for each month. MAY
XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september 195,000 october 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. vi) the company plans to pay rm 6,500 in cash for a brand-new computer in august. vii) a quarterly dividend of rm 10,000 will be paid to ABC…
Gardner Company expects sales for October of $259,000. Experience suggests that 55% of sales are for cash and 45% are on credit. The company collects 50% of its credit sales in the month of sale and 50% in the month following sale. Budgeted Accounts Receivable on September 30 is $73,500. What is the amount of cash expected to be collected in October? Multiple Choice $215,950. $274,225. $142,450. $200,725. $129,500.
Markham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 20,000 $ 26,000 $ 35,000 $ 38,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $29,600. $22,100. $31,850. $35,000.
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Graham Potato Company has projected sales of $12,000 in September, $15,000 in October, $22,000 in November, and $18,000 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $18,500 and $11,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts September October November December
Earthie's Shoes has 55% of its sales in cash and the remaining 45% are credit sales. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Prince Charles Island Company has expected sales of $6,000 in September, $10,000 in October, $16,000 in November, and $12,000 in December. Cash sales are 20 percent and credit sales are 80 percent of total sales. Historically, 40 percent of receivables are collected in the month after the sale, and the remaining 60 percent collected two months after. Assume that the company's cash payments for November are $13,000, and December $6,000. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Sales Credit sales Cash sales Collections in the month after credit sales Collections two months after credit sales Total cash receipts Prince Charles Island Company Cash Receipts Schedule September S Cash receipts Cash payments Net cash flow Prince Charles Island Company Cash Budget November Beginning cash balance Cumulative cash balance. Monthly loan or (repayment). Cumulative loan balance. Ending cash…