Rooney Ltd has recorded the following sales for the first three months of 2011: January £30,000 February £35,000 March £42, 000 70% of sales are paid for immediately in cash. Of the remaining 30% of sales, 60% are paid for 1 month later, 30% are paid for 2 months later, and 10% become bad debts. How much cash is expected to be received in March? £35, 700 £29, 400 £38, 400 £57,900

Rooney Ltd has recorded the following sales for the first three months of 2011: January £30,000 February £35,000 March £42, 000 70% of sales are paid for immediately in cash. Of the remaining 30% of sales, 60% are paid for 1 month later, 30% are paid for 2 months later, and 10% become bad debts. How much cash is expected to be received in March? £35, 700 £29, 400 £38, 400 £57,900

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter16: Supply Chains And Working Capital Management

Section: Chapter Questions

Problem 11P

See similar textbooks

Similar questions

A firm has projected sales in October, November, and December of P10,000, P20,000, and P30,000, respectively. The firm makes 20% of sales for cash and collects the balance one month following the sale. What is the firm’s total cash receipts in December? P18,000 P20,000 P22,000 P24,000
A firm collects 25% of its credit sale in the month of sale and the remainder in the following month. The credit sale for the month of June is GHC 150,000. It expert to pay bills of GHC 22,000 in July. The depreciation for the month is GHC 1000. If the company maintains an end month cash balance of GHC 100,000, what is the external finance required?
AXE Co. expects to have sales of P30,000 in January, P33,000 in February, and P38,000 in March. If 20 % of sales are for cash, 40 % are credit sales paid in the month following the sale, and 40 % are credit sales paid 2 months following the sale, what are the cash receipts from sales in March? *
Air corporation has the following projected sales: P958,450.00 (October) P1,001,515.00 (November) P1,200,000.00 (December). Air corporation collects 50% of the month's sales in the month of sales, 35% in the month following sale, and 15% in the second month following the sale. What would be the cash collection in December? A) P143,767.50 B) P2,294,298.00 P1,837,730.00 P2,201,515.00
XYZ has forecast its sales revenues and purchases for the last 5 months of 2015 to be as follows: Sales Purchases August $22,000 $17,000 September 15,000 19,500 October 25,000 29,000 November 30,000 20,000 December 26,000 24,000 60% of sales are on credit. On the basis of past experience, 50% of the accounts receivable is collected the month after the sale and the remainder are collected 2 months after the sale. Purchases are paid 30 days after they are incurred. The firm has a cash balance of $5,000 on hand as of October 31, but its minimum required cash balance is $4,000 Required: A. Prepare a schedule of cash receipts for October, November, and December. B. Prepare a cash budget for the same period.
XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september 195,000 october 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. vi) the company plans to pay rm 6,500 in cash for a brand-new computer in august. vii) a quarterly dividend of rm 10,000 will be paid to ABC…
If a firm had credit sales of $1,550,000 for March and collected its sales 30% in the month of sale and 70% in the month following the sale, how much of March sales would be collected in cash in March?
8. AXE Co. expects to have sales of P30,000 in January, P33,000 in February, and P38,000 in March. If 20 % of sales are for cash, 40 % are credit sales paid in the month following the sale, and 40 % are credit sales paid 2 months following the sale, what are the cash receipts from sales in March? А. Р30,000 В. Р32,800 С. Р38,000 D. P47,400 E. P55,000
Mercurius forecasts the following sales figures for the next four months. June July August September 420,000 350,000 380,000 440,000 Cash sales average 15% of total sales. Credit sales are collected 60% in the month of sale and 40% in the month following sale. What is Mercurius' estimated accounts receivable balance on 30 September?(Answer without comma separators, e.g., 1000 instead of 1,000)
(16-11) Cash Conversion Negus Enterprises has an inventory conversion period of 50 days, an average collection period of 35 days, and a payables deferral period of 25 days. Assume that cost of goods sold is 80% of sales. Cycle a. What is the length of the firm's cash conversion cycle? b. If annual sales are $4,380,000 and all sales are on credit, what is the firm's investment in accounts receivable? C. How many times per year does Negus Enterprises turn over its inventory?
7. March, April and May sales are P100,000, P120,000, and P125,000 respectively. A total of 80% of all sales are credit sales and P20% are cash sales. A total of 60% of credit sales are collected in the month of sale and 40% are collected in the next month. There are no bad debt expenses. What is the accounts receivable balance at the end of May? P72,000 P50,000 P80,000 P40,000
Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 140 $ 160 $ 180 $ 210 Sales for the first quarter of the following year are projected at $155 million. Accounts receivable at the beginning of the year were $61 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 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 $76 million. Finally, the company started the year with a $73 million cash balance and wishes to maintain a $40 million minimum balance. a-1. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can invest any excess funds in…