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 cost | 97,462 | |
| Loan | 60,000 | |
| Owner equity in the plan | 37,462 | |
| Lowest DSCR over the loan | 2.18x | lenders look for 1.25x or more |
| Lowest closing cash (year end) | 27,579 | below 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 value | 182,838 | |
| Equity IRR | 55.6% | |
| Revenue, year 1 | 115,875 | |
| EBITDA margin, final year | 29.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 rate | 21.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 equity | 12.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 build | 7.5% | ||||||||||||
| Pre-opening costs (capitalised, 5-year life) | 0 | ||||||||||||
| Opening working capital (cash raised with the project) | 10,000 | ||||||||||||
| Interest capitalised during construction | 0 | ||||||||||||
| Loan arrangement fees | 0 | ||||||||||||
| WORKING CAPITAL | |||||||||||||
| Receivable days | 1 | ||||||||||||
| Payable days | 22 | ||||||||||||
| Inventory days | 22 | ||||||||||||
| 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 use | 0 | ||||||||||||
| LOAN | |||||||||||||
| Loan drawn | 60,000 | opening balance below adds capitalised interest | |||||||||||
| Opening balance when trading starts | 60,000 | ||||||||||||
| Interest rate (a year) | 9.00% | ||||||||||||
| Term (months, including interest-only) | 60 | ||||||||||||
| Interest-only months at the start | 0 | ||||||||||||
| REVENUE STREAMS (units by year; price in year 1, then growth) | |||||||||||||
| Stream | Price yr 1 | Price growth | Direct cost % | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
| Full Mobile Dog Grooming Package (Medium Dog Baseline) | 95 | 3.0% | 12.0% | 1,125 | 1,275 | 1,380 | 1,395 | 1,410 | 1,410 | 1,425 | 1,425 | 1,425 | 1,425 |
| High-Margin Add-On Spa Treatments & Grooming Upsells | 20 | 3.0% | 10.0% | 450 | 510 | 552 | 558 | 564 | 564 | 570 | 570 | 570 | 570 |
| STAFF (headcount by year; salary in year 1, grows with inflation) | |||||||||||||
| Role | Salary yr 1 | On-costs % | Department | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
| Lead Mobile Groomer / Owner-Operator | 45,000 | 14.4% | Grooming Services | 0.83 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| OPERATING COSTS (annual amount at today's prices; fixed grows with inflation, variable with volume, % with revenue) | |||||||||||||
| Cost line | Amount / % | Growth | Type | ||||||||||
| Grooming Consumables & Supplies | 8,640 | 3.7% | variable | ||||||||||
| Marketing & Local Advertising | 4,200 | 3.7% | variable | ||||||||||
| Commercial Van & Liability Insurance | 4,044 | 3.7% | fixed | fixed charge, below GOP | |||||||||
| Mobile Van Fuel & Drive Energy | 3,996 | 3.7% | variable | ||||||||||
| Credit Card & Payment Processing Fees | 2.26% | follows revenue | pct of revenue | ||||||||||
| Van & Grooming Equipment Maintenance | 2,448 | 3.7% | fixed | ||||||||||
| Professional Services (Accounting & Legal) | 1,500 | 3.7% | fixed | ||||||||||
| ASSETS (cost; life in years, 0 = land / not depreciated; renewed 1 = bought again at end of life, 0 = one-off) | |||||||||||||
| Asset | Cost | Life | Class | Renewed | |||||||||
| Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster) | 33,000 | 5 | vehicles | 1 | |||||||||
| Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation | 32,000 | 6 | technology | 1 | |||||||||
| Full Vehicle Graphic Wrap & Professional Branding Signage | 3,000 | 5 | vehicles | 1 | |||||||||
| Custom Waterproof Storage Cabinetry & Tool Racks | 1,200 | 6 | software | 1 | |||||||||
| Electric Lift Grooming Table with Van Floor Anchors | 1,650 | 5 | vehicles | 1 | |||||||||
| Stainless Steel Bathing Tub & Prima Recirculating Bathing System | 2,400 | 7 | other | 1 | |||||||||
| High-Velocity Dual-Motor Force Blower Dryer | 850 | 4 | other | 1 | |||||||||
| 50-Gal Fresh & Grey Water Tanks, Pump & Electric Water Heater Setup | 2,100 | 6 | other | 1 | |||||||||
| 3000W Pure Sine Wave Inverter + 400Ah LiFePO4 Battery Auxiliary Power System | 1,500 | 5 | other | 1 | |||||||||
| Professional Clippers, Japanese Steel Shears, Blades & Hand Tool Kit | 1,000 | 3 | technology | 1 | |||||||||
| iPad, POS Card Reader, Peplink 5G Cellular Router & Mounting System | 2,100 | 3 | technology | 1 | |||||||||
| City of Plano Permits, Commercial Vehicle Registration & Business Licensing | 560 | 1 | vehicles | 0 | |||||||||
| Build cost (sum of assets) | 81,360 |
Revenue, costs and EBITDA
USD · every cell is a formula on the Inputs sheet
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||
| Full Mobile Dog Grooming Package (Medium Dog Baseline) — revenue | 106,875 | 124,759 | 139,084 | 144,814 | 150,762 | 155,285 | 161,645 | 166,494 | 171,489 | 176,634 | |
| High-Margin Add-On Spa Treatments & Grooming Upsells — revenue | 9,000 | 10,506 | 11,712 | 12,195 | 12,696 | 13,077 | 13,612 | 14,021 | 14,441 | 14,874 | |
| Total revenue | 115,875 | 135,265 | 150,796 | 157,008 | 163,458 | 168,361 | 175,257 | 180,515 | 185,930 | 191,508 | |
| Full Mobile Dog Grooming Package (Medium Dog Baseline) — direct cost | 12,825 | 14,971 | 16,690 | 17,378 | 18,091 | 18,634 | 19,397 | 19,979 | 20,579 | 21,196 | |
| High-Margin Add-On Spa Treatments & Grooming Upsells — direct cost | 900 | 1,051 | 1,171 | 1,219 | 1,270 | 1,308 | 1,361 | 1,402 | 1,444 | 1,487 | |
| Total direct costs | 13,725 | 16,022 | 17,861 | 18,597 | 19,361 | 19,942 | 20,759 | 21,381 | 22,023 | 22,683 | |
| Gross profit | 102,150 | 119,243 | 132,935 | 138,411 | 144,097 | 148,420 | 154,498 | 159,133 | 163,907 | 168,825 | |
| Activity index (sales at year-1 prices) | 115,875 | 131,325 | 142,140 | 143,685 | 145,230 | 145,230 | 146,775 | 146,775 | 146,775 | 146,775 | |
| Staff: Lead Mobile Groomer / Owner-Operator | 42,919 | 53,408 | 55,384 | 57,433 | 59,558 | 61,762 | 64,047 | 66,417 | 68,874 | 71,423 | |
| Total payroll | 42,919 | 53,408 | 55,384 | 57,433 | 59,558 | 61,762 | 64,047 | 66,417 | 68,874 | 71,423 | |
| Grooming Consumables & Supplies | 7,624 | 8,960 | 10,056 | 10,542 | 11,049 | 11,458 | 12,009 | 12,453 | 12,914 | 13,391 | |
| Marketing & Local Advertising | 3,706 | 4,355 | 4,889 | 5,124 | 5,371 | 5,570 | 5,837 | 6,053 | 6,277 | 6,510 | |
| Commercial Van & Liability Insurance | 4,044 | 4,194 | 4,349 | 4,510 | 4,677 | 4,850 | 5,029 | 5,215 | 5,408 | 5,608 | |
| Mobile Van Fuel & Drive Energy | 3,526 | 4,144 | 4,651 | 4,876 | 5,110 | 5,299 | 5,554 | 5,759 | 5,973 | 6,194 | |
| Credit Card & Payment Processing Fees | 2,615 | 3,053 | 3,403 | 3,544 | 3,689 | 3,800 | 3,956 | 4,074 | 4,196 | 4,322 | |
| Van & Grooming Equipment Maintenance | 2,448 | 2,539 | 2,633 | 2,730 | 2,831 | 2,936 | 3,044 | 3,157 | 3,274 | 3,395 | |
| Professional Services (Accounting & Legal) | 1,500 | 1,556 | 1,613 | 1,673 | 1,735 | 1,799 | 1,865 | 1,934 | 2,006 | 2,080 | |
| Operating costs | 21,419 | 24,606 | 27,245 | 28,488 | 29,786 | 30,862 | 32,265 | 33,431 | 34,640 | 35,892 | |
| Gross operating profit (GOP) | 37,813 | 41,229 | 50,306 | 52,490 | 54,752 | 55,795 | 58,186 | 59,285 | 60,393 | 61,510 | |
| Operator fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Fixed charges (insurance) | 4,044 | 4,194 | 4,349 | 4,510 | 4,677 | 4,850 | 5,029 | 5,215 | 5,408 | 5,608 | |
| EBITDA | 33,769 | 37,035 | 45,957 | 47,980 | 50,076 | 50,946 | 53,157 | 54,070 | 54,985 | 55,902 | |
| EBITDA margin | 29.1% | 27.4% | 30.5% | 30.6% | 30.6% | 30.3% | 30.3% | 30.0% | 29.6% | 29.2% | |
| Renewal reserve (cash) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation and replacement
USD · straight line; assets renewed at the end of their lives unless a renewal reserve is set
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||
| Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster) — depreciation | 7,095 | 7,095 | 7,095 | 7,095 | 7,095 | 8,508 | 8,508 | 8,508 | 8,508 | 8,508 | |
| Pre-Owned High-Roof Commercial Cargo Van (Ford Transit / Ram ProMaster) — replacement | 0 | 0 | 0 | 0 | 0 | 42,542 | 0 | 0 | 0 | 0 | |
| Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation — depreciation | 5,733 | 5,733 | 5,733 | 5,733 | 5,733 | 5,733 | 7,130 | 7,130 | 7,130 | 7,130 | |
| Professional Mobile Grooming Conversion Fit-Out & Thermal Insulation — replacement | 0 | 0 | 0 | 0 | 0 | 0 | 42,779 | 0 | 0 | 0 | |
| Full Vehicle Graphic Wrap & Professional Branding Signage — depreciation | 645 | 645 | 645 | 645 | 645 | 773 | 773 | 773 | 773 | 773 | |
| Full Vehicle Graphic Wrap & Professional Branding Signage — replacement | 0 | 0 | 0 | 0 | 0 | 3,867 | 0 | 0 | 0 | 0 | |
| Custom Waterproof Storage Cabinetry & Tool Racks — depreciation | 215 | 215 | 215 | 215 | 215 | 215 | 267 | 267 | 267 | 267 | |
| Custom Waterproof Storage Cabinetry & Tool Racks — replacement | 0 | 0 | 0 | 0 | 0 | 0 | 1,604 | 0 | 0 | 0 | |
| Electric Lift Grooming Table with Van Floor Anchors — depreciation | 355 | 355 | 355 | 355 | 355 | 425 | 425 | 425 | 425 | 425 | |
| Electric Lift Grooming Table with Van Floor Anchors — replacement | 0 | 0 | 0 | 0 | 0 | 2,127 | 0 | 0 | 0 | 0 | |
| Stainless Steel Bathing Tub & Prima Recirculating Bathing System — depreciation | 369 | 369 | 369 | 369 | 369 | 369 | 369 | 475 | 475 | 475 | |
| Stainless Steel Bathing Tub & Prima Recirculating Bathing System — replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3,327 | 0 | 0 | |
| High-Velocity Dual-Motor Force Blower Dryer — depreciation | 228 | 228 | 228 | 228 | 264 | 264 | 264 | 264 | 305 | 305 | |
| High-Velocity Dual-Motor Force Blower Dryer — replacement | 0 | 0 | 0 | 0 | 1,057 | 0 | 0 | 0 | 1,222 | 0 | |
| 50-Gal Fresh & Grey Water Tanks, Pump & Electric Water Heater Setup — depreciation | 376 | 376 | 376 | 376 | 376 | 376 | 468 | 468 | 468 | 468 | |
| 50-Gal Fresh & Grey Water Tanks, Pump & Electric Water Heater Setup — replacement | 0 | 0 | 0 | 0 | 0 | 0 | 2,807 | 0 | 0 | 0 | |
| 3000W Pure Sine Wave Inverter + 400Ah LiFePO4 Battery Auxiliary Power System — depreciation | 322 | 322 | 322 | 322 | 322 | 387 | 387 | 387 | 387 | 387 | |
| 3000W Pure Sine Wave Inverter + 400Ah LiFePO4 Battery Auxiliary Power System — replacement | 0 | 0 | 0 | 0 | 0 | 1,934 | 0 | 0 | 0 | 0 | |
| Professional Clippers, Japanese Steel Shears, Blades & Hand Tool Kit — depreciation | 358 | 358 | 358 | 400 | 400 | 400 | 446 | 446 | 446 | 497 | |
| Professional Clippers, Japanese Steel Shears, Blades & Hand Tool Kit — replacement | 0 | 0 | 0 | 1,199 | 0 | 0 | 1,337 | 0 | 0 | 1,491 | |
| iPad, POS Card Reader, Peplink 5G Cellular Router & Mounting System — depreciation | 752 | 752 | 752 | 839 | 839 | 839 | 936 | 936 | 936 | 1,044 | |
| iPad, POS Card Reader, Peplink 5G Cellular Router & Mounting System — replacement | 0 | 0 | 0 | 2,517 | 0 | 0 | 2,807 | 0 | 0 | 3,131 | |
| City of Plano Permits, Commercial Vehicle Registration & Business Licensing — depreciation | 602 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| City of Plano Permits, Commercial Vehicle Registration & Business Licensing — replacement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pre-opening (5 years) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Weighted asset life (years) | 5 | ||||||||||
| Capitalised interest and loan fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Reserve-funded renewals (7-year life) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total depreciation | 17,052 | 16,450 | 16,450 | 16,578 | 16,613 | 18,290 | 19,973 | 20,080 | 20,121 | 20,280 | |
| Maintenance capex (replacements or reserve) | 0 | 0 | 0 | 3,716 | 1,057 | 50,470 | 51,335 | 3,327 | 1,222 | 4,621 |
Loan, tax, working capital and the three statements
USD · the balance sheet balances by construction (cash comes from the cash flow)
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||
| LOAN (monthly annuity after the interest-only months) | |||||||||||
| Interest-only months this year | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| First repayment month this year (of the amortising term) | 1 | 13 | 25 | 37 | 49 | 61 | 73 | 85 | 97 | 109 | |
| Last repayment month this year | 12 | 24 | 36 | 48 | 60 | 60 | 60 | 60 | 60 | 60 | |
| Interest | 4,996 | 4,063 | 3,042 | 1,925 | 704 | 0 | 0 | 0 | 0 | 0 | |
| Principal repaid | 9,950 | 10,883 | 11,904 | 13,021 | 14,242 | 0 | 0 | 0 | 0 | 0 | |
| Loan balance, end of year | 50,050 | 39,167 | 27,263 | 14,242 | (0) | (0) | (0) | (0) | (0) | (0) | |
| Debt service | 14,946 | 14,946 | 14,946 | 14,946 | 14,946 | 0 | 0 | 0 | 0 | 0 | |
| PROFIT AND LOSS | |||||||||||
| Revenue | 115,875 | 135,265 | 150,796 | 157,008 | 163,458 | 168,361 | 175,257 | 180,515 | 185,930 | 191,508 | |
| EBITDA | 33,769 | 37,035 | 45,957 | 47,980 | 50,076 | 50,946 | 53,157 | 54,070 | 54,985 | 55,902 | |
| Depreciation | 17,052 | 16,450 | 16,450 | 16,578 | 16,613 | 18,290 | 19,973 | 20,080 | 20,121 | 20,280 | |
| EBIT | 16,717 | 20,586 | 29,507 | 31,403 | 33,463 | 32,656 | 33,184 | 33,990 | 34,864 | 35,621 | |
| Interest | 4,996 | 4,063 | 3,042 | 1,925 | 704 | 0 | 0 | 0 | 0 | 0 | |
| Profit before tax | 11,721 | 16,523 | 26,465 | 29,477 | 32,759 | 32,656 | 33,184 | 33,990 | 34,864 | 35,621 | |
| Tax losses brought forward | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Tax losses carried forward | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Income tax | 2,461 | 3,470 | 5,558 | 6,190 | 6,879 | 6,858 | 6,969 | 7,138 | 7,321 | 7,480 | |
| Owners' book equity at the start of the year | 37,462 | 46,721 | 59,775 | 80,682 | 103,969 | 129,849 | 155,647 | 181,862 | 208,714 | 236,256 | |
| Zakat | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Tax and zakat | 2,461 | 3,470 | 5,558 | 6,190 | 6,879 | 6,858 | 6,969 | 7,138 | 7,321 | 7,480 | |
| Net income | 9,259 | 13,053 | 20,908 | 23,287 | 25,879 | 25,798 | 26,215 | 26,852 | 27,542 | 28,141 | |
| WORKING CAPITAL | |||||||||||
| Receivables | 317 | 371 | 413 | 430 | 448 | 461 | 480 | 495 | 509 | 525 | |
| Inventory | 827 | 966 | 1,077 | 1,121 | 1,167 | 1,202 | 1,251 | 1,289 | 1,327 | 1,367 | |
| Payables | 2,362 | 2,702 | 2,981 | 3,110 | 3,244 | 3,354 | 3,499 | 3,618 | 3,741 | 3,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 operations | 27,528 | 29,651 | 37,483 | 39,932 | 42,563 | 44,150 | 46,265 | 46,999 | 47,733 | 48,493 | |
| Maintenance capex | 0 | 0 | 0 | 3,716 | 1,057 | 50,470 | 51,335 | 3,327 | 1,222 | 4,621 | |
| Loan principal repaid | 9,950 | 10,883 | 11,904 | 13,021 | 14,242 | 0 | 0 | 0 | 0 | 0 | |
| Closing cash | 27,579 | 46,346 | 71,925 | 95,121 | 122,385 | 116,065 | 110,995 | 154,667 | 201,178 | 245,050 | |
| BALANCE SHEET (year end) | |||||||||||
| Fixed assets at cost | 87,462 | 87,462 | 87,462 | 91,178 | 92,235 | 142,705 | 194,040 | 197,367 | 198,589 | 203,210 | |
| Accumulated depreciation | 17,052 | 33,501 | 49,951 | 66,529 | 83,142 | 101,432 | 121,405 | 141,485 | 161,607 | 181,887 | |
| Cash | 27,579 | 46,346 | 71,925 | 95,121 | 122,385 | 116,065 | 110,995 | 154,667 | 201,178 | 245,050 | |
| Receivables + inventory | 1,145 | 1,336 | 1,490 | 1,551 | 1,615 | 1,663 | 1,731 | 1,783 | 1,837 | 1,892 | |
| Total assets | 99,134 | 101,643 | 110,926 | 121,321 | 133,093 | 159,001 | 185,361 | 212,332 | 239,998 | 268,266 | |
| Payables | 2,362 | 2,702 | 2,981 | 3,110 | 3,244 | 3,354 | 3,499 | 3,618 | 3,741 | 3,869 | |
| Loan | 50,050 | 39,167 | 27,263 | 14,242 | (0) | (0) | (0) | (0) | (0) | (0) | |
| Equity paid in | 37,462 | 37,462 | 37,462 | 37,462 | 37,462 | 37,462 | 37,462 | 37,462 | 37,462 | 37,462 | |
| Retained earnings | 9,259 | 22,313 | 43,220 | 66,507 | 92,387 | 118,185 | 144,400 | 171,252 | 198,794 | 226,935 | |
| Owners' book equity | 46,721 | 59,775 | 80,682 | 103,969 | 129,849 | 155,647 | 181,862 | 208,714 | 236,256 | 264,397 | |
| Total liabilities and equity | 99,134 | 101,643 | 110,926 | 121,321 | 133,093 | 159,001 | 185,361 | 212,332 | 239,998 | 268,266 | |
| CHECK: assets − liabilities − equity (must be 0) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| LENDER VIEW | |||||||||||
| Working-capital build covered by the opening reserve | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Opening reserve left | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | |
| Cash available for debt service (CFADS) | 32,525 | 33,714 | 40,525 | 38,141 | 42,211 | (6,320) | (5,070) | 43,672 | 46,511 | 43,872 | |
| DSCR | 2.18x | 2.26x | 2.71x | 2.55x | 2.82x |
Returns
USD · IRR on undiscounted flows, NPV at the Inputs rates; investment at t=0, year 1 at t=1
| t=0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |
| EBIT | 0 | 16,717 | 20,586 | 29,507 | 31,403 | 33,463 | 32,656 | 33,184 | 33,990 | 34,864 | 35,621 |
| Losses brought forward (unlevered) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Losses carried forward (unlevered) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Unlevered tax and zakat | 0 | 3,511 | 4,323 | 6,197 | 6,595 | 7,027 | 6,858 | 6,969 | 7,138 | 7,321 | 7,480 |
| Project cash flow (FCFF) | (97,462) | 31,475 | 32,860 | 39,886 | 37,737 | 42,063 | (6,320) | (5,070) | 43,672 | 46,511 | 43,872 |
| Exit value (final year) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 223,606 |
| Project cash flow with exit | (97,462) | 31,475 | 32,860 | 39,886 | 37,737 | 42,063 | (6,320) | (5,070) | 43,672 | 46,511 | 267,478 |
| Equity cash flow (FCFE, with exit net of the loan) | (37,462) | 17,579 | 18,768 | 25,579 | 23,195 | 27,264 | (6,320) | (5,070) | 43,672 | 46,511 | 267,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 value | 182,838 | ||||||||||
| Project IRR with exit value | 34.8% | ||||||||||
| Equity IRR (after financing, with exit) | 55.6% | ||||||||||
| Equity NPV at the cost of equity | 149,004 | ||||||||||
| Lowest DSCR over the loan | 2.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 workbook | Study engine | Difference | |
| Revenue, all years | 1,623,974 | 1,623,973 | 1 |
| EBITDA, all years | 483,877 | 483,877 | −0 |
| Depreciation, all years | 181,887 | 181,887 | 0 |
| Interest, all years | 14,730 | 14,730 | 0 |
| Tax, all years | 60,324 | 60,324 | 0 |
| Net income, all years | 226,935 | 226,934 | 1 |
| Closing cash, final year | 245,050 | 245,050 | 0 |
| Loan balance, final year | (0) | 0 | −0 |
| Project NPV (no sale) | 93,836 | 93,836 | 0 |
| Project IRR (no sale) | 29.88% | 29.88% | −0.00% |
| Project NPV with exit | 182,838 | 182,838 | −0 |
| Equity IRR | 55.60% | 55.60% | 0.00% |
| Equity NPV | 149,004 | 149,004 | −0 |
| Lowest DSCR | 2.18 | 2.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.
| Month | Revenue | EBITDA | Loan payments | Net cash flow | Cash balance |
| 1 | 0 | (1,801) | 1,246 | (2,945) | 7,055 |
| 2 | 0 | (1,801) | 1,246 | (2,945) | 4,109 |
| 3 | 0 | (6,093) | 1,246 | (7,237) | (3,128) |
| 4 | 2,575 | (3,909) | 1,246 | (5,053) | (8,181) |
| 5 | 5,150 | (1,724) | 1,246 | (2,868) | (11,049) |
| 6 | 7,725 | 460 | 1,246 | (684) | (11,733) |
| 7 | 10,300 | 2,645 | 1,246 | 1,501 | (10,232) |
| 8 | 12,875 | 4,829 | 1,246 | 3,685 | (6,547) |
| 9 | 15,450 | 7,014 | 1,246 | 5,870 | (677) |
| 10 | 18,025 | 9,198 | 1,246 | 8,054 | 7,378 |
| 11 | 20,600 | 11,383 | 1,246 | 10,239 | 17,617 |
| 12 | 23,175 | 13,568 | 1,246 | 9,962 | 27,579 |
| 13 | 11,272 | 3,086 | 1,246 | 1,853 | 29,432 |
| 14 | 11,272 | 3,086 | 1,246 | 1,853 | 31,285 |
| 15 | 11,272 | 3,086 | 1,246 | 1,853 | 33,138 |
| 16 | 11,272 | 3,086 | 1,246 | 1,853 | 34,991 |
| 17 | 11,272 | 3,086 | 1,246 | 1,853 | 36,844 |
| 18 | 11,272 | 3,086 | 1,246 | 1,853 | 38,698 |
| 19 | 11,272 | 3,086 | 1,246 | 1,853 | 40,551 |
| 20 | 11,272 | 3,086 | 1,246 | 1,853 | 42,404 |
| 21 | 11,272 | 3,086 | 1,246 | 1,853 | 44,257 |
| 22 | 11,272 | 3,086 | 1,246 | 1,853 | 46,110 |
| 23 | 11,272 | 3,086 | 1,246 | 1,853 | 47,963 |
| 24 | 11,272 | 3,086 | 1,246 | (1,617) | 46,346 |