Western Company is preparing a cash budget for June. The company has $10,400 in cash at the beginning of June and anticipates $31,600 in cash receipts and $37,700 in cash payments during June. Western Company has an agreement with its bank to maintain a minimum cash balance of $10,000. As of May 31, the company has no loans outstanding. To maintain the $10,000 required balance, during June the company must:
Q: Karim Corporation requires a minimum $8,200 cash balance. Loans taken to meet this requirement cost…
A: Preparation of cash budget are as follows
Q: Papst Company is preparing its cash budget for the month of May. The following information is…
A: 1. $176,9002. $201,6003. $181,2004a. $197,9004b. $119,700Explanation:Only the March provision for…
Q: The budget director of Heather's Florist has prepared the following sales budget. The company had…
A: the amount of accounts receivable the company will report on its third quarter pro forma balance…
Q: Bantam Industries has budgeted the following information for March: Cash receipts Beginning cash…
A: Lets understand the basics. Cash budget is prepared by the management to estimate the flow of cash…
Q: Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and…
A: >Cash Budget is prepared as part of budgeting process. >It is usually the final budget…
Q: Foyert Corporation requires a minimum $7,400 cash balance. Loans taken to meet this requirement cost…
A: Budgeting anticipates revenue and expenditures for a future period based on the past performance and…
Q: Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and…
A: The cash budget is prepared to record the cash receipts and cash payments for the period. The cash…
Q: During December 2021, Hybrid has the following information to prepare its cash budget for January (4…
A: Calculation of amount of collection from credit sales to customer : Particulars Amount For…
Q: ces Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received)…
A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…
Q: All sales at Alaska Company are on credit. The company is preparing a cash budget for November. The…
A: Cash receipts means the amount of cash collected by the entity either from the sales of current…
Q: crane company management wants to maintain a minimum monthly cash balance of $26,500. At the…
A: The cash budget is an estimate of cash receipts and their payment during a future period of time.
Q: Santos Co. is preparing a cash budget for February. The company has $14.000 cash at the beginning of…
A: Cash budget refers to the process of creating a budget in order to estimate the cash flows of a…
Q: The Kansas Company is preparing a cash budget for the month of July. The following information on…
A: The cash budget is prepared by the management to estimate the expected cash receipt and cash…
Q: The budget director of Heather's Florist has prepared the following sales budget. The company had…
A: The account receivables represent the amount due from the customers but not received yet. The…
Q: A company is preparing its cash budget. Its cash balance on January 1 is $290,000, and it has a…
A: A Cash budget represents the expected future cash flow of an organization over a defined period of…
Q: The budget director of Heather’s Florist has prepared the following sales budget. The company had…
A: Cash receipts means the amount of cash received by the entity during a particular period whether the…
Q: Matthew Young has been working on Sheffield Paints' cash budget for the coming year. Based on his…
A: A cash budget is prepared to estimate the cash flows of a business during a specific period of time.…
Q: $14,500, accounts receivable of $473,000, inventories of $482,250, and accounts payable of $169,055.…
A: A Cash Budget is a forecast of expected cash receipts & expected cash payments. The Cash Budget…
Q: Santos Company is preparing a cash budget for February. The company has $19,000 cash at the…
A: The cash budget is prepared to estimate the cash balance and cash requirements for the period. The…
Q: The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain…
A: The cash flow statement is used to record the various activities for the inflow and outflow of cash…
Q: Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and…
A: The cash budget is prepared by the entity to know the cash receipts and cash payments for the…
Q: The cash budget for the first three quarters of the HICASH-932 company is given below (000 omitted).…
A: A cash budget is prepared to estimate the total cash received and total cash disbursement. It is…
Q: Zolezzi Incorporated is preparing its cash budget for March. The budgeted beginning cash balance is…
A: Budgeting anticipates revenue and expenditures for a future period based on the past performance and…
Q: The cash budget for the first three quarters of the HCASH-420 company is given below (000 omitted.…
A: Financial budgets: Financial budgets are prepared in order to ascertain the resources required to…
Q: a. Complete the cash budget by filling in the missing amounts
A: Given in the question: Desired to maintain the cash balance of $15,000 at the end of each month and…
Q: Cougar Hotel is preparing a cash budget for October. The hotel has $12,000 cash at the ending of…
A: Formula: Ending cash balance without considering borrowings = Beginning balance + Receipts -…
Q: Bantam Industries has budgeted the following information for March: Cash receipts Beginning cash…
A: Introduction: Cash budget is prepared by the management to estimate the flow of cash during a…
Q: Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and…
A: The cash budget is usually prepared to forecast the future inflow and outflow of the cash. This will…
Q: Karim Corporation requires a minimum $9,700 cash balance. Loans taken to meet this requirement cost…
A: Cash budget is the statement prepared by the entity to estimate the cash receipts and cash payments…
Q: Sunshine Company is in the process of developing its first quarter budget by month and is having…
A: A Cash Budget represents the cash receipts and cash payments for the period. It helps the company to…
Q: Papst Company is preparing its cash budget for the month of May. The following information is…
A: "Since you have asked a question with sub-parts more than three, as per guidelines, the first three…
Q: Eastern has $12,000 cash at the beginning of June and anticipates $30,000 in cash receipts and…
A: Cash budget refers to estimation of cash flows for the organization over given period of time.
Q: Karim Corporation requires a minimum $8,800 cash balance. Loans taken to meet this requirement cost…
A: Answer:-Cash budget is the statement prepared by the entity to estimate the cash receipts and cash…
Q: Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and…
A: Lets understand the basics. Management prepares budget for the purpose of determining future profit…
Q: Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost…
A: Budget means the expected value of future. Budget will be compared with actual value and variance is…
Q: is preparing a budget company has $1 beginning February and anticipates $67,000 in cash receipts and…
A: The cash budget is prepared to record the receipts and payments during the period. The cash budget…
Q: A company requires a minimum $12,400 cash balance at each month-end. If necessary, a loan is taken…
A: Budgeting is a method of estimating expected future outcomes based on past events. Budgeting…
Q: Spartan Industries has budgeted the following information for January Cash Receipts $ 43,400…
A: Interest payment refers to the amount of money paid by a borrower to a lender for the use of…
Q: Santos Company is preparing a cash budget for February. The company has $16,000 cash at the…
A: Cash budget means expected cash receipts and expected cash payment with opening and closing cash…
Q: Rogers Services, Inc., has $8,000 cash on hand on January 1. The company requires a minimum cash…
A: A cash budget is prepared at the beginning of the period to minimize the cash expenses by the…
Q: Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash…
A: For a company or an organization cash is an important source which are are used by the company to…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- 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 $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 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. Beginning cash balance Add: Cash receipts Total cash available KAYAK COMPANY Cash Budget January $ 30,000…On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. January February March Month Credit Sales $300,000 (actual) 400,000 (actual) 473,000 (estimated) April May 671,000 (estimated) 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale Collections one month after the sale Collections two months after the sale Uncollectible accounts 50% 30 15 5 Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Compute Spicer's budgeted cash balance at the ends of March, April, and May. Answer is complete but not entirely…The following information was taken from Trusted Care Company's cash budget for the month of April: Beginning cash balance Cash receipts Cash disbursements If the company has a policy of maintaining an end of the month minimum cash balance of $25,000, the amount the company would have to borrow is $10,000 $13,000 $11,000 $0 $27,000 62,000 75,000
- Floss Company has $13,000 in cash on hand on January 1 and has collected the following budget data: Assume Floss has cash payments for selling and administrative expenses including salaries of $66,000 plus commissions of 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $11,000. Prepare a cash budget for January and February. Will Floss need to borrow cash by the end of February? Beginning bye preparing the cash budget for January, then the cash budget for February. (Complete all input fields. Enter a “0” for any zero balances. )The Lowville Company has budgeted the following data for November: • Sales of $1,728,300, all in cash. • A cash balance on November 1 of $72,000. • Cash disbursements (other than interest) during November of $1,740,000. • A minimum cash balance of $90,000 at the end of each month. The company has 2% open line of credit for $100,000. All borrowing will take place at the beginning of the month. The November interest will be paid in cash when repayment is made. The excess (deficiency) of cash available over disbursements for November will be: A. $(11,700) B. $ (29,700) C. $60,300 D. $72,000 1. 2. The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is: A. $11,700 B. $18,000 C. $29,700 D. $30,000 The minimum cash balance the Lowville Company should have in order to make both repayment and interest payment in December should be closest to: A. $18,060 B. $29,800 C. $90,600 D. $119,800Karim Corporation requires a minimum $8,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $8,300 is used to repay loans at month-end. The cash balance on July 1 is $8,700, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan July $ 24,300 28,450 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance August $ 32,300 30,300 Loan balance - Beginning of month Additional loan (loan…
- Vaughn, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Vaughn desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Beginning cash balance Collections from sales Total cash available Less disbursements Materials purchases Direct labor Manufacturing overhead Selling & administrative expenses Equipment purchase Dividends Total disbursements Excess (deficiency) of cash Minimum cash balance Cash available (needed) Financing: Borrowings Repayments Interest Total financing Ending cash balance October 50,000 66,500 5,000 20,000 28,500 66,000 15.000 -14,500 $15.500 November $15.500 $ 93,500 10.000 6,000 24,000 25,000 28.500 15.000 -150 -15,150 $13,350 $ December 120,000 14,000 8,000 22,000 5,000 15,000 9,000 $ Quarter…Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $225,000 $ 293,000 $ 438,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May: 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate…Karim Corporation requires a minimum $8,100 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $8,100 is used to repay loans at month-end. The cash balance on July 1 is $8,500, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash available July August $ 24,100 $ 32,100 28,150 30,100 Total cash payments Preliminary cash balance Loan activity Ending cash balance September $ 40,100 32,100 KARIM CORPORATION Cash Budget $ July Loan balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance…
- The president of the retailer Prime Products has just approached the company's bank with a request for a $57,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $30,800. Accounts receivable on April 1 will total $159,600, of which $136,800 will be collected during April and $18,240 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…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).The accountant for Baird's Dress Shop prepared the following cash budget. Baird's desires to maintain a cash balance of $24,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month. Required a. Complete the cash budget by filling in the missing amounts. b. Determine the amount of net cash flows from operating activities Baird's will report on the third quarter pro forma statement of cash flows. c. Determine the amount of net cash flows from financing activities Baird's will report on the third quarter pro forma statement of cash flows. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the cash budget by filling in the missing amounts. Note: Any shortages or repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount. Cash Budget July August September Section 1: Cash receipts Beginning cash balance…
