E21-15 Deitz Corporation is projecting a cash balance of $30,000 in its December 31, 2016, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $185,000. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $43,000. Other information gathered for the first quarter of 2017 is sale of equipment $3,000, direct labor $70,000, manufacturing overhead $35,000, selling and administrative expenses $45,000, and purchase of securities $14,000. Deitz wants to maintain a balance of at least $25,000 cash at the end of each quarter. Instructions Prepare a cash budget for the first quarter.

E21-15 Deitz Corporation is projecting a cash balance of $30,000 in its December 31, 2016, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $185,000. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $43,000. Other information gathered for the first quarter of 2017 is sale of equipment $3,000, direct labor $70,000, manufacturing overhead $35,000, selling and administrative expenses $45,000, and purchase of securities $14,000. Deitz wants to maintain a balance of at least $25,000 cash at the end of each quarter. Instructions Prepare a cash budget for the first quarter.

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

Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?
Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $300,000 $320,000 $290,000 Cash disbursements 280,000 360,000 300,000 The expected cash balance at January 1, 2016, is $82,000. Brewster wants to maintain a cash balance at the end of each month of at least $80,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31, 2016. Brewster CorporationCash Budget for the Quarter EndedMarch 31, 2016 January February March Beginning cash balance Answer Answer Answer Cash receipts Answer…
Suppose that the Sales in December 2019 were 26,630. The sales are expected to grow by 7% in January 2020, by 5% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 11%. The company's cash collection is as follows: 71% is collected in the same month and the remainder in the next month. What is the cash collection for July, 2020?
The following information pertains to Omega Projects Ltd for the three months ended 31 December 2020. Actual Budgeted October November December R R R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional information: It is expected that debtors will settle their accounts as follows: 20% in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of The remaining 5% is usually written off as bad Trade creditors are paid in the month after the purchases at a discount of 5%. 50% of the salaries and wages are weekly wages. Because wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were…
None
Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley’s financial performance: Beginning-of-period balances:Accounts Receivable: $135,000Accounts Payable: $67,500Accumulated Factory Depreciation: $720,000Cash: $33,750 Estimates for end-of-period balances:Accounts Receivable: $168,750Accounts Payable: $45,000Accumulated Factory Depreciation: $740,000 Budgeted activity levels for the period:Sales: $625,000Purchases of Direct Materials: $112,000Direct Labor Wages: $187,500Manufacturing Overhead: $62,500Selling and Administrative Expenses: $105,000 Except for purchases of direct materials, all expenses are paid as incurred. What is the budgeted ending cash balance for the period? Select one: a. None of these options are correct. b. $223,000 c. $191,750 d. $175,500 e. $155,500
Janniel Inc. is preparing its budget for 2016. Income statement for 2015 is presented below: Sales (100,000 units) P1,000,00 Cost of sales 600,000 Gross Profit P400,000 Operating expenses 240,000 Operating Income P160,000 Operating expenses includes depreciation of P40,000. For the year 2016, the company plans to increase selling price by 10% which is expected to decrease sales volume in units by 5%. The cost of sales as a percent of sales will increase to 62%. Other than depreciation, all operating costs are variable. Required: What is the budgeted income for 2016?
The beginning cash balance is $18,000. Sales are forecasted at $860,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $11,300 will be collected in the current year. The company is required to make a $14,000 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $95,000, and the annual interest rate is 8%. Compute the excess of available cash over cash disbursements. Excess of available cash over cash disbursements $
Give me correct answer and explanation.
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)
6
LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of December 31, 2018 is as follows: Assets Liabilities Cash $5,000 Accounts Payable $9500 Accounts Recievable 28,000 Inventories Direct Materials 8,100 Finished Goods (500 Units) 16,870 Stockholders Equity Equipment - gross 45,000 Accumulated depreciation 15.000 Common Stock $15,000 Net Equipment 30,000 Retained Earnings 63,470 Total Assets $87,970 Total Liabilities and $87,960 Equity LB sells one product for $45/unit. The Company forecasts that it will sell 2,000; 1,500; 1,600; and 1,700 units in January, February, March and April, respectively. • Sales to customers are all on credit. 40% of the cash for these sales is collected in the month of the sale and the remaining 60% is collected in the following month. LB wants finished goods inventory equal to 25% of the next month's sales on hand at the end of each month. LB wants direct materials equal to 75% of the current month's production…