ABC Company has a cash balance of $40,000 on August 1 and requires a minimum ending cash balance of $28,960. Cash receipts from sales budgeted for August are $210,960. Cash disbursements budgeted for August include inventory purchases, $32,000; other manufacturing expenses, $52,000; operating expenses, $43,000; bond retirements, $65,000; and dividend payments, $30,000. Required: Prepare a cash budget for ABC Company for August.

ABC Company has a cash balance of $40,000 on August 1 and requires a minimum ending cash balance of $28,960. Cash receipts from sales budgeted for August are $210,960. Cash disbursements budgeted for August include inventory purchases, $32,000; other manufacturing expenses, $52,000; operating expenses, $43,000; bond retirements, $65,000; and dividend payments, $30,000. Required: Prepare a cash budget for ABC Company for August.

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

Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget…
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 February March $ 519,000 409,000 476,000 $ 459,200 349,200 532,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 Less: Cash payments for Interest on loan…
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 $ 310,000 $ 438,038 $365,008 $ 335,000 Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments and interest should be indicated by a minus sign. The company's beginning cash balance for the upcoming fiscal year will be $25,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…
Mass Company has $9,500 in cash on hand on January 1 and has collected the following budget data: E (Click the icon to view the budget data) Assume Mass has cash payments for selling and administrative expenses including salaries of $60,000 plus commissions of 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of $9,000 Prepare a cash budget for January and February. Will Mass need to borrow cash by the end of February? Begin by preparing the cash budget for January, then prepare the cash budget for February (Complete all input fields. Enter a "0" for any zero balances.) Mass Company Cash Budget Two Months Ended January 31 and February 28 January Beginning cash balance Cash receipts Data Table Cash available Cash payments: Purchases of merchandise inventory January February Selling and administrative expenses Sales 1.340,000 $ 690,000 Total cash payments Cash receipts from customers 851 420 871,100 Ending cash balance before financing Cash payments…
Foyert Corporation requires a minimum $7,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.
Riverbed Inc. provided the following information: April Projected merchandise purchases $92,500 Calculate budgeted cash disbursements for May. May $82,000 Total budgeted cash disbursements $ June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. $69,000
Karim Corporation requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $9,000 is used to repay loans at month-end. The cash balance on July 1 is $9,400, 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. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 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.)
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.
D’s Company Ltd expects to have a cash balance of $45000 on March 1, 2024.Relevant monthly budget data for the months of March and April are as follows:• Collections from customers: March $85000; April $150000• Payments for direct materials: March $50000; April $75000• Direct labour: March $30000; April $45000. Wages are paid in the month they are incurred.• Manufacturing overhead: March $21000; April $25000. These costs include depreciation of$1500 per month. All other overhead costs are paid as incurred.• Selling and administrative expenses: March $15000; April $20000. These costs are exclusive ofdepreciation. They are paid as incurred.• Sales of marketable securities in March are expected to be realised $12000 in cash.D’s Company Ltd. has a line of credit at a local bank that enables it to borrow up to$25000. Thecompany wants to maintain a minimum monthly cash balance of $20000. prepare cash budgets for march n april 2024