Share
Explore BrainMass

Cash Budgeting

G Enterprises

G Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May June and July are $70,000, $80,000 and $100,000 respectively. The firm has a cash balance of $5000 on May 1st and wants to maintain a minimum cash balance of $5000. Prepare and interpret a cash budget for May June and July 1-the firm make

Cash Budget Analyst

Imagine it is July 2009 and you are a budget analyst for your company that makes seasonal items. Create a cash budget for the months July through December using the sales estimates and other information about the company given below. Sales forecast Month Sales (in thousands) May 200 June 200 July 400 August 500 Septembe

Example Cash Budgeting Problems

Use Microsoft Excel and use formulas. On January 1 Winter Snow begins business. This company is operated as a sole proprietorship. The company received $18,000 cash, $8,000 contributed by the owner (Taylor Snow), and $10,000 from a short-term note payable received on the first day of business. They are attempting to project c

Budgeting and Profit Planning II

--attached The Beaver Corporation has budgeted sales for next year as follows: _ Quarter _ First Second Third Fourth Sales in Units........................10,000 13,000 16,500 15,000 1. The ending inventory of finished goods for each quarter shou

4 slides with notes and 2 to 3 references

As a member of the finance team, you have been asked to prepare the upcoming year's organizational budget for Verybest Hospital. After reviewing specific data, internal input, and external input from various sources, you find that the executive management team would like the budget to reflect the following: increase in reven

Prepare a cash budget to help explain the lack of liquidity

Cash Budgeting The Elusive Cash Balance "What do you mean we've used up all our cash and lines of credit? I don't get it! I thought we had a healthy financial position as per last year's financial statements. How could this have happened, Carl?" said Robert McGovern to his chief accountant. "If our suppliers find out, we

Managerial Accounting - Crimson Company Scenario

Crimson Company, a producer of aftermarket automobile products, has just completed its master budget process for the next fiscal year. With three weeks remaining before the new period begins, you are reviewing the budget spreadsheets to make sure they contain the most up-to-date information. I.The initial estimate of unit sa

Managerial Accounting

Yummi-Lik Sensitivity Analysis Worksheet To begin: Retrieve the Excel file your group created for problem 6-40 and save it to the hard drive. Open it in Excel, then go to Windows button>Save As. Save another copy of the file with a different filename (such as 6-40w). Re-open the original file, then go to the View tab; in

Preparing A Personal Cash Budget

Donna and Sherman Terrel are preparing a budget for 2010. Donna is a systems analyst with an airplane manufacturer, and Sherman is working on a Master's degree in educational psychology. The Terrels do not have any children or other dependents. Donna estimates her salary will be about $45,600 in 2010; Sherman expects to work onl

Marine Tech, Inc: Prepare and analyze monthly cash budgets

Please help with this problem in excel attached. Show all working in work format BM Accounting what the numbers mean 8th edition a. Cash Budget MARINE TECH, INC. Cash Budget For the months of April, May, and June, 2009 April May June Beginning Cash Balance

Book value

Questions 72-76 address a capital budgeting problem and are related, though there are assumptions made in sequential questions to avoid an initial error causing all subsequent responses to be in error. Consider the following for questions 72-76: A new product is being considered by Stanton Corp. An outlay of $40,000 is requ

Purchase budget & expected cash collection.

At March 31 Streuling Enterprises, a merchandising firm, had an inventory of 38,000 units, and it had accounts receivable totaling $85,000. Sales, in units, have been budgeted as follows for the next four months: April 60,000 May 75,000 June 90,000 July 81,000 Streuling's board of directors has established a

Finance For Decision Making

Please help! I need assistance with the following three questions in the spreadsheet attached. At he end of 2005, Uma Corporation was considering undertaking a major long-term project in an effort to remain competitive in its industry. The production and sales departments determined the potential annual cash flow savi

Finance Budget

The ZYX Corporation is planning to request a line of credit from its bank and wants to estimate its cash needs for the month of September. The following sales forecasts have been made for 2005: July $500,000 August $400,000 September $300,000 October $200,000 November $100,000 Collection estimat

The Value of Budget Reports

Describe the value of the monthly budget report, the quarterly budget report, and the fiscal year budget report. What would occur without reviews of budget reports?

Budgetary Planning: Hass Company

Prepare a cash budget for 2 months... -------------- Hass Company prepares monthly cash budgets. Relevant data from operating budgets for 2011 are: January February Sales

Accounting

Kim incorporated is preparing its master budget for 2004. In addition to the cash flows listed, assume that the company expects to pay $10,000 in income taxes each quarter. Assume Kim expects to paya $20,000 dividend in the 4th quarter. The beg. cash balance is $160,000. Qu

Budgeted Financial Statements

Handy Hardware is a retail hardware store. Information about the store's operation follows. a. November 20x1 sales amounted to $200,000 b. Sales are budgeted at $220,000 for December 20x1 and $200,000 for January 20x2. c. Collections are expected to be 60 percent in the month of sale and 38 percent in the month following th

Filing Out Values in a Proforma Cash Budget

Problem 2 The director of budget of the store Flory' s Kitchen has prepared the following budget of sales. The business has balance of $100.000 in accounts receivable to January 1. The business normally charges the 100% of its accounts receivable in the following month for sale. Sales January February

FINANCE

II- Cash Flow and Financial Planning: A- Gerry Jacobs, a financial analyst for Best Value Supermarkets, has prepared the following sales and cash disbursement estimates for the period August through December of the current year. Month Sales Cash Disbursements August $400 $300 September 500 500 October 500 700 November

Highline: Cash Budgeting

Highline Hospital provides a wide range of health services in its community. Highline's board of directors has authorized the following capital expenditures that are planned for October 1, 2009: Intra-aortic pump $1,400,000 Computed tomographic scanner 850,000 X-ray Equipment 550,000 Laboratory equipment

Cash Budgeting: Sales Forecast

Jensen Corporation has the following sales forecasts for the selected three month period in 2011. Month: Sales: July $24,000 August $14,000 September $16,000 Seventy percent of sales are collected in the month of the sale, and the remainder are collected in th

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