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

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. 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. $ 1 6 69 47 10 2 (5) Quarter (000 omitted) 2 3 57 32 9 2 100 6 108 30 22 2 7 4 31 2 (13) (000 omitted) Year 369 98 51
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 370,000 $ 338,000 $300,000 $ 358,000 Borrowings Repayments Interest The company's beginning cash balance for the upcoming fiscal year will be $35,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Total financing Endinn…
Mooney Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first quarter of the next year). The cash collection estimates are based on sales projections and expected collection of receivables. The sales and cash collection estimates are shown in the following table (in millions of dollars): Q1 Q2 Q3 Q4 Q5 Sales $1,100 $1,400 $1,450 $1,250 $1,500 Total cash collections $1,100 $1,150 $1,200 $1,200 You also have the following information about Mooney Equipment: • In any given period, Mooney’s purchases from suppliers generally account for 72% of the expected sales in the next period, and wages, supplies, and taxes are expected to be 15% of next period’s sales. • In the third quarter, Mooney expects to expand one of its plants, which will require an additional $1,072 million investment. • Every quarter, Mooney pays $60 million in interest and…
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 200,000 $ 350,000 $ 230,000 $250,000 $274,000 $244,000 $234,000 $ 254,000 Total cash receipts Total cash disbursements The company's beginning cash balance for the upcoming fiscal year will be $24,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.)
Fayette Medical Clinic has budgeted the following cash flows. February $232,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $240,000 $272,000 220,000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round intermediate and final answers to the nearest whole dollar amounts.) X Answer is not complete. Cash Budget January February March Section 1: Cash receipts Beginning cash…
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Garden Depot Is a retailer that provided the following budgeted cash flows for next year. 1st Quarter 2nd Quarter $410,000 $ 260,000 $ 316,000 $ 286,000 3rd Quarter $ 290,000 $ 276,000 Total cash receipts Total cash disbursements The company's beginning cash balance for next year will be $36,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume Interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance…
Garden Depot is a retaller that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter $ 280,000 $ 344,888 Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest 2nd Quarter $ 480,000 $ 314,000 The company's beginning cash balance for the upcoming fiscal year will be $45,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Total financing Ending cash balance Required:…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year 01 02 04 Sales # 330 $390 a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables 03 $450 Beginning receivables Sales Cash collections Ending receivables S Beginning receivables Sales Cash collections Ending receivables 01 01 300 330 01 330 b. Accounts receivable at the beginning of the year are $360. The company has a 60-day collection period Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e-g.. 32. 02 330 02 390 Q² 390 03 350 03 450 03 c. Accounts…
Please answer with excel forumlas and step by step explanations. Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $8,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 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. $ 1 S 70 42 14 2 (8) Quarter (000 omitted) 2 3 52 32 8 2 94 10 103 30 17 2 14 4 34 2 (21) (000 omitted) Year 347 103 49
Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…