Western Company is preparing a cash budget for June. The company has $10,600 cash at the beginning of June and anticipates $31,400 in cash receipts and $37,300 in cash disbursements 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 owes $15,000 to the bank. To maintain the $10,000 required balance, during June the company must: Borrow $5,900 Borrow $10,000 Borrow $5,300 Repay $4,700 Repay $5,300

Western Company is preparing a cash budget for June. The company has $10,600 cash at the beginning of June and anticipates $31,400 in cash receipts and $37,300 in cash disbursements 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 owes $15,000 to the bank. To maintain the $10,000 required balance, during June the company must: Borrow $5,900 Borrow $10,000 Borrow $5,300 Repay $4,700 Repay $5,300

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

Spartan Industries has budgeted the following information for January Cash Receipts $ 43,400 Beginning Cash Balance $ 16,400 Cash Payments $ 61,400 Desired Ending Cash Balance $ 11,400 If there is not enough cash on hand to meet the desired ending balance, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,700 increments. Interest is paid monthly on the first day of the following month. The interest rate is 1 percent per month. The company had no debt before January 1 The shortage or surplus of cash before considering cash borrowed or interest payments in January would be a: Multiple Choice $1,600 shortage $9,800 shortage.
Given the following information, complete the cash budget: Collections occur one month after the sale. January’s credit sales were $90,000. The firm has a certificate of deposit for $50,000 that matures in April. Salaries are $150,000 a month. The monthly mortgage payment is $20,000. Monthly depreciation is $10,000. Property tax of $35,000 is due in February. Round your answers to the nearest dollar. Enter the disbursements values as positive values. Use a minus sign to enter shortage of cash, negative beginning and ending cash values, if any. Do not leave any cells blank. If the answer is zero, enter "0". February March April Sales $ 170,000 $ 200,000 $ 230,000 Cash sales $ 35,000 $ 20,000 $ 70,000 Collections $ $ $ Other receipts $ $ $ Total cash receipts $ $ $ Salaries $ $ $ Mortgage $ $ $ Other disbursements $ $ $ Total cash disbursements $ $ $ Net…
s
Santos Company is preparing a cash budget for February. The company has $16,000 cash at the beginning of February and budgets $65,000 in cash receipts from sales and $114,000 in cash payments during February. Prepare the cash budget for February assuming the company maintains a $5,000 minimum cash balance and will take a loan if necessary to maintain this balance. The company has no loans outstanding on February 1. (Negative cash balances, if any, should be indicated with minus sign.) SANTOS COMPANY Cash Budget February Beginning cash balance Total cash available Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month
Rogers Services, Inc., has $8,000 cash on hand on January 1. The company requires a minimum cash balance of $7,300. January cash collections are $548,380. Total cash payments for January are $565,830. Prepare a cash budget for January. How much cash, if any, will Rogers need to borrow by the end of January? Complete the cash budget below. (Use parentheses or a minus sign for negative ending cash balances or deficiencies.) Rogers Services, Inc. Combined Cash Budget For the Month Ended January 31 Beginning cash balance Plus: Cash collections Total cash available Less: Cash payments Ending cash balance before financing Minimum cash balance desired Cash excess (deficiency)
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business are $250,000, $300,000, and $406,000, respectively, for September, October, and November. The company expects to sell 25% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month of the sale and 30% in the month following the sale. The cash collections in November are a.$101,500 b.$382,150 c.$213,150 d.$458,580
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,800
Karim 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…
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…