Explore BrainMass

Cash Budgeting

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

Ledford Corporation: Prepare the Cash Budget for June

See attached file. Ledford Corporation has the following information available from various schedules to prepare its cash budget for the June: Receipts: Sales (terms 2/10, net 30): May $90,000, June $100,000, July $120,000 Collection pattern: 65% in month of sale, 70% take the discount 35% in month after sale Income f

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

Monthly cash budget

1 Excel Spreadsheet and 1 Word doc page Details: Please read the relevant parts of your textbook which refer to cash flow and financial planning. To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a Cash Budget for his latest venture- Cyrus Br

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


4-6A. (Cash budget) The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows: January $ 90,000 May $300,000 February 120,000 June 270,000 March 135,000 July 225,000 April 240,000 August 150,000 Of Sharpe's sales, 10 percent is for ca

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


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


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

Management Accounting: Company Goals and Depreciation

1. The CFO of your company comments, "I don't understand why other companies waste so much time by creating budgets. I set company goals, and everyone strives to meet them." Is this a valid approach? How would you respond to the CFO? 2. A classmate in your accounting class says, "Depreciation is a source of cash flow for a co