CASH BUDGET 3. EEVEE CORP. prepared cash estimates for the next four months. developed for certain items: The following estimates were April P6,000 2,000 1,500 2,600 2,400 In February, credit sales totaled P9,000, and purchases totaled P5,000. January credit sales were P12,000. Accounts receivable collections amount to 30 % in the month after the sale and 60% in the second month after the sale; 10% of the receivables are never collected. Payroll and other expenses are paid in the month incurred. Seventy-five percent of the purchases are paid in the month incurred, and the remainder are paid in the following month. A P15,000 tax payment is due on June 15. The cash balance was P5,000 on March 1. The company wants a minimum cash balance of P5,000 per March May P8,000 6,000 2,500 2,800 2,600 Item June Cash sales P10,000 5,000 2,000 3,000 2,500 P11,000 9,000 3,000 4,000 2,800 Credit sales Payroll Purchases Other expenses month. REQUIREMENTS: (a) Prepare a cash budget for the four-month period, March through June. (b) List the amount of funds available for investing or required for borrowing in each month.

CASH BUDGET 3. EEVEE CORP. prepared cash estimates for the next four months. developed for certain items: The following estimates were April P6,000 2,000 1,500 2,600 2,400 In February, credit sales totaled P9,000, and purchases totaled P5,000. January credit sales were P12,000. Accounts receivable collections amount to 30 % in the month after the sale and 60% in the second month after the sale; 10% of the receivables are never collected. Payroll and other expenses are paid in the month incurred. Seventy-five percent of the purchases are paid in the month incurred, and the remainder are paid in the following month. A P15,000 tax payment is due on June 15. The cash balance was P5,000 on March 1. The company wants a minimum cash balance of P5,000 per March May P8,000 6,000 2,500 2,800 2,600 Item June Cash sales P10,000 5,000 2,000 3,000 2,500 P11,000 9,000 3,000 4,000 2,800 Credit sales Payroll Purchases Other expenses month. REQUIREMENTS: (a) Prepare a cash budget for the four-month period, March through June. (b) List the amount of funds available for investing or required for borrowing in each month.

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

Newman Medical Clinic has budgeted the following cash flows. January February March $101,000 $107,000 $127,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Cash Budget Beginning cash balance Add: Cash receipt Cash available Less: Cash payments 90,500 31,500 Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) For inventory purchases For S&A expenses Interest expense per month…
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.)
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…
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $40,000 and $77,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month?
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.)
Tomo, Inc. has prepared its third quarter budget and provided the following data: Jul $49,000 Aug $39,800 Sep $47,900 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 17,900 11,100 0 The cash balance on June 30 is projected to be $4,600. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the final projected cash balance at the end of August taking into consideration all the financing transactions. 31,000 12,100 13,700 O A. $46600 OB. $-8842 OC. $15000 O D. $6158 21,800 8,700 24,900
X-Tel budgets sales of $55,000 for April, $110,000 for May, and $70,000 for June. Sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. Total sales for March were $13,000. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from: Total cash receipts X-TEL Schedule of Cash Receipts from Sales April $ $ 55,000 $ 0 $ May 110,000 $ 0 $ June 70,000 0
A company's budgeted sales and cash payments for merchandise for the next two months follow. July August Budgeted sales $ 33,300 $ 42,300 Budgeted cash payments for merchandise purchases 20,510 17,540 Sales in June are $26,800. Sales are 40% cash and 60% on credit. All credit sales are collected in the month after the sale. The June 30 balance sheet includes $12,600 in cash and $2,100 in loans payable. The company requires a $12,600 minimum cash balance. The company takes loans as needed at month-end to meet this minimum balance. Interest of 1% month (based on the loan balance at the beginning of the month) is paid at each month-end. Preliminary cash balances above $12,600 at each month-end are used to repay any loans. Expenses include office salaries of $5,410 per month, rent of $3,310 per month, sales commissions at 10% of sales dollars, and shipping at 2% of sales dollars; these expenses are paid in the month incurred. Dividends of $1,160 will be paid in August. Prepare a schedule…
The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $41,000. b. Actual sales for May and June and expected sales for July are as follows: May $ 68,400 $ 87,400 $ 95,800 $ 415,000 $ 614,000 $ 692,000 June July Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected In the second month following sale. The remaining 2% is uncollectible. C. Purchases of inventory will total $376,000 for July. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $174,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $452,000 for July. Of this amount, $63,500 is for depreciation. e. A new web server for the Marketing Department costing $86,500 will be…
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.
Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $45,000 and $65,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month? Multiple Choice $13,500 $31,500 $25,500 $49,000