esAgarwal, Incorporated, has a 50-day average collection period and wants to maintain a minimum cash balance of $40 million, which iswhat the company currently has on hand. The company currently has a receivables balance of $198 million and has developed thefollowing sales and cash disbursement budgets (in millions):SalesTotal cash disbursementBeginning receivablesSalesCash collectionsEnding receivablesTotal cash collectionsTotal cash disbursementsNet cash inflowBeginning cash balanceNet cash inflowQ1$ 459302Ending cash balanceMinimum cash balanceCumulative surplus (deficit)Q2$531466Complete 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 inmillions rounded to the nearest whole million dollar amount, e.g., 32.Q1Q3$ 612720AGARWAL, INCORPORATEDCash Budget(in millions)459Q4$576477302Q2531466Q3612720Q4576477

Answer:- Businesses and individuals can estimated and manage cash flow for a give period, typically…

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 01 $ 459 302 Beginning receivables Q2 $ 531 466 Q3 $ 612 720 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. 04 $ 576 477 Q1 AGARWAL, INCORPORATED Cash Budget (in millions) Q2 Q3 Q4

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 01 $ 459 302 Beginning receivables Q2 $ 531 466 Q3 $ 612 720 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. 04 $ 576 477 Q1 AGARWAL, INCORPORATED Cash Budget (in millions) Q2 Q3 Q4

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The management of MNGO Corporation is currently evaluating if they will need to borrow funds for their fourth quarter operation. Below are the different forecasted cash inflows and outflows of MNGO Corporation for the fourth quarter of the year Forecasted sales for October, November and December are $100,000, $150,000, and $ 180,000 respectively. Based on experience 40% is on cash sales, 40% is collected the following month and the remaining 20% is collected after 2 months when sales was made. It is expected that the company will be receiving $10,000 from its investments on Marketable securities on December. A scrap value of $3,000 is expected to be received by the company on November for the sales of depreciated assets. Monthly cash purchases on inventory is estimated to be 35% of monthly sales. Payment of accounts payable is done monthly which is 10% of the previous months sales. Monthly salary and wages are paid in cash amounting to $20,000 Monthly estimated utilities expense is…
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
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $4,000 to start each quarter. Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $ 7 Add collections from customers 109 392 Total cash available 89 Less disbursements: * Purchase of inventory 48 58 32 Selling and administrative expenses 45 30 127 Equipment purchases 11 9 23 53 Dividends 2 2 2 2 Total disbursements 114 Excess (deficiency) of cash available over disbursements (2) 7 Financing: Borrowings Repayments (including interest) * Total financing Cash balance, ending "Interest will total $1,000 for the year. 18 (22)
ABC Corporation would like to know what its optimal cash balance for its petty cash fund. The daily average disbursement is P5,000. ABC operates 365 days a year. Cost to transfer money into the account average P250 each time. If the money is not in this account, it could have been in an investment account earning 5% per year. Requiired: 1. Optimum cash balance 2. Total cost of holding and maintaining the optimal cash balance
It typically takes Law Corporation 8 days to receive and deposit customer remissions. Law is considering a lockbox system and anticipates that the system will reduce the float time to 5 days. Average daily cash receipts are P220,000. The rate of return is 10 percent. Requirement: What is the reduction in cash balances associated with implementing the system? What is the rate of return associated with the earlier receipt of the funds? What should be the maximum monthly charge associated with the lockbox proposal?
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash ba of $7,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $ 7 $ 7 Add collections from customers 84 88 105 378 Total cash available 91 95 Less disbursements: Purchase of inventory 44 54 28 Selling and administrative expenses Equipment purchases 41 32 30 124 8 8 19 45 Dividends 2 2 2 2 Total disbursements 95 96 Excess (deficiency) of cash available over disbursements (2) (1) 12
37
From the above given information, I am to construct a tabular form of cash budget, however, I don't really understand the question, so I think my answer is wrong, can you try it for me so I can check with my answer?
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $3,000 to start each quarter. Required: Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest)* Total financing Cash balance, ending *Interest will total $1,000 for the year. Quarter 1 (000 omitted) $ 9 97 54 7 2 (5) Quarter 2 (000 omitted) 64 45 9 2 120 12 Quarter 3 (000 omitted) 124 30 29 2 12 Quarter 4 (000 omitted) 30 2 (12) Year (000 omitted) 431 137 55
Please answer numbers 4 and 5 with complete solutions that are original not copy-paste. Thank you so much.
Bhupatbhai
The excess (deficiency) of cash available over disbursements for December would be: P40,400 P68,600 P28,200 P12,200