Gilmore Company needs to know its anticipated cash inflows for the next quarter by month. Cash sales are 25 percent of total sales each month. Historically, sales on account have been collected as follows: 50 percent in the month of the sale, 30 percent in the month after the sale, and the remaining 20 percent two months after the sale.

Gilmore Company needs to know its anticipated cash inflows for the next quarter by month. Cash sales are 25 percent of total sales each month. Historically, sales on account have been collected as follows: 50 percent in the month of the sale, 30 percent in the month after the sale, and the remaining 20 percent two months after the sale.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter21: Supply Chains And Working Capital Management

Section: Chapter Questions

Problem 3MC

See similar textbooks

Similar questions

Your projected sales for the first 3 months of next year are as follows:January, $15,000; February, $20,000; and March, $25,000. Based on lastyear’s data, cash sales are 20 percent of total sales for each month. Of theaccounts receivable, 60 percent are collected in the month after the sale and40 percent are collected in the second month following the sale. Sales forNovember of the current year are $15,000 and for December are $17,000.You have the following estimated payments: January, $4,500; February,$5,500; and March, $5,200.a. Using the format from the pro forma cash budget in Table 6–8, what is yourmonthly cash budget for January, February, and March?b. What will your accounts receivable be for the beginning of April?c. Will your company have any borrowing requirements for any month duringthis 3-month period?
Discus Productions needs to know its anticipated ensh inflows for the next quarter by month Cash sales are 10% of total sales each month. Historically, sales on sccount have been collected as follows 60% in the month of ale, 30% in the month after the sale, and the reurining 10% two months after the sale. Sales for the quarter are projected as follows: April, S120,000: May, S100,000; and June, 590,000. Accounte receivable on March 31 were S60,000, The expected caalh collections of Discn Productions for June are Oa $92,000. Oh S89.000. Oe $91.200. Od 595.400.
jagdish
The Dunce Company expects to have sales of 30,000 in January, 33,000 in February, and 38,000 in March. If 20 percent of sales are for cash, 40 percent are credit sales paid in the month following the sale, and 40 percent are credit sales paid two months following the sale, how much is the expected cash receipts in March?
Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 23 140 Month 3 Month 4 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. $ $ 2 3 32 26 160 130 > Answer is complete but not entirely correct. Expected Cash Collections 4 22 110 191,000 X 172,000 X
Assume that sales and expenses forecasts for months April, May, June, and July are as follows. 20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan.Any excess over $20,000,000 will be used to reduce or pay off cumulative loan.Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time.Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July and interpret the result in detail.
Assume that sales and expenses forecasts for months April, May, June, and July are as follows. 20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan.Any excess over $20,000,000 will be used to reduce or pay off cumulative loan.I nitial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: 1. Prepare cash budget proforma for months June and July. Provide in-text citations and references, and explain your work in detail.
Assume that sales and expenses forecasts for months April, May, June, and July are as follows. 20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan. Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July. Provide in-text citations and references, and explain your work in detail.
Brandeis, Inc has a 45-day accounts payable period. The firm has expected quarterly sales of $2,400, $2,800, $3,600, and $4,200, respectively, for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $1,200 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for quarter 3 of the next year? Each quarter has 90 days. Multiple Choice $3,900 $2,730 $2,240 $2,870 $3,060
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…
The ABC Company expects to have sales of $30,000 in January, $33,000 in February, and $38,000 in March. If 20 percent of sales are for cash, 40 percent are credit sales paid in the month following the sale, and 40 percent are credit sales paid 2 months following the sale, what are the cash receipts from sales in February?
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% 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 accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or…