All-in-one Dashboard
Core inputs and core outputs
Pay in installments of $19.75 with
,
and
Shipping Estimate
USA
- USA
- CAN
- USA
- CAN
Ships within 48 hours · Estimated delivery Jul 22 - Jul 27
Promo Codes Available:
For Your Every Summer RSVP, with Code: SUMMER15
Description
Pelican's SnoBalls Franchise Financial Model 2026What Does the Pelican's SnoBalls Franchise Financial Model Contain? This franchise unit financial projections spreadsheet includes everything from dynamic labor scheduling to detailed CAPEX schedules for equipment, signage, and initial inventory. [dynamic_pic1] All in one Dashboard Core inputs and core outputs [dynamic_pic2] Low Base High Three scenario analysis [dynamic_pic3] Professional Charts Presentation ready [dynamic_pic4] ROE Components DuPont
What Does the Pelican's SnoBalls Franchise Financial Model Contain?
This franchise unit financial projections spreadsheet includes everything from dynamic labor scheduling to detailed CAPEX schedules for equipment, signage, and initial inventory.
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Six Questions Your Pelican's SnoBalls Franchise Financial Model Must Answer
We built this franchise unit financial model using our own research into the shaved ice industry and specific unit economics. Key assumptions like the $463,000 year-one revenue and the 8% royalty are pre-populated but fully editable to match your local market. Here is the quick math: with a 5-month break-even, the model shows a fast path to operational stability if you manage your $11,000+ monthly fixed costs effectively.
When willthe unit turn a profit?
The model shows the unit reaching its break-even date by May 2026, just five months after launching. While year-one EBITDA hits $90,000, the real jump happens in year five as revenue crosses the $1 million mark. Still, you need to watch those 8% royalties closely as they scale with your SnoBall and topping sales.
Profit Boosters
- Upsell premium toppings
- Optimize trailer routes
- Manage seasonal labor
[dynamic_pic9]
How muchcapital do I need?
You will need roughly $260,500 to cover the startup capital requirements for food service franchises like this one. This covers the $32,000 franchise fee, $95,000 for leasehold improvements, and $48,000 for the mobile trailer. We also factored in $12,000 for initial inventory and $9,500 for the POS system to get you through the first month.
Major Capital Uses
- Leasehold Improvements: $95,000
- Mobile Trailer: $48,000
- Franchise Fee: $32,000
[dynamic_pic10]
What ismy expected return?
Based on the current projections, the franchise investment return calculator shows an IRR of 3.23% and a 4-year payback period. While the ROE is 0.64, the long-term value sits in the $336,000 EBITDA potential by year five. Evaluating franchise profitability before investing is the only way to ensure these numbers meet your personal goals.
Key Metrics
- IRR: 3.23%
- Payback: 4 Years
- Year 5 EBITDA: $336k
[dynamic_pic11]
What isthe break-even point?
The unit hits its monthly break-even point in May 2026. The biggest driver for this is the high-margin SnoBall sales, which carry a low COGS of about 10% for ice and syrups. If you can keep the $6,500 rent and $1,200 marketing spend fixed, volume from the mobile trailer and catering becomes your best friend.
Speed to Break-Even
- Maximize catering orders
- Control syrup waste
- Boost foot traffic
[dynamic_pic12]
How muchrunway is required?
The lowest cash point occurs in June 2026 at $989,000 based on the initial funding. You need enough buffer to handle the $11,000+ in monthly fixed costs before the summer peak kicks in. Honestly, having a 6-month reserve is the safest bet for estimating operating expenses for a mobile food business.
Cash Protection
- Phase equipment buys
- Negotiate rent abatement
- Monitor inventory levels
[dynamic_pic13]
How doscenarios change outcomes?
Our franchise P&L statement allows you to toggle between Low, Medium, and High cases. A 10% drop in SnoBall sales significantly delays your 4-year payback, while hitting the High case can push year-one EBITDA well past $100,000. It helps you see the impact of typical profit margins for shaved ice franchises under different market conditions.
Hitting the High Case
- Expand corporate catering
- Increase average ticket
- Improve crew speed
Finance: update unit break-even and payback model by Friday
[dynamic_pic14]
Pelican's SnoBalls Franchise Financial Model Template Features & Benefits
FlexibleExcel Framework
This franchise financial model is built in Excel so you can tweak every variable to fit your specific territory. Whether you are adjusting the mix of SnoBall sales and catering or changing the crew member headcount, the pre-filled formulas handle the heavy lifting. It defintely saves you hours of manual entry when building a franchise business plan template.
- Editable assumptions and formulas
- Revenue and pricing drivers
- Staffing and payroll inputs
- Operating expense categories
Five-YearGrowth Roadmap
We mapped out a 60-month path showing revenue scaling from $463,000 in year one to over $1 million by year five. This helps you see the long-term potential of retail franchise financial projections. You can track how EBITDA shifts as you add more crew members and scale the mobile trailer operations over several seasons.
- 5-year revenue forecasts
- Profit and cash flow projections
- Balance sheet view
- Long-term profitability analysis
Feeand Royalty Tracking
This model accounts for the $32,000 initial franchise fee and the ongoing 8% royalty fee to ensure your unit economics are accurate. Since there is no brand marketing fund contribution in this specific setup, you can see exactly how that affects your store-level margin. It is vital to understand these obligations before signing your FDD.
- Initial franchise fee inputs
- Royalty expense calculations
- Marketing fund contributions
- Ongoing franchise cost tracking
Investmentand Break-Even
Calculating how to calculate startup costs for a dessert franchise is the first step to avoiding a cash crunch. With $95,000 in leasehold improvements and $48,000 for a mobile trailer, your initial investment is significant. This tool provides a clear break-even analysis to show when your daily ticket volume covers these fixed costs.
- Total startup investment
- Fixed and variable cost analysis
- Break-even sales estimates
- Margin and contribution view
PerformanceIndustry Benchmarks
We include benchmarks for labor and occupancy to ensure your $6,500 monthly rent stays within a healthy percentage of sales. If your ice and syrup costs drift above the projected 9-10%, the model flags it immediately. It is a reality check for your franchise profitability analysis compared to typical industry standards.
- Labor cost benchmarks
- Occupancy cost benchmarks
- Gross margin ranges
- Revenue driver benchmarks
How to Use the Template
Download and Open
Simply purchase and download the financial model template, then access it instantly using Microsoft Excel or Google Sheets. No installation or technical expertise required-just open and start working.
Input Key Data:
Enter your business-specific numbers, including revenue projections, costs, and investment details. The pre-built formulas will automatically calculate financial insights, saving you time and effort.
Analyse Results:
Leverage the investor-ready format to confidently showcase your financial projections to banks, franchise representatives, or investors. Impress stakeholders with clear, data-driven insights and professional reports.
Present to Stakeholders:
Leverage the investor-ready format to confidently present your projections to banks, franchise representatives, or investors.
Shipping Notes
- Free Standard Shipping on $100+ Orders to the USA.
- Except Preorder products are shipped in 48 hours.
- Delivery to the USA:
- Standard Shipping : 3-10 business days
- If time is of the essence, please consider selecting expedited delivery for faster service.
Exchange/Return Notes
- We offer a 30-day return/exchange service after receiving.
- Final sale items are not eligible for returns or exchanges.
- To process your return/exchange, please contact us at [email protected]
- Please click here for more details>>> Return & Exchange Policy
4.4 ★★★★★
Based on 13 reviews
Sort
Product Reviews
★★★★★ 5
A bewitching retelling of Arthurian legend!
Format: Kindle
In a land where the Fae have nearly become only a legend and those who still posses even a morsel of the blood are few and far between, Morgan finds herself cast aside by most of society due to her rumored half-Fae lineage, including her brother, King Arthur. With the kingdom at the brink of war, Arthur entrusts her with a quest to retrieve a Fae weapon of legendary power: the sword of Perun, Excalibur. Accompanied by men she loathes, Captain Kairos Draven and Ragnar Whitehorn, she embarks on her long and unbeknownst perilous journey, only to find that things she once believed to be myth are in fact very real. With devastating twists, omitted truths, witty banter and fierce action, Queen of Roses leaves you begging to know more about the secrets of Aercanum!
Wow, wow, wow! Going into this story, I did not realize that it was going to be a retelling of Arthurian legend, especially not one with a fantastical twist! The unique spin almost gave me The Witcher vibes and I think adding Fae into the mix was quite interesting. I knew the basics of the legend but after reading this book, it has piqued my interest and makes me want to learn more about it. My attention was snatched as soon as I finished the prologue and I knew that I was going to devour this story. I truly enjoyed the gender swaps and even how Arthur was portrayed as villainous. Morgan’s past and even her parts of her present is absolutely heartbreaking, and I felt for her at times. I can only recall one other book that made me hate characters the way I despised Florian and Arthur, leaving me with my blood boiling and feeling disgusted. Even after finishing the book, Draven is still a mystery to me and I cannot figure out how to feel about him. I guess they just means that the author did an excellent job at conveying each character’s persona! The rich world building and imagery made it easy for me to visualize the places that the group visited along their journey. I am truly engulfed in this story and I cannot wait to see wait fate awaits Morgan and how the Fae will be even more incorporated in the next book!.
I received a free copy of this book and am voluntarily leaving a review.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on August 11, 2023
★★★★★ 4
Enchanting
Format: Kindle
"Queen of Roses" by Briar Boleyn is a delightful and refreshing reimagining of the classic tale of King Arthur, with a captivating twist that places the spotlight on Morgan, a character who has often been overshadowed in traditional retellings. Boleyn's creative decision to shift the narrative perspective to Morgan breathes new life into the story, offering readers an intriguing and compelling look at the Arthurian world from an entirely different angle.
One of the most commendable aspects of this book is its incorporation of Fae elements, which adds an enchanting layer of magic and mystery to the already familiar Arthurian setting. Boleyn skillfully weaves the world of the Fae into the narrative, creating a captivating backdrop against which the events of the story unfold. This addition not only adds depth to the world-building but also provides ample opportunities for twists and turns that keep readers thoroughly engrossed.
However, while the book boasts numerous strengths, it does have one noticeable flaw: the characterization of Morgan. While it is reasonable to create a flawed and complex protagonist, it appears that at times, Morgan's character becomes overly difficult and hard to relate to. Her persistently negative perception of one of the main male characters, who is a potential love interest, despite his efforts to support and assist her, may come across as somewhat irrational and could test the patience of some readers. Striking a balance between a strong, independent character and one who can recognize genuine support and affection could have enhanced the overall reader experience.
Nonetheless, the allure of "Queen of Roses" lies in its innovative approach to the Arthurian legend and its skillful blending of fantasy elements into a familiar narrative. Boleyn's evocative prose draws readers into a world where magic, destiny, and fate entwine, leaving us eager to uncover the mysteries that unfold within the pages.
I received a free copy of this book via Booksprout and am voluntarily leaving a review.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on July 28, 2023
★★★★★ 5
An action-packed dark romantasy
Format: Kindle
I loved this book! Queen of Roses is an Arthurian-inspired dark romantasy that is the first book in the Blood of Fae series. The story follows Morgan, the princess of Camelot who is rumored to be part fae. Fueled by prejudiced hatred and a mistrust of fae blood, Morgan’s abusive father strips her of her birthright and hands it to her half-brother, Arthur. Instead of becoming queen, Morgan is commanded to join the temple of the goddesses when she comes of age.
However, Arthur turns into a psychopathic, power-hungry, fae-hating king as he ages. He develops malevolent plans and commands Morgan to find an ancient weapon with legendary power. Although Morgan is wary of Arthur’s intentions, she embraces the opportunity to go on a journey and potentially change her fate.
The story picks up from there and we follow Morgan on her quest to find the ancient relic. It’s full of high stakes adventure, mystery, tension, banter, forced proximity, hidden magic, self discovery, and betrayal. This first installment of the series intricately develops the world building and character development. There’s little romance in this book, but it is evident that it is a slow burn that will continue to develop throughout the remainder of the series.
Overall, I loved the world building, the epic fantasy, Morgan’s journey of self discovery, and all of the twists and turns that set the stage for the future installments. I can’t wait to see what happens next!
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on April 7, 2024
★★★★★ 4
Arthurian Fae Quest…say less.
Format: Kindle
A fae centered Arthurian tale unlike any I’ve read so far. The author did a great job at descriptive world building, with scenes easily playing out in my minds eye. There was plenty of action, suspense, and even a touch of horror. An enemies to lovers, slow burn romance, a quest, with plot twist and turns aplenty. There was a love triangle, which I’m not usually a fan of but, it played out well in this story line. The FMC, Morgan Pendragon, was so blatantly naïve, yet I typically expect as much in a ‘book one’ of a series, especially one that features a fairly sheltered princess. I was happy to read that in spite of this, she still showed a strong sense of morals, fire, and spine. Now our MMC? Kairos Draven, aka Void’s Edge. Oh, how I’m a sucker for a smoking’ hot grumpy warrior alpha with a witty mouth, and a strong sense of “touch her and die” attitude, so you know who held all my cards. That ending? Just made me swoon all the harder. Now add a battlecat that rivals the size of a horse…and well Ms. Briar Boleyn you have well and truly stolen my heart. I’m excited to see where the story goes from here, and follow along to see more of the characters growth. I went into this story fairly blind, and I think I enjoyed it all the more because of it.
Once the story got going, it had me in an absolute chokehold and it was difficult to put down.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 12, 2024
★★★★★ 3
Not a bad start
Format: Kindle
3 stars
Thank you Netgalley and Briar Boleyn for the ARC!
A camelot/king Arthur retelling with fae. I was hooked by the idea of this book immediately and was eager to jump into this world.
• slow burn
• enemies to lovers
• who did this to you
Morgan Pendragon watched her mother die by her father's hand when she was just eight years old, hiding under the bed. Morgan is believed to have the tainted blood of the fae in her veins and is cast aside so that her fathers illegitimate son, Arthur, can become the king. She's seen his cruel treatment of the fae firsthand, so when he sends her on a journey to find a fae weapon she seizes the opportunity to do more with her life. Along the way, she finds more than she could have imagined.
I don't know a whole lot about King Arthur and Camelot but I had a lot of fun with this story! The plot has some similar tropes to popular romantasy books (From blood and ash) but there's enough originality here that it doesn't feel like I'm reading a copy. I liked how the fae were different in appearance than what is typical in most fantasy books I've read. In this book they have blue hair, violet skin and a wide range of other characteristics. I thought that the world building was easy to follow and I could easily immerse myself into this world. After reading the blurb I kept wondering when she was going to go on the journey to find Excalibur and it doesn't happen until around the 45% mark.
The story is a bit slow at times but starts to pick up once they begin their journey to find Excalibur. The John Wick style Inn was a fun concept that I enjoyed reading about.
There are a lot of similarities to this and FBAA and I would have liked to have it be a little more different, but I'm hoping book two will have the story turn into something of its own. Overall I enjoyed reading this story and I'm looking forward to reading book two especially after that ending.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 27, 2023