Cash flow of accounts receivable. Myers and Associates, a famous law firm in California, bills its clients on the first of each month. Clients pay in the following fashion: 40% pay at the end of the first month, 30% pay at the end of the second month, 20% pay at the end of the third month, 5% pay at the end of the fourth month, and 5% default on their bills. Myers wants to know the anticipated cash flow for the first quarter of 2015 if the past billings and anticipated billings follow this same pattern. The actual and anticipated billings are as follows:
Fourth Quarter Actual Billings |
First Quarter Anticipated Billings |
|||||
Oct. |
Nov. |
Dec. |
Jan. |
Feb. |
Mar. |
|
$290,000 |
$236,000 |
$214,000 |
$246,000 |
$267,000 |
$298,000 |
What is the anticipated cash flow for January of 2015 if past billings and anticipated billings follow this same pattern? $________ (Round to the nearest dollar.)
What is the anticipated cash flow for February of 2015 if past billings and anticipated billings follow this same pattern? $_______ (Round to the nearest dollar.)
What is the anticipated cash flow for March of 2015 if past billings and anticipated billings follow this same pattern? $_______ (Round to the nearest dollar.)
Anticipated Cash flow for Month of january:
40% of billing of this month(january)
(246000*40%)= 98400
30% of previous month(December)
(214000*30%)=. 64200
20% of previous second month (November)
(236000*20%)= 47200
5% of Previous third month
(290000*5%)= 14500
____'__________________________________________
224300
________________________________________________
Anticipated Cash flow for Month of february:
40% of billing of this month(February)
(267000*40%)= 106800
30% of previous month(January)
(246000*30%)= 73800
20% of previous second month (December)
(214000*20%)= 42800
5% of Previous third month(November)
(236000*5%)=. 11800
__________________________________
235200
__________________________________
Anticipated Cash flow for Month of March:
40% of billing of this month(March)
(298000*40%)=. 119200
30% of previous month(February)
(267000*30%)= 80100
20% of previous second month (january)
(246000*20%)=. 49200
5% of Previous third month(November)
(214000*5%)= 10700
__________________________________
259200
__________________________________
So, Anticipated Cash flow for Month of january is $ 224300
Anticipated Cash flow for Month of february is $235200
Anticipated Cash flow for Month of March is $259200
Please thumbs up.
Cash flow of accounts receivable. Myers and Associates, a famous law firm in California, bills its...
Production cash outflow. California Cement Company produces its products two months in advance of anticipated sales and ships to warehouse centers the month before sale. The inventory safety stock is 23% of the anticipated month's sale. Beginning inventory in September 2014 was 33,323 units. Each unit costs $2.73. The average sales price per unit is $5.71. The cost is made up of 35% labor, 56% materials, and 9% shipping (to the warehouse). The company pays for labor the month of...
Production cash outflow. California Cement Company produces its products two months in advance of anticipated sales and ships to warehouse centers the month before sale. The inventory safety stock is 20% of the anticipated month's sale. Beginning inventory in September 2014 was 33,275 units. Each unit costs $2.88. The average sales price per unit is $5.83. The cost is made up of 25% labor, 65% materials and 10% shipping (to the warehouse). The company pays for labor the month of...
follow The firm makes 14% of all sales for cash and collects on 43% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $13,000 in September and April $17,000 in January and 000 in September and Apri, $17,000 in January and March, and $26,000 n February. The f pays cash for 9% of its purchases. It pays for 53% o s purchases in e o ing month and for 38%...
Walton Medical Clinic has budgeted the following cash flows: February $124,000 March January $118,000 Cash receipts Cash payments For inventory purchases For S&A expenses $144,000 94,000 36,000 99,000 40,000 81,000 41,000 Walton Medical had a cash balance of $17,000 on January 1. The company desires to maintain a cash cushion of $5,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments...
Depreciation and accounting cash flow A firm in the third year
of depreciating its only asset, which originally cost $173,000 and
has a 5-year MACRS recovery period
, has gathered the following data relative to the current
year's operations:
Accruals
$15,300
Current assets
117,000
Interest expense
15,200
Sales revenue
413,000
Inventory
69,600
Total costs before depreciation, interest and taxes
297,000
Tax rate on ordinary income
21%
a. Use the relevant data to determine the operating cash flow
for the current...
Swifty Products, a rapidly growing distributor of home gardening
equipment, is formulating its plans for the coming year. Carol
Jones, the firm’s marketing director, has completed the following
sales forecast.
Month
Sales
Month
Sales
January
$904,900
July
$1,501,400
February
$1,002,000
August
$1,501,400
March
$904,900
September
$1,606,000
April
$1,154,600
October
$1,606,000
May
$1,260,000
November
$1,501,400
June
$1,406,000
December
$1,704,000
Phillip Smith, an accountant in the Planning and Budgeting
Department, is responsible for preparing the cash flow projection.
He has gathered the...
(Preparation of a cash budget) Lewis Printing has projected its sales for the first 8 months of 2016 as follows: January $140,000 April $300,000 July $200,000 February $100,000 May $255,000 August $200,000 March $170,000 June $180,000 Lewis collects 30 percent of its sales in the month of thesale, 40 percent in the month following the sale, and the remaining 30 percent 2 months following the sale. During November and December of 2015, Lewis's sales were...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
At the end of January, $5,000 of accounts receivable are past
due, and the company estimates that 50% of these accounts will not
be collected. Of the remaining accounts receivable, the company
estimates that 2% will not be collected. No accounts were written
off as uncollectible in January.
Unpaid salaries at the end of January are $28,100. Prepare the
adjusting entry for salaries.
On January 1, 2021, the general ledger of Freedom Fireworks includes the following account balances: Credit Debit...
3. Prena 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare a production budget. (Hint: Unit sales - Sales in dollars / Selling price per unit.) Prepare a direct materials budget. 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 7. Prepare a cash payments...