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 Total cash receipts $ 250,000 $ 400,000 $ 280,000 $ 300,000 Total cash disbursements $ 309,000 $ 279,000 $ 269,000 $ 289,000   The company’s beginning cash balance for the upcoming fiscal year will be $34,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. (Cash deficiency, repayments and interest should be indicated by a minus sign.)

Vishnu

The company provides the following information regarding the cash budget for next year:   Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?

Verle, Inc. has a cash balance of $24,000 on April 1. The company is now preparing the cash budget for the second quarter. Budgeted cash collections and payments are as follows: Cash collections Cash payments: Purchases of direct materials Operating expenses Apr May Jun $24,000 $24,000 $25,000 5,800 4,600 4,600 6,000 3,500 5,300 There are no budgeted capital expenditures or financing transactions during the quarter. Based on the above data, calculate the projected cash balance at the end of May. OA. $60,200 OB. $24,000 OC. $52,100 OD. $55,600

The budgeted sales of Kelley, SA for the given months are as follows:   Cash Sales Credit Sales April $38,000 $256,000 May $54,000 $250,000 June $36,000 $192,000 July $33,000 $190,000 August $35,000 $287,000 To prepare a cash budget, the company needs to determine the expected cash collections each month, and has provided the following additional information:   The Accounts Receivable balance on April 1 was $82,015. Of this amount, $57,015 represented uncollected March sales and $25,000 represented uncollected February sales. Collections on Credit sales: 65% in month of sale 30% in month following sale 5% in second month following sale Part 1:   What should the April cash collected be? $BLANK Part 2: For August 1, what is budgeted Accounts Receivable? (76,100, 100,300, 109,950, 144950, OR 79,700)

The controller of Optimum wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance Dividends were declared on June 15* $130,000 44, 000 83,600 13,000 198,000 122,400 47,000 70, 000 Cash expenditures to be paid in July for operating expenses Depreciation expense Cash collections to be received Merchandise purchases to be paid in cash Equipment to be purchased for cash Optimum wishes to maintain a minimum cash balance of *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "O" wherever required).

Determine the anticipated total cash receipts for the month of January for Madison Co. in preparing a Cash Budget, given the following info: Accounts Receivable balance as of January 1 $296,000.00 Budgeted Sales for January = $860,000.00 Madison Co. assumes all monthly sales are on account. And that 75% of the sales on account will be collected in the month of the sale, and that the remainder will be collected the following month. $688,000.00 $812,000.00 $941,000.00 O $468,000.00

Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley's financial performance: Beginning-of-period balances: Accounts Receivable: $108,000 Accounts Payable: $54,000 Accumulated Factory Depreciation: $576,000 Cash: $27,000 Estimates for end-of-period balances: Accounts Receivable: $135,000 Accounts Payable: $36,000 Accumulated Factory Depreciation: $592,000 Budgeted activity levels for the period: Sales: $500,000 Purchases of Direct Materials: $89,600 Direct Labor Wages: $150,000 Manufacturing Overhead: $50,000 Selling and Administrative Expenses: $84,000 Except for purchases of direct materials, all expenses are paid as incurred. What is the budgeted ending cash balance for the period? Select one: O O O a. $178,400 b. $140,400 $152 400

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 $ 350,000 $ 393,000 3rd Quarter $ 400,000 $ 353,000 4th Quarter $ 420,000 $ 373,000 $ 470,000 $ 363,000 The company's beginning cash balance for the upcoming fiscal year will be $20,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.) 2nd Quarter…

Gadubhai