Month April May June July Collections from customers are normally 66 percent in the month of sale, 18 percent in the month following the sale, and 14 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 $63,000, and sales for August are forecasted at $69,000. Cash disbursements for expenses are expected to be $14,200 for the month of August. The company's cash balance on August 1 was $30,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. Required 1 Sales $82,000 75,000 64,000 72,000 Complete this question by entering your answers in the tabs below. Month July June August Total Required 2 Required 3 Prepare the expected cash collections during August. TEJAS WINDOW TINT Expected Cash Collections August Sales Purchases $ 42,000 57,000 45,000 63,000 Percent % % % Expected Collections $ 0

Month April May June July Collections from customers are normally 66 percent in the month of sale, 18 percent in the month following the sale, and 14 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 $63,000, and sales for August are forecasted at $69,000. Cash disbursements for expenses are expected to be $14,200 for the month of August. The company's cash balance on August 1 was $30,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. Required 1 Sales $82,000 75,000 64,000 72,000 Complete this question by entering your answers in the tabs below. Month July June August Total Required 2 Required 3 Prepare the expected cash collections during August. TEJAS WINDOW TINT Expected Cash Collections August Sales Purchases $ 42,000 57,000 45,000 63,000 Percent % % % Expected Collections $ 0

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

Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business September, October, and November are $245,000, $311,000, and $413,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in November from accounts receivable are projected to be: a. $231,280 O b. $187,740 Oc. $329,784 Od. $274,820
All sales are made on credit terms of net 30 days and are collected the following month and no bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October. The October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or “safety” stock), which the company intends to maintain. Cost of goods sold average 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales. Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes. The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12%. There are no capital expenditures planned during the period, and no dividends will be paid. The company’s desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during…
Walker Company prepares monthly budgets. Company policy is to end each month with merchandise inventory equal to 15% of budgeted unit sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. Beginning inventory on July 1 is 27,000 units. The company budgets sales of 200,000 units in October. The merchandise cost per unit is $2. Budgeted sales units. Units to purchase July 180,000 200,250 August 315,000 308,250 September 270,000 259,500 Prepare the merchandise purchases budgets for the months of July, August, and September. WALKER COMPANY Merchandise Purchases Budget July August September Next period budgeted sales units Ratio of inventory to future sales 0 0 0 Total required units Units to purchase Cost per unit Cost of merchandise purchases
In 2021 the company “AROFAH” will prepare a cash budget. The cash receipts and disbursements plan for the first six months (January to June) are as follows: Admission Plan: Sales Receipts: Sales are made in cash as much as 50% and 50% credit of sales. Of credit sales, 60% is received one month after the month of sale and the remaining is received 2 months after the month of sale. The total receipts of receivables in January and February are IDR 200,000 and IDR 300,000, respectively. The acceptance plans are: A. The amount of sales are: B. Other receipts are: January IDR 1,400,000 January IDR 200,000 February IDR 1,500,000 February IDR 300,000 March IDR 1,500,000 March IDR 100,000 April IDR 1,600,000 April IDR 200,000 May IDR 1,700,000 May IDR 400,000 June IDR 1,650,000 June IDR 500,000 2. Expediture Plan : A. Purchase of raw materials: B. Purchase of…
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.
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business September, October, and November are $239,000, $309,000, and $419,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in October from accounts receivable are estimated to be a. $173,040 b. $206,500 c. $139,580 d. $247,800
5
Old Antique Store prepared the following budget information for the month of May: Sales are budgeted at $303,000. All sales are on account and a provision for bad debts is made for each month at three percent of sales for the month. Inventory was $91,000 on April 30; an inventory increase of $17,000 is planned for May 31. All inventory is marked to sell at cost plus 50 percent. Estimated cash disbursements for selling and administrative expenses for the month are $55,000. Depreciation for May is projected at $6,700. Old Antique's budgeted cost of inventory purchases for May is:Multiple Choice $101,000. $151,500. $203,200. $219,000. $202,000.
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts Cash payments $ 525,000 400,000 450,000 $ 475,000 350,000 525,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay Ibans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add Cash receipts Total cash available Less Cash payments for Interest on loan Total…
The following assumptions are made by a company when preparing its cash budget Invoices paid in the month after sales. Invoices paid in the second month after sale Invoices paid in the third month after sale Bad debts 50% 30% 15% 5% Invoices are issued on the last day of each month. Customers paying in the month after sale are entitled to deduct a 4% settlement discount. Credit sales values for August to November are budgeted as follows: August September October November $100 000 $120 000 $80 000 $70 000 The amount budgeted to be received from credit sales in November is ABCD ] $89 400 ] $91000 [ ] ] $100 000 $92 000