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 cashbudget 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 BudgetFor the Month Ended January 31Beginning cash balancePlus: Cash collectionsTotal cash availableLess: Cash paymentsEnding cash balance before financingMinimum cash balance desiredCash excess (deficiency)

A cash budget is prepared at the beginning of the period to minimize the cash expenses by the…

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 ca budget for January. How much cash, if any, will Rogers need to borrow by the end of January?

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 ca budget for January. How much cash, if any, will Rogers need to borrow by the end of January?

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

Justin Company's budget includes the following credit sales for the current year: September, $41,000; October, $52,000; November, $46,000; December, $48,000. Credit sales are collected as follows: 20% in the month of sale, 55% in the first month after sale, 22% in the second month after sale, and 3% is uncollectible. How much cash can Justin expect to collect in November as a result of current and past credit sales? Multiple Choice $35,420. $46,820. $49,620. $44,220. $46,000.
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 $ 519,000 $ 468,000 404,000 452,000 353,000 521,000 Kayak requires a minimum cash balance of $40,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 $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,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.)
Dorel Company expects to have a cash balance of $5,000 on January 1, 2013. Relevant monthly budget data for the first two months of 2013 are as follows: 1. Collections from customers: January $60,000; February $75,000 2. Sales of marketable securities in January are expected to realize $10,000 in cash. 3. Purchase delivery truck in January and paid cash $12,000. 4. Payments to suppliers: January $15,000; February $25,000 5. Direct labour: January $25,000; February $20,000. Wages are paid in the month they are incurred. 6. Manufacturing overhead: January $8,000; February $7,000. These costs include depreciation of $3,000 per month. All other overhead costs are paid as incurred. 7. Selling and administrative expenses: January $10,000; February $12,000. These costs are excluşive of depreciation. They are paid as incurred. Dorel Company has a line of credit at a local bank. It can borrow up to $20,000 at 4% per annum, The company wants to keep a minimum monthly cash balance of $15,000
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
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:
Urban Industries needs to maintain a minimum cash balance of $10,000 and has entered into an agreement with their bank to accomplish this. Urban is preparing a cash budget for September. Urban has $11,300 in cash at the beginning of September and anticipates $30,700 in cash receipts and $35,900 in cash payments during September. As of August 31, the company has no loans outstanding. To maintain the $10,000 required balance, during September the company must: O A. Borrow $3,900. O B. Borrow $10,000. OC. Borrow $5,200. OD. Repay $3,900. OE.Repay $6.100.
A Company is preparing a cash budget for June The company has $83,750 cash at the beginning of June and anticipates $102,930 in cash receipts and $116,870 in cash disbursements during June. This company has an agreement with its bank to maintain a cash balance of at least $81 250. As of May 31. the company owes $30,000 to the bank To maintain the $81.250 required balance, during June the company must O Borrow $11 440 O Repay $13,940 O Borrow $30 000 Repay $30,000 O Repay $11,440
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…
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
Santos Company is preparing a cash budget for February. The company has $15,000 cash at the beginning of February and budgets $72,000 in cash receipts from sales and $105,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 Beginning cash balance Total cash available Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month February
Santos Co. is preparing a cash budget for February. The company has $20,000 cash at the beginning of February and anticipates $75,000 in cash receipts and $100,250 in cash payments during February. What amount, if any, must the company borrow during February to maintain a $5,000 cash balance? The company has no loans outstanding on February 1.
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 $ 525,000 400,000 450,000 $ 475,000 350,000 525,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 Ibans 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 Total…