SmartHelping / 6-Year Financial Model / Excel
Online Travel Agency
Build a financial forecast for an online or boutique travel agency. Connect booking commissions, trip markups and advertising revenue with operating costs, financial statements and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Follow bookings through the financial forecast.
Watch the walkthrough to review the travel segments, revenue assumptions, operating costs and financial outputs. Open the screenshots below for a closer look at the workbook.
What the model includes
Build the forecast around the travel agency’s operations.
Use assumptions for bookings, commissions, customer service and other operating costs to evaluate startup costs, business performance and alternative scenarios.
Up to 72 months of forecasting
Create a forecast covering up to six years, with monthly and annual pro forma reports.
Integrated financial statements
Review a connected income statement, balance sheet and cash flow statement as the operating assumptions change.
12 configurable travel segments
Set up to 12 travel segments with separate launch timing, booking volumes, growth, average booking values and commission assumptions.
DCF, IRR and MOIC
Evaluate discounted cash flow and investment returns with analysis for the project and investors.
Pricing, volume and cost scenarios
Change the operating assumptions to compare potential outcomes. Choose whether to include a terminal value in the analysis.
Executive summary, charts and KPIs
Use the annual executive summary, financial visualizations and key performance indicators to communicate the forecast.
Three revenue streams
Configure how the agency earns revenue.
The model includes booking commissions, a boutique trip markup approach and website advertising revenue, with assumptions you can adjust over the projection period.
Booking commissions
Configure up to 12 travel segments, such as airline tickets, hotel bookings, cruises and tours. For each segment, enter the start month, starting monthly bookings, monthly compounded booking growth, average booking value and average commission earned. Adjust these assumptions over the six-year forecast.
Boutique trip markups
Model an agency that charges an initial fee, pays the travel expenses and earns the difference. Configure the customer fee, special agent costs, booking costs and other costs per booking.
Website advertising
Forecast ad revenue using website traffic, traffic growth, average impressions per user and average CPM — the earnings per 1,000 impressions.
Variable costs
Connect service capacity and payment costs to activity.
Alongside direct costs for boutique bookings, the model includes customer service staffing and credit card fee assumptions.
Customer service representatives
Enter the number of representatives required per monthly booking. A ratio of 0.001 means one representative for every 1,000 bookings per month. Adjust that ratio over time and combine it with salary assumptions to calculate customer service expenses.
Credit card processing
Set the credit card fee input and the percentage of revenue to which it applies so the forecast reflects the relevant processing costs.
How to use the model
Turn the booking plan into a financial forecast.
Set up the travel segments
Define the start month, initial bookings, compounded booking growth, average booking value and commissions for up to 12 segments.
Configure the other revenue streams
Enter the boutique trip fees and direct costs, then add website traffic, impressions and CPM assumptions for advertising revenue where relevant.
Build the operating cost plan
Set customer service staffing ratios and salary costs, credit card fees and the other cost assumptions for your agency.
Compare the financial results
Review monthly and annual statements, the executive summary, KPIs and investment returns. Adjust pricing, volume and costs, and choose whether to include terminal value.
Who this model is for
For online booking businesses and boutique agencies.
Online travel agency founders
Evaluate a booking business with multiple travel segments, commission income, website advertising and customer service costs.
Boutique travel operators
Assess the economics of curated trips where the agency charges the customer, covers travel expenses and earns a margin on each booking.
Business planning considerations
Ground the forecast in how you plan to compete.
Use these questions when developing the assumptions behind your travel agency plan.
Market position and customer acquisition
Define why a customer would choose your agency over an established platform. Research gaps in the market and the cost of reaching and acquiring your target customers.
Niche and local experiences
Consider the audience and experiences you want to serve, such as adventure travel, wellness retreats, eco-tourism, senior travel or curated cultural and culinary experiences.
Supplier relationships and partnerships
Assess the supplier terms you can obtain and the relationships needed with airlines, hotels, tour operators and other providers. Consider how local partners or travel influencers fit the plan.
Technology and operating infrastructure
Plan the cost of booking systems, user accounts, supplier coordination and ongoing platform work. Evaluate the cost and customer value of features such as destination previews or personalized trip suggestions.
Service and sustainability
Decide how personalized support, sustainable accommodations or other travel options fit your offering. Reflect the service commitments and related costs in the operating plan.
Markets and operating requirements
Consider the countries and regions you will serve, including currency exposure, local practices and the travel-industry requirements relevant to those markets.
Also available in these bundles
Need models for more than one business?
This template is included in the Industry-Specific, Hospitality, Service Business and Super Smart bundles.
Industry-Specific Financial Models
Explore financial models built around the operating assumptions of different businesses and industries.
View the Industry-Specific bundleHospitality Models
Explore financial models for hospitality and travel-related businesses.
View the Hospitality bundleService Business Models
Review financial models built for businesses that deliver services.
View the Service Business bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleQuestions before you buy
A few useful details.
How long is the forecast?
The model supports up to 72 months, or six years, with monthly and annual pro forma reports.
How many travel segments can I configure?
Use up to 12 segments. Each has inputs for start month, starting monthly bookings, compounded booking growth, average booking value and commission earned.
Can I model boutique trips as well as commissions?
Yes. The model includes a markup approach where the agency charges an initial fee and pays the trip expenses. Inputs cover the customer fee, special agent costs, booking costs and other costs per booking.
Does it include advertising revenue?
Yes. Advertising assumptions include website traffic and growth, average impressions per user and CPM, or earnings per 1,000 impressions.
How is customer service staffing calculated?
A configurable ratio links the number of customer service representatives to monthly bookings. For example, 0.001 means one representative per 1,000 bookings per month. Salary assumptions then determine the related expense.
Which financial outputs are included?
The model includes integrated financial statements, monthly and annual reports, an annual executive summary, charts, KPIs, DCF analysis, IRR and MOIC for the project and investors. Terminal value is optional.
Build the financial plan behind the bookings
Connect travel revenue to cash flow and returns.
Get the Online Travel Agency Financial Model for $45 and evaluate your booking mix, revenue streams and operating costs over a six-year forecast.
