Rating
FORECASTED CASH FLOW
Forecasted Cash Flow
Forecasted Cash Flow
Forecasted Cash Budget
March
April
May
June
July
August
September
October
November
Cash on Hand
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
Forecasted Sales
250,000
275,000
320,000
450,000
575,000
700,000
825,000
350,000
285,000
Payment Collection (10%)
25000
27500
32000
45000
57500
70000
82500
35000
28500
Payment Collection (65%)
162500
178750
208000
292500
373750
455000
536250
227500
Payment Collection (25%)
62500
68750
80000
112500
143750
175000
206250
Direct Manufacturing Costs
187,500
206,250
240,000
337,500
431,250
525,000
618,750
262,500
Expenses
Administrative salaries
35,000
35,000
35,000
35,000
35,000
35,000
35,000
35,000
35,000
Lease payments
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
Depreciation charges
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
One-time Plant investment
95,000
Income Tax Payments
55,000
55,000
Miscellaneous Costs
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
Forecasted Cash at end
-187,500
-41,250
8,250
-190,750
-26,250
6,250
-17,500
458,750
437,250
Forecasting your cash inflow (collections) determines your cash outflow (expenses) parameters. To forecast cash inflow, ...