Agarwal, Incorporated, has a 32-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company currently has on hand. The company currently has a receivables balance of $245 million and has developed the following sales and cash disbursement budgets (in millions): Sales Total cash disbursement Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow 01 $ 400 332 Ending cash balance Minimum cash balance Cumulative surplus (deficit) 02 $ 502 443 Complete the following cash budget for the company. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Q1 03 $ 608 779 AGARWAL, INCORPORATED Cash Budget (in millions) 400 04 $ 568 471 332 Q2 502 443 Q3 608 779 Q4 568 471

Agarwal, Incorporated, has a 32-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company currently has on hand. The company currently has a receivables balance of $245 million and has developed the following sales and cash disbursement budgets (in millions): Sales Total cash disbursement Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow 01 $ 400 332 Ending cash balance Minimum cash balance Cumulative surplus (deficit) 02 $ 502 443 Complete the following cash budget for the company. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Q1 03 $ 608 779 AGARWAL, INCORPORATED Cash Budget (in millions) 400 04 $ 568 471 332 Q2 502 443 Q3 608 779 Q4 568 471

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter17: The Management Of Cash And Marketable Securities

Section: Chapter Questions

Problem 2P

See similar textbooks

Similar questions

Hurzdan, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $35 million, which is what the company currently has on hand. The company currently has a receivables balance of $189 million and has developed the following sales and cash disbursement budgets (in millions): Q2 Sales $450 Total cash disbursement 268 390 Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Q1 $378 Complete the following cash budget for the company. (A negative answer should be Indicated by a minus sign. Do not round Intermediate calculations and enter your answers in millions rounded to the nearest whole million dollar amount, e.g., 32.) + Q3 Q4 $531 $495 412 617 Q1 HURZDAN, INC. Cash Budget (in millions) 378 268 Q2 450 390 Q3 531 617 Q4 495 412
Agarwal, Incorporated, has a 30-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company currently has on hand. The company currently has a receivables balance of $187 million and has developed the following sales and cash disbursement budgets (in millions): Sales Total cash disbursement Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow Q1 $360 320 Ending cash balance Minimum cash balance Cumulative surplus (deficit) Q2 $ 432 388 Complete the following cash budget for the company. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions rounded to the nearest whole million dollar amount, e.g., 32. $ Q1 Q3 $513 617 AGARWAL, INCORPORATED Cash Budget (in millions) 187 360 Q4 $ 477 391 320 Q2 432 388 Q3 513 617 Q4 477 391
es Agarwal, Incorporated, has a 50-day average collection period and wants to maintain a minimum cash balance of $40 million, which is what the company currently has on hand. The company currently has a receivables balance of $198 million and has developed the following sales and cash disbursement budgets (in millions): Sales Total cash disbursement Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow Q1 $ 459 302 Ending cash balance Minimum cash balance Cumulative surplus (deficit) Q2 $531 466 Complete the following cash budget for the company. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions rounded to the nearest whole million dollar amount, e.g., 32. Q1 Q3 $ 612 720 AGARWAL, INCORPORATED Cash Budget (in millions) 459 Q4 $576 477 302 Q2 531 466 Q3 612 720 Q4 576 477
Cash Management. A firm maintains a separateaccount for cash disbursements. Total disbursementsare $100,000 per month, spread evenly over the month.Administrative and transaction costs of transferringcash to the disbursement account are $10 per transfer.Marketable securities yield 1% per month. Determinethe size and number of transfers that will minimizethe cost of maintaining the special account. (LO4)
Agarwal, Incorporated, has a 32-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company currently has on hand. The company currently has a receivables balance of $245 million and has developed the following sales and cash disbursement budgets (in millions): Sales Total cash disbursement Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow 01 $ 400 332 Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) 02 $ 502 443 Complete the following cash budget for the company. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Q1 Q3 $ 608 779 AGARWAL, INCORPORATED Cash Budget (in millions) 400 04 $ 568 471 332 Q2 502 443 Q3 608 779 Q4 568 471
(Short-Term Finance and Planning) You are hired as a financial manager and your first task is to establish the cash budget of your firm. You gathered the following information. The firm receives all income from sales Sales estimates (in millions) Q1 = 1,000; Q2 = 1,250; Q3 = 1,500; Q4 = 2,000; Q1 next year = 1,200 Accounts receivable Beginning receivables = $3000 Average collection period = 45 days Accounts payable Purchases = 60% of next quarter’s sales Beginning payables = 1,200 Accounts payable period is 45 days Other expenses Wages, taxes, and other expense are 25% of sales Interest and dividend payments are $100 A major capital expenditure of $500 is expected in the second quarter The initial cash balance is $100 and the company maintains a minimum balance of $50
The XYZ customer service branch maintains a disbursement account which is funded by the main office. The branch needs funds for daily disbursements of P40,000 and a minimum balance of P20,000. The cost to transfer funds from the main office to the branch averages P300. The return on money marketable securities is 5%. If the entity uses a 250-day year for financial analysis, how much is the optimal cash amount to be requested by the branch each time?
.You have recently been hired to improve the performance of MJ Cor., which has been experiencing a severe cash shortage. As one part of your analysis, you want to determine the firm's cash conversion cycle. Data gathered were as follows: Current inventory : P120,000 Annual sales : P600,000 Accounts receivable : P157,808 : P25,000 : P365,000 : net 30 days : net 50 days. Accounts payable Total annual purchases Purchases credit terms Receivables credit terms Using 365-day year, the estimated current cash conversion cycle (in days) is?
Striker Company estimates its expected cash receipts for the period to be $80,000 and its expected cash disbursements to be $70,000. The beginning cash balance for the period was $5,000. The management wants to maintain a minimum cash balance of $40,000. Knowledge Check 01 How much cash will the company need to borrow? O $15,000 O $25,000 O $30,000 O $40,000
Tox ltd management expect the next three months from January to March 2018 to demand some unusual cash flows. A cash balance of R106 764 is currently on hand.1. Sales for December 2017: R1 339 200 2. Total sales forecasts are: • January 2018 R 669 600 • February 2018 R 892 800 • March 2018 R 781 200 •April 2018 R 892 800 3. 40% of all sales are on credit, while cash sales amount to 60% of total sales. 4. Cost of goods sold average 75% of sales. Inventory purchased during each month averages the cost of sales for the following month. The creditor payment period averages 15 days and goods are purchased consistently over the month. 5. Operating expenses are projected as follows: • Salaries and wages at 12% of sales paid in the month of the sale. • Other expenses at an average of 10%of sales paid in the month of the sale. • Cash receipts expected from repayment of a loan to an employee of R 22 320 due in March 2018. • Repayment of short-term loan of R11 160 is due in March 2018. •…
Frosty Corp. has a minimum cash balance of PHP 100,000 and forecasted sales of PHP 1,000,000. Accounts receivable is expected to be 5% of sales while inventory is expected to be 15% of cost of sales. Gross profit ratio is 20%. Non-Current assets are budgeted at PHP 400,000. Questions: 1. How much is the total asset requirement? 2. How much is the Accounts receivable? 3. How much is the Inventory?
You are hired as a financial manager and your first task is to establish the cash budget of your firm.You gathered the following information. The firm receives all income from sales•Sales estimates (in millions)* Quarter1 = 1,000; Quarter2 = 1,250; Quarter3 = 1,500; Quarter4 = 2,000; Quarter1 next year = 1,200• Accounts receivable* Beginning receivables = $3000* Average collection period = 45 days• Accounts payable* Purchases = 60% of next quarter’s sales* Beginning payables = 1,200* Accounts payable period is 45 days• Other expenses*Wages, taxes, and other expense are 25% of sales*Interest and dividend payments are $100*A major capital expenditure of $500 is expected in the second quarter•The initial cash balance is $100 and the company maintains a minimum balance of $50 1) Required: establish the cash budget of the firm.