Pricing and Margin Calculator

What is the Pricing and Margin Calculator?

The Pricing and Margin Calculator is a WGAN 2026 spreadsheet-style form template designed for real estate photographers, 3D tour creators, and reality-capture professionals. It combines a per-shoot service pricing table with an annual Cost of Doing Business (CODB) worksheet. Yellow input cells accept quantities, unit prices, discounts, travel reimbursement, and tax rates, while blue cells automatically calculate subtotals, total due, estimated shoot cost, and gross margin percentage.

When should you use this form?

Use the Pricing and Margin Calculator when quoting a new real estate photography or 3D tour job, reviewing whether existing service prices cover actual business costs, or setting rates at the start of a new market or fiscal year. It is also useful when adding a new service line — such as drone video, virtual staging, or schematic floor plans — and needing to verify that the new price sustains the required hourly rate derived from annual overhead.

What's included in this template?

• Per-shoot service menu with 14 line items (HDR photos, 3D digital twin, floor plans, drone, video, staging, and more)
• Quantity and unit-price inputs with auto-calculated subtotals per service
• Discount percentage field with dollar-value deduction
• Travel reimbursement calculator using IRS mileage rate
• Sales tax rate field with computed tax amount
• Annual Cost of Doing Business (CODB) worksheet covering 10+ expense categories
• Sustaining hourly rate cell derived from total annual costs and billable hours
• Gross margin estimate and margin-as-percentage-of-total calculation per shoot

How do I fill out this form?

1. Open the form at forms.wgan.info. Navigate to forms.wgan.info, locate the Pricing and Margin Calculator in the WGAN 2026 Forms Library, and open the online form to begin entering data.
2. Complete the CODB annual expenses worksheet. Fill in each yellow cell in the Cost of Doing Business sheet — equipment, software, insurance, mileage, taxes, and other overhead — so the sustaining hourly rate calculates automatically.
3. Enter services, quantities, and unit prices. On the per-shoot pricing sheet, enter a quantity of 1 or more for each service delivered and adjust the unit price yellow cells to reflect your local market rates.
4. Set discount, travel, and tax fields. Input any discount percentage, the number of reimbursable miles at the current IRS rate, and the applicable sales tax rate to produce an accurate total due.
5. Review margin estimate for the shoot. Enter the estimated hours of work for this shoot; the form will display estimated shoot cost, gross margin dollars, and margin as a percentage of the total invoice.
6. Download or export the completed calculator. Once all yellow cells are filled and blue calculated fields reflect the correct totals, use the download or export option on forms.wgan.info to save or share the completed file.

Preview

First 2 pages shown — watermarked. Subscribe to fill out and download the unbranded document.