Input Area:
Beginning cash balance
Outlay in third Q
Target cash balance
Last years' sales
Inputa Data (Do not change) (These are different from Textbook intentic
Compute results here
105,800
305,000
95,000
Q1
Q2
Q3
Q4
795,000
844,000
914,000
783,000
Growth rate in sales
8.50%
Collection period
50
Beg A/R
348,000
Percent uncollectible
% of purchases for next Q sales
Suppliers paid
44%
39
% of sales for expenses
23%
Interest and dividends
32,000
Output Area:
Sales next year
Sales following year
Collections from previous quarter
Collections from current quarter sales
Payments to suppliers for previous quarter
Payments to suppliers for current quarter
Expenses
Dividends and interest
Outlay
Net cash flow
Cash Balance
Beginning cash balance
Net cash inflow
Ending cash balance
Minimum cash balance
Cumulative surplus (deficit)
Quarterly cash flow
Q1
Q2
Q3
Q4
Q1
Q2
Q3
Q4