Financial planning workbook

Use this workbook when you:

• want to understand how export activity will affect your profitability and working capital over the next 12 to 36 months  
• want to understand how channel expenses and market pricing may impact revenue and margin expectations 

You can start with a simple version for your first market and refine or duplicate it as you add markets, channels or products.

This workbook is designed to be used progressively rather than completed all at once. Start with simple assumptions and rough estimates, then refine them as your market research, export activities, and actual results evolve. Focus first on understanding the order of magnitude and timing of costs and cash flows, not precision. The goal is to support sound decisions and informed conversations, not to produce a perfect forecast.

Begin with a short assumptions section or worksheet. Record:

• time frame for your projections (for example, monthly for the next 12 to 24 months or quarterly for 2 to 3 years)
• currencies you will use and exchange rate assumptions
• expected customer payment terms (for example, 30, 60, or 90 days)
• assumptions about price levels, major cost drivers, and planned launch dates

Keep assumptions simple and clearly stated so they can be updated as conditions change.​ Here is an example:

Create a volumes and prices section with: 

• rows for key markets or segments
• columns for each time period

For each combination, estimate:

• expected units sold or contract values
• average selling price per unit or contract in the customer currency and, if useful, in your home currency

Use realistic, scenario‑based estimates rather than optimistic projections. Initial sales in international markets often take more time, especially when working through channel partners.

Here is an example:

Create an export cost breakdown section that groups costs into practical categories, such as:

• product and packaging costs linked to export volumes
• logistics and shipping (transport, insurance, handling, warehousing)
• duties, taxes and fees (where applicable)
• sales and marketing (campaigns, travel, digital channels, local partners)
• after‑sales support and service
• internal overheads attributable to

Combine your volumes, prices and costs into a basic export profit and loss (P&L) view. For each period, calculate:

• total export revenue
• total variable and direct costs
• contribution margin (revenue minus variable and direct costs)
• any incremental fixed or overhead costs related to exporting
• approximate operating profit or loss for your export activity

This view helps assess whether your export plans are likely to contribute positively to your overall business once realistic costs are included.​

Create a cash flow section focused on timing: when cash actually leaves and enters your bank account. For each period, record:

• cash inflows from export customers based on payment terms and expected delays
• cash outflows for production, logistics, marketing and other costs, including any deposits or prepayments you must make
• net cash flow (inflows minus outflows) and the cumulative cash position for the export activity

This highlights periods where additional working capital financing may be needed, even if the P&L appears profitable.

Review your P&L and cash flow views together, and assess:

• whether the export activity is moving toward positive contribution and operating profit within a reasonable time frame
• what level of working capital is needed at peak cash outflow periods
• whether volumes, pricing, costs or phasing can be adjusted to improve viability

Use this review to refine your export plan and prepare for discussions with banks, potential financiers and partners.​

Summarize key financial points and incorporate them into the:

• financial and resourcing sections of the Export plan template

Keep your workbook as a living document and update it as actual results become available.

You can recreate the workbook as a simple spreadsheet using these sections:

Sheet 1: Assumptions

• Time frame and periods
• Currencies and exchange rate assumptions
• Payment terms and expected collection delays

Sheet 2: Volumes and prices

• Rows for markets, segments or products
• Columns for periods, with projected units or contract values and average prices

Sheet 3: Export costs

• Cost categories (production, logistics, duties, marketing, support, overhead)
• Cost per unit and total cost per period, linked to volumes where practical

Sheet 4: Export P&L summary

• Revenue, costs, contribution margin and approximate operating profit or loss per period

Sheet 5: Export cash flow

• Cash inflows and outflows by period
• Net cash flow and cumulative cash balance attributable to export activity

You can add optional summary graphs or indicators if helpful, but the core value comes from clear tables and assumptions that you can adjust as conditions change.​