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
China Company expects to have a cash balance of $40,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $90,000, February $200,000. Payments for direct materials: January $60,000, February $95,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,000, February $41,000. These costs include depre- ciation of $1,000 per month. All other overhead costs are paid as incured. Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $10,000 in cash. China 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 $25,000. Instructions Prepare a cash budget for January and February.
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. )
Nestee controller for Mactan Relaters has assembled the following data to assist in the preparation of a cash budget for the third quarter of 2021: Sales- May $100,000 ;June $120,000; July $90,000 ; August $100,000 September $135,000; October $110,000 Each month, 30% of sales are for cash and 70% ore on credit. The collection pattern for credit sales is 20% in the month of sale, 50% in the following month, and 30% in the second month following the sale. Each month the ending inventory exactly equals 50% of the cost of next month's sales. The markup on goods is 25% of cost. Inventory purchases are paid in the month following the purchase. Monthly expenses are as follows: Salaries and wages $10,000; Depreciation $4,000; Utlites $1,000; Other $1,700. Property taxes of $15,000 are due and payable on July 15,2021. Advertising fees of $6,000 must be paid on August 20,2021. A lease on a new storage facility is scheduled to begin on September 2, 2021.Monthly payments are $5,000. The…
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 $
Kronos Ltd is preparing a cash budget for May and June of 2021. Past records reveal that 15% of all credit sales are collected during the month of sale, 45% in the month following the sale, 30% in the second month following the sale and 10% in the third month following the sale. The company pays for 55% of purchases in the month after purchase, and the balance is paid in the month following that. Selling expenses amount to $2 400 per month plus 10% of monthly sales. Administrative expenses are estimated to be $9 800 per month, which includes $2 600 of depreciation expense. Finance expenses are $1600 per month. All selling and distribution, administrative, and finance and other expenses (except depreciation) are paid for when incurred. It is planned to purchase equipment during May 2019 at a cost of $7 500. A $5 800 loan payable will be repaid in full including interest charges during June 2019. The interest due at maturity date will be $750. The company’s expected…
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…