Solution
Ashish answered on
Apr 17 2021
Running Head: Case Analysis of Chester & Wayne
Case Analysis of Chester & Wayne
Student Name:
Student ID:
17th April 2019
The cash budget and all other required schedule for every month of the 4th quarter and for the quarter in total are shows below:
Â
October
November
December
Total
Cash Budget
Â
Â
Â
Â
Cash Collection
Â
Â
Â
Â
40% after 2% Discount
$308,700
$324,106
$340,334
$973,140
25% without Discount
$196,875
$206,700
$217,050
$620,625
30% next month
$225,000
$236,250
$206,700
$667,950
Warehouse Rental
$24,000
Â
Â
$24,000
Sale of Marketable Securities
$7,351
$192,649
Â
$200,000
Bo
owing
Â
$29,750
$53,393
$83,143
Total Collection
$761,926
$989,455
$817,477
$2,568,858
Less Payments
Â
Â
Â
-
60% of Purchases & Othe
$429,871
$452,875
$470,561
$1,353,306
Expenses (This Month)
40% of Purchases & Othe
$354,155
$286,580
$301,916
$942,652
Expenses (Next Month)
Equipment Acquisition
Â
$250,000
Â
$250,000
Dividend Payment
Â
Â
$45,000
$45,000
Total Payments
$784,026
$989,455
$817,477
$2,590,958
Surplus or Deficit
($22,100)
$0
$0
($22,100)
Opening...