Pharoah Company expects to have a cash balance of $64,800 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. Collections from customers: January $89,800, February $164,800. Payments to suppliers: January $58,800, February $93,800. Wages: January $30,530, February $40,530. Wages are paid in the month they are incurred. Administrative expenses: January $21,530, February $24,530. These costs include depreciation of $1,000 per month. All 1. 2. 3. 4. other costs are paid as incurred. Selling expenses: January $15,530, February $20,530. These costs are exclusive of depreciation. They are paid as incurred. Sales of short-term investments in January are expected to realize $12,530 in cash. Pharoah Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $38,800. 5. 6.

Pharoah Company expects to have a cash balance of $64,800 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. Collections from customers: January $89,800, February $164,800. Payments to suppliers: January $58,800, February $93,800. Wages: January $30,530, February $40,530. Wages are paid in the month they are incurred. Administrative expenses: January $21,530, February $24,530. These costs include depreciation of $1,000 per month. All 1. 2. 3. 4. other costs are paid as incurred. Selling expenses: January $15,530, February $20,530. These costs are exclusive of depreciation. They are paid as incurred. Sales of short-term investments in January are expected to realize $12,530 in cash. Pharoah Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $38,800. 5. 6.

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

ABC Company has a cash balance of $37,000 on August 1 and requires a minimum ending cash balance of $24,160. Cash receipts from sales budgeted for August are $200,160. Cash disbursements budgeted for August include inventory purchases, $29,000; other manufacturing expenses, $55,000; operating expenses, $40,000; bond retirements, $62,000; and dividend payments, $27,000. Required: Prepare a cash budget for ABC Company for August. Beginning cash balance. Cash Receipts: Total cash available Cash Disbursements: Total cash disbursements Ending cash balance August
Boris detergents expects to have a cash balance of P46,000 on January 1, 2020. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January P71,000, February P146,000. 2. Payments to suppliers: January P40,000, February P75,000. 3. Wages: January P30,000, February P40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January P21,000, February P24,000. These costs include depreciation of P1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January P15,000, February P20,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize P12,000 in cash. The Company has a line of credit at a local bank that enables it to borrow up to P25,000. The company wants to maintain a minimum monthly cash balance of P20,000. Prepare a cash budget for January and February.
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.
The following is the sales budget for Yellowhead Inc. for the first quarter of 2021: January February $212,000 $232,000 March $255,000 Sales Credit sales are collected as follows: 70% in the month of the sale, 15% In the month after the sale, and 15% in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $96,000 ($66,000 of which was uncollected December sales), a. Calculate the sales for November. (Omit "$" sign in your response.) November sales $ b. Calculate the sales for December. (Round the final answer to 2 decimal places. Omit "$" sign in your response.) $ December sales c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations. Round the final answers to 2 decimal places. Omit "$" sign in your response.) January February March Cash collections $ $ $
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. )
Giving questions, Prepare a cash budget for the January and February for the year 2020
A manufacturing company's sales budget indicates the following sales: January: $30,000; February: $20,000; March: $15,000. The company expects 80% of the sales to be on account. Credit sales are collected 30% in the month of the sale and 70% in the month following the sale. The total cash receipts collected during March will be $
The following information was taken from Pharoah Company cash budget for the month of July: Beginning cash balance $155000 Cash receipts 149000 Cash disbursements 211000 If the company has a policy of maintaining an end of the month cash balance of $155000, the amount the company would have to borrow is
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…
Crane Company expects to have a cash balance of $36,000 on January 1,2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $68,000, February $120,000.Payments for direct materials: January $40,000, February $60,000.Direct labor: January $24,000, February $36,000. Wages are paid in the month they are incurred.Manufacturing overhead: January $16,800, February $20,000. These costs include depreciation of $1,200 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $12,000, February $16,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $9,600 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $20,000. The company wants to maintain a minimum monthly cash balance of $16,000. Prepare a cash budget for January and February. ReceiptsCollections from…
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.