A firm's annual credit sales are $171 million, with 49.56% of its daily average paid out in purchases. It usually takes the company 34 days to meet its purchasing obligations. This payment pattern has not changed in recent years. However, the firm's commitment to accounts receivable has shifted based on its current annual net income of $28.6k which meets the 3.44 % required return, anticipated by senior management a year earlier. Normally, the firm collects its accounts in 23 days, an average which remains unaffected. Required: In percentage terms, by how much are the firm's receivables greater (or less) than its payables?
Q: Harrelson Inc. currently has $750,000 in accounts receivable. Its days sales outstanding (DSO) is 55…
A: Excel Spreadsheet: Excel Workings:
Q: Company has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4…
A: Company estimated sales for next four quarters as follows : Sales of Q1 = 150 million Q2 = 180…
Q: A company has total annual sales (all credit) of $400,000 and a gross profit margin of 20 percent.…
A: The ratio analysis helps to analyze the financial statements of the business.
Q: The Cannon Ball has projected its first quarter sales at $11,200, second quarter sales at $10,900,…
A: Calculation of cash surplus (deficit) at the end of the first quarter: Answer: Cash deficit at the…
Q: The company has the following expected pattern of collections on credit sales 70 percent collected…
A: Collection from june sales = june sales x 70% = 150000*70% = P105000
Q: Garrett Industries turns over its inventory six times each year; it has an average collection period…
A: Cash conversion cycle =Days of inventory outstanding (DIO) + Days sales outstanding (DSO) - Days…
Q: The Professional Service Company expects 80% of sales for cash and 20% on credit. The company…
A: The budgets are prepared to estimate the requirements for the future period.
Q: Anderson Motors is a chain of car dealerships. Sales in the fourth quarter of last year were…
A: An income statement helps the business enterprises in determining how much gross profit or net…
Q: Shown below is the sales forecast for Cooper Inc. for the first four months of the coming year Apr…
A: Cash inflows in March = cash sales + cash collected in month of march
Q: The Professional Service Company expects 70% of sales for cash and 30% on credit. The company…
A: Credit Sales of June: 70% will be collected in June. 25% will be collected in July. 5% are not…
Q: Libscomb Technologies' annual sales are $6,615,140 and all sales are made on credit, it purchases…
A: The question is based on the concept of financial ratios
Q: ntonio is an analyst at Barrilla Group. The firm turns over its inventory 5 times each year. It has…
A: Cash conversion cycle tells that how much period is required to collect money from customer and…
Q: The Danser Corporation expects to generate sales equal to $30,000 in January, $33,000 in February,…
A: Total cash collection for March is 20% of March sales, 50% of February Sales and 30% of January…
Q: Sales for the first quarter of the following year are projected at $195 million. Accounts receivable…
A: Given:
Q: Ingraham Inc. currently has $205,000 in accountsreceivable, and its days sales outstanding (DSO) is…
A: Calculate the current sales as shown below: Hence, the current sales are $1,053,873.239.
Q: Owen’s Electronics has nine operating plants in seven southwestern states. Sales for last year were…
A: According to the percentage of sales method, the accounts in the balance sheet possess a percentage…
Q: Biondi Manufacturing Company has an average accounts receivable balance of $1,250,000, an average…
A: Cash conversion cycle shows how a firm efficiently convert its investment in inventory into sales…
Q: areez Pharma is trying to determine the effect of its inventory and receivable turnover ratios on…
A: Cash Conversion cycle is the number of times cash is circulated in the cycle of receivables, payable…
Q: a) Calculate the firm’s operating cycle. b) Calculate the firm’s cash conversion cycle c) Calculate…
A: The operating cycle of the company means the cycle in which the operating activities of the business…
Q: In 2021, Chatsworth Company expects sales of $40,000 in July, $50,000 in August, and $30,000 in…
A: July sales = $40,000 July Cash sales = 40% July Credit sales = 60% Uncollectble amount = 5% of…
Q: Mareez Pharma is trying to determine the effect of its inventory and receivable turnover ratios on…
A: Cash conversion cycle is the total time period taken by the firm to complete its operating cycle. It…
Q: What is the maximum level of accounts receivable that ALei can carry and have a 35-day average…
A: Answer a: Average collection period = Accounts receivableAnnual credit…
Q: The Brenmar Sales Company had a gross profit margin (gross profits÷sales) of 34 percent and…
A: Average collection period is period required to receive all accounts receivable that means money…
Q: Libscomb Technologies' annual sales are $5,024,963 and all sales are made on credit, it purchases…
A: Cash cycle = Days inventory outstanding + days sales outstanding - days payable outstanding Days…
Q: The Lux Co. has an inventory conversion period of 60 days, a receivable conversion period of 35…
A: The answer is stated below:
Q: Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q3…
A: The question is based on the concept of Cost Accounting.
Q: Company’s average age of accounts receivable is 40 days, while the average age of accounts payable…
A: Introduction:- The following formula used to calculate the length of its cash conversion cycle as…
Q: Mareez Pharma is trying to determine the effect of its inventory and receivable turnover ratios on…
A: Net income=Sale×Net income margin=$5,000,000×10%=$500,000
Q: Calculate the firm’s cash conversion cycle, its daily cash operating expenditure, and the amount of…
A: Inventory Turnover ratio shows how many times a company has sold and replaced inventory during a…
Q: The Raattama Corporation had sales of $3.5 million last year, and it earned a 5% return (after…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Watts Industries' carries 87 days in Inventory, and collects its Accounts Receivable in 75 days. If…
A: The cash conversion cycle is the number of days required for the cash invested in inventory to be…
Q: Consider a company that has sales in May, June, and July of $11 million, $10 million, and $12…
A: The sales in the months of May, June and July are $11 Million, $10 Million and $ 12 Million…
Q: a) Kareem & Sons last year reported sales of 12 million and an inventory turnover ratio of 4. The…
A: Inventory = Sales/ Inventory turnover ratio Accounts receivable = DSO * Average Day Sales
Q: National Co. has an inventory conversion period of 60 days, a receivable conversion period of 35…
A: The Cash Conversion Cycle (CCC) is one of the various quantitative indicators that may be used to…
Q: b) Medwing Corporation has a DSO of 19 days. The company averages 5,500 in credit sales each day.…
A: Answer b: Average amount of receivables=Sales×DSO360=$5,500×19360=$290.28
Q: Kareem & Sons last year reported sales of 12 million and an inventory turnover ratio of 4. The…
A: “Hey, since there are multiple questions posted, we will answer first question. If you want any…
Q: If a firm had credit sales of $1,550,000 for March and collected its sales 30% in the month of sale…
A: March sales collected in March = Credit March sales x 30%
Q: Graham Potato Company has projected sales of $11,400 in September, $14,500 in October, $21,400 in…
A: Cash receipt schedule represents the total cash collected in a particular period by the company and…
Q: Gillstrap Promotions has projected the following
A: Net cash inflow is calculated by deducting cash outflows from cash inflow.
Q: Libscomb Technologies' annual sales are $5,851,355 and all sales are made on credit, it purchases…
A: Cash Cycle in days = Inventory Holding Period + Accounts receivable collection period - Accounts…
Q: As a result, the firm's days sales outstanding (DSO) is
A: Days Sales Outstanding: It shows the average number of days it takes for a firm to obtain payment…
Q: A company has total annual sales (all credit) of $400,000 and a gross profit margin of 20 percent.…
A: The connection between various objects in financial statements is represented by ratio analysis. It…
Q: In 2021, Chatsworth Company expects sales of $40,000 in July, $50,000 in August, and $30,000 in…
A: The cash receipts during period consists of receipts from current sales and receipts from past…
Q: Libscomb Technologies' annual sales are $6,997,444 and all sales are made on credit, it purchases…
A: Receivables turnover = Net credit sales / Average Receivables
Q: Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year…
A: Formula: Cash received amount = Total sales x collectible percentage of sales amount for the month.…
Step by step
Solved in 3 steps
- The Raattama Corporation had sales of $3.5 million last year, and it earned a 5% return (after taxes) on sales. Recently, the company has fallen behind in its accounts payable. Although its terms of purchase are net 30 days, its accounts payable represents 60 days’ purchases. The company’s treasurer is seeking to increase bank borrowing in order to become current in meeting its trade obligations (that is, to have 30 days’ payables outstanding). The company’s balance sheet is as follows (in thousands of dollars): How much bank financing is needed to eliminate the past-due accounts payable? Assume that the bank will lend the firm the amount calculated in part a. The terms of the loan offered are 8%, simple interest, and the bank uses a 360-day year for the interest calculation. What is the interest charge for 1 month? (Assume there are 30 days in a month.) Now ignore part b and assume that the bank will lend the firm the amount calculated in part a. The terms of the loan are 7.5%, add-on interest, to be repaid in 12 monthly installments. What is the total loan amount? What are the monthly installments? What is the APR of the loan? What is the effective rate of the loan? Would you, as a bank loan officer, make this loan? Why or why not?Atlantic Northern Inc. currently has $715,000 in accounts receivable and generated $4,650,000 in sales (all on credit) during the year that just ended. The firm’s days sales outstanding (DSO) is days. Use 365 days as the length of a year in all calculations. Atlantic Northern Inc.’s CFO is unhappy with its DSO and wants to improve collections next year. Sales are expected to grow by 13% next year, and the CFO wants to lower the DSO to the industry average of 30 days. How much accounts receivable is the firm expected to carry? $453,471 $431,877 $410,283 $388,689A firm's annual credit sales are $1.71 million, with 49.56% of its daily average paid out in purchases. It usually takes the company 34 days to meet its purchasing obligations. This payment pattern has not changed in recent years. However, the firm's commitment to accounts receivable has shifted based on its current annual net income of $28.6k which meets the 3.44% required return, anticipated by senior management a year earlier. Normally, the firm collects its accounts in 23 days, an average which remains unaffected. Required: In percentage terms, by how much are the firm's receivables greater (or less) than its payables? Note: The term "k is used to represent thousands (x $1.000). % (ROUND YOUR ANSWER TO 2 DECIMAL PLACES. FOR EXAMPLE: 17.23)
- Harrelson Inc. currently has $750,000 in accounts receivable, and its days sales outstanding (DSO) is 55 days. It wants to reduce its DSO to 35 days by pressuring more of its customers to pay their bills on time. If this policy is adopted, the company’s average sales will fall by 15%. What will be the level of accounts receivable following the change? Assume a 365-day year.Ruth Company currently has $1,000,000 in accounts receivable. Its average collection period is is 50 days. Assume a 365-day year. The company wants to reduce its average collection period to the industry average of 32 days by pressuring more of its customers to pay their bills on time. The company's CFO estimates that if this policy is adopted the company's average sales will fall by 10 percent. Assuming that the company adopts this change and succeeds in reducing its DSo to 32 days and does lose 10 percent of its sales, what will be the level of accounts receivable following the change? this is a bonus question Select one: a. $900,000 b. $676,667 c. $776,000 d. $576,000 e. $976,667 IIIThe Raattama Corporation had sales of $3.5 million last year, and it earned a 5% return (after taxes) on sales. Recently, the company has fallen behind in its accounts payable. Although its terms of purchase are net 30 days, its accounts payable represents 60 days’ purchases. The company’s treasurer is seeking to increase bank borrowing in order to become current in meeting its trade obligations (that is, to have 30 days’ payables outstanding). The company’s balance sheet is as follows (in thousands of dollars): How much bank financing is needed to eliminate the past-due accounts payable? Assume that the bank will lend the firm the amount calculated in part a. The terms of the loan offered are 8%, simple interest, and the bank uses a 360-day year for the interest calculation. What is the interest charge for 1 month? (Assume there are 30 days in a month.) (1) What is the total loan amount? (2) What are the monthly installments? (3) What is the APR of the loan? (4) What is…
- Brown Corporation had average days of sales outstanding of 19 days in the most recent fi scal year. Brown wants to improve its credit policies and collection practices and decrease its collection period in the next fi scal year to match the industry average of 15 days. Credit sales in the most recent fi scal year were $300 million, and Brown expects credit sales to increase to $390 million in the next fi scal year. To achieve Brown’s goal of decreasing the collection period, the change in the average accounts receivable balance that must occur is closest to: C . –$1.22 million.Brown Corporation had average days of sales outstanding of 19 days in the most recent fi scal year. Brown wants to improve its credit policies and collection practices and decrease its collection period in the next fi scal year to match the industry average of 15 days. Credit sales in the most recent fi scal year were $300 million, and Brown expects credit sales to increase to $390 million in the next fi scal year. To achieve Brown’s goal of decreasing the collection period, the change in the average accounts receivable balance that must occur is closest to: A . +$0.41 million.Kim Mitchell, the new credit manager of the Vinson Corporation, was alarmed to find that Vinson sells on credit terms of net 90 days while industry-wide credit terms have recently been lowered to net 30 days. On annual credit sales of $2.32 million, Vinson currently averages 95 days of sales in accounts receivable. Mitchell estimates that tightening the credit terms to 30 days would reduce annual sales to $2,195,000, but accounts receivable would drop to 35 days of sales and the savings on investment in them should more than overcome any loss in profit. Assume that Vinson’s variable cost ratio is 79%, taxes are 40%, and the interest rate on funds invested in receivables is 18%. Assuming a 365-day year, calculate the net income under the current policy and the new policy. Do not round intermediate calculations. Round your answers to the nearest dollar. Current policy: $ New policy: $ Should the change in credit terms be made?
- The Boyd Corporation has annual credit sales of $2.8 million. Current expenses for the collection department are $38,000, bad debt losses are 1.6%, and the days sales outstanding is 30 days. The firm is considering easing its collection efforts such that collection expenses will be reduced to $23,000 per year. The change is expected to increase bad - debt losses to 2.6% and to increase the days sales outstanding to 45 days. In addition, sales are expected to increase to $2,825,000 per year. Suppose that the opportunity cost of funds is 18%, the variable cost ratio is 65%, and taxes are 40%. Assuming a 365-day year, calculate the cost of carrying receivables under the current policy and the new policy. Enter your answers as positive values. Do not round intermediate calculations. Round your answers to the nearest dollar.If a firm has sales of $22,242,000 a year, and the average collection period for the industry is 35 days, what should this firm’s accounts receivable be if the firm is comparable to the industry? Assume there are 365 days in a year. Do not round intermediate calculations. Round your answer to the nearest dollar. $Edwards Industries has $320 million in sales. The companyexpects that its sales will increase 12% this year. Edwards’ CFO uses a simple linearregression to forecast the company’s receivables level for a given level of projected sales.On the basis of recent history, the estimated relationship between receivables and sales (inmillions of dollars) is as follows:Receivables = $9.25 + 0.07(Sales)Given the estimated sales forecast and the estimated relationship between receivables andsales, what are your forecasts of the company’s year-end balance for receivables and itsyear-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basisof a 365-day year.