How To Build A Franchise Cash Flow Forecast

Building a cash flow forecast is essential to determine if a franchise is viable in the Philippines. It shows when cash enters and leaves your business. This guide helps you forecast income and expenses to avoid liquidity issues.

Estimate Your Initial Setup Costs

Before opening, you need a clear picture of startup expenses. Based on the directory, a brand like Icy Pink Scramble needs a ₱50,000 franchise fee, while larger setups like The French Baker require higher capital. Your forecast must include franchise fees, security deposits for leases, construction or renovation costs, initial inventory, and equipment. For food cart concepts, initial inventory is usually lower than inline stores. Total initial investment can range from below ₱150,000 to over ₱5M. Map these out over the first two months, including permit applications and training expenses.

Map Monthly Operating Expenses

Cash outflow continues even if sales are low. List fixed costs such as rent, salaries for employees, and monthly rent. Variable costs depend on sales volume, including cost of goods sold (ingredients for food brands or inventory for retail) and utilities like electricity and water. Franchisors often require royalties and marketing fees, often calculated as a percentage of gross sales. Always include a 10 percent buffer for unexpected costs, such as equipment repairs or additional packaging. Map these over 12 months.

Advisors Ready To Help

Consultant

Financing Readiness · Site Selection

Mentor

Low-Capital Startups

Coach

Low-Capital Startups · Site Selection

Advisor

Franchise Agreements · Multi-Unit Expansion

Are you a franchise advisor? Get your own workspace here

Project Your Revenue Streams

Be conservative when estimating revenue. Look at the ROI months for guidance; for instance, a 12-month ROI for a brand like Captain Calamares suggests a high, consistent volume. Base your projections on the average transaction size and estimated daily traffic, considering, for instance, high, moderate, and low sales days. Consider seasonal trends in the Philippines, such as higher demand during school openings or summer months. Start with lower sales projections in the first three months to account for slow startup weeks.

Determine Your Cash Flow Gap

Subtract total expenses from total revenue for each month to find your net cash flow. A negative number means you need cash reserves to stay afloat. For example, a ₱800,000 Noodle Box franchise may have high early expenses before profits settle in. Your forecast must show you have sufficient funding to cover these gaps. If your forecast shows negative cash flow past the six-month mark, you may need to reduce expenses or reconsider your target daily sales. Always ensure your initial capital covers these initial deficits.

Create A 12-Month Pro-Forma

Compile the data into a spreadsheet for the first year. Update this forecast monthly with real numbers to compare with projections. This helps in understanding the seasonality of your business. If your brand is a food cart (e.g., Icy Pink Scramble), sales might dip in rainy seasons, whereas a retail store might spike during holidays. A solid 12-month projection allows you to plan for annual royalty payments or equipment maintenance, keeping your franchise cash-positive.