Explore BrainMass

Cash Budgeting

Cash budgeting

Grace Jones, the recently hired treasurer of Toy World, Inc., a manufacturer of speciality toys, was summoned to the office of Dan Culbreth, the president and chief executive officer. When she got to Dan's office, Grace found him shuffling through a set of worksheets. He told her that because of a recent tightening of credit

Prepare a Pro Forma Income Statement

1. Prepare a Pro Forma Income Statement Net Sales =2,938 COGS=1,598 SG&A=475 Depreciation=45 Interest Exp=32 Tax=15% Net Sales Cost Of Goods Sold Gross Profit Selling & Admin Exp Depreciation Interest Exp Income Before Taxes Income Taxes Net Profit 2. In a fixed cash budget, cash flow estimates are made for a si

Developing a Cash Budget

The sales budget for your company in the coming year is based on a 20 percent quarterly growth rate with the first-quarter sales projection at $100 million. In addition to this basic trend, the seasonal adjustments for the four quarters are 0, -$10, -$5, and $15 million, respectively. Generally, 50 percent of the sales can b

Cash Budget Analysis missing data

A cash budget, by quarter, is given below for a retail company. The company requires a minimum cash balance of at least $5,000 to start each quarter. Required: Fill in the missing amounts in the table below: QUARTER 1 2

Budgeting Cash Collections

I sell a product which I purchased for $20 for $30. Budgeted sales in total dollars for next year are $720,000. The sales information are the follow: Month Sales Revenue May $30,000 June $42,000 July $48,000 August $60,000 My account balances at July 1 include: Cash $15,000 Merchandise Inventory $16,000

Schedule of expected cash collections/purchses budget

14. Caprice Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: -Sales are budgeted at $350,000 for November, $320,000 for December, and $300,000 for January. -Collections are expected to be 80% in the month of sale, 16% in the month following the sale, and 4% uncollectible. -The c

Cash budget

The Kenanga Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales $50,000 $70,000 $90,000 $60,000 Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on ac

Calculating the Cash Budget for Cornell, Inc.

Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2007: April May June Credit sales $380,000 $396,000 $438,000 Credit purchases 147,000 175,500 200,500 Cash disbursements Wages, taxes, and

Schedule of Expected Cash Collections; Cash Budget

Jodi Horton, president of the retailer Crestline Products, has just approached the company's bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories in support of peak April sales. Since the company has had some difficulty in paying off its loans in the past, the

Cash Budget for Finance Samples

Chap 4 # 24 and 25 complete cash budget Archer electronics company's actual sales and purchases for April and may are show here along with forecasted sales and purchases for june through September. Sales Purchases April(actual) 320,000

WACO Co. - Preparation of a Cash Budget

Preparation of a cash budget Use the following information to prepare the July cash budget for the WACO Co. It should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31. a. beginning cash balance on July 1: $50,000 b. cash receipts from sales: 30% is collected in the

Loblaw Manufacturing: Create a cash budget with Financial Analysis

Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs over August to December period. You have gathered the following information. Month Sales Other Payments August 160,000 80,000 September 110,000 65,000 October 95,000 60,000 November 84,000 45,000 December 76,000 48,000 J

Glover: Compute budgeted cash collections and disbursements for Company A, B & C CASH BUDGET Company A Company B Company C Beginning cash balance $100 $300 $700 Cash collections ? 400 ? Cash disbursements 500

What is a cash budget?

1. What is a cash budget? a. Detailed plan of future cash flows b. A budget that shows only what cash comes in c. A historical look at cash flows d. A report that analyzes the cash account e. A report that analyzes the accounts receivable 2. What is the key in

Quarterly Cash Budget

Given the new details below to do the following: · Construct a quarterly cash budget for Lawrence · Tell me what is the largest amount of bank debt needed and when is it needed · Circle them in the on the borrowing line of the matrix · What is the largest amount of surplus cash flow generated by Lawrence and when doe

Cash Receipts & Cash Budget

2. The Merry Christmas Gift Shoppe has forecast its sales revenues and purchases for the last 5 months of 2008 to be as follows: Sales Purchases August $22,000 $17,000 September 15,000 19,500 October 25,000 29,000 November 30,000 20,000 December 26,000 24,000 60% of sales are on credit. On the basis of past experie

Meeks Company: compute cash collections, budgeted inventory, cash payments

See attached file All sales at Meeks Company, a wholesaler, are made on credit. Experience has shown that 70% of the accounts receivable are collected in the month of the sale, 26% are collected in the month following the sale, and the remaining 4% are uncollectible. Actual sales for March and budgeted sales for the following

Preparing a cash budget

Prepare a cash budget for Rotor Products, Inc. for the second quarter of 2006, based on the following. All are for cash: Total Sales March 2006 (actual) 425,000 April 2006 330,000 May, 2006 420,000 June, 2006 450,000 The company estimates its purchases

Cash budget problem

The following information is budgeted for Jana supply company for the next quarter: April May June Sales $110,000 $130,000 $180,000 Merchandise purchases $85,000 $92,000 $105,000 Selling and administrative

Activity based budgeting

Please see attached file. The Airhart Company's budgeted income statement reflects the following amounts: Sales Purchases Expenses January $190,000 $78,000 $34,000 February

Wilma Brown, treasurer of Columbia Civic Theater (CCT)

See attach word document and excel file. Wilma Brown, treasurer of Columbia Civic Theater (CCT), was preparing a loan request to the Northeast National Bank in December 2004. The loan was necessary to meet the cash needs of the theater for year 2005. In a few short years, the CCT had established itself as a premier theater. I

Finance problem cash budget

23. Cash Budget. The following data are from the budget of Ritewell Publishers. Half the company's sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $30 and total sales in January were $180

P7-2A Oneida Company: Preparation of cash budgets (for three periods)

Preparation of cash budgets (for three periods) See pdf attached Question 2: (10 points) Problem 7-2A: Preparation of cash budgets (for three periods) L.O. C3, P2 During the last week of August, Oneida Company's owner approaches the bank for an $100,000 loan to be made on September 2 and repaid on November 30 with annua

Prepare a master budgeting template for sales, production and cash flow

Budgeting Your task is to make a master budgeting template in a spreadsheet. Obtain the pre-formatted spreadsheet (master.xls). The information necessary for making the master budget is given in Part I of the spreadsheet. You need to enter formulas in Part II. Once you enter all required formulas, you can use this mas

Define each of the budgets listed and briefly describe its uses

Directions: define each of the budgets listed and briefly describe its uses. 1.Sales budget 2.Production budget 3.Direct materials budget 4.Direct labor budget 5.Manufacturing overhead budget 6.Selling and administrative expense budget 7.Budgeted income statement 8.Cash budget