Purchase Solution

Cash budget for West Valley Memorial Hospital

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 1, 2006, is $236,000.
b. Actual services performed during May and June and projected services for July are:
May June July
Cash services (bills paid by individuals
as they leave the hospital) . . . . . . . . . . . . . . . . . . $110,000 $ 90,000 $120,000
Credit services (bills paid by insurance
companies and Medicare) . . . . . . . . . . . . . . . . . . 900,000 1,000,000 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
Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.