Cash Flow Forecasts: Formula, Example, Calculator & Exam Guide
A cash flow forecast predicts the cash a business expects to receive and pay out over a future period. It helps owners, managers and students understand liquidity, spot possible cash shortages, plan finance, and make better decisions before a problem becomes serious.
Core idea
Forecast future cash inflows and outflows month by month so the business can predict its closing balance.
Main formula
Net cash flow equals total cash inflows minus total cash outflows.
Exam focus
Students are often asked to complete missing values, explain problems and recommend solutions.
Decision value
A forecast supports planning for overdrafts, delayed payments, stock purchases, expansion and seasonal sales.
What Is a Cash Flow Forecast?
A cash flow forecast is a forward-looking financial plan that estimates how much cash will enter and leave a business during a future period, usually monthly or quarterly. It does not simply show whether a business is profitable. It shows whether the business has enough cash available at the right time to pay wages, suppliers, rent, loan repayments, taxes, insurance, delivery costs and other bills.
This distinction is essential in Business Studies. A business can be profitable on paper but still fail because it runs out of cash. For example, a retailer may sell goods on credit and record revenue, but if customers do not pay until later, the business may not have enough immediate cash to pay suppliers. A cash flow forecast helps managers see this timing gap.
In simple terms, the forecast begins with an opening balance. The business then adds expected cash inflows and subtracts expected cash outflows to find the net cash flow. This is added to the opening balance to find the closing balance. The closing balance then becomes the next period’s opening balance.
Cash flow forecast definition
A cash flow forecast is an estimate of future cash inflows, cash outflows, net cash flow and closing cash balances over a defined time period.
Why it matters
It shows whether the business may face a cash shortage, when the shortage may occur, and what action managers should take.
Cash Flow Forecast vs Profit
Cash flow and profit are related, but they are not the same. Profit is calculated by comparing revenue with costs over a period. Cash flow focuses on the actual movement of money in and out of the business bank account. Profit can include credit sales that have not yet been received as cash. Cash flow focuses on when money is actually received or paid.
| Comparison Point | Cash Flow Forecast | Profit Statement / Income Statement |
|---|---|---|
| Main purpose | Predicts liquidity and cash availability. | Measures profit or loss over a period. |
| Timing focus | Records cash when it is actually received or paid. | May record revenue and costs when earned or incurred. |
| Key risk shown | Cash shortage, overdraft need, weak working capital. | Low gross profit, low profit margin, excessive expenses. |
| Typical exam task | Complete missing balances, interpret negative cash flow, suggest solutions. | Calculate profit, interpret margins, compare performance. |
Swipe horizontally to view the full table on mobile.
Cash Flow Forecast Formulas
The formulas are simple, but students often lose marks because they confuse opening balance, closing balance and net cash flow. Use these formulas in this order.
Formula explanation
Cash inflows include cash sales, payments from debtors, owner investment, bank loans, grants, proceeds from selling assets and other money entering the business. Cash outflows include wages, rent, raw materials, stock purchases, marketing, delivery, electricity, insurance, loan repayments and tax payments.
Net cash flow shows the difference between inflows and outflows for one period. A positive net cash flow means more cash came in than went out during that period. A negative net cash flow means more cash went out than came in. Negative net cash flow is not always a disaster, but it needs explanation. It may be caused by expansion, buying equipment, seasonal stock purchases, late customer payments or falling sales.
Quick example
A business has an opening balance of $2,000. During March, it expects cash inflows of $7,500 and cash outflows of $6,200.
The business expects to finish March with $3,300 in cash. That $3,300 becomes April’s opening balance.
Cash Flow Forecast Diagram
The diagram below shows the basic flow of a forecast. The opening balance moves into the month. Cash inflows increase the balance. Cash outflows reduce it. The result is the closing balance, which becomes the next month’s opening balance.
Interactive Cash Flow Forecast Calculator
Use this mini tool to practise a six-month cash flow forecast. Enter an opening balance, monthly inflows and monthly outflows. The tool calculates net cash flow, closing balance, lowest balance and a simple liquidity risk message.
| Month | Cash Inflows | Cash Outflows | Net Cash Flow | Closing Balance |
|---|---|---|---|---|
| Month 1 | — | — | ||
| Month 2 | — | — | ||
| Month 3 | — | — | ||
| Month 4 | — | — | ||
| Month 5 | — | — | ||
| Month 6 | — | — |
Swipe horizontally to use the full calculator on mobile.
How to interpret the result
Enter figures and click calculate. If the closing balance becomes negative or falls below the safety balance, the business may need action such as reducing outflows, improving credit control, arranging an overdraft, delaying non-essential spending or increasing cash sales.
How to Prepare a Cash Flow Forecast
A strong forecast is not just a table. It is a decision-making process. A business owner must think carefully about sales timing, payment terms, costs, seasonality, supplier behaviour, customer behaviour and unexpected changes. Students should also remember that the forecast is only an estimate. It becomes useful when managers update it with actual data and use it to make decisions.
Choose the time period
Decide whether the forecast will be weekly, monthly, quarterly or yearly. Small businesses often use monthly forecasts because many costs, such as rent and salaries, are paid each month. A start-up may need weekly forecasts if cash is tight.
Estimate opening cash balance
Start with the amount of cash available at the beginning of the first period. This may be money in the bank plus any cash held by the business. In later periods, the opening balance is normally the previous period’s closing balance.
Estimate cash inflows
Add expected cash sales, customer payments, loans, owner capital, grants and other receipts. The key is timing. If customers buy on credit in March but pay in April, the cash inflow appears in April, not March.
Estimate cash outflows
Include wages, rent, materials, stock, transport, electricity, interest, loan repayments, taxes, marketing and insurance. Again, use the month when the cash is actually paid.
Calculate net cash flow
Subtract total cash outflows from total cash inflows. A positive number increases the closing balance. A negative number reduces it.
Calculate closing balance
Add the net cash flow to the opening balance. Then carry that closing balance forward as the next period’s opening balance.
Interpret and take action
Look for months where the closing balance is negative, dangerously low or falling. Then recommend practical actions. A good answer explains both the problem and why the solution fits the business context.
Worked Cash Flow Forecast Example
The table below shows a simplified forecast for a small café. The café begins with $1,200 cash. It expects sales to rise in April and May, but it must pay for a new coffee machine in March. The forecast shows why the café may need short-term finance even if sales are improving.
| Item | January | February | March | April | May |
|---|---|---|---|---|---|
| Opening balance | $1,200 | $1,700 | $2,100 | ($800) | $1,000 |
| Cash inflows | $5,000 | $5,300 | $5,600 | $6,200 | $6,500 |
| Cash outflows | $4,500 | $4,900 | $8,500 | $4,400 | $4,700 |
| Net cash flow | $500 | $400 | ($2,900) | $1,800 | $1,800 |
| Closing balance | $1,700 | $2,100 | ($800) | $1,000 | $2,800 |
Swipe horizontally to view the full example on mobile.
Interpretation
The café has a cash flow problem in March because the closing balance becomes negative. This is caused by a large outflow for the coffee machine. The business is not necessarily failing, because April and May show positive net cash flow. However, it still needs to manage March carefully.
Possible recommendation
The café could arrange a short-term overdraft, lease the coffee machine instead of buying it outright, delay the purchase, negotiate longer supplier credit, or encourage faster customer payments. The best solution depends on cost, risk, timing and whether the machine is necessary for future sales.
Common Causes of Cash Flow Problems
A cash flow problem occurs when a business does not have enough cash available to meet its short-term obligations. This can happen even when the business has customers, assets or a profitable long-term idea. For exam answers, always link the cause to the effect on cash. Do not simply write “high costs.” Explain how high costs increase cash outflows and reduce the closing balance.
Late customer payments
If customers buy on credit and delay payment, the business may record sales but not receive cash quickly. This reduces cash inflows during the period when bills still need to be paid.
Too much inventory
Buying too much stock ties up cash. Stock may sit on shelves while the business still needs cash for wages, rent and suppliers.
Seasonal sales
Some businesses earn most revenue during certain months. During quieter months, cash inflows may fall below normal outflows.
Rapid expansion
Expansion can increase sales, but it may require cash for equipment, staff, marketing and premises before the new sales arrive.
Unexpected costs
Repairs, legal costs, delivery problems, exchange-rate changes and supplier price rises can increase outflows suddenly.
Weak planning
If a business does not forecast cash carefully, it may not arrange finance early enough and may face expensive emergency borrowing.
How to Improve Cash Flow
Cash flow solutions should be practical and matched to the cause of the problem. A short-term overdraft can solve a temporary timing gap, but it may not solve poor sales or long-term losses. Reducing costs can help, but cutting essential spending may damage quality or sales. A strong exam response weighs both benefits and drawbacks.
| Method | How It Improves Cash Flow | Possible Drawback | Best Used When |
|---|---|---|---|
| Arrange an overdraft | Provides short-term cash to cover temporary shortages. | Interest and fees increase costs. | The shortage is temporary and future inflows are reliable. |
| Ask customers to pay faster | Increases cash inflows sooner. | Customers may dislike stricter terms. | Many sales are made on credit. |
| Offer cash discounts | Encourages early payment and improves liquidity. | Reduces profit per sale. | Cash is more urgent than short-term profit margin. |
| Delay supplier payments | Reduces immediate cash outflows. | Can damage supplier relationships. | Suppliers allow credit and the business communicates clearly. |
| Lease equipment | Avoids a large one-off cash outflow. | Total long-term cost may be higher. | The business needs equipment but wants to protect cash. |
| Reduce inventory | Frees cash tied up in unsold stock. | May cause stock shortages if demand rises. | The business holds excessive or slow-moving stock. |
| Increase sales promotion | Can increase cash sales and inflows. | Marketing costs may rise before sales improve. | Demand exists but customers need encouragement to buy. |
Swipe horizontally to view the full table on mobile.
What Makes a Cash Flow Forecast Accurate?
A forecast is only as useful as the assumptions behind it. Good managers do not treat a forecast as a fixed promise. They treat it as a planning tool that needs regular review. If actual sales are lower than expected, the forecast must be updated. If supplier prices rise, the outflow estimates need changing. If customers start paying late, the business must adjust its expected inflows and prepare for pressure on working capital.
Accuracy depends on the quality of sales estimates, cost estimates, credit terms, supplier terms, stock plans and seasonal assumptions. A new business may find forecasting harder because it has limited past data. An established business can use previous years’ sales, customer behaviour and supplier invoices to make more reliable estimates.
Reliable forecast inputs
- Previous sales data and seasonal trends.
- Confirmed customer orders and contracts.
- Supplier quotes and payment terms.
- Known rent, wage, insurance and loan payments.
- Realistic assumptions about credit sales and late payments.
Forecast limitations
- Unexpected events can change sales and costs.
- New businesses may lack reliable past data.
- Over-optimistic sales forecasts create false confidence.
- Inflation, supply delays and exchange rates can affect outflows.
- Competitor actions may reduce expected inflows.
Exam Guide: Cash Flow Forecasts
Cash flow forecasts are a high-value Business Studies topic because they combine calculation, interpretation and decision-making. Students may be asked to complete a missing value, explain why a business has a cash flow problem, evaluate a method of improving cash flow, or use forecast data to recommend whether a business should expand, borrow, delay spending or change credit terms.
Cambridge IGCSE Business Studies 0450 focus
In Cambridge IGCSE Business Studies 0450, cash-flow forecasting appears in the finance and accounting area under financial information and decisions. Students should understand why cash is important, what a cash-flow forecast is, how a simple forecast is constructed, how to amend or complete a simple forecast, how to interpret it and how short-term cash flow problems can be overcome.
The 2026 Cambridge IGCSE Business Studies assessment uses two external papers. Paper 1 is Short Answer and Data Response, 1 hour 30 minutes, 80 marks and 50% of the qualification. Paper 2 is Case Study, 1 hour 30 minutes, 80 marks and 50% of the qualification. Candidates answer all questions in both papers.
IB Business Management connection
In IB Business Management, cash flow forecasts support quantitative analysis, business decision-making and evaluation. Students should be able to interpret numerical information, connect the forecast to business context and discuss the usefulness and limitations of financial planning tools.
For IB-style answers, calculation alone is not enough. Strong responses explain what the numbers mean, apply them to the case, compare possible actions and reach a justified conclusion.
| Question Type | What Examiners Expect | Common Mistake | How to Improve |
|---|---|---|---|
| Calculate missing figure | Correct use of inflows, outflows, net cash flow and balances. | Adding outflows instead of subtracting them. | Write the formula before calculating. |
| Define term | Clear meaning of opening balance, net cash flow or closing balance. | Giving a vague answer such as “money in business.” | Include timing: start, during or end of the period. |
| Explain cash flow problem | Cause, effect and link to the forecast data. | Only saying “costs are high.” | Use data: “Outflows exceed inflows by...” |
| Recommend solution | Relevant method, benefit, limitation and conclusion. | Listing many solutions without judgement. | Choose the best option for the case. |
| Evaluate usefulness | Balanced view of benefits and limitations of forecasting. | Assuming the forecast is always accurate. | Mention uncertainty and need for updates. |
Swipe horizontally to view the full exam guide table on mobile.
Score Improvement Table
The table below is a practical revision guide, not an official grade-boundary table. Official thresholds can change by exam session, difficulty and board. Use this table to understand how answer quality usually improves from basic to excellent.
| Performance Level | Calculation Skill | Explanation Skill | Evaluation Skill | Target Action |
|---|---|---|---|---|
| Basic | Can identify inflows and outflows but may confuse balances. | Gives simple definitions. | Little or no judgement. | Memorise the three core formulas. |
| Developing | Can calculate net cash flow and closing balance. | Explains why negative cash flow is a problem. | Mentions a solution but may not justify it fully. | Practise linking data to business context. |
| Secure | Accurately completes forecast tables. | Explains causes and effects using figures. | Compares two possible solutions. | Add benefits and drawbacks for each method. |
| Excellent | Uses calculations confidently and checks reasonableness. | Applies every point to the case. | Reaches a justified conclusion based on data and context. | Write balanced, decision-focused answers. |
Latest Exam Timetable Notes
Exam dates can vary by board, administrative zone, country and school entry. Always confirm your final timetable with your school, exam centre or the official exam board portal. The details below are included as a helpful revision planning snapshot.
| Course / Board | Paper | Latest Published Detail Included Here | Student Action |
|---|---|---|---|
| Cambridge IGCSE Business Studies 0450 | Paper 1: Short Answer and Data Response | November 2026 Zone 4: 0450/12, Tuesday 6 October 2026, AM, 1h 30m. | Check your administrative zone before adding this to your personal timetable. |
| Cambridge IGCSE Business Studies 0450 | Paper 2: Case Study | November 2026 Zone 4: 0450/22, Friday 16 October 2026, AM, 1h 30m. | Practise case-study application and cash-flow interpretation. |
| IB Business Management | Paper 1, Paper 2 and HL Paper 3 | Official May 2026 schedule placed Business Management paper 1 and HL paper 3 on 29 April 2026, and paper 2 on 30 April 2026. | For the next IB session, confirm the official schedule through your IB coordinator. |
Swipe horizontally to view the full timetable table on mobile.
How to Write High-Scoring Answers
Students often understand the calculation but lose marks in explanation and evaluation. A strong answer follows a simple structure: define the issue, use data, explain impact and recommend action. The examiner needs to see that you understand both the number and the business consequence.
Useful paragraph structure
Point: The business may face a cash flow problem in March. Evidence: The forecast shows a negative closing balance of $800. Explanation: This means the business may not have enough cash to pay short-term bills such as wages or suppliers. Decision: The business could arrange a short-term overdraft because the problem appears temporary and later months show positive net cash flow.
Command Words and Response Style
| Command Word | What to Do | Cash Flow Example |
|---|---|---|
| Define | Give a precise meaning. | “Net cash flow is cash inflows minus cash outflows during a period.” |
| Calculate | Show the correct numerical answer, preferably with working. | “$5,000 − $4,500 = $500 net cash flow.” |
| Explain | Develop a reason and link it to the business. | “Late customer payments reduce inflows, so the firm may not pay suppliers on time.” |
| Analyse | Show cause and effect using data or context. | “The large March outflow creates a negative balance, increasing overdraft risk.” |
| Evaluate | Compare options and make a justified judgement. | “Leasing may be better than buying because it protects cash, although total cost may be higher.” |
Cash Flow Forecasts in Real Business Decisions
Cash flow forecasts are not only classroom tools. They are used by start-ups, restaurants, online stores, manufacturers, construction firms, schools, clinics and service businesses. A business that expects a busy sales month may still need cash before that month arrives. A manufacturer may need to buy raw materials weeks before customers pay. An e-commerce store may pay for advertising before sales revenue is received. A school may receive fees at certain times but pay salaries every month. Forecasting helps managers connect business activity with cash timing.
Lenders may also ask for a cash flow forecast before approving finance. A forecast helps show whether the business can repay the loan. Investors may use it to judge whether the business model is realistic. Suppliers may use payment history and forecast strength to decide whether to offer trade credit. Owners use forecasts to decide whether to hire staff, buy equipment, open a new branch or reduce risk.
A forecast is especially important during periods of uncertainty. If prices rise, customer demand changes or suppliers shorten credit terms, the business must check whether it can still survive short-term pressure. The strongest businesses do not wait until cash runs out. They use forecasts to notice danger early.
Common Student Mistakes
Confusing cash and profit
Profit is not the same as cash. A business can make sales but still wait for cash if customers buy on credit.
Forgetting the previous balance
The next month’s opening balance is usually the previous month’s closing balance.
Wrong sign for negative numbers
A negative net cash flow reduces the opening balance. It should not be added as a positive figure.
Ignoring context
A generic answer may be limited. Use the business situation, month, figures and cause of the problem.
One-sided recommendations
Every solution has limits. For example, an overdraft helps cash but increases interest costs.
Assuming forecasts are certain
Forecasts are estimates. Sales, costs and payment timing can change, so forecasts must be reviewed.
Revision Checklist
Use this checklist before attempting exam questions on cash flow forecasts. If you can complete each item confidently, you are ready to move from basic calculations to full exam-style explanations and evaluations.
Knowledge checklist
- I can define cash inflow, cash outflow, net cash flow, opening balance and closing balance.
- I can explain why cash is important to a business.
- I can explain the difference between cash and profit.
- I can describe how a simple cash flow forecast is constructed.
- I can identify causes of short-term cash flow problems.
Skill checklist
- I can calculate net cash flow accurately.
- I can calculate closing balance and carry it forward.
- I can find missing values in a forecast table.
- I can interpret negative closing balances using data.
- I can recommend and justify methods to improve cash flow.
Cash Flow Forecasts FAQ
What is a cash flow forecast?
A cash flow forecast is an estimate of future cash inflows, cash outflows, net cash flow and closing cash balances over a chosen period. It helps a business predict whether it will have enough cash to pay short-term bills.
What is the formula for net cash flow?
Net cash flow is calculated as total cash inflows minus total cash outflows: \( \text{Net Cash Flow} = \text{Cash Inflows} - \text{Cash Outflows} \).
What is the formula for closing balance?
Closing balance is calculated as opening balance plus net cash flow: \( \text{Closing Balance} = \text{Opening Balance} + \text{Net Cash Flow} \).
Why can a profitable business still have cash flow problems?
A profitable business can have cash flow problems if revenue is recorded before cash is received, if customers pay late, if the business buys too much stock, or if large expenses must be paid before sales cash arrives.
How can a business solve a short-term cash flow problem?
It can arrange an overdraft, ask customers to pay faster, offer discounts for early payment, delay supplier payments, reduce inventory, lease equipment, reduce non-essential costs or increase cash sales.
Is a cash flow forecast always accurate?
No. It is based on estimates. Sales, costs, customer payments, supplier prices and economic conditions may change. Businesses should compare forecast figures with actual figures and update the forecast regularly.
What does a negative closing balance mean?
A negative closing balance means expected cash outflows and previous cash position leave the business below zero cash at the end of the period. It suggests the business may need finance or urgent action to improve cash flow.
What is working capital?
Working capital is current assets minus current liabilities. It shows the short-term funds available for daily business operations: \( \text{Working Capital} = \text{Current Assets} - \text{Current Liabilities} \).
Final Summary
Cash flow forecasts help businesses predict whether they will have enough cash to survive and grow. The most important formulas are net cash flow equals inflows minus outflows, and closing balance equals opening balance plus net cash flow. The closing balance from one period normally becomes the opening balance for the next period.
For students, the topic is important because it tests both numeracy and business judgement. A high-quality answer does more than calculate. It interprets the numbers, explains causes, recommends practical action and evaluates limitations. For businesses, the topic is important because cash shortages can damage supplier relationships, delay wages, increase borrowing costs and stop expansion plans.
The best way to master cash flow forecasts is to practise completing tables, then write short explanations for what the figures mean. Focus on timing, not just total sales. Ask: when will cash come in, when will cash go out, and what will the closing balance be?