Shown below is the sales forecast for Cooper Inc. for the first four months of the coming year Feb $24,000 $120.000 Jan $15.000 $100,000 Mar $20000 $90,000 Apr $14,000 $70.000 Cash sales Credit sales On average, 50% of credit sales are paid for in the month of the sale. 30% in the month following sale, and the remainder are paid two months after the month of the sale Assuming there are no bad debts, the expected cash intlow in March is

Shown below is the sales forecast for Cooper Inc. for the first four months of the coming year Feb $24,000 $120.000 Jan $15.000 $100,000 Mar $20000 $90,000 Apr $14,000 $70.000 Cash sales Credit sales On average, 50% of credit sales are paid for in the month of the sale. 30% in the month following sale, and the remainder are paid two months after the month of the sale Assuming there are no bad debts, the expected cash intlow in March is

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
JoAnn Manufacturing has projected the following sales for the coming year: Sales $25,847.50 C$25,182.50 $22,604.17 Q1 $23,560.83 Q2 $ 54,750 $ 61,850 Q3 The company places orders each quarter that are 35 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? $70,050 Q4 $75,750
Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
JoAnn Manufacturing has projected the following sales for the coming year 01 02 03 04 Sales $53,475 $59,725 $ 68,775 $ 74,050 The company places orders each quarter that are 30 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? Mutiple Choice O $21.360.00 121687.50 $22.22969 $19,72750
Neha Wholesalers supplied you with the following projected information:1. Expected sales are as follows:August R350 000September R280 000October R300 0002. Cash sales are expected to be 50% of total sales. The balance is on credit.3. Debtors are expected to settle their accounts as follows:40% in the month of the sale60% one month after the sale4. Expected purchases are as follows:August R100 000September R 40 000October R 50 0005. All purchases are on credit. Creditors are paid one month after the purchases less 10%discount.6. Rent expenses amount to R7 000 per month, Rent will increase by 15% from 1 October.7. Selling expenses are expected at 1% of total sales and are paid during the month of sales.8. Insurance amounts to R360 000 per annum, payable monthly.9. The owner intends making a cash drawings of R5 000 each month.10. Interest on fixed deposit of R2 000 is due on 1 September.11. The bank balance on 31 July is expected to be R25 000 favourable.Required:1.1 The Debtors…
The management of Kirkut Enterprises prepared the following forecasted total sales schedule for the five months ending December 2021 August September October November December R310 000 R330 000 R325 000 R340 000 R410 000 Additional information: Cash sales comprise 40% of total sales. These customers are entitles to a 4% discount. Credit sales are collected as follows: 40% in the month of sale - these customers get a 2% discount 55% in the month after the sale 5% is written off as bad debts Cash receipts for cash sales made for the period August to December will total: O A. R686 000 O B. R1 715 000 O C. R658 560 D. R1 646 400
Dora Distribution has projected the following quarterly sales. The accounts receivable at the beginning of the year is $970 and the collection period is 60 days. What are collections for the first quarter? Q1 Q2 Q3 Q4 Sales $ 1,585 $ 1,705 $ 1,995 $ 2,075
Projector Limited has the following projection for the 4 months ending August 2018:MayJuneJulyAugustR’sR’sR’sSales320 000380 000420 000460 000Purchases160 000160 000230 000250 000Rent income11 00011 000??Salaries26 80026 800??1. 50% of the sales are for cash and the balance is on credit.2. All credit sales are collected one month after the sale.3. All purchases are on credit. Creditors are paid in full one month after the month of purchase.4. The tenants rent contract stipulates an increase of 20% from 1 July 2018.5. Salaries are expected to increase to R32 000 per month as at 1 August 2018.6. A new motor vehicle will be purchased during June 2017. Repayments of R6 000 per month will commence on 1 July 2017.7. Advertising costs are expected to be 2% of sales from 1 June 2018.8. A fixed deposit of R25 000 will mature in the month of July 2018.9. On 31 May 2018, the bank is expected to have a favourable balance of R420 000.Required:Prepare a Cash Budget for the three (3) months ending…
Jamaica Co’s sales forecast for the first five months of 2018 are as follows: January February March April May $ 32,000 $ 36,000 $ 48,000 $ 46,000 $ 55,000 Additional information provided is as follows: (i) Sales for November and December of the previous year were $40,000 and $45,000 respectively. (ii) Sixty percent of sales will be for cash; 30% will be collected in the first month following the sale; and the remaining 10% will be collected in the second month following the sale. (iii) Raw material purchases are settled a month after purchase. Each month’s purchases is shown below: December January February March April $22,400 $25,200 $33,600 $32,200 $38,500 (iv) Wages total $4,200 monthly. (v) Other expenses are $1,800 in January but is expected to increase by $550 each month; (vi) Equipment costing $15,000 will be ordered in January. A…
Keedis Products has projected the following sales for the coming year Q1 02 21 04 Sales $19,550 $14,850 $ 15,675 $ 16,175 The company places orders each quarter that are 30 percent of the following quarter's sales and has a 60-day payables period. What is the payment of accounts for the second quarter? Mutiple Choice O $4,52000 $3,135.00 $4,53750 $5.395.00 $4,455.00
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 180 $ 200 $ 220 $ 250 Sales for the first quarter of the following year are projected at $195 million. Accounts receivable at the beginning of the year were $77 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $10 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $81 million cash balance and wishes to maintain a $40 million minimum balance. b-1. Complete the following short-term financial plan assuming that Wildcat maintains a minimum cash balance of $20 million.…