Required InformationTES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has thefollowing balance sheet as of March 31.TES-417 Inc.Balance SheetMarch 31AssetsCash$82,000Accounts receivableInventory52,5ee217,000Plant and equipment, net of depreciationTotal assetsLiabilities and Stockholders' EquityAccounts payable78,000Common stock347.00055,500Retained earningsTotal liabilities and stockholders' equityTES-417 accountants have made the following estimates:1. Sales for April, May, June, and July will be $280,000, $300.000, $290,000, and $310,000, respectively.2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April.3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accountspayable at March 31 are related to previous merchandise purchases and will be paid in April.4. Monthly selling and administrative expenses are always $52,000. Each month $5,000 of this total amount is depreciation expense and the remaining $47,000 is spent for expenses that are paid in the month they are incurred.5. The company will not borrow money or pay or declare dividends during the 2nd quarter. The company will not issue any common stock or repurchase its own stock during the 2nd quarter.How much is the company's expected cash collections in the month of May?Multiple ChoiceOOOO$182,000$195,000$287,000$105,000

Expected cash collection is the collection of cash which has been received by the company during the…

Answered: How much is the company's expected cash…

Business

Accounting

How much is the company's expected cash collections in the month of May?

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

Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)
Watts Industries' carries 87 days in Inventory, and collects its Accounts Receivable in 75 days. If the firm pays its Accounts Payable in 26 days, what is Watts' Cash Conversion Cycle?
Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?
How much should this company expect in cash collections for the month of January? ROUND TO NEAREST WHOLE DOLLAR
If Service World has $1,950 cash, $400 of government Treasury bills purchased last month with a six-week maturity, and $940 of cash set aside for legal reasons, how much will the company report on the balance sheet as “Cash and Cash Equivalents”?
Your company collected $340.00 million and spent $381.00 million this month. If previous month's cash position (cumulative cash) is $14.31 million and your company target cash position is $20.00 million. What's your company's cash surplus/shortage at the end of this month, with positive number indicates a surplus and negative number indicates a shortage? Note: your answer should be in millions of dollars
1. Calculate the expected cash collections for July. 2. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July.
please answer within 30 minutes. Projected Cash Receipts,Romaris Brothers Inc. needs a cash receipts schedule for the months of April, May, and June. Actual Sales: February = $500,000, March = $500,000. Forecast Sales: April =$560,000, May= $610,000, June= $650,000, July= $650,000, Assuming that sales are the only source of cash inflows and that 30% of them are for cash and the remainder are collected evenly over the following 2 months. Prepare a schedule of projected cash receipts for April, May and June. Projected Cash Disbursements Romaris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. The following information was collected from financial records: Purchases: Purchases are calculated as 50% of the next month’s sales, 15% of purchases are made in cash, 60% of purchases are paid for 1 month after purchase, and the remaining 25% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $9,000 per month. Wages and…
1. The treasurer of Yoda Inc. needs to estimate cash collections from accounts receivable for September, October, and November 2022. Forty percent of the company's customer's pay in cash the rest are credit customers. The collection pattern for the credit customers is 20% in the month of the sale and 80% in the following month. They have zero uncollectible accounts. Estimated total sales are as follows: August $70,000 September $80,000 October $85,000 November $100,000 a. What is Yoda's cash collections for September, October, and November? - September cash collections: - October cash collections: - November cash collections: b. The accounts receivable balance at the end of November will be:
How would this be solved ?
Bantam Industries has budgeted the following information for March: Cash receipts Beginning cash balance Cash payments Desired ending cash balance If there is a cash shortage, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,000 increments, and interest is paid monthly at 1% on the first day of the following month. The company had no debt before March 1. How much cash will the company need to borrow in March? Multiple Choice $13,000 $65,000 $ 343,000 23,000 388,000 43,000 $52,000 The company should not need to borrow any cash In March
i need the answer quickly