Purchase Solution

Cash budget

Not what you're looking for?

Ask Custom Question

The management of West Valley Memorial Hospital needs to prepare a cash budget for July 2006. The following information is available:
a. The cash balance on July 1st is $236,000.
b. Actual services performed during May and June and projected services for July are:
Cash services (bills paid by individuals):
May: $110,000 June: $90,000 July: $120,000
Credit services (bills paid by insurance co):
May: $900,000 June: $1,000,000 July: $875,000
Credit sales are collected over a 2-month period, with 60% collected during the month the service is performed and 40% in the following month.
c. Hospital personnel plan to purchase $80,000 of supplies during July on account. Accounts payable are usually paid one-half in the month of purchase and one-half in the following month. The accounts payable balance on July 1, 2006 is $35,000.
d. Salaries and wages paid during July will be approximately $600,000. (ignore income and other tax withholdings)
e. Depreciation on the hospital and equipment for July will be $100,000.
f. A short- term bank loan of $80,000 (including interest) will be repaid in July.
g. All other cash expenses for July will total $56,000.
Prepare the hospital's July cash budget.

Purchase this Solution
Solution Summary

Excel file contains West Valley Memorial Hospital's cash budget for the month.

Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • What information is needed in order to prepare a cash budget?

    171897 Cash Budgets and Operating Budgets What information is needed in order to prepare a cash budget? What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget?

  • Description of a cash budget & its useful to an organization

    The cash budget is somewhat based upon the operating budget, as sales are used to calculate what is expected in terms of the cash receipts budget. As you will find out, cash is king.

  • Budgeting

    8276 Cash budgeting: production budget, purchasing budget, sales budget and cash budget See attachment for a cash budgeting question. Please see the attached file.

  • Operating budget and cash budgets

    235866 Operating budget and a cash budget What information is needed in order to prepare a cash budget? What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget?

  • Cash Budget

    Why is it important to create a cash budget? Please see the attachment The solution explains how to create a cash budget and explains the importance of cash budget

  • The Purpose of the Cash Budget

    Cash budget sales budget, purchase budget, production budget etc. The cash budget is a summary of the firm's expected cash inflows and Outflows over a particular period of time.

  • Budgets for Healthcare Organization

    The expense budget lists all operating expenses that are expected to be incurred during the budget period, both fixed and variable. 3) Cash budget The cash budget represents the organization's cash inflows and outflows.

  • What are the steps to creating a cash budget?

    This is usually the last budget that the company prepares. To prepare a cash budget, the first number used to start the budget is the beginning cash balance.

  • Budget Discussion Questions for Mama's Needlework

    Cash Budget: Why doesn't the Net Cash from Operations of $93 match the Annual Budget $105? One reason is that our budget components were only for Product B. What is the other reason? Cash Budget: Why did they borrow $50 in the first quarter?

  • cash budget

    251803 Solving a cash budget problem Is there concerns with the cash budget and the company with this budget attachment. Is there concerns with the cash budget and the company with this budget attachment Let us understand about budget.

View More Related Solutions