Printing is disabled for samples. Get your own study at simplefeasibility.com.
← All samples

Mobile Dog Grooming Van · Plano, Texas

Full Business Plan sample · figures in USD · view only

This is an unedited sample. Every figure came straight out of the SimpleFeasibility pipeline.

Business plan 78 pagesInvestor model 8 sheetsInvestor deck 14 slides

Computed values from the investor workbook, read-only. The customer receives the live Excel file with every formula.

Mobile Dog Grooming Van — financial model

Plano, Texas, United States · USD · 10 operating years · change the yellow cells on Inputs

Verdict (at the study's inputs): Feasible if restructured
Feasible if restructured: the business itself works (30.5% EBITDA margin once trading settles), but the plan as funded does not — it is $14,195 short of equity.
Total project cost97,462
Loan60,000
Owner equity in the plan37,462
Lowest DSCR over the loan2.18xlenders look for 1.25x or more
Lowest closing cash (year end)27,579below zero means more equity or a facility is needed
Project NPV, no sale (headline)93,836
Project IRR, no sale (headline)29.9%
Project NPV with exit value182,838
Equity IRR55.6%
Revenue, year 1115,875
EBITDA margin, final year29.2%
Balance sheet check (sum of differences, must be 0)0.00
How the model was built
• Projection extended to 10 years (a professional study and a lender look at the loan's whole life).
• Capacity: Single high-roof mobile van: 6 grooms/day x 5 operating days/week x 50 weeks/year = 1,500 maximum annual grooms; sales are held to 95% of it (1,425).
• Year one: 3 months before opening, then a 9-month ramp-up, so it sells 42% of a full year; staff are paid from a month before opening, fixed charges all year.
• Assets with lives shorter than the 10-year projection (Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster), 5 yrs; Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation, 6 yrs; Full Vehicle Graphic Wrap & Professional Branding Signage, 5 yrs; Custom Waterproof Storage Cabinetry & Tool Racks, 6 yrs) are replaced at the end of their lives and paid for in that year — a services reserve of 1% of revenue would not fund them.
• Contingency of 7.5% on the capital cost (equipment and set-up) — lenders expect one; it is part of the money to raise.
• Financing as the founder proposed it: USD 35,000 of the founder's own money + USD 60,000 loan at 9% over 5 years.
• Tax: Income-tax provision 21% (21% federal + no state income tax in Texas). For a sole proprietor or single-member LLC the same order of tax is paid by the owner as income and 15.3% self-employment tax.
• Tax losses carried forward without a time limit (United States rule; continuity or annual-cap conditions not modelled).
• Exit value at 4× final-year EBITDA (services norm), shown as the secondary view; the headline NPV and IRR exclude it.

Inputs

Yellow cells drive the whole model. Change them and every sheet recalculates.

GENERAL
Inflation (cost and salary growth)3.7%
Income tax rate21.00%Income-tax provision 21% (21% federal + no state income tax in Texas). For a sole proprietor or single-member LLC the same order of tax is paid by the owner as income and 15.3% self-employment tax.
Profit taxed at nil each year (threshold)0
Zakat rate (Saudi-owned company)0.0%
Discount rate (project)9.7%
Cost of equity12.7%
Exit value: multiple of final-year EBITDA (0 = no sale)4.0x
SENSITIVITY (1 = as planned)
Selling prices ×1.00
Sales volumes ×1.00
Direct costs ×1.00
Operating costs ×1.00
Salaries ×1.00
INVESTMENT
Contingency on the build7.5%
Pre-opening costs (capitalised, 5-year life)0
Opening working capital (cash raised with the project)10,000
Interest capitalised during construction0
Loan arrangement fees0
WORKING CAPITAL
Receivable days1
Payable days22
Inventory days22
Renewal reserve, % of revenue by year (all 0 = renew assets at the end of their lives)0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Reserve in use0
LOAN
Loan drawn60,000opening balance below adds capitalised interest
Opening balance when trading starts60,000
Interest rate (a year)9.00%
Term (months, including interest-only)60
Interest-only months at the start0
REVENUE STREAMS (units by year; price in year 1, then growth)
StreamPrice yr 1Price growthDirect cost %Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Full Mobile Dog Grooming Package (Medium Dog Baseline)953.0%12.0%1,1251,2751,3801,3951,4101,4101,4251,4251,4251,425
High-Margin Add-On Spa Treatments & Grooming Upsells203.0%10.0%450510552558564564570570570570
STAFF (headcount by year; salary in year 1, grows with inflation)
RoleSalary yr 1On-costs %DepartmentYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Lead Mobile Groomer / Owner-Operator45,00014.4%Grooming Services0.831.001.001.001.001.001.001.001.001.00
OPERATING COSTS (annual amount at today's prices; fixed grows with inflation, variable with volume, % with revenue)
Cost lineAmount / %GrowthType
Grooming Consumables & Supplies8,6403.7%variable
Marketing & Local Advertising4,2003.7%variable
Commercial Van & Liability Insurance4,0443.7%fixedfixed charge, below GOP
Mobile Van Fuel & Drive Energy3,9963.7%variable
Credit Card & Payment Processing Fees2.26%follows revenuepct of revenue
Van & Grooming Equipment Maintenance2,4483.7%fixed
Professional Services (Accounting & Legal)1,5003.7%fixed
ASSETS (cost; life in years, 0 = land / not depreciated; renewed 1 = bought again at end of life, 0 = one-off)
AssetCostLifeClassRenewed
Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster)33,0005vehicles1
Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation32,0006technology1
Full Vehicle Graphic Wrap & Professional Branding Signage3,0005vehicles1
Custom Waterproof Storage Cabinetry & Tool Racks1,2006software1
Electric Lift Grooming Table with Van Floor Anchors1,6505vehicles1
Stainless Steel Bathing Tub & Prima Recirculating Bathing System2,4007other1
High-Velocity Dual-Motor Force Blower Dryer8504other1
50-Gal Fresh & Grey Water Tanks, Pump & Electric Water Heater Setup2,1006other1
3000W Pure Sine Wave Inverter + 400Ah LiFePO4 Battery Auxiliary Power System1,5005other1
Professional Clippers, Japanese Steel Shears, Blades & Hand Tool Kit1,0003technology1
iPad, POS Card Reader, Peplink 5G Cellular Router & Mounting System2,1003technology1
City of Plano Permits, Commercial Vehicle Registration & Business Licensing5601vehicles0
Build cost (sum of assets)81,360

Revenue, costs and EBITDA

USD · every cell is a formula on the Inputs sheet

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Full Mobile Dog Grooming Package (Medium Dog Baseline) — revenue106,875124,759139,084144,814150,762155,285161,645166,494171,489176,634
High-Margin Add-On Spa Treatments & Grooming Upsells — revenue9,00010,50611,71212,19512,69613,07713,61214,02114,44114,874
Total revenue115,875135,265150,796157,008163,458168,361175,257180,515185,930191,508
    Full Mobile Dog Grooming Package (Medium Dog Baseline) — direct cost12,82514,97116,69017,37818,09118,63419,39719,97920,57921,196
    High-Margin Add-On Spa Treatments & Grooming Upsells — direct cost9001,0511,1711,2191,2701,3081,3611,4021,4441,487
Total direct costs13,72516,02217,86118,59719,36119,94220,75921,38122,02322,683
Gross profit102,150119,243132,935138,411144,097148,420154,498159,133163,907168,825
Activity index (sales at year-1 prices)115,875131,325142,140143,685145,230145,230146,775146,775146,775146,775
    Staff: Lead Mobile Groomer / Owner-Operator42,91953,40855,38457,43359,55861,76264,04766,41768,87471,423
Total payroll42,91953,40855,38457,43359,55861,76264,04766,41768,87471,423
    Grooming Consumables & Supplies7,6248,96010,05610,54211,04911,45812,00912,45312,91413,391
    Marketing & Local Advertising3,7064,3554,8895,1245,3715,5705,8376,0536,2776,510
    Commercial Van & Liability Insurance4,0444,1944,3494,5104,6774,8505,0295,2155,4085,608
    Mobile Van Fuel & Drive Energy3,5264,1444,6514,8765,1105,2995,5545,7595,9736,194
    Credit Card & Payment Processing Fees2,6153,0533,4033,5443,6893,8003,9564,0744,1964,322
    Van & Grooming Equipment Maintenance2,4482,5392,6332,7302,8312,9363,0443,1573,2743,395
    Professional Services (Accounting & Legal)1,5001,5561,6131,6731,7351,7991,8651,9342,0062,080
Operating costs21,41924,60627,24528,48829,78630,86232,26533,43134,64035,892
Gross operating profit (GOP)37,81341,22950,30652,49054,75255,79558,18659,28560,39361,510
Operator fees0000000000
Fixed charges (insurance)4,0444,1944,3494,5104,6774,8505,0295,2155,4085,608
EBITDA33,76937,03545,95747,98050,07650,94653,15754,07054,98555,902
EBITDA margin29.1%27.4%30.5%30.6%30.6%30.3%30.3%30.0%29.6%29.2%
Renewal reserve (cash)0000000000

Depreciation and replacement

USD · straight line; assets renewed at the end of their lives unless a renewal reserve is set

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster) — depreciation7,0957,0957,0957,0957,0958,5088,5088,5088,5088,508
Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster) — replacement0000042,5420000
Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation — depreciation5,7335,7335,7335,7335,7335,7337,1307,1307,1307,130
Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation — replacement00000042,779000
Full Vehicle Graphic Wrap & Professional Branding Signage — depreciation645645645645645773773773773773
Full Vehicle Graphic Wrap & Professional Branding Signage — replacement000003,8670000
Custom Waterproof Storage Cabinetry & Tool Racks — depreciation215215215215215215267267267267
Custom Waterproof Storage Cabinetry & Tool Racks — replacement0000001,604000
Electric Lift Grooming Table with Van Floor Anchors — depreciation355355355355355425425425425425
Electric Lift Grooming Table with Van Floor Anchors — replacement000002,1270000
Stainless Steel Bathing Tub & Prima Recirculating Bathing System — depreciation369369369369369369369475475475
Stainless Steel Bathing Tub & Prima Recirculating Bathing System — replacement00000003,32700
High-Velocity Dual-Motor Force Blower Dryer — depreciation228228228228264264264264305305
High-Velocity Dual-Motor Force Blower Dryer — replacement00001,0570001,2220
50-Gal Fresh & Grey Water Tanks, Pump & Electric Water Heater Setup — depreciation376376376376376376468468468468
50-Gal Fresh & Grey Water Tanks, Pump & Electric Water Heater Setup — replacement0000002,807000
3000W Pure Sine Wave Inverter + 400Ah LiFePO4 Battery Auxiliary Power System — depreciation322322322322322387387387387387
3000W Pure Sine Wave Inverter + 400Ah LiFePO4 Battery Auxiliary Power System — replacement000001,9340000
Professional Clippers, Japanese Steel Shears, Blades & Hand Tool Kit — depreciation358358358400400400446446446497
Professional Clippers, Japanese Steel Shears, Blades & Hand Tool Kit — replacement0001,199001,337001,491
iPad, POS Card Reader, Peplink 5G Cellular Router & Mounting System — depreciation7527527528398398399369369361,044
iPad, POS Card Reader, Peplink 5G Cellular Router & Mounting System — replacement0002,517002,807003,131
City of Plano Permits, Commercial Vehicle Registration & Business Licensing — depreciation602000000000
City of Plano Permits, Commercial Vehicle Registration & Business Licensing — replacement0000000000
Pre-opening (5 years)0000000000
Weighted asset life (years)5
Capitalised interest and loan fees0000000000
Reserve-funded renewals (7-year life)0000000000
Total depreciation17,05216,45016,45016,57816,61318,29019,97320,08020,12120,280
Maintenance capex (replacements or reserve)0003,7161,05750,47051,3353,3271,2224,621

Loan, tax, working capital and the three statements

USD · the balance sheet balances by construction (cash comes from the cash flow)

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
LOAN (monthly annuity after the interest-only months)
Interest-only months this year0000000000
First repayment month this year (of the amortising term)11325374961738597109
Last repayment month this year12243648606060606060
Interest4,9964,0633,0421,92570400000
Principal repaid9,95010,88311,90413,02114,24200000
Loan balance, end of year50,05039,16727,26314,242(0)(0)(0)(0)(0)(0)
Debt service14,94614,94614,94614,94614,94600000
PROFIT AND LOSS
Revenue115,875135,265150,796157,008163,458168,361175,257180,515185,930191,508
EBITDA33,76937,03545,95747,98050,07650,94653,15754,07054,98555,902
Depreciation17,05216,45016,45016,57816,61318,29019,97320,08020,12120,280
EBIT16,71720,58629,50731,40333,46332,65633,18433,99034,86435,621
Interest4,9964,0633,0421,92570400000
Profit before tax11,72116,52326,46529,47732,75932,65633,18433,99034,86435,621
Tax losses brought forward0000000000
Tax losses carried forward0000000000
Income tax2,4613,4705,5586,1906,8796,8586,9697,1387,3217,480
Owners' book equity at the start of the year37,46246,72159,77580,682103,969129,849155,647181,862208,714236,256
Zakat0000000000
Tax and zakat2,4613,4705,5586,1906,8796,8586,9697,1387,3217,480
Net income9,25913,05320,90823,28725,87925,79826,21526,85227,54228,141
WORKING CAPITAL
Receivables317371413430448461480495509525
Inventory8279661,0771,1211,1671,2021,2511,2891,3271,367
Payables2,3622,7022,9813,1103,2443,3543,4993,6183,7413,869
Net working capital(1,217)(1,365)(1,491)(1,559)(1,629)(1,691)(1,768)(1,835)(1,904)(1,977)
Increase in working capital(1,217)(148)(126)(68)(71)(62)(77)(67)(70)(72)
CASH FLOW
Cash from operations27,52829,65137,48339,93242,56344,15046,26546,99947,73348,493
Maintenance capex0003,7161,05750,47051,3353,3271,2224,621
Loan principal repaid9,95010,88311,90413,02114,24200000
Closing cash27,57946,34671,92595,121122,385116,065110,995154,667201,178245,050
BALANCE SHEET (year end)
Fixed assets at cost87,46287,46287,46291,17892,235142,705194,040197,367198,589203,210
Accumulated depreciation17,05233,50149,95166,52983,142101,432121,405141,485161,607181,887
Cash27,57946,34671,92595,121122,385116,065110,995154,667201,178245,050
Receivables + inventory1,1451,3361,4901,5511,6151,6631,7311,7831,8371,892
Total assets99,134101,643110,926121,321133,093159,001185,361212,332239,998268,266
Payables2,3622,7022,9813,1103,2443,3543,4993,6183,7413,869
Loan50,05039,16727,26314,242(0)(0)(0)(0)(0)(0)
Equity paid in37,46237,46237,46237,46237,46237,46237,46237,46237,46237,462
Retained earnings9,25922,31343,22066,50792,387118,185144,400171,252198,794226,935
Owners' book equity46,72159,77580,682103,969129,849155,647181,862208,714236,256264,397
Total liabilities and equity99,134101,643110,926121,321133,093159,001185,361212,332239,998268,266
CHECK: assets − liabilities − equity (must be 0)0.000.000.000.000.000.000.000.000.000.00
LENDER VIEW
Working-capital build covered by the opening reserve0000000000
Opening reserve left10,00010,00010,00010,00010,00010,00010,00010,00010,00010,000
Cash available for debt service (CFADS)32,52533,71440,52538,14142,211(6,320)(5,070)43,67246,51143,872
DSCR2.18x2.26x2.71x2.55x2.82x

Returns

USD · IRR on undiscounted flows, NPV at the Inputs rates; investment at t=0, year 1 at t=1

t=0Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
EBIT016,71720,58629,50731,40333,46332,65633,18433,99034,86435,621
Losses brought forward (unlevered)00000000000
Losses carried forward (unlevered)00000000000
Unlevered tax and zakat03,5114,3236,1976,5957,0276,8586,9697,1387,3217,480
Project cash flow (FCFF)(97,462)31,47532,86039,88637,73742,063(6,320)(5,070)43,67246,51143,872
Exit value (final year)0000000000223,606
Project cash flow with exit(97,462)31,47532,86039,88637,73742,063(6,320)(5,070)43,67246,511267,478
Equity cash flow (FCFE, with exit net of the loan)(37,462)17,57918,76825,57923,19527,264(6,320)(5,070)43,67246,511267,478
Project NPV, no sale at the end (headline)93,836
Project IRR, no sale at the end (headline)29.9%
Project NPV with exit value182,838
Project IRR with exit value34.8%
Equity IRR (after financing, with exit)55.6%
Equity NPV at the cost of equity149,004
Lowest DSCR over the loan2.18x

Checks

Each line: what this workbook calculates, what the study's engine calculated, the difference. All should be zero (within a dollar of rounding) before any input is changed.

This workbookStudy engineDifference
Revenue, all years1,623,9741,623,9731
EBITDA, all years483,877483,877−0
Depreciation, all years181,887181,8870
Interest, all years14,73014,7300
Tax, all years60,32460,3240
Net income, all years226,935226,9341
Closing cash, final year245,050245,0500
Loan balance, final year(0)0−0
Project NPV (no sale)93,83693,8360
Project IRR (no sale)29.88%29.88%−0.00%
Project NPV with exit182,838182,838−0
Equity IRR55.60%55.60%0.00%
Equity NPV149,004149,004−0
Lowest DSCR2.182.18−0.00
Balance sheet check, every year (must be 0)0.00
The engine rounds each yearly figure to the dollar, so sums over ten years can differ by a few dollars; a larger difference means an input has changed.

Months 1–24

A monthly profile of the study's annual model at the study's inputs (values): revenue follows the opening date and ramp-up; each year closes on the annual cash balance.

MonthRevenueEBITDALoan paymentsNet cash flowCash balance
10(1,801)1,246(2,945)7,055
20(1,801)1,246(2,945)4,109
30(6,093)1,246(7,237)(3,128)
42,575(3,909)1,246(5,053)(8,181)
55,150(1,724)1,246(2,868)(11,049)
67,7254601,246(684)(11,733)
710,3002,6451,2461,501(10,232)
812,8754,8291,2463,685(6,547)
915,4507,0141,2465,870(677)
1018,0259,1981,2468,0547,378
1120,60011,3831,24610,23917,617
1223,17513,5681,2469,96227,579
1311,2723,0861,2461,85329,432
1411,2723,0861,2461,85331,285
1511,2723,0861,2461,85333,138
1611,2723,0861,2461,85334,991
1711,2723,0861,2461,85336,844
1811,2723,0861,2461,85338,698
1911,2723,0861,2461,85340,551
2011,2723,0861,2461,85342,404
2111,2723,0861,2461,85344,257
2211,2723,0861,2461,85346,110
2311,2723,0861,2461,85347,963
2411,2723,0861,246(1,617)46,346

This is an unedited sample. Every figure came straight out of the SimpleFeasibility pipeline.