LiveWebinar: Build a business plan that gets opened more than once (w/ AI)Register
Upmetrics

Ice Cream Shop Business Plan: Bank Loan & Funding Financials

Vinay Kevadia
Vinay KevadiaUpmetrics Team

Opening an ice cream shop involves more decisions than most first-time owners expect. How will the product be made, who will make it, and how will the shop cover fixed costs when foot traffic slows in winter? A business plan forces those answers before the doors open.

The financial piece is where most plans fall short. Equipment, leasehold improvements, staffing, and working capital all need to be funded before a single scoop is sold. Revenue builds gradually. The plan has to show how the numbers work from month one, not just at full capacity.

The market question matters just as much. Who is the customer, what are they currently settling for, and why will they choose something different? A shop without a clear answer to that question is a gamble, not a business.

This business plan presents Frostline Creamery, a craft retail ice cream shop opening in August 2026 in Brookfield, Wisconsin, built around a $250,000 SBA 7(a) loan and a three-revenue-stream model built to run year-round.

Executive Summary

Frostline Creamery will open in August 2026 at 15375 W. Bluemound Road, Brookfield, Wisconsin 53005. The seven-mile primary trade area is currently served only by national chains and a seasonal soft-serve stand. No independent in-house batch producer operates in the corridor.

Maya Bennett and Daniel Reyes are co-founders, each holding a 50% membership interest. Maya brings eight years of multi-unit retail operations experience.

Daniel holds a Penn State Ice Cream Short Course credential and spent five years as pastry lead at Sage & Stone, a Milwaukee restaurant group.

The Concept

Frostline makes everything from scratch. Daniel churns each batch in-house using Wisconsin dairy from Sassy Cow Creamery in Columbus, WI. There is no pre-made mix, no shortcuts. At any given time, the shop runs about 24 flavors: eight that stay year-round and sixteen that rotate with the seasons.

Market Overview

The North American ice cream market sits at $31.86 billion in 2026 and is expected to reach $37.66 billion by 2031. Artisanal formats are the fastest-growing segment within that market. Frostline enters at exactly the right point in that curve, with in-house batch production and a rotating local menu that fits what the premium consumer is already moving toward.

Target market

Frostline’s core customer is a Brookfield family, parents who care about where their food comes from and have no problem paying a fair price for something made locally. The kids are typically 3 to 14. The second customer is a young professional, 22 to 35, who follows the flavor drops, orders the cakes, and brings groups in for events.

Funding Request & Use of Funds

Frostline is asking for a $250,000 SBA 7(a) loan through First Wisconsin Community Bank. Combined with $80,000 in owner equity, total startup capital comes to $330,000. The loan repays at $3,099.59 per month over 10 years at a fixed 8.5% APR.

Of the $330,000 total, $180,000 goes into capitalized assets. The remaining $150,000 covers working capital, launch expenses, deposits, insurance, and a cash reserve through the ramp period.

Year 1 ($) Year 2 ($) Year 3 ($)
Annual Transactions 51,053 60,243 67,471
Total Revenue $485,000 $572,300 $640,976
Gross Profit $234,337 $276,518 $309,700
Net Income (Pre-Tax) $(40,946) $7,578 $22,998
Ending Cash $96,907 $112,055 $140,898

Funding request and use of funds breakdown for the ice cream shop

Writing a business plan from scratch takes time. Use an AI business plan generator to create a structured, investor-ready plan in minutes.

Business Overview

Frostline Creamery is registered in Wisconsin as a Limited Liability Company as of March 2026. The structure was chosen for its pass-through taxation and the personal liability protection it provides to both members.

Location

The shop occupies a 1,400 square foot endcap suite at The Shoppes at Brookfield Commons, 15375 West. Bluemound Road, Brookfield, Wisconsin 53005. The lease is signed for a 10-year term at $36,000 base rent in year one, with 5% annual escalators.

Ownership & Management

Maya Bennett holds 50% ownership and runs all operations and customer experience. Her eight years managing multi-unit retail gave her the systems and staffing instincts that most first-time shop owners spend two years figuring out. She runs the floor, owns the schedule, and manages all non-dairy vendor relationships.

Daniel Reyes holds 50% ownership and runs all production and menu development. Five years as pastry lead at Sage & Stone in Milwaukee gave him the production skills to make ice cream in-house from day one. Daniel manages the dairy supply contract with Sassy Cow Creamery directly.

Business Model

Revenue comes from three streams: retail scoops and sundaes, custom ice cream cakes, and private event catering. Walk-in retail is the core. Cake pre-orders and catering fill the margin and carry the slower months.

All retail transactions run through the Square POS at the counter. Cake orders are invoiced through Square with a 50% deposit on the order and the balance collected at pickup. Catering events require a signed agreement and 25% deposit to confirm, with the balance collected on the day.

Vision

By Year 3, Frostline operates three revenue streams at full capacity, sources 100% of its dairy from Wisconsin farms, carries 24 rotating flavors year-round, and has wholesale pints in at least 10 local grocery and specialty retail locations.

Goals

Frostline’s goals are tied directly to what the business needs to prove in each phase of growth.

  1. Build a private event calendar that runs year-round, not just in peak season, by Year 2.
  2. Reach $485,000 in Year 1 revenue and turn net profitable by Year 2.
  3. Grow catering from 1 to 2 events per month in Year 1 to 4 or more per month by Year 3.
  4. Evaluate a second location in Wauwatosa or New Berlin based on Year 3 performance.

Market Analysis

The Industry

The global ice cream market was valued at $82.70 billion in 2025 and is projected to reach $151.96 billion by 2034, growing at a 7.23% annual rate.

The North American ice cream market sits at $31.86 billion in 2026 and is expected to reach $37.66 billion by 2031. Artisanal formats are the standout segment, projected to expand at a 3.40% annual rate through 2031, faster than every other category in the market.

Ice cream industry market size and growth projection chart

Premium and regular ice cream accounts for 80% of the market. The average American eats roughly 18 pounds of ice cream per year, or about 4 gallons.

The Brookfield Opportunity

Brookfield Wisconsin local market opportunity overview

Brookfield has a 2026 population of 41,163 with a median household income of $129,548.

Who We’re Selling To

Frostline serves two customer segments in the Brookfield trade area, both within 10 minutes of the shop.

The first is the Brookfield families with kids between 3 and 14. These are parents who plan their weekends with intention. Saturday afternoons, post-game stops, birthdays that need a cake. They know where they want to spend and keep going back to places that hold up.

The second is young professionals, 22 to 35. This customer treats Frostline the way people treat a neighborhood coffee spot. After-work visits, office events, and the anniversary dessert. They follow seasonal drops on Instagram and care where the product comes from.

Competitive Analysis

Frostline opens on a corridor where frozen dessert options already exist. They split into two groups: national chains built around convenience and price, and one regional quick-service restaurant with deep Wisconsin loyalty.

The Competitors

Cold Stone Creamery

Cold Stone operates about four miles north of Frostline. The brand carries strong name recognition and steady foot traffic, built around a mix-in format and centralized supply chain. The menu is standardized across locations.

The business does not emphasize rotating seasonal flavors, private event bookings, or a dedicated custom cake program. Its positioning is built around consistency and established national branding rather than localized product differentiation.

Baskin-Robbins

Baskin is located less than two miles from Frostline on the same retail corridor. The store benefits from broad brand familiarity, a large flavor selection, and a convenient high-traffic location.

Its offering includes standard ice cream cakes and occasion-based desserts, but the operating model is primarily centered on convenience, speed, and accessible pricing rather than experience-driven visits.

Culver’s

Culver’s operates on the same corridor and has one of the most loyal customer bases in Wisconsin. Frozen custard is made fresh daily in-store. The format is drive-through, built around speed and volume.

However, frozen custard functions as one part of a larger burger-and-sides menu. The format prioritizes drive-through convenience and quick-service volume rather than destination dessert experiences or specialty event orders.

Grocery and Big-Box Retailers (Indirect Competitors)

Major grocery and big-box retailers, including Pick ‘n Save, Walmart, and Target, compete within the packaged frozen dessert category through pints, novelty bars, and seasonal take-home products.

These retailers primarily serve at-home consumption tied to routine grocery shopping and value pricing.

Frostline’s Positioning

Frostline positions itself as a premium neighborhood ice cream destination, competing on craft quality, custom celebration cakes, and in-store experience rather than price or speed.

Small batch production, rotating seasonal flavors, and made-to-order cakes put distance between Frostline and national chains built around convenience. That distance supports higher perceived value and a stronger average ticket.

Private event catering adds a third axis that no direct competitor touches. Cold Stone, Baskin-Robbins, and Culver’s don’t offer cakes or events at the local franchise level.

That gap is what makes the three-stream model both a competitive differentiator and a practical answer to Wisconsin’s seasonal pressure.

The menu starts with small-batch ice cream Daniel makes himself, then builds out from there. Custom cakes, specialty sundaes, and private event catering are the three extensions, all higher-margin, all running out of the same production kitchen.

The Menu

Frostline’s menu is built around what Daniel makes in-house. Twenty-four flavors, four sundae builds, custom cakes in four sizes, and a seasonal release program that gives regulars a reason to come back every month.

Ice cream shop menu offerings and pricing

Events & Catering

Frostline takes private bookings for two formats. Both are booked through the website or by phone. A written quote goes out within 48 hours, and a 25% deposit confirms the date.

In-shop private rentals run after hours at a $300 base plus $9 per guest. Minimum 15 guests, maximum 60. The shop is cleared for the group, three flavor choices are set up at the counter, and all toppings and paper goods are included. Set up and breakdown are handled by Frostline staff.

Off-site catering brings the operation to the customer via the delivery van. Pricing runs $11 per guest with a $75 delivery fee within 10 miles. Minimum 25 guests. The same three-flavor setup, toppings, and paper goods travel with the van. Final guest count is confirmed seven days before the event, and the balance is collected on the day.

Marketing & Sales Strategy

Frostline’s marketing plan covers launch, ongoing acquisition, and retention across five channels. The total Year 1 budget is $23,000, split between a $14,000 launch spend and $9,000 in ongoing marketing.

Customer Acquisition & Launch Plan

The first 90 days have one job: get the trade area through the door. Everything after that is about bringing them back.

Local SEO and Google Business Profile are claimed and optimized as of May 2026. Weekly posts, photo updates, and review responses keep the listing active. This is the first place a parent searching “ice cream near me” lands.

Instagram and TikTok carry the brand week to week. Short-form video of Daniel’s production process, weekly flavor drops, and behind-the-counter content build the audience before the doors open. The target is 5,000 Instagram followers by month 12.

School partnerships put Frostline in front of the primary customer directly. In Year 1, Frostline plans to sponsor four local elementary school fall festivals to build early community awareness and introduce families to the brand. Teachers and staff receive 10% off year-round.

Local press gets a pitch at launch. The Brookfield Patch and Milwaukee Journal Sentinel food section are the two targets. A regional food photographer is hired for the grand opening to give both outlets something to run.

Brookfield Farmers Market activations run every Saturday from June through September. It is the highest-concentration family traffic point in the trade area outside of the shop itself.

The $14,000 launch budget is allocated across four line items:

Activity Purpose
Exterior signage on endcap facade Visibility to daily vehicles on Bluemound Road
Grand opening event First wave of walk-ins and neighborhood awareness
Meta and Google digital ads Paid search, organic search, and social media build
Printed flyers and door hangers Direct reach into nearby residential subdivisions

Customer Retention

Square Loyalty runs through the POS automatically. Every purchase earns a stamp. Buy nine single scoops and get the tenth scoop free. No app, no sign-up friction.

Family Birthday Club keeps families coming back annually. Kids get a free single scoop in their birthday month. Parents opt in with an email address at the counter. That email list becomes the direct marketing channel for flavor drops and seasonal announcements.

Daniel’s Choice email list gives subscribers early access to the monthly limited release, one week before the public. That one-week window is the reason people stay on the list.

Sales Process

Frostline runs three sales channels. Each has its own order flow and payment structure.

  • The walk-in counter is the primary channel, driving 92% of Year 1 revenue. Customer arrives, reviews the flavor board, orders at the Square POS (Point of Sale), pays, and is served in under three minutes at peak.
  • Custom cakes are available by pre-order with a 48-hour minimum lead time for round cakes and seven days for sheet cakes. A 50% deposit is required at the time of order. Custom flavor combinations, writing, and decoration are included in the base price.
  • Catering and private events begin with a phone or website inquiry. A written quote goes out within 48 hours. A signed event agreement and 25% deposit confirm the booking. Final guest count is due seven days before the event, and the balance is collected on the day.

Operations Plan

Frostline operates out of a 1,400 square foot endcap suite at 15375 W. Bluemound Road, Brookfield, WI 53005. The space is divided into three zones:

  • 600 square foot front of house with a service counter, 16 seats, and a restroom;
  • A 600-square-foot production kitchen where Daniel runs the batch freezer three days a week
  • 200 square feet of back-of-house for admin, staff, and receiving. Everything the shop sells comes out of that kitchen.

Equipment

The $120,000 equipment investment covers everything from the batch freezer Daniel runs three days a week to the van that delivers catering events across the trade area.

Ice cream shop equipment list and costs

Operating Days & Hours

Frostline operates seven days a week, year-round, on two seasonal schedules. Peak season runs April through September, off-peak October through March.

Day Peak (Apr–Sep) Off-Peak (Oct–Mar)
Monday – Thursday 12 pm – 9 pm 2 pm – 8 pm
Friday 12 pm – 10 pm 12 pm – 9 pm
Saturday 11 am – 10 pm 12 pm – 9 pm
Sunday 11 am – 9 pm 12 pm – 7 pm

Daily Operating Workflow

Maya arrives at 8:00 AM, pulls the prior day’s POS report, places dairy and supply orders, and preps the front of house. On production days, Tuesday, Thursday, and Saturday, Daniel arrives at the same time and runs the batch freezer for three to four hours.

Doors open at 11:00 AM on weekends and noon on weekdays. One counter staff member is on the floor. Daniel works on cake decorating and custom orders in the kitchen.

A second counter staff member comes in at 2:00 PM as family traffic builds. Maya moves to the floor. Daniel shifts to cake pickups and catering prep.

Two staff members cover the floor through closing. Closing duties: deep clean display cases, mop the kitchen, restock the counter, complete the cash drop, and set the alarm.

Sourcing & Supply Chain Integrity

The ingredient list at Frostline is not accidental. Every primary supplier was contracted before the opening.

  • Daniel signed a 12-month supply contract with Sassy Cow Creamery in Columbus, WI, in April 2026. That deal covers primary dairy and is in place ahead of the August opening.
  • For mix-ins, Frostline pulls from regional producers: Door County Tart Cherries, Wisconsin Walnut Co., and Bake & Co. Wholesale out of Milwaukee.
  • Cones are sourced from Joy Cone Co. Packaging runs through a single Wisconsin-based distributor.

Technology

Frostline runs on four platforms from day one.

  • Square for Restaurants handles all points of sale, inventory tracking, and online ordering. Square Loyalty runs the customer rewards program through the same system.
  • QuickBooks Online handles accounting, payroll, and financial reporting.
  • 7shifts manages staff scheduling and shift communication.
  • Mailchimp runs the email list for flavor drop announcements and seasonal promotions.

Inventory Management

Frostline manages six inventory categories: dairy and base ingredients, mix-ins and toppings, cake ingredients, beverages, cones and packaging, and cleaning supplies.

Mix-ins, toppings, cake ingredients, and beverages are ordered weekly. Cones and packaging come in every two weeks. Cleaning supplies are restocked monthly.

Reorder points are built into the Square POS, so nothing runs short mid-week. The target is 25 days of inventory on hand at any time. Storage space in the production kitchen is finite, so smaller frequent orders keep product fresh and reduce spoilage risk. Spoilage is budgeted at 1.5% of the cost of goods sold.

Frostline carries four insurance policies from day one. General liability and property insurance are prepaid for the first 12 months at $6,000. Workers’ compensation coverage is in place before the first staff member starts.

The delivery van carries commercial auto insurance for all off-site catering runs. All policies are placed through Heartland Mutual in Brookfield.

On the compliance side, the Wisconsin Retail Food Establishment license is filed and pending approval ahead of the August opening. The shop operates under a signed 10-year lease reviewed by Jenkins Patel Law in Milwaukee before execution.

Both founders hold current ServSafe Manager certification. Daniel holds a Wisconsin Pasteurization Operator’s permit. All business formation documents are filed with the Wisconsin Department of Financial Institutions.

Food Safety

Frostline meets all Wisconsin food service licensing requirements before the August 2026 opening. Every permit, certification, and protocol is in place.

  • Wisconsin Retail Food Establishment License issued by the Wisconsin Department of Agriculture, Trade, and Consumer Protection, renewed annually
  • ServSafe Manager Certification held by both Maya Bennett and Daniel Reyes
  • A Hazard Analysis and Critical Control Points (HACCP) is documented and on file
  • Allergen Handling Protocol covers dairy, nuts, eggs, and gluten with separate scoops, sanitation between flavors, and ingredient cards posted at the counter

Management Team

Frostline opens with two full-time owners and five part-time counter staff in Year 1. Maya and Daniel each take $50,000 in Year 1, $100,000 combined. Counter staff labor runs $106,700 for the year across five part-time employees.

Ownership

Maya Bennett leads operations. She owns the schedule, manages all non-dairy vendor relationships, and runs everything the customer experiences from the moment they walk in. She is on the floor 50 hours a week in peak season.

Daniel Reyes leads production and menu development. He runs the batch freezer on Tuesday, Thursday, and Saturday, manages the dairy supply contract with Sassy Cow Creamery, and handles all cake and catering execution. Production days run 45 to 55 hours per week.

Both are active full-time from opening day.

Staff Roles

Every staff role at Frostline exists for a reason. Here is what each one does and when it comes on.

Counter Staff

Counter Staff handle every customer interaction from open to close. They take orders at the Square POS, maintain the display cases, hand off custom cake pickups, and complete opening and closing duties. In peak season, they work 25 to 35 hours per week. Off-peak drops to 12 to 18.

Starting wage is $18 per hour with annual increases of 3%. The senior counter staff member is cross-trained on vendor order placement and floor management to cover Maya when needed.

Assistant Manager (Year 2)

The Assistant Manager takes over the floor on Maya’s off days. They open the shop, manage the staff schedule for the week, run the daily opening and closing checklist, and handle any customer issues without escalating to Maya.

This role exists so Maya can step back from daily floor coverage and focus on business development and catering growth. Salary is $40,000 per year.

Cake and Catering Coordinator (Year 3)

They manage the custom cake order pipeline from first inquiry to pickup. They confirm orders, coordinate production timing with Daniel, handle client communication, and manage event logistics for off-site catering.

As cake volume and event bookings grow through Year 3, Daniel cannot run production and manage client relationships simultaneously. This role takes that load off him entirely. The salary is $20 per hour at 25 hours per week.

Advisors

Four external advisors are already in place heading into Year 1.

  • A SCORE Wisconsin mentor was assigned in March 2026 and is available for monthly check-ins.
  • Lindsay O’Connell, CPA, based in Brookfield, covers tax filings and financial reporting.
  • Jenkins Patel Law out of Milwaukee handles contracts, lease reviews, and business legal matters.
  • Heartland Mutual, also in Brookfield, carries the general liability, property, and workers’ comp policies.

Key Risks & Mitigations

Every brick-and-mortar food business carries a defined set of risks. The four below are the ones most likely to affect Frostline’s ability to service the SBA loan on schedule.

Risk Impact Mitigation
Seasonality Walk-in traffic drops 30% in off-peak months. Fixed costs stay the same. Cake pre-orders and event deposits carry the slower months. Owner draws are reduced before debt service is touched.
Dairy Price Volatility A 10% price increase on dairy reduces gross margin by 1.5 percentage points. 12-month fixed-price contract with Sassy Cow locks dairy costs through Year 1. Annual menu price increases of 5% absorb renewal inflation.
Owner Dependency If either founder is out, operations and production are both exposed. Senior counter staff cross-trained on open and close. On-call co-packer covers emergency production. The Assistant Manager in Year 2 removes the risk.
Competitive Response Cold Stone or Culver’s may run local promotions if Frostline gains share. Neither operates cakes nor events at the franchise level. A second independent craft producer is the real long-term threat, but requires significant capital to replicate.

Financial Plan

Frostline’s three-year financial plan is anchored by $330,000 in total startup capital, split between a $250,000 SBA 7(a) loan and $80,000 in owner equity. The model reaches $140,898 in ending cash by Year 3 while maintaining a disciplined loan repayment schedule and growing net income every year.

The sections below detail startup costs, funding sources, and the assumptions driving every pro forma statement.

Startup Costs

Expense Amount
Ice cream batch freezer + display cases + walk-in freezer + bakery oven (capitalized equipment) $87,500
POS system + 2 terminals + iPad ordering kiosk (capitalized) $7,500
Delivery van (used 2022 Ford Transit Connect, capitalized) $25,000
Leasehold improvements — counter, paint, signage, seating, plumbing, electrical (capitalized) $60,000
Initial inventory (ice cream base, dairy, mix-ins, packaging, cones) $15,000
Lease deposits + first 2 months prepaid rent $24,000
Insurance — 12 months prepaid (general liability + property) $6,000
Licenses, permits, food handler certs, business formation fees (Year 1 expense) $5,000
Professional fees — legal, accounting, architect for layout (Year 1 expense) $6,000
Marketing launch — signage, grand opening, initial digital ads, PR (Year 1 expense) $14,000
Working capital reserve (cash on hand for slow ramp) $80,000
Total Startup Costs $330,000

Startup costs breakdown for the ice cream shop

Source of Funds

Source Amount
SBA 7(a) Loan (First Wisconsin Community Bank) $250,000
Owner equity contribution (Bennett + Reyes combined) $80,000
Total Startup Capital $330,000

Financial Assumptions

Item Assumption
Average ticket price $9.50 (mix of scoops $5–$7, sundaes $9–$13, cakes $35–$50, catering events)
Annual transactions Year 1: 51,053; Year 2: 60,243; Year 3: 67,471
Year-over-year revenue growth Year 2: +18.0%; Year 3: +12.0%
Direct materials/food cost 28% of revenue
Direct labor (counter staff, scoopers — paid hourly) 22% of revenue
Payroll tax rate 7.65% (employer FICA) — applied separately to direct labor and to owner salaries
Owner salaries (combined Bennett + Reyes) Year 1: $100,000; Year 2: $110,000; Year 3: $120,000
Annual rent (1,400 sqft suburban WI retail) Year 1: $36,000; +5% annual escalator
AR collection assumption DSO = 0 days (cash-and-card retail; catering invoiced and collected on event day)
AP payment assumption DPO = 30 days (Net 30 with food/dairy suppliers)
Inventory days on hand 25 days (perishable; rapid turnover)
Bank First Wisconsin Community Bank
Loan amount $250,000
Loan term 10 years
Interest rate 8.5% fixed APR
Monthly loan payment $3,099.59
Annual loan payment $37,195
Interest expense (Yr 1–3) Yr 1: $20,614; Yr 2: $19,148; Yr 3: $17,553
Principal repayment (Yr 1–3) Yr 1: $16,581; Yr 2: $18,047; Yr 3: $19,642
Ending loan balance (Yr 3) $195,730

Spreadsheets are exhausting & time-consuming

Build accurate financial projections w/ AI-assisted features

Start Forecasting

Financial forecasting

Depreciation Schedule

Asset Cost Useful Life Annual Dep. Acc. Dep. Y1 Net PP&E Y1 Acc. Dep. Y2 Net PP&E Y2 Acc. Dep. Y3 Net PP&E Y3
Restaurant/kitchen equipment
(batch freezer, displays, walk-in, bakery oven, smallwares)
$87,500 7 years $12,500 $12,500 $75,000 $25,000 $62,500 $37,500 $50,000
POS system + terminals $7,500 5 years $1,500 $1,500 $6,000 $3,000 $4,500 $4,500 $3,000
Delivery van $25,000 5 years $5,000 $5,000 $20,000 $10,000 $15,000 $15,000 $10,000
Leasehold improvements $60,000 10 years $6,000 $6,000 $54,000 $12,000 $48,000 $18,000 $42,000
TOTAL $180,000 $25,000 $25,000 $155,000 $50,000 $130,000 $75,000 $105,000

Income Statement (Profit & Loss)

Year 1 ($) Year 2 ($) Year 3 ($)
Annual transactions 51,053 60,243 67,471
Total Revenue $485,000 $572,300 $640,976
COGS
Direct materials/food cost (28%) $135,800 $160,244 $179,473
Direct labor (22%) $106,700 $125,906 $141,015
Payroll tax on direct labor (7.65% of DL) $8,163 $9,632 $10,788
Total COGS $250,663 $295,782 $331,276
Gross Profit $234,337 $276,518 $309,700
Gross Margin 48.32% 48.32% 48.32%
Operating Expenses
Owner salaries $100,000 $110,000 $120,000
Owner payroll taxes (7.65%) $7,650 $8,415 $9,180
Rent (annual; +5% escalator) $36,000 $37,800 $39,690
Insurance (general liability, property, workers comp) $6,500 $6,825 $7,165
Accounting, legal & professional fees $4,800 $5,040 $5,290
Phone & utilities (electric heavy for freezers) $14,400 $15,120 $15,876
Ongoing marketing $9,000 $11,000 $13,000
Fuel & vehicle (catering deliveries) $3,200 $3,800 $4,200
Supplies (cleaning, paper, gloves) $4,500 $5,250 $5,775
Repairs & maintenance $3,500 $4,200 $4,800
Technology subscriptions (POS, accounting, email) $3,600 $3,750 $3,950
Credit card processing (~2.5% × 95% of revenue) $11,519 $13,592 $15,223
Marketing launch (one-time) $14,000
Licenses & permits (one-time) $5,000
Professional services setup (one-time) $6,000
Total Operating Expenses $229,669 $224,792 $244,149
EBITDA $4,668 $51,726 $65,551
Depreciation $25,000 $25,000 $25,000
EBIT $(20,332) $26,726 $40,551
Interest expense $20,614 $19,148 $17,553
Net Income (Pre-Tax) $(40,946) $7,578 $22,998

Three-year income statement projection for the ice cream shop

Cash Flow Statement

Year 1 ($) Year 2 ($) Year 3 ($)
Beginning Cash $105,000 $96,907 $112,055
Operating Activities
Net income (pre-tax) $(40,946) $7,578 $22,998
Depreciation (non-cash) $25,000 $25,000 $25,000
Change in Accounts Receivable $0 $0 $0
Change in Inventory $(2,168) $(3,091) $(2,431)
Change in Accounts Payable $20,602 $3,708 $2,918
Change in Prepaid Expenses $6,000 $0 $0
Net Cash from Operations $8,488 $33,195 $48,485
Investing Activities
Capital expenditures $0 $0 $0
Net Cash from Investing $0 $0 $0
Financing Activities
Loan principal repayment $(16,581) $(18,047) $(19,642)
Net Cash from Financing $(16,581) $(18,047) $(19,642)
Net Change in Cash $(8,093) $15,148 $28,843
Ending Cash $96,907 $112,055 $140,898

Opening Balance Sheet (at Launch)

Line Item Amount ($)
ASSETS
Cash (working capital reserve + one-time-expense float) $105,000
Inventory (opening stock) $15,000
Prepaid rent + insurance $30,000
Gross PP&E (equipment + vehicle + leasehold improvements) $180,000
Total Assets $330,000
LIABILITIES & EQUITY
SBA 7(a) Term Loan $250,000
Members’ paid-in capital $80,000
Total Liabilities + Equity $330,000

Balance Sheet (Years 1-3)

Year 1 ($) Year 2 ($) Year 3 ($)
ASSETS
Cash $96,907 $112,055 $140,898
Accounts receivable $0 $0 $0
Inventory $17,168 $20,259 $22,690
Prepaid expenses (security deposits) $24,000 $24,000 $24,000
Net PP&E $155,000 $130,000 $105,000
Total Assets $293,075 $286,314 $292,588
LIABILITIES
Accounts payable $20,602 $24,310 $27,228
SBA term loan $233,419 $215,372 $195,730
Total Liabilities $254,021 $239,682 $222,958
EQUITY
Paid-in capital $80,000 $80,000 $80,000
Retained earnings (cumulative net income) $(40,946) $(33,368) $(10,370)
Members’ Capital $39,054 $46,632 $69,630

Three-year balance sheet projection for the ice cream shop

Break-Even Analysis

Item Value
Average ticket price $9.50
Direct materials per ticket (28% × $9.50) $2.66
Direct labor per ticket (22% × $9.50) $2.09
Payroll tax on labor per ticket (7.65% × $2.09) $0.16
Total variable cost per ticket $4.91
Contribution margin per ticket $4.59
Contribution margin (%) 48.32%
Annual fixed operating costs
(Year 2 ongoing OpEx, excl. one-time and depreciation)
$224,792
Break-even tickets per year 48,975
Break-even tickets per month 4,081
Break-even revenue (annual) $465,260

The Quickest Way to turn a Business Idea into a Business Plan

Fill-in-the-blanks and automatic financials make it easy.

Frequently Asked Questions

Vinay Kevadia

Vinay Kevadia

Vinay Kevadiya is the founder and CEO of Upmetrics, the #1 business planning software. His ultimate goal with Upmetrics is to revolutionize how entrepreneurs create, manage, and execute their business plans. He enjoys sharing his insights on business planning and other relevant topics through his articles and blog posts. Read more