A buyer proposes to acquire a 22-year-old independent bicycle, fitness and outdoor retailer with a service department together with the 4,375 SF building it occupies at the north end of Washington Street in Columbus, Indiana, financed with a single SBA 7(a) loan, in a change-of-ownership transaction that SOP 50 10 8.1 Appendix 15 classifies as an Initial Acquisition and tests on historical, not projected, debt service coverage. The seller's statements show pre-tax income of $45,640 on $1,720,000 of sales in fiscal 2025; normalized under Appendix 15 for depreciation, interest, the seller's $120,000 salary, the $54,000 rent paid to the seller's own real estate entity and a one-time cost, and reduced for a $75,000 buyer's salary and the $29,384 of tax, insurance and repairs the buyer will carry as owner of the building, the business produced $151,256 of cash flow available for debt service in fiscal 2025 and $132,796 in fiscal 2024, $142,026 on the two-year average. The proposal, a $1,189,092 loan at 9.25 percent over 25 years with a 10 percent cash injection, costs $122,198 a year and is covered at 1.24x on fiscal 2025, 1.09x on fiscal 2024 and 1.16x on the average, below the 1.25x the Appendix requires on either basis. Restructured with a $150,000 seller note on full standby for the term of the loan, the 7(a) loan falls to $1,035,463 and $106,410 a year, and the historical coverage is 1.42x on fiscal 2025, 1.25x on fiscal 2024 and 1.33x on the average. Determination: not feasible as proposed; feasible as restructured, conditioned on the seller's tax returns reconciling to the normalized statements, an appraisal of the building at or above the $720,000 allocated to it, the lender's confirmation of the standby note's treatment under SOP 50 10 8.1, a transition agreement with the seller, and verification of the inventory at closing.
Model study prepared by MMCG Invest | Michal Mohelsky, J.D., FMVA | October 3, 2026
Study at a Glance
| Item | Finding |
|---|---|
| Subject | Model acquisition of an independent bicycle, fitness equipment and outdoor retailer with a service department, in business since 2004, together with its 4,375 SF single-tenant retail and showroom building built in 1907 on 0.41 acres at the north end of Washington Street, Columbus, Bartholomew County, Indiana (the building is modeled on the published listing record of 1201 Washington Street) |
| Transaction | Initial Acquisition under SOP 50 10 8.1 Appendix 15: business assets of $450,000 (inventory $220,000 at cost, furniture, fixtures and equipment $40,000, goodwill $190,000) and real estate of $720,000, negotiated from a $799,000 asking price, plus $60,000 of working capital |
| Loan program | SBA 7(a), 75 percent guaranteed, 25-year maturity because real estate exceeds 51 percent of proceeds, 10 percent cash equity injection, borrower occupies 100 percent of the building |
| Total Subject Project Cost (restructured) | $1,317,181 |
| Historical cash flow available for debt service, normalized | Fiscal 2025 $151,256; fiscal 2024 $132,796; two-year average $142,026 |
| Appendix 15 test | 1.25x historical debt service coverage on the last fiscal year or the two-year average; projections not permitted because operations continue; Quality of Earnings report not required below a $3,000,000 purchase price |
| Debt service coverage (as proposed, $1,189,092 loan) | 1.24x fiscal 2025, 1.09x fiscal 2024, 1.16x average: fails on both bases |
| Debt service coverage (restructured, $1,035,463 loan plus $150,000 seller standby note) | 1.42x fiscal 2025, 1.25x fiscal 2024, 1.33x average: passes on both bases |
| Buyer's projections, for information only | 1.45x, 1.53x and 1.61x in Years 1 to 3 on the restructured loan |
| Real estate test | Imputed market rent of $56,875 on the building at $13 per SF is 3.3 percent of sales; the business pays a third party for the space with room to spare |
| Determination | Not feasible as proposed; feasible as restructured, conditioned on reconciliation of the seller's fiscal 2024 and 2025 federal tax returns to the normalized statements, an appraisal at or above $720,000, the lender's written confirmation of the standby note's treatment, a seller transition agreement, and a physical inventory at closing at or above $220,000 at cost |
Determination
MMCG concludes that the proposed acquisition of the business and its building is not feasible as proposed and is feasible as restructured. The proposal fails the historical test that governs it. Under SOP 50 10 8.1 Appendix 15, a change of ownership that continues the seller's operation is an Initial Acquisition, and an Initial Acquisition must show historical debt service coverage of at least 1.25x measured on the last fiscal year or on the average of the last two, with projections permitted only where the special-use property is fully secured or where there is no continuity of operations, neither of which applies to a going-concern retailer bought with its inventory, its staff and its customer list. The seller's fiscal 2025 statements, normalized for the items the Appendix allows and reduced for the costs the buyer will carry, produce $151,256 of cash flow available for debt service; fiscal 2024 produces $132,796 and the two-year average $142,026. The proposed structure, a $1,189,092 7(a) loan at 9.25 percent over 25 years funding the $450,000 business price, the $720,000 building, $60,000 of working capital, the $31,214 upfront guarantee fee and $60,000 of closing costs after a $132,121 cash injection, costs $122,198 a year. Coverage is 1.24x on fiscal 2025, 1.09x on fiscal 2024 and 1.16x on the average, and the lender cannot choose a basis on which it passes.
Restructured with a $150,000 seller note on full standby for the term of the 7(a) loan, with interest accruing and no payment until the SBA loan is repaid, the 7(a) loan falls to $1,035,463, the upfront fee to $27,181 and the annual debt service to $106,410. Historical coverage is 1.42x on fiscal 2025, 1.25x on fiscal 2024 and 1.33x on the average, and the test is met on either basis the lender elects. The buyer's cash injection of $131,718 remains 10 percent of the project and the study does not count the standby note toward it. The building is tested separately and passes: an imputed market rent of $13 per SF on 4,375 SF, $56,875 a year, is 3.3 percent of sales against a specialty retailer's typical occupancy cost of 6 to 10 percent, so the business could pay a third party for the space and the real estate is not carrying the credit. The buyer's own projections, which carry sales growth of 3 percent and a $75,000 salary, show 1.45x in Year 1 rising to 1.61x in Year 3 on the restructured loan; the Appendix does not permit them to govern and the study presents them for information. The determination is conditioned on the seller's fiscal 2024 and 2025 federal returns reconciling to the normalized statements, an appraisal of the building at or above the $720,000 allocated to it, the lender's written confirmation of the standby note's treatment under SOP 50 10 8.1, a transition agreement under which the seller remains for ninety days, and a physical inventory at closing at or above $220,000 at cost.
Scope and Basis of This Model Study
This is an MMCG model study: a complete feasibility analysis of a retail business acquisition with real estate under SOP 50 10 8.1 Appendix 15, prepared to show 7(a) lenders, buyers and sellers how MMCG normalizes a seller's history, applies the Appendix's historical test, tests the real estate on an imputed rent and restructures a transaction that fails by a narrow margin. It is not a client engagement. The building is modeled on the published listing record of 1201 Washington Street, a 4,375 SF 1907 single-tenant retail and showroom building on 0.41 acres offered at $799,000, and the business and its financial statements are MMCG model statements constructed to illustrate the normalization; MMCG has no relationship with the building's owner, any broker, any tenant or any buyer, and the analysis does not represent an offer, an appraisal, a valuation of any business or a recommendation to buy any building. Figures drawn from the U.S. Census Bureau, the Columbus Downtown 2030 Strategic Plan and its press coverage, the Bartholomew County Auditor's tax rate cards, the Indiana Department of Local Government Finance, the Bureau of Labor Statistics, HUD, Columbus City Utilities and the Code of Federal Regulations are identified as such. Figures labeled MMCG assumption, MMCG estimate or model statement are underwriting inputs set by MMCG, and items that could not be verified from a primary source at the study date are listed in the Conditions and Limitations section rather than estimated silently. In particular, the market rent for a single-tenant Washington Street building, a recorded 2024 to 2026 sale of a comparable building, the primary text of SOP 50 10 8.1 Appendix 15 and its treatment of seller standby debt, and the Bartholomew County commercial permit and transfer costs were not confirmed from primary sources at the study date and are carried as stated assumptions.
Project Business Plan
The buyer will acquire and continue the operation of an independent bicycle, fitness equipment and outdoor retailer that has traded from the same Washington Street building since 2004, keeping its name, its five employees, its supplier accounts with two bicycle manufacturers and a fitness equipment distributor, its service department and its customer list, and will acquire the building from the seller's real estate entity in the same closing. The physical program is the existing 4,375 SF single-story building: a 3,000 SF sales floor and showroom with the storefront on Washington Street, a 900 SF service department with four repair stands, a fitting area and parts storage, and 475 SF of office, receiving and restroom, on a 0.41-acre lot with parking for eleven cars and a rear service door. The business operates six days a week with the owner-operator, a service manager, two sales and service staff and two part-time seasonal staff, five full-time equivalents plus the owner. The buyer will hold the business and the building in one operating company, which satisfies the occupancy test at 100 percent and keeps the loan outside the Eligible Passive Company rules, and will provide the personal guarantee the program requires. The transition agreement keeps the seller in the store for ninety days after closing to transfer supplier relationships, the service book and the fleet and institutional accounts. The Project is positioned as the city's full-service bicycle and fitness retailer on the main street the Columbus Downtown 2030 plan wants activated, in a city whose People Trail network and architecture tourism support a cycling and outdoor trade, with the service department as the recurring and online-resistant revenue the lender underwrites.
Marketing and Sales Strategy
The buyer changes nothing in the first year except what the seller already planned: the service department's online booking, a fitting program for the city's road and gravel riders, a fleet maintenance account program for Cummins, the hospital and the school district's athletic departments, and a winter fitness equipment season that already carries the store's fourth quarter. The seller's email list and the store's standing in the regional cycling clubs transfer under the agreement. The buyer's own additions, an e-bike program with the manufacturers' demo fleet and a used-bike trade program, are in the projections and not in the historical test.
Amenities
- 3,000 SF sales floor and showroom with Washington Street storefront
- 900 SF service department with four repair stands and a fitting area
- Two bicycle manufacturer dealer agreements and a fitness equipment distributor account, transferred at closing
- Online service booking and a fleet maintenance account program
- Eleven-space parking lot and rear service door on 0.41 acres
- Seller's ninety-day transition under the purchase agreement
Site and Location Analysis
The subject building is modeled on the published listing record of 1201 Washington Street, a 4,375 SF single-tenant retail and showroom building built in 1907, classified by the listing platform as Class C, on 0.41 acres at the north end of Washington Street, offered at $799,000, or $182.63 per SF. The study allocates $720,000 to the real estate, a negotiated figure $79,000 below the asking price and $164.57 per SF, and conditions the determination on an appraisal at or above it, because no recorded 2024 to 2026 sale of a comparable Washington Street building was found and the asking price is the only price evidence. The building's age places it inside the Columbus Historic District's period but its individual contributing status was not verified; the buyer's transaction carries no rehabilitation and no historic credit.
Columbus is the seat of Bartholomew County, a city of 52,655 at the July 1, 2025 estimate and 50,474 at the 2020 Census, the headquarters of Cummins Inc., and a city whose Downtown 2030 Strategic Plan, presented July 21, 2025, found that average daily downtown visitors fell 22 percent and downtown employees fell 41 percent between 2019 and 2024 and set the activation of Washington Street as one of three primary objectives. The subject's trade is less exposed to that decline than a downtown restaurant's: a specialty bicycle and fitness retailer draws from the county and the region on destination trips, its service department draws its own repeat visits, and the city's People Trail network and its architecture tourism bring the cycling customer downtown. The study carries the plan's figures as the context for the sales history rather than as a demand driver, because under Appendix 15 the history, not the future, is the test.
Trade Area and Demand
The trade area for a specialty bicycle and fitness retailer is the county and the regional riding population rather than a ring. Bartholomew County's median gross rent of $958 and the city's of $1,157, HUD's fiscal 2026 Fair Market Rents of $1,257 for a one-bedroom and $1,415 for a two-bedroom, and the Columbus metropolitan area's mean hourly wage of $29.71 across all occupations in May 2025 against a national $33.54 describe a mid-income manufacturing city with a professional base at Cummins and the hospital, which is the specialty retailer's customer. The seller's statements are the demand evidence the Appendix recognizes: $1,640,000 of sales in fiscal 2024 and $1,720,000 in fiscal 2025, a 4.9 percent increase, at a 38.5 percent gross margin that reflects a mix of bicycles at the manufacturers' dealer margin, fitness equipment at a distributor margin, accessories and apparel at a higher margin and service labor at a very high one. The study tests the history for the items that would make it unrepresentative, a liquidation sale, a one-time institutional order, a change in the dealer agreements, and finds a $9,000 one-time legal cost in fiscal 2025 and nothing else; the manufacturers' dealer agreements are assignable with consent and the consent is a closing deliverable.
Competitive Supply
MMCG identified the specialty and mass-market supply for the subject's categories from the operators' pages and listings.
Competitor Number 1 Mass-market bicycle and fitness retail, Columbus and the regional centers The big-box sporting goods and general merchandise stores in Columbus and the Indianapolis metropolitan area 45 miles north carry entry-level bicycles and fitness equipment and set the price floor on the subject's lower-margin categories. The subject does not compete with them on entry price; it competes on brand, fit and service.
Competitor Number 2 Independent bicycle dealers, Indianapolis and Bloomington The nearest specialty competitors for the subject's manufacturer brands, 45 and 40 miles away, which capture the county's enthusiasts who shop in the larger market and which the subject's service department and fitting program are positioned to retain.
Competitor Number 3 Online bicycle, parts and fitness equipment sellers The structural competitor for parts, accessories and fitness equipment, against which the subject's service labor, fitting and warranty work are the online-resistant revenue. The Census Bureau's e-commerce share of retail sales reached 17.1 percent in the second quarter of 2026, and the subject's history already reflects it.
Competitor Number 4 Downtown Washington Street retail and service tenants The street's existing specialty tenants, which share the subject's foot traffic and the plan's activation program. A white-box storefront at 217 Washington Street asks $12 per SF, which with the subject's corner showroom frontage supports the $13 imputed rent the study carries.
No new specialty bicycle or fitness retailer was identified as announced or opened in Bartholomew County between 2024 and 2026.
The Appendix 15 Classification and Test
SOP 50 10 8.1, in force for loans numbered on or after October 1, 2026, governs change-of-ownership transactions in Appendix 15. The transaction is classified first. An Initial Acquisition is the purchase of a business by a buyer who does not already own it; a Business Expansion is the purchase of a business by an existing business in the same or a similar line; an Owner Buyout is the purchase of a partner's interest; and an ESOP or Cooperative transaction is its own category. The buyer here is an individual forming a new operating company to acquire the business, so the transaction is an Initial Acquisition. The test that follows is historical: debt service coverage of at least 1.25x on the proposed debt, measured on the last fiscal year or on a two-year average, using the seller's cash flow normalized for the items the Appendix allows. A Business Expansion would be tested at 1.15x; the subject is not one. Projections may replace history only where the special-use property is fully secured by collateral or where there is no continuity of operations and the loan is underwritten as a startup; a going concern bought with its inventory, staff, dealer agreements and customer list continues, and the history governs. A Quality of Earnings report is required when the business purchase price reaches $3,000,000; at $450,000 it is not, and the lender's own reconciliation of the statements to the tax returns is the verification. Advisory and agent fees may not be counted toward the equity injection; the buyer's injection is cash.
Normalization of the Seller's Cash Flow
The seller's fiscal 2024 and 2025 statements are model statements prepared for this study and reconcile to the model tax returns. The normalization adds back the non-cash and non-recurring items the Appendix allows, replaces the seller's compensation and the related-party rent with the buyer's actual costs, and arrives at the cash flow available for the proposed debt.
| Line | Fiscal 2024 | Fiscal 2025 |
|---|---|---|
| Sales | $1,640,000 | $1,720,000 |
| Cost of goods sold (61.5 percent) | $1,008,600 | $1,057,800 |
| Gross profit (38.5 percent) | $631,400 | $662,200 |
| Payroll and burden, excluding owner | $258,000 | $265,000 |
| Owner's salary | $120,000 | $120,000 |
| Rent paid to the seller's real estate entity | $54,000 | $54,000 |
| Utilities | $13,500 | $14,000 |
| Insurance | $10,500 | $11,000 |
| Marketing | $21,000 | $22,000 |
| Card fees (2.3 percent of sales) | $37,720 | $39,560 |
| Shop supplies and tools | $17,000 | $18,000 |
| Administrative and professional | $15,500 | $16,000 |
| Vehicle | $9,000 | $9,000 |
| Depreciation | $21,000 | $21,000 |
| Interest on seller's line of credit | $6,500 | $6,000 |
| Other operating | $12,000 | $12,000 |
| One-time legal cost | $0 | $9,000 |
| Total expenses | $595,720 | $616,560 |
| Pre-tax income as reported | $35,680 | $45,640 |
| Add back: depreciation | $21,000 | $21,000 |
| Add back: interest on debt retired at closing | $6,500 | $6,000 |
| Add back: owner's salary | $120,000 | $120,000 |
| Add back: rent paid to the seller's real estate entity, building acquired | $54,000 | $54,000 |
| Add back: one-time legal cost | $0 | $9,000 |
| Deduct: buyer's reasonable salary | ($75,000) | ($75,000) |
| Deduct: property tax, insurance and repairs the buyer carries as owner | ($29,384) | ($29,384) |
| Cash flow available for debt service, normalized | $132,796 | $151,256 |
| Two-year average | $142,026 |
The two judgments in the table are the buyer's salary and the building's carrying cost. The buyer's salary of $75,000 is set from the Columbus metropolitan area's May 2025 wage data for retail sales supervisors and small-business managers and from the buyer's own personal financial statement; the sensitivity table shows the test at $90,000. The building's carrying cost replaces the $54,000 related-party rent with the costs the buyer will actually bear as owner: property tax of $15,884 on an assessed value of $620,000 at the City of Columbus taxing district's pay-2026 rate of 2.5619 per $100, below the 3 percent nonresidential cap; insurance of $7,500; and repairs and reserves of $6,000. The vehicle expense is left in the statements because the buyer will carry one. No addback is taken for the seller's family on the payroll because none is on it.
The Real Estate Test
The lender underwrites the building as if a third party occupied it. The study carries an imputed market rent of $13 per SF on 4,375 SF, $56,875 a year, against the $12 ask for an 800 SF white-box suite at 217 Washington Street and the subject's larger, corner showroom frontage. At $56,875 the imputed rent is 3.3 percent of fiscal 2025 sales, against an occupancy cost of 6 to 10 percent of sales typical of specialty retail, so the business could pay a third party for the space with room to spare and the real estate is not the credit. The building's price of $720,000, $164.57 per SF, capitalizes the imputed rent at 7.9 percent before the owner's carrying costs, which is consistent with the market cap rate for retail of 7.4 percent and with a Class C single-tenant building in a secondary downtown. The appraisal is a condition because the asking price is the only comparable, and the study recommends that the lender obtain a going-concern allocation as well as a real estate value so that the $450,000 business price and the $720,000 building price are each supported.
Program Fit: 7(a) Rather Than 504
The transaction is a 7(a) loan rather than a 504 project because the business, its inventory and its working capital are 40 percent of the proceeds and a 504 debenture finances only the real estate and long-lived equipment. A single 7(a) loan funds the business assets, the building, the working capital, the guarantee fee and the closing costs; the SBA guarantee is 75 percent because the loan exceeds $150,000; the maturity is 25 years because real estate is more than 51 percent of proceeds, $720,000 of $1,317,181 or 54.7 percent; and the interest rate is carried at 9.25 percent, the Wall Street Journal prime rate of 7.00 percent effective September 17, 2026 plus 2.25 percent, inside the program's maximum spread for a loan of this size. The fiscal 2027 upfront guarantee fee for a loan between $700,001 and $5,000,000 is 3.5 percent of the guaranteed portion up to $1,000,000, $27,181 on the restructured loan's $776,597 guaranteed portion, financed in the loan, and the lender's annual service fee is 0.55 percent of the outstanding guaranteed balance. The borrower occupies 100 percent of the building and the occupancy test of 13 CFR 120.131(b) is met without an Eligible Passive Company; holding the business and the building in one entity avoids the EPC lease and rent cap rules, and the study notes that a buyer who prefers a separate real estate entity may use one with the Operating Company as co-borrower, because the loan includes working capital. The equity injection is 10 percent of the total project in cash, $131,718, from the buyer's verified liquid assets; the seller's standby note is not counted toward it.
The Seller Standby Note
The restructure's instrument is a $150,000 note from the buyer to the seller, subordinate to the SBA loan, on full standby for the term of the 7(a) loan: no principal or interest payments until the SBA loan is repaid in full, with interest accruing at a stated rate and the note documented on SBA's standby form. Because no payment is due during the term, the note's debt service is zero in the Appendix 15 test and the 7(a) loan it displaces is the saving: $153,629 less loan, $4,033 less upfront fee and $15,788 less annual debt service. The study does not count the note toward the buyer's injection and does not rely on any partial-standby treatment. The lender's written confirmation of the note's treatment under SOP 50 10 8.1, including the standby form, the accrual terms and whether any portion may be counted toward the injection, is a condition, and the seller's willingness to carry the note is the first commercial step.
Zoning, Transfer and Dealer Consent
The building is an existing retail use on Washington Street inside the city's downtown zoning, and the transaction carries no change of use, no construction and no permit beyond a zoning compliance letter at $10 under the City's planning fee schedule. The transfer items are commercial: the assignment of the two bicycle manufacturers' dealer agreements with the manufacturers' consent, the assignment of the fitness equipment distributor account, the transfer of the service department's warranty authorizations, the assignment of the store's domain, email list and online booking system, a non-compete from the seller, and the ninety-day transition agreement. Columbus City Utilities' commercial accounts transfer at closing with no system development charge because the service exists. The study carries a Phase I Environmental Site Assessment under ASTM E1527-21 in the closing cost because the building dates from 1907 and the lender's collateral is the real estate.
Utilities, Environmental and Property Tax
The building's utilities are the seller's history, $14,000 in fiscal 2025, carried forward. Property tax is carried at $15,884 on an assessed value of $620,000, an MMCG estimate of the assessor's market value-in-use after the sale, at the City of Columbus taxing district's pay-2026 rate of 2.5619 per $100, up from 2.5430 for pay 2025; the 3 percent cap on nonresidential property does not bind at that rate. Insurance is carried at $7,500 for the building and $11,000 for the business's liability, inventory and contents. The Phase I is in the closing cost, and the building's age places a lead paint and asbestos survey inside the lender's collateral review.
Trade Area Demographics
| Measure | Value |
|---|---|
| City of Columbus population, July 1, 2025 estimate | 52,655 |
| Population, 2020 Census | 50,474 |
| Mean hourly wage, all occupations, Columbus MSA, May 2025 | $29.71 (national $33.54) |
| Median gross rent, city (ACS 2020 to 2024) | $1,157 |
| Average daily downtown visitors, 2019 to 2024 | Down 22 percent (Downtown 2030 plan) |
| Downtown employees, 2019 to 2024 | Down 41 percent (Downtown 2030 plan) |
| E-commerce share of U.S. retail sales, Q2 2026 | 17.1 percent (Census) |
| Seller's sales, fiscal 2024 and 2025 (model statements) | $1,640,000 and $1,720,000 |
| Downtown white-box storefront asking rent | $12 per SF (217 Washington Street) |
| City of Columbus taxing district rate, pay 2026 | 2.5619 per $100 of assessed value |
Source: U.S. Census Bureau; Bureau of Labor Statistics; City of Columbus, Downtown 2030 Strategic Plan; Bartholomew County Auditor; LoopNet; MMCG model statements.
Under Appendix 15 the seller's two years of sales are the demand evidence, and the trade area figures are the context in which the lender reads them.
Project Cost Estimate
Location: Washington Street, Columbus, IN 47201 Size in SF (Gross): 4,375 (existing building)
| Item | Cost | Cost in % | Cost per SF |
|---|---|---|---|
| Real Estate | |||
| Building and Site Acquisition (4,375 SF, 0.41 acres, allocated from the combined price) | $720,000 | 54.7% | $164.57 |
| Closing, Title, Survey and Phase I ESA | $15,000 | 1.1% | $3.43 |
| Total Real Estate | $735,000 | 55.8% | $168.00 |
| Business Assets | |||
| Inventory at cost, verified at closing | $220,000 | 16.7% | $50.29 |
| Furniture, Fixtures, Equipment and Service Tools | $40,000 | 3.0% | $9.14 |
| Goodwill, Dealer Agreements, Customer List and Non-Compete | $190,000 | 14.4% | $43.43 |
| Total Business Assets | $450,000 | 34.2% | $102.86 |
| Working Capital and Financial Cost | |||
| Working Capital | $60,000 | 4.6% | $13.71 |
| SBA 7(a) Upfront Guarantee Fee (3.5% of the 75% guaranteed portion) | $27,181 | 2.1% | $6.21 |
| Legal, Business Valuation, Appraisal and Closing | $45,000 | 3.4% | $10.29 |
| Total Working Capital and Financial Cost | $132,181 | 10.0% | $30.21 |
| Total Subject Project Cost | $1,317,181 | 100.0% | $301.07 |
Source: MMCG
The project carries no construction and no reserve beyond working capital because the business continues without interruption and the Appendix's test is on history, not ramp. The business price of $450,000 is 2.97 times the seller's normalized cash flow before the buyer's salary and the building's carrying cost, and 0.26 times sales, inside the range at which independent specialty retailers trade; the lender's business valuation is a condition. The proposal is carried at $1,321,214 with a $31,214 upfront fee on a $1,189,092 loan and a $132,121 injection.
Loan Assumptions (restructured)
| Item | Value |
|---|---|
| Buyer's cash equity injection | $131,718 (10.0% of total project cost), from verified liquid assets |
| Seller note | $150,000, subordinate, full standby for the term of the 7(a) loan, interest accruing, no payments |
| SBA 7(a) loan | $1,035,463, 75 percent guaranteed ($776,597) |
| Interest rate | 9.25% (MMCG assumption: the Wall Street Journal prime rate of 7.00% effective September 17, 2026 plus 2.25%) |
| Maturity and amortization | 25 years, real estate more than 51 percent of proceeds |
| Annual debt service | $106,410 |
| As proposed, for comparison | $1,189,092 loan, no seller note, $122,198 a year |
SBA 7(a) Program Compliance
The transaction is an eligible change of ownership under 13 CFR 120.202, financing the purchase of a going concern and its real estate by a new owner who will operate it, with the borrower occupying 100 percent of the building under 120.131(b). The loan is within the $5,000,000 limit and the guaranteed portion within the $3,750,000 cap of 120.151. Under SOP 50 10 8.1 Appendix 15 the transaction is an Initial Acquisition tested at 1.25x historical debt service coverage on the last fiscal year or the two-year average, the test is met as restructured on both bases, projections are not used, no Quality of Earnings report is required below $3,000,000, and the equity injection is cash with no advisory or agent fee counted. The seller's standby note is documented on SBA's form and its treatment confirmed by the lender in writing. The fiscal 2027 upfront fee of 3.5 percent of the guaranteed portion and the 0.55 percent annual service fee are carried. The buyer's personal guarantee and the lender's collateral in the real estate, inventory, equipment and intangibles are carried. SBA may require a feasibility study under 120.160(b) and the lender has requested one because the buyer is new to ownership and the real estate is more than half the loan; the study's role in an Appendix 15 file is to normalize and explain the history, not to replace it.
The Buyer's Projections, for Information
The buyer's projections carry sales growth of 3 percent a year from the fiscal 2025 base, the fiscal 2025 cost structure with payroll escalating 3 percent, the buyer's $75,000 salary escalating 3 percent, and the owner's carrying cost of the building. They are presented because the lender's credit memorandum will include them and because they show the direction of the business under the buyer's plan; they do not govern the Appendix 15 test.
| Line | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Sales | $1,750,000 | $1,802,500 | $1,856,575 |
| Gross profit (38.5 percent) | $673,750 | $693,962 | $714,781 |
| Operating expenses including buyer's salary and building carrying cost | $519,584 | $531,230 | $543,225 |
| Cash flow available for debt service | $154,166 | $162,732 | $171,556 |
| Annual debt service (restructured) | $106,410 | $106,410 | $106,410 |
| Debt service coverage (restructured) | 1.45x | 1.53x | 1.61x |
| Debt service coverage (as proposed, $122,198 a year) | 1.26x | 1.33x | 1.40x |
Break-Even Analysis
At the fiscal 2025 cost structure the business's fixed operating cost, payroll, the buyer's salary, utilities, insurance, marketing, shop supplies, administrative, vehicle and other, together with the building's carrying cost, is $471,384, and its variable cost of goods and card fees is 63.8 percent of sales, so each dollar of sales contributes 36.2 cents. Thresholds are stated as a share of fiscal 2025 sales of $1,720,000.
| Threshold | Sales | Share of fiscal 2025 | Sales per SF |
|---|---|---|---|
| Cash flow break-even before debt | $1,302,166 | 75.7 percent | $298 |
| 1.00x debt service coverage, restructured | $1,596,116 | 92.8 percent | $365 |
| 1.25x debt service coverage, restructured | $1,669,605 | 97.1 percent | $382 |
| 1.00x debt service coverage, as proposed | $1,639,729 | 95.3 percent | $375 |
| 1.25x debt service coverage, as proposed | $1,724,122 | 100.2 percent | $394 |
| Fiscal 2025 actual | $1,720,000 | 100.0 percent | $393 |
The business covers its operating cost at 76 percent of its own sales and the restructured debt at 93 percent. The $150,000 standby note is worth about three points of break-even sales at each test, and as proposed the 1.25x threshold sits above the fiscal 2025 actual, which is the failure in one line. That is the shape of a sound Appendix 15 credit: the seller's history clears the proposed debt with a margin the buyer's first year of ownership can absorb, and the structure is sized to the history rather than to the buyer's plan.
Sensitivity Analysis
The sensitivity cases are run on the fiscal 2025 normalized cash flow, which is the basis the lender is most likely to elect, and are stated for both structures.
| Case (fiscal 2025 normalized) | Cash flow available for debt service | Coverage, restructured ($106,410) | Coverage, as proposed ($122,198) |
|---|---|---|---|
| Base case | $151,256 | 1.42x | 1.24x |
| Two-year average basis | $142,026 | 1.33x | 1.16x |
| Fiscal 2024 basis | $132,796 | 1.25x | 1.09x |
| Sales 10 percent below fiscal 2025 at the same cost structure | $88,992 | 0.84x | 0.73x |
| Gross margin 2 points below fiscal 2025 | $116,856 | 1.10x | 0.96x |
| Buyer's salary $90,000 rather than $75,000 | $136,256 | 1.28x | 1.12x |
| Interest rate 100 basis points higher | $151,256 | 1.31x | 1.14x |
| Buyer's Year 1 projection | $154,166 | 1.45x | 1.26x |
The restructured transaction passes the historical test on all three bases and holds above 1.25x with a $90,000 buyer's salary and a 100 basis point rate increase. A 10 percent sales decline at the fiscal 2025 cost structure falls to 0.84x, which is the risk of a specialty retailer's first year under new ownership and the reason the transition agreement and the dealer consents are conditions. As proposed, the transaction fails the test on every basis and holds above 1.0x only at the base, the average, the salary and the rate cases.
Risk Factors and Mitigants
- Historical test. The proposal fails Appendix 15 by one point on fiscal 2025 and by sixteen on fiscal 2024. The standby note cures it on both bases; the seller's willingness to carry $150,000 for 25 years with no payment is the commercial condition.
- Normalization. The $120,000 owner's salary and the $54,000 related-party rent are the addbacks that make the test; both must reconcile to the seller's returns and the real estate entity's lease, and the lender's reconciliation is a condition.
- Transition. A specialty retailer's customers and dealer agreements follow its owner. The ninety-day transition, the non-compete and the manufacturers' consents are the mitigants.
- Dealer agreements. Assignment requires the manufacturers' consent, and a withheld consent removes a brand from the sales floor. Consent before closing is a closing deliverable.
- Inventory. $220,000 at cost is 17 percent of the project; a physical count at closing with an adjustment mechanism is a condition.
- Real estate price. The only comparable is the asking price. The appraisal and the going-concern allocation are conditions.
- E-commerce. Parts and fitness equipment are exposed; service labor and fitting are not. The history already reflects the exposure and the buyer's plan adds service.
- Buyer's salary. The test moves 14 points between $75,000 and $90,000. The buyer's personal financial statement must show that $75,000 supports the household.
Conditions and Limitations
The determination of not feasible as proposed and feasible as restructured is subject to the following conditions precedent on the restructured transaction:
- Reconciliation of the seller's fiscal 2024 and 2025 federal income tax returns, the real estate entity's returns and the lease between them to the normalized statements, with the lender's written agreement to each addback and deduction.
- An appraisal of the building at or above the $720,000 allocated to it and a business valuation supporting the $450,000 allocated to the business assets, with the purchase agreement contingent on both.
- The lender's written confirmation of the $150,000 seller note's treatment under SOP 50 10 8.1 as full standby for the term, documented on SBA's standby form, with its accrual terms stated and its exclusion from the debt service test and from the equity injection confirmed.
- An executed transition agreement keeping the seller in the store for ninety days, an executed non-compete, and the manufacturers' and distributor's written consents to the assignment of the dealer and distribution agreements before closing.
- A physical inventory at closing at or above $220,000 at cost, with a purchase price adjustment for any shortfall.
The following items could not be verified from a primary source at the study date and are disclosed: the primary text of SOP 50 10 8.1 Appendix 15 on the coverage floors, the Quality of Earnings threshold and the treatment of seller standby debt, in place of which the study carries the figures as reported by SBA lenders and advisers and conditions the determination on the lender's confirmation; a recorded 2024 to 2026 sale of a comparable Washington Street building, in place of which the study carries the asking price and an imputed rent; a published market rent for a single-tenant Washington Street building, in place of which the study carries $13 per SF against a white-box ask of $12; the subject building's contributing status in the historic district; the Bartholomew County transfer and recording costs; and the detailed May 2025 Columbus wages for retail supervisors, in place of which the study carries the metropolitan area's all-occupations and food service means and the buyer's own statement.
What the Lender Received
- The written determination with the as-proposed and restructured transactions stated side by side and the five conditions precedent
- The Appendix 15 classification as an Initial Acquisition, the 1.25x historical test stated on both bases, and the reasons projections do not govern
- The normalization of the seller's fiscal 2024 and 2025 statements line by line, with each addback and deduction stated and the buyer's salary and the building's carrying cost reasoned
- The real estate test on an imputed market rent, the implied capitalization rate and the recommendation for a going-concern allocation
- The program fit analysis: 7(a) rather than 504, the 25-year maturity, the guarantee, the fiscal 2027 fee and the single-entity occupancy
- The seller standby note analysis with its effect on the loan, the fee and the test
- The trade area and competitive context, with the plan's downtown figures and the e-commerce exposure by category
- The project cost estimate and loan assumptions in MMCG's standard format for both structures
- The buyer's projections for information, labeled as not governing
- The break-even analysis at each test for both structures
- The sensitivity cases on the fiscal 2025 basis, including the two-year average and fiscal 2024 bases, the salary case and the sales decline
- The 7(a) compliance notes: eligibility, occupancy, loan and guarantee limits, Appendix 15, injection, standby documentation, fees and the feasibility study trigger
This model study applies the methodology described on MMCG's SBA retail feasibility study and retail feasibility study pages. MMCG prepares retail business acquisition feasibility studies for SBA 7(a) and 504 lenders nationwide, with engagements from $4,900 and delivery in 9 to 16 business days.
Sources
- Electronic Code of Federal Regulations, 13 CFR 120.110, 120.111, 120.131, 120.151, 120.160 and 120.202
- U.S. Small Business Administration, SOP 50 10 8.1 with Technical Updates, effective October 1, 2026, Appendix 15, and Information Notice 5000-881797 on fiscal year 2027 7(a) program fees; SBA Form 155, Standby Creditor's Agreement
- U.S. Census Bureau, QuickFacts, Columbus city and Bartholomew County, Indiana, Population Estimates V2025 and ACS 2020 to 2024; Quarterly Retail E-Commerce Sales, 2nd Quarter 2026, August 18, 2026
- City of Columbus, Indiana, Columbus Downtown 2030 Strategic Plan (Sasaki, SB Friedman, Storyboard), presented July 21, 2025; The Republic, July 23, 2025; City of Columbus Planning, Schedule of Application Fees
- Bartholomew County Auditor, 2025 pay 2026 and 2024 pay 2025 tax rate cards; Indiana Department of Local Government Finance, Property Tax Caps / Circuit Breaker Credits fact sheet, April 2024
- Bureau of Labor Statistics, Occupational Employment and Wages in Columbus, IN, May 2025, released July 9, 2026
- U.S. Department of Housing and Urban Development, FY2026 Fair Market Rent Schedule; STATS Indiana, Bartholomew County InDepth Profile
- Cityfeet, 1201 Washington Street, Columbus, IN; LoopNet, 217 Washington Street, Columbus, IN; accessed October 3, 2026
- Columbus City Utilities, commercial service and connection fee pages
- CoStar, United States Retail National Report, October 3, 2026 (market cap rate)
- Wall Street Journal, U.S. prime rate, effective September 17, 2026
- ASTM International, E1527-21
- MMCG model financial statements for the subject business, fiscal 2024 and 2025, prepared for this study
