Test

Franchise comparison

Using this spreadsheet

Please change the cells marked in green only, so formulas aren't affected. Your need the franchise fee. If a franchisor is offer an intial investment of £3,000, followed by 24 months of £300 repayment fees, you'd enter £10,200 as the franchise fee (£3,000 + 24*£300 (£7,200)). You'll also need details of the average commission earned on bookings and then the commission split with the franchisor, along with their monthly fee and credit card fee. The Holiday Franchise Company details have already been completed for you. Hope you find this helpful.

Assumptions

Revenue

Forecast Length (months)

The Holiday Franchise Company

Package Type

Find out which package you would be eligible for here.

Franchise Fee

New To Travel Fee

Travel Professional Fee

Average Commission on bookings

Avg Booking percent

Overall Comission

Commission to franchisor (us) 2% of Revenue

Commission percent

Franchisor Commission sum

Commission to franchisee (you)

Franchisee Commission sum

Monthly Fee

Monthly Fee Cost

Average Credit Card Fee

credit card percentage

Revenue for Franchisee

Revenue for Franchisee NTT

Revenue for Franchisee TP