Revenue & Calc
Set agent relationships, listing frequency, capture rate, package mix, prices, and seasonality to forecast booked orders and revenue.

The Real Estate Photography Financial Model is an Excel template projecting listing-media sales from agent demand, bookings, package prices, and seasonality. Its operating inputs connect to delivery costs, staffing, EBITDA, and financial planning reports.
The illustrated 2026–2030 business serves residential sale and rental listings in Raleigh and North Carolina’s Triangle. One salaried photographer, a part-time coordinator, and per-order remote editing support five mutually exclusive photography packages.
The workbook connects monthly listing demand with package sales, expense schedules, financial statements, and decision reports.
Set agent relationships, listing frequency, capture rate, package mix, prices, and seasonality to forecast booked orders and revenue.
Plan editing, delivery, mileage, payment fees, promotions, overhead, and salaried staffing without duplicate costs.
Separate opening equipment and setup spending, owner equity, optional borrowing, and cash uses.
Review monthly Income Statement, Cash Flow Statement, Balance Sheet, and combined Summary reports.
Examine Dashboard scenarios, Returns, Valuation, benchmarks, expense mix, and model reconciliations.
Revenue starts with agent-generated listing opportunities, converts them into booked orders, and allocates each order to exactly one priced media package.
In 2026, 40 agent relationships each yield an estimated 0.75 eligible listings monthly. An 80% capture rate produces 24 baseline monthly bookings before seasonality; active relationships increase to 80 by 2030.
Each listing buys one complete package. Included floorplan, drone, and video features are never charged again as separate services.
| Package | Price / order | Order mix |
|---|---|---|
| Photos Only | $200 | 30% |
| Photos and Floorplan | $275 | 25% |
| Photos and Drone | $325 | 20% |
| Photos and Video | $475 | 15% |
| Full Marketing Package | $650 | 10% |
Prices and package allocations are editable planning estimates, not observed local market averages.
The Revenue Forecast organizes agent volume, booking conversion, complete-package prices, mix, and launch timing. Calc applies repeating monthly seasonality and consolidates package orders and revenue for reporting.
24 baseline monthly orders × $330 weighted package price × 12 seasonal-equivalent months = $95,040 annual revenue.
The selected mix yields a $330 weighted order price. January and December demand is 65% of baseline; May and June reach 130%. The twelve seasonal multipliers sum to 12.
The cost build separates order-linked delivery expense, revenue-based selling expense, fixed overhead, and salaried staff so each cost appears once.
The COGS and Operating Expenses forecast applies 18% of revenue to editing, 3% to media delivery, and 6% to mileage. Additional variable rates are 3.1% for processing and 5% for agent promotions.
Direct costs total 27% of revenue; variable operating expenses total 8.1%. Annual fixed costs of $11,400 cover home workspace, software, insurance, communications, professional services, maintenance, and compliance.
Remote editors are vendors paid per completed order, not payroll employees. This example excludes prints, physical staging, commercial photography, additional shooters, studio rent, and brokerage revenue.
The Payroll Forecast includes one owner-photographer FTE at $58,000 annually. Coordinator staffing increases from 0.25 FTE in 2026 to 0.5 FTE in 2030 at $40,000 per full-time role, lifting total base payroll from $68,000 to $78,000.
Opening equipment, prelaunch cash spending, and equity funding are planned separately from recurring expenses and the operating EBITDA forecast.
Opening purchases include $6,000 for camera bodies and lenses, $1,800 for lighting and supports, $1,800 for drone equipment, and $2,500 for a workstation. Backup storage, field supplies, registrations, the website, and preopening work are separately identified.
The existing personal car requires no purchase, borrowing, or depreciation in this example; incremental mileage and insurance remain operating costs.
The Sources and Uses of Funds report compares funding with operating, investing, and financing cash uses. Illustrated initial owner funding is $43,390, intended for setup and three months of first-year recurring outflows, without committed external financing.
Receivable, payable, and inventory days are all zero. Customers pay before file delivery; CapTable, CAPEX, and Debt schedules separately support changes to equity, equipment purchases, and financing.
The selected 2026–2030 case increases agent relationships while holding the documented pricing and cost-rate assumptions, producing the following projected annual operating results.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $95,040 | $112,759 | -$17,719 |
| 2027 | $118,800 | $123,099 | -$4,299 |
| 2028 | $142,560 | $133,439 | $9,121 |
| 2029 | $166,320 | $143,778 | $22,542 |
| 2030 | $190,080 | $156,118 | $33,962 |
Illustrative planning estimates, rounded to whole dollars. Operating expenses include direct costs, variable and fixed expenses, and base payroll.
EBITDA is negative in 2026 and 2027, becomes positive in 2028, and reaches $33,962 in 2030. The estimated agent pool expands faster than fixed overhead and salaried coordinator coverage.
EBITDA deducts modeled operating costs but is not net profit, cash, or investment return. Further statement calculations depend on depreciation, tax, financing, and other workbook assumptions.
The Projected Income Statement presents monthly revenue, direct and operating costs, EBITDA, depreciation, interest, tax, and accounting profit. It distinguishes the supplied EBITDA figures from net-profit calculations not reported for this case.
Although customers prepay, cash planning still depends on payment timing, capital purchases, owner contributions, and any new financing.
The Cash Flow Forecast tracks operating receipts and payments, investment spending, funding, and closing cash reconciliation. Review it with the Balance Sheet to test liquidity separately from operating EBITDA.
The Returns tools distinguish the revenue needed to cover operating costs from the cash needed to recover investment, without assigning an unsupported payback date to the example.
The Returns report distinguishes sales break-even, cash break-even, investment payback, and annual return on invested capital. It compares revenue with operating cost requirements and tracks investment recovery through project cash flows.
Adjust booked demand, prices, package mix, editing costs, or staffing to examine EBITDA sensitivity. Dashboard Low, Base, and High controls compare revenue and expense scenarios.
Valuation, ratios, benchmarks, and Checks supply further analysis. No valuation amount, payback month, IRR, financing approval, or observed industry benchmark is asserted here.
It suits an independent listing photographer or small residential media service planning package sales, booking demand, hiring, and equipment funding.
The case focuses on homes up to 3,000 square feet in the Raleigh–Triangle area. Replace relationships, conversion, seasonality, package pricing, expense rates, and salaries to reflect your operations.
Commercial assignments, physical staging, prints, subcontract shooters, studio leasing, and brokerage income are outside this model’s example and would require additional inputs.
These answers clarify the editable assumptions, pricing mechanics, forecast limitations, and available financial analysis.
Yes. It is an Excel financial model structured around listing orders, complete photography packages, operating costs, staffing, startup investment, and connected financial reports.
Yes. The five complete-package prices and their allocation percentages are operating inputs, allowing a different service mix without counting included drone, floorplan, or video work twice.
The forecast combines active agent relationships, eligible listings per agent, order capture, one package per booking, and repeating monthly seasonality.
No. Contract photo and video editing is charged as a revenue-linked direct cost; payroll covers the salaried owner-photographer and booking coordinator.
Yes. CAPEX, funding, and sources-and-uses schedules separate opening purchases and owner contributions from annual operating expenses.
No. The example ends at EBITDA. Net profit, liquidity, cash flow, and investor returns are separate calculations requiring their own assumptions and financial reports.
Yes. Dashboard controls offer Low, Base, and High revenue and expense assumptions, with connected scenario comparisons for operating margins and EBITDA.
No. Startup funding is a selected planning input; cash break-even, payback, financing capacity, and return measures must be evaluated separately in the workbook.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
This template made advanced modeling feel manageable, even without deep Excel skills. I got through the inputs and five-year forecast in about two hours instead of spending a full day stuck on formulas.
It gave me a much clearer picture of runway and possible shortfalls for my photography business. I could map monthly cash flow fast and walk into a planning call with real numbers.
I liked how the structure reduced the fear of breaking something with one wrong cell. The checks and clean layout saved me from a few mistakes and kept the model easy to trust.