homework

profileshaaeh
su_mhc6305_w6_a1.xls
Home>Business & Finance homework help>homework

Cash Budgeting

Cash Budgeting Case Study © 2007 South University
Beaver Creek Clinic
Enter appropriate input values in cells colored red.
INPUT DATA: KEY OUTPUT:
Projected Billings ($): Projected Cost Data: Net
Cash Flow
2006 Variable costs: Jan $0
November 0 Supplies as a % of billings 0.0% Feb $0
December 0 % paid before use: Mar $0
2007 2 months prior 0.0% Apr $0
January 0 1 month prior 0.0% May $0
February 0 Jun $0
March 0 Fixed Costs:
April 0 Monthly clinical labor costs: Cum (Loan)
May 0 High season $0 or Surplus
June 0 Low season $0 Jan $0
July 0 Feb $0
August 0 Other monthly costs: Mar $0
Gen/admin expense $0 Apr $0
Billings as a % Lease payment $0 May $0
of forecast* 0.0% Misc expense $0 Jun $0
Cash Balance Data: Semi-annual costs:
Loan amortization $0
Target balance $0
Beginning cash $0 One-time costs:
New equipment $0
Collections Data:
% from patients 0.0% *This input is used to create scenarios in which
% coll in 1 month 0.0% actual collections are less than forecasted.
% coll in 2 months 0.0%
MODEL-GENERATED DATA:
Monthly Cash Budget:
I. COLLECTIONS/PAYMENTS November December January February March April May June July August
Billings (expected) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Billings (actual) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Collections:
Month of sale $0 $0 $0 $0 $0 $0 $0 $0
1 month after sale 0 0 0 0 0 0 0
2 months after sale 0 0 0 0 0 0
Total collections $0 $0 $0 $0 $0 $0
Supplies purchases $0 $0 $0 $0 $0 $0 $0 $0
Supplies payments:
2 mos prior to use $0 $0 $0 $0 $0 $0 $0 $0
1 mo prior to use 0 0 0 0 0 0 0
Total supplies costs $0 $0 $0 $0 $0 $0
II. CASH GAIN OR LOSS FOR MONTH January February March April May June
Collections $0 $0 $0 $0 $0 $0
Payments:
Supplies $0 $0 $0 $0 $0 $0
Clinical labor 0 0 0 0 0 0
General/administrative expenses 0 0 0 0 0 0
Lease expense 0 0 0 0 0 0
Miscellaneous expenses 0 0 0 0 0 0
Term loan payment 0
New equipment 0
Total payments $0 $0 $0 $0 $0 $0
Net cash gain (loss) $0 $0 $0 $0 $0 $0
III. CASH SURPLUS OR LOAN REQUIREMENTS January February March April May June
Cash at start if no borrowing is done $0 $0 $0 $0 $0 $0
Cumulative cash $0 $0 $0 $0 $0 $0
Target cash balance 0 0 0 0 0 0
Surplus cash or total loans outstanding
to maintain target cash balance $0 $0 $0 $0 $0 $0
Daily Cash Budget:
I. COLLECTIONS/PAYMENTS Day 1 2 3 4 5 6 7 8 9 10 11
Billings $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Collections:
Patient payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
30-day payors 0 0 0 0 0 0 0 0 0 0 0
60-day payors 0 0 0 0 0 0 0 0 0 0 0
Total collections $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Supplies payments:
2 mos prior to use 0
1 mo prior to use 0
Total supplies costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
II. CASH GAIN OR LOSS
Collections $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payments:
Supplies $0
Clinical labor $0
General/admin expenses 0
Lease expense 0
Misc expenses 0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0
Term loan payment
Total payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net cash gain (loss) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
III. CASH SURPLUS OR LOAN REQUIREMENTS
Cash at start if no
borrowing is done $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cumulative cash $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Target cash balance 0 0 0 0 0 0 0 0 0 0 0
Surplus cash or total loans
outstanding to maintain
target cash balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Day 1 2 3 4 5 6 7 8 9 10 11
Daily Cash Budget - Continued:
Day 12 13 14 15 16 17 18 19 20 21
I. COLLECTIONS AND PAYMENTS
Billings $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Collections:
Patient payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
30-day payors 0 0 0 0 0 0 0 0 0 0
60-day payors 0 0 0 0 0 0 0 0 0 0
Total collections $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Supplies payments:
2 mos prior to use
1 mo prior to use
Total supplies costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
II. CASH GAIN OR LOSS
Collections $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payments:
Supplies
Clinical labor $0
General/admin expenses 0
Lease expense
Misc expenses $0 $0 $0 0 $0 $0 $0 $0 $0 $0
Term loan payment
Total payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net cash gain (loss) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
III. CASH SURPLUS OR LOAN REQUIREMENTS
Cash at start if no
borrowing is done $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cumulative cash $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Target cash balance 0 0 0 0 0 0 0 0 0 0
Surplus cash or total loans
outstanding to maintain
target cash balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Day 12 13 14 15 16 17 18 19 20 21
Daily Cash Budget - Continued:
Day 22 23 24 25 26 27 28 29 30 31
I. COLLECTIONS AND PAYMENTS
Billings $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Collections:
Patient payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
30-day payors 0 0 0 0 0 0 0 0 0 0
60-day payors 0 0 0 0 0 0 0 0 0 0
Total collections $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Supplies payments:
2 mos prior to use
1 mo prior to use
Total supplies costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
II. CASH GAIN OR LOSS 31
Collections $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payments:
Supplies
Clinical labor
General/admin expenses
Lease expense
Misc expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Term loan payment
Total payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net cash gain (loss) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
III. CASH SURPLUS OR LOAN REQUIREMENTS
Cash at start if no
borrowing is done $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cumulative cash $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Target cash balance 0 0 0 0 0 0 0 0 0 0
Surplus cash or total loans
outstanding to maintain
target cash balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Day 22 23 24 25 26 27 28 29 30 31
&A
Page &P