Below is an overview of the primary SBA loan programs, how different businesses or startups might use them, where overlaps might occur, and the potential risks to keep in mind.
SmartHelping / Business + Real Estate / Excel
Underwrite an acquisition that combines an operating business with its real estate. Build a streamlined 10-year forecast for revenue, expenses and NOI, layer in SBA or conventional financing, test a future refinance and allocate returns through a flexible preferred-return waterfall.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through how the operating business, property, debt, reserve and partnership assumptions connect to the 10-year forecast and investor outputs.
What the model includes
Use a concise assumptions framework to forecast combined NOI, structure separate business and property financing, solve for reserves and evaluate LP/GP returns.
Enter the key acquisition, operating, financing and exit assumptions without navigating an unnecessarily complex workbook structure.
Build gross revenue, salaries and wages, and other operating expenses into a connected annual NOI forecast for the combined acquisition.
Enter annual expenses directly or use an expense ratio to drive the operating-cost forecast as revenue changes over time.
Use SBA 504 financing for the real estate portion and SBA 7(a) financing for the operating-business portion of the transaction.
Switch off the SBA 504 structure when an assumed or standard real estate loan is more appropriate, then consolidate eligible debt in a future refinance.
Review a consolidated sources-and-uses summary and solve for the reserve needed to support the forecast and transaction structure.
Set preferred-return tiers, hurdles and distribution terms to reflect the economics agreed between the limited and general partners.
Evaluate LP and GP IRR, equity multiple, discounted cash flow and DSCR, supported by eight visualizations and a consolidated dashboard in a fully unlocked Excel file.
Flexible debt and refinance logic
The model separates the operating-business purchase from the real estate purchase, while keeping the debt service, reserve needs and future refinance connected to the same forecast.
Structure the real estate portion using SBA 504 financing assumptions and calculate the resulting debt service within the acquisition forecast.
Finance the operating-business portion separately with SBA 7(a) assumptions so the property and business purchase prices remain distinct.
Turn off the SBA 504 option and use an assumed or conventional real estate loan when that structure better reflects the transaction.
Test a later refinancing event and roll the applicable existing debt balances into the new facility to see the impact on cash flow and returns.
How to use it
Enter the business and property purchase values, revenue drivers, salaries and wages, other costs, growth assumptions and exit timing.
Project annual operating expenses directly or use an expense ratio so costs move with revenue across the 10-year forecast.
Configure SBA or alternative loans, define a potential future refinance, review sources and uses, and solve for the required reserve.
Set the preferred-return waterfall and review LP/GP IRR, equity multiple, DCF, DSCR and the consolidated dashboard as assumptions change.
Who gets value from it
Evaluate an operating-business purchase together with the property needed to run it, rather than treating the two assets in isolation.
Model businesses such as assisted living facilities where operating performance and real estate financing are closely connected.
Review the project economics, capital structure and LP/GP outcomes under a configurable preferred-return waterfall.
Use a fully editable framework to test debt service, reserve needs, coverage and returns as acquisition assumptions change.
Also available in these bundles
The Business + Real Estate JV Model is also included in the Real Estate, Joint Venture and Super Smart bundles.
Explore acquisition, development, operating and investor-return models across multiple real estate strategies.
View Real Estate BundleCompare preferred returns, IRR hurdles and partnership distribution structures across a broader set of JV models.
View Joint Venture BundleGet the complete SmartHelping template collection for real estate, operating forecasts, valuation, finance and more.
View Super Smart BundleRelated real estate models
Underwrite hotel operations, financing, value creation and investment returns.
Explore the hotel modelPlan repeated property acquisitions, renovations, sales and business growth.
Explore the fix-and-flip modelUnderwrite historical operations, rent roll assumptions, value-add plans, financing and partnership returns.
Explore the detailed multifamily modelCompare a sale-leaseback structure with alternative ownership and financing scenarios.
Explore the sale-leaseback modelForecast the construction, financing and operating economics of a retail property.
Explore the retail construction modelModel land development, lot release timing, costs, sales and project returns.
Explore the lot-development modelUnderwrite tenant revenue, operating costs, financing and returns for a strip center.
Explore the strip-mall modelEvaluate apartment-building acquisition assumptions, operations, debt and investment performance.
Explore the apartment modelModel lease income, expenses, financing and exit returns for a single-tenant asset.
Explore the industrial modelForecast lot rent, occupancy, operating costs, financing and investor returns.
Explore the mobile-home-park modelCombine multiple property uses in one leveraged acquisition and operating forecast.
Explore the mixed-use modelCompare and consolidate the economics of as many as six self-storage investments.
Explore the self-storage modelPlan the acquisition, operation and financing of a growing rental-property portfolio.
Explore the rental-scaling modelForecast development costs, unit sales, financing and returns for a condo project.
Explore the condo modelModel nightly rates, occupancy, operating costs and returns across an STR portfolio.
Explore the STR modelBuild a 10-year acquisition forecast using units, rent, occupancy and operating assumptions.
Explore the unit-based modelConnect resident capacity, occupancy, staffing and operating costs to long-term returns.
Explore the assisted-living modelEvaluate leased-unit economics, occupancy, rates, operating costs and expansion.
Explore the rental-arbitrage modelForecast hotel development or purchase assumptions, operations, financing and exit value.
Explore the hotel modelTest how occupancy and other assumptions affect property-level investment returns.
Explore the sensitivity modelUse a streamlined annual-only structure for a multifamily acquisition.
Explore the annual multifamily modelEstimate purchase, renovation, holding and sale economics for an individual flip.
Explore the flipping calculatorForecast managed units, fee revenue, staffing, overhead and business cash flow.
Explore the property-management modelModel transaction volume, commissions, agent splits, operating costs and profitability.
Explore the brokerage modelTrack development budgets, actual spending, timing and remaining project costs.
Explore the development modelOrganize real estate diligence and project tasks in a structured template.
Explore the real estate checklistEstimate cash flow and investment return for a rental-property opportunity.
Explore the rental ROI calculatorRelated capital-structure tools
Model seller-financed purchase terms, payments, balances and investment outcomes.
Explore the seller-financing modelDistribute cash across three LP return hurdles and changing LP/GP splits.
Explore the IRR waterfallAdd a GP catch-up mechanism to a three-hurdle partnership distribution structure.
Explore the catch-up waterfallModel a senior preferred-equity leg, repayment priority and subordinate equity returns.
Explore the preferred-equity modelModel preferred returns, return of capital and residual partnership distributions.
Explore the preferred-return modelEvaluate a real estate purchase funded through seller-financing structures with no initial equity.
Explore the zero-down modelEstimate asset reclassification, accelerated depreciation and potential tax-timing effects.
Explore the cost-segregation modelQuestions before you buy
It is designed for transactions that combine an operating business with its real estate, such as the acquisition of an assisted living facility or another property-dependent company.
The model supports SBA 504 financing for the real estate portion and SBA 7(a) financing for the operating-business portion. The SBA 504 structure can also be replaced with an assumed or standard real estate loan.
Yes. You can forecast operating expenses from an expense ratio or enter annual expense assumptions directly, depending on the level of detail available for the deal.
Yes. The refinance option can replace the applicable existing debt balances with a new facility so you can see how the transaction affects cash flow, coverage and investor returns.
The model includes a flexible preferred-return waterfall with configurable tiers and hurdles, plus LP and GP IRR, equity multiple, discounted cash flow and DSCR outputs.
Yes. The Excel file is fully unlocked and editable. It is also included in the Real Estate, Joint Venture and Super Smart bundles linked above.
Underwrite the business, property and partnership together
Connect operating performance, real estate, SBA or alternative financing, reserves, refinancing and LP/GP returns in one 10-year Excel model. One-time purchase for $75.
SmartHelping / Cap Table / Excel
See how a convertible note and a new equity round change company ownership. Model the note's valuation cap, discount and accrued interest, compare pre- and post-money capitalization, and quantify dilution before negotiating financing terms.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
See how the note terms, next financing round and stakeholder inputs flow through conversion pricing, share counts and ownership percentages.
What the model includes
Start with the existing shareholders, enter the convertible note and next-round assumptions, and see the resulting conversion price, share issuance and post-financing capitalization.
Track stakeholder shares, ownership percentages and the change in capitalization before and after the financing transaction.
Build the starting capitalization across founders, employees, early investors or other shareholder groups using the ownership structure that fits the company.
Enter principal, interest, time outstanding, valuation cap and discount assumptions to calculate the amount and price used at conversion.
Enter the next round's pre-money valuation and new capital raised to see how the new investors and converted note affect total shares.
Calculate the conversion price under both methods and identify the note-holder-favorable result used to determine the converted shares.
Account for the note's annual interest rate and time outstanding so accrued interest is reflected in the ownership issued at conversion.
Use two built-in sensitivity tables to compare ownership outcomes as important note and financing-round variables change.
Use the ownership chart to communicate the shift in stakeholder percentages. The Excel workbook is fully editable, unlocked and uses yellow input cells with blue text.
Convertible note mechanics
The model turns the note and next-round assumptions into a transparent share-price comparison, converted share count and fully updated capitalization table.
Combine invested principal with accrued interest based on the annual rate and the amount of time the note has been outstanding.
Use the assumed pre-money valuation and existing fully diluted shares to establish the price paid by the new equity investors.
Compare the valuation-cap price with the discounted next-round price and apply the more favorable conversion price for the note holder.
Add the note-holder and new-investor shares to the existing capitalization, then calculate the resulting ownership and dilution for every stakeholder group.
How to use it
Define the initial stakeholder groups, existing share counts and current ownership before the note conversion or new financing round.
Enter the principal, annual interest rate, time outstanding, valuation cap and conversion discount.
Set the pre-money valuation and new investment amount to calculate the next-round price and resulting share issuance.
Compare the pre- and post-money cap tables, ownership chart and two sensitivity tables before finalizing the financing assumptions.
Who gets value from it
See how convertible-note and new-round terms affect founder ownership before entering a financing negotiation.
Understand how the valuation cap, discount and accrued interest determine conversion price and final ownership.
Build a transparent capitalization analysis that can be reviewed, adjusted and explained to decision-makers.
Evaluate the post-money ownership structure and the dilution created by both the note conversion and new equity issuance.
Also available in these bundles
The Cap Table + Convertible Note Model is also included in the Super Smart, Sensitivity Tables, Valuation Models and Accounting Tools bundles.
Get the complete SmartHelping template collection for forecasting, valuation, accounting, financing, real estate and more.
View Super Smart BundleExplore models built to show how key assumptions change ownership, returns, valuation and operating outcomes.
View Sensitivity Tables BundleCompare capitalization, company value and investment economics with a broader set of valuation tools.
View Valuation Models BundleAccess accounting-focused templates for ownership, costing, reporting, schedules and financial analysis.
View Accounting Tools BundleRelated financial models
Explore templates built to compare alternative operating, financing and investment cases.
Browse scenario modelsModel a distressed-business acquisition, operating recovery, financing and investor returns.
Explore the turnaround modelAllocate manufacturing overhead through a connected production and inventory framework.
Explore the absorption-costing modelBuild a flexible debt schedule for startup modeling and changing repayment assumptions.
Explore the loan scheduleCompare quantitative valuation methods and assess a range of potential company values.
Explore the valuation modelEstimate asset reclassification, accelerated depreciation and potential tax-timing effects.
Explore the cost-segregation modelCalculate the sales volume or revenue required to cover fixed and variable costs.
Explore the break-even modelTurn financial and operating assumptions into presentation-ready charts for a pitch deck.
Explore the visualization modelQuestions before you buy
You can model a convertible note, a new priced equity round, or both together to see the effect on stakeholder ownership and company capitalization.
The starting cap table supports as many as five stakeholder groups, allowing you to represent founders, employees, early investors or other existing holders.
The model includes principal, annual interest, time outstanding, valuation cap and discount assumptions, along with the resulting conversion price and converted shares.
It compares the share price implied by the valuation cap with the discounted next-round share price and uses the note-holder-favorable result.
You receive detailed pre- and post-money cap tables, two dilution sensitivity tables and a chart comparing the ownership structure before and after the financing or note conversion.
Yes. The Excel workbook is fully unlocked and editable, with input cells highlighted in yellow and blue text. It is also included in the Super Smart, Sensitivity Tables, Valuation Models and Accounting Tools bundles.
See the dilution before signing the term sheet
Connect the existing cap table, convertible note terms and next equity round in one editable Excel model. One-time purchase for $45.
Calculating a Weighted Average Cost of Capital (WACC) for a real estate acquisition that includes debt, preferred equity, and common equity follows the same general principles as a corporate WACC calculation—just with an additional layer to account for the preferred equity’s cost and weighting. Below is a step-by-step outline of how to approach it.
Variable costs are expenses that change in direct proportion to a company’s level of production or sales volume. Unlike fixed costs (such as rent or a monthly lease payment), variable costs rise as production or sales increase and fall as production or sales decrease. Because of this direct correlation, variable costs are typically expressed on a per-unit or percentage-of-sales basis in financial models.
Below is a high-level example business plan for an electric vehicle (EV) charging station company looking to scale profitably. The plan includes key sections such as market analysis, business model, marketing strategy, operations plan, financials with assumptions, and exit strategies. While this outline doesn’t include exhaustive detail, it provides a useful framework and practical considerations.
Below is a simplified example of a SaaS-based business plan for a fictional company we’ll call TaskFlow, which offers cloud-based project management and collaboration software to small and medium-sized businesses. The plan includes typical assumptions about user growth, revenue streams, churn, operating expenses, and funding. These figures are illustrative and meant to provide a framework for how a pro forma might look in the early years of the company’s life cycle.
Below is an example business plan outline for a cleaning services company that seeks to acquire recurring revenue contracts and scale to profitability. The plan highlights key assumptions, estimated financials, and a possible exit strategy. All figures are illustrative and can be adjusted based on your specific market and growth goals.
Below is an example of a concise, structured business plan for a startup plumbing company. The plan includes a realistic set of assumptions and outlines a path to scale profitably. Adjust any details to fit your specific market conditions and personal expertise.
SmartHelping / Fitness + Franchise Scaling / Excel
Plan the rollout of one to many fitness studios or franchise locations over as many as 15 years. Connect location-level capacity and revenue ramps to opening schedules, startup costs, capex, leverage, three financial statements and investor returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through how average-studio economics, deployment tranches, capex timing, operating costs and debt flow into the monthly forecast, statements and investor results.
What the model includes
Define the economics of the average studio, schedule new openings in deployment tranches, time the initial costs and financing, and see the consolidated financial and investor impact.
Toggle the visible forecast period to match the rollout plan, with a maximum projection horizon of 15 years.
Schedule an unlimited number of studios or stores across defined rollout groups while keeping each opening tied to the consolidated forecast.
Define maximum members or customers, the ramp to capacity, as many as three pricing tiers, annual price growth, other income and associated margins.
Set the lease-signing month, number of locations signed and the average delay between signing and opening for every rollout tranche.
Define three primary capex categories, two non-capex categories and the payment pattern relative to each lease-signing month.
Finance eligible costs using loan-to-cost assumptions, interest-only periods and conversion to amortizing debt under two flexible leverage structures.
Model costs beginning at lease signing or opening, member-level expenses, tenure-based cost changes, revenue-based fees and detailed FTE schedules.
Follow the Income Statement, Balance Sheet and Cash Flow Statement with cash, depreciation, accounting-equation checks and visible cash-flow activity.
Enter investments and distributions below project cash flow, automatically distribute remaining exit cash, and review DCF, IRR and equity multiple.
Review debt-service coverage and operating KPIs such as average gross profit per studio per month and year in a fully editable Excel workbook.
Expansion and leverage mechanics
Each studio tranche carries its own timing, cost and financing logic, while the model consolidates every opening into one cash plan and set of financial statements.
Define when each capex and non-capex item is paid relative to lease signing, then apply that pattern automatically to every deployment tranche.
Use a loan-to-cost draw structure with interest-only payments, convert the first facility to amortizing debt, and fund later openings through a second facility with its own refinance event.
Alternatively, create a separate loan calculation for each rollout tranche, including its own interest-only period and conversion to amortization.
Set a capex reserve percentage for future equipment renewal and, when terminal value is displayed, repay the remaining loan balance at exit.
How to use it
Enter capacity, the member or customer ramp, pricing tiers, other revenue, direct costs and location-level margins.
Set each lease-signing month, the count of locations signed and the delay from signing to opening across as many as 36 tranches.
Define capex and startup-cost timing, debt assumptions, corporate overhead, direct operating costs and FTE hiring.
Use the cash plan, three statements, DSCR, DCF, IRR, equity multiple and 18 visualizations to stress-test the expansion strategy.
Who gets value from it
Translate member capacity, pricing and location-level costs into a long-range opening and funding plan.
Adapt the customer-capacity framework to stores, service locations or other repeatable brick-and-mortar concepts.
Coordinate lease timing, startup spending, debt draws, staffing and corporate overhead across a consolidated forecast.
Evaluate capital requirements, coverage, financial statements and returns as the rollout pace or unit economics change.
Also available in these bundles
The Fitness Studio Scaling Model is also included in the Retail Trade, SaaS / Subscription, Capacity-Constrained, Industry-Specific and Super Smart bundles.
Explore store, franchise and retail operating models built around customers, locations, inventory and expansion.
View Retail Trade BundleCompare recurring-revenue models with membership, customer-ramp, retention and subscription economics.
View SaaS / Subscription BundleExplore models where physical capacity, utilization and expansion timing drive revenue and capital needs.
View Capacity ModelsAccess detailed operating models designed around the economics of specific business types and sectors.
View Industry-Specific BundleGet the complete SmartHelping template collection for forecasting, valuation, accounting, financing, real estate and more.
View Super Smart BundleRelated financial models
Plan a repeatable rollout of compact coworking locations with capacity, opening and operating assumptions.
Explore the coworking-pod modelForecast a mobile or on-demand cleaning operation with customer demand, crews, costs and startup funding.
Explore the on-demand service modelModel transaction growth, credit performance, financing needs and profitability for a BNPL startup.
Explore the BNPL modelBuild a franchise expansion forecast around new locations, fees, operating costs and growth.
Explore the franchise modelPlan the deployment, utilization, capital spending and financing of an expanding charging network.
Explore the EV charging modelForecast the opening and operation of a growing retail footprint with up to 25 locations.
Explore the retail-scaling modelModel machine deployment, unit economics, restocking costs and portfolio expansion over time.
Explore the vending modelBuild a focused forecast for one gym or fitness center using membership and operating assumptions.
Explore the fitness-center modelForecast enrollment, class capacity, pricing, instructors and operating performance.
Explore the courses modelEvaluate retail construction, tenant economics, financing and investment returns.
Explore the retail construction modelQuestions before you buy
Yes. The structure can be adapted to many retail, franchise or service-location concepts by treating maximum members as customer capacity and membership pricing as average monthly customer spending.
The forecast can display from 1 to 180 months and supports an unlimited number of locations organized into as many as 36 deployment tranches.
Define capacity, the ramp to capacity over each studio's tenure, as many as three member-pricing tiers, annual price increases, other income per member and the associated margin.
The model supports detailed capex and non-capex startup costs, payment timing relative to lease signing, loan-to-cost assumptions, two master credit facilities and separate term loans by tranche.
You receive connected monthly and annual Income Statements, Balance Sheets and Cash Flow Statements, plus DCF, IRR, equity multiple, DSCR, investor summaries and 18 visualizations.
Yes. The Excel workbook is fully unlocked and editable, with yellow input cells and blue text. It is also included in the Retail Trade, SaaS / Subscription, Capacity-Constrained, Industry-Specific and Super Smart bundles.
Turn a rollout concept into a financeable plan
Connect location economics, opening schedules, capital spending, leverage, operating costs, financial statements and investor returns in one editable Excel model. One-time purchase for $45.