or August. The company has $18,100 cash at the beginning of August and anticipates $123,000 in cash receipts and $136700 in cashts to maintain a minimum cash balance of $10,00O. To maintain the minimum cash balance of $10,00O, the company must borrow. Southland Company Is preparing a cash budget for August. Thne company has $18,100 cash at the beginning of August and anticipates $123.000 lepayments during August. Southland Company wants to maintain a minimum cash balance of $10,000. To maintain the minimum cash balance cfMultiple Choice$10,000.$0.$28,100.$8,100.$5,600.

The cash budget is prepared to estimate the requirements for cash during the period.

Southland Company Is preparing a cash budget for August. The company has $18,100 cash at the beginning of August and anticipaten $123000 payments during August. Southland Company wants to maintain a minimum cash balance of $10,000. To maintain the minimum canin balance ch Multiple Choice $10,000. $0. $28,100. $8,100. $5,600.

Southland Company Is preparing a cash budget for August. The company has $18,100 cash at the beginning of August and anticipaten $123000 payments during August. Southland Company wants to maintain a minimum cash balance of $10,000. To maintain the minimum canin balance ch Multiple Choice $10,000. $0. $28,100. $8,100. $5,600.

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

Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $39,161 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first day of the month. That way they will not risk having too low of a balance during the month. They can borrow any amount of money needed. They may not pay loans back in installments. They have to pay them back all at once. The interest rate is 12%. Assume if they pay back money, they pay it back on the last day of the month. What is the ending cash balance for November after all loan repayments of principle and interest? Round your answer to the nearest whole…
The following information was taken from Bonita Industries's cash budget for the month of July: Beginning cash balance $440000 Cash receipts 404000 Cash disbursements 558000 If the company's policy is to maintain a minimum end of the month cash balance of $430000, the amount the company would have to borrow in July is $286000. $144000. $10000. $26000.
Cheddar's Café is preparing its cash budget for August. At the beginning of the month, the café expects to have $17,500 in total available cash. Over the course of the month, it expects to make $12,250 in cash disbursements and obtain $3,750 in financing. What is Cheddar's anticipated ending cash balance for August? O $9,000 O $5,250 O $26,000 O $1,500
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. January February⚫ March Cash Receipts Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,000 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, 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 $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
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 $ 210,000 $ 240,000 $ 281,000 $ 241,000 The company's beginning cash balance for the upcoming fiscal year will be $26,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: Borrowings Repayments Interest $360,000 $ 251,000 Required: Prepare…
Tomo, Inc. has prepared its third quarter budget and provided the following data: Jul $49,000 Aug $39,800 Sep $47,900 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 17,900 11,100 0 The cash balance on June 30 is projected to be $4,600. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the final projected cash balance at the end of August taking into consideration all the financing transactions. 31,000 12,100 13,700 O A. $46600 OB. $-8842 OC. $15000 O D. $6158 21,800 8,700 24,900
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…
Bantam Industries has budgeted the following information for March: Cash receipts Beginning cash balance Cash payments Desired ending cash balance If there is a cash shortage, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,000 increments, and interest is paid monthly at 1% on the first day of the following month. The company had no debt before March 1. How much cash will the company need to borrow in March? Multiple Choice $13,000 $65,000 $ 343,000 23,000 388,000 43,000 $52,000 The company should not need to borrow any cash In March
Bustillo Incorporated is working on its cash budget for March. The budgeted beginning cash balance is $36,000. Budgeted cash receipts total $117,000 and budgeted cash disbursements total $111,000. The desired ending cash balance is $53,500. To attain its desired ending cash balance for March, the company needs to borrow: Multiple Choice $95,500 $11,500 $0 $53,500
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.
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 $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, 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 $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
Garden Depot is a retailer that provided the following budgeted cash flows for next year: 1st Quarter 2nd Quarter 3rd Quarter 4th QuarterTotal cash receipts $ 290,000 $ 410,000 $ 340,000 $ 360,000Total cash disbursements $ 351,000 $ 321,000 $ 311,000 $ 331,000The company’s beginning cash balance for next year will be $47,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.