# Build a What-If Business Simulator with TX Sheet Control

> The What-If Business Simulator uses TX Sheet Control to forecast 24 months for a fictional SaaS company. Change pricing, churn, or spending in the workbook or scenario controls, then compare projected revenue, operating profit, and cash across three independently editable scenarios.

- **Author:** Bjoern Meyer
- **Published:** 2026-11-16
- **Modified:** 2026-11-16
- **Description:** The What-If Business Simulator uses TX Sheet Control to forecast 24 months for a fictional SaaS company. Change pricing, churn, or spending in the workbook or scenario controls, then compare projected revenue, operating profit, and cash across three independently editable scenarios.
- **5 min read** (819 words)
- **Tags:**
  - TX Sheet Control
  - ASP.NET Core
  - JavaScript
- **Web URL:** https://www.textcontrol.com/blog/2026/11/16/what-if-business-simulator-with-tx-sheet-control/
- **LLMs URL:** https://www.textcontrol.com/blog/2026/11/16/what-if-business-simulator-with-tx-sheet-control/llms.txt
- **LLMs-Full URL:** https://www.textcontrol.com/blog/2026/11/16/what-if-business-simulator-with-tx-sheet-control/llms-full.txt

---

What happens to cash if monthly churn doubles? How long will a price increase take to show up in operating profit? The [What-If Business Simulator](https://demos.textcontrol.com/demos/sheet-control/business-simulator) lets you explore those questions in a 24-month forecast for Northstar Software, a fictional subscription business.

The sample combines an ASP.NET Core host with the TX Sheet Control browser editor. Sliders and numeric inputs change worksheet assumptions. Spreadsheet formulas calculate the forecast, and native dashboards visualize the results from the same workbook.

  ![Northstar Software executive dashboard with six financial KPI cards, charts, and scenario controls](https://s1-www.textcontrol.com/assets/dist/blog/2026/11/16/a/assets/simulator-executive.webp "Northstar Software executive dashboard with six financial KPI cards, charts, and scenario controls") The executive dashboard opens on month 24. Select an earlier month to inspect its KPIs and cost breakdown while the trend charts continue to show all 24 months. 

### Build the Forecast in the Workbook

Four worksheets make the model easy to inspect. **Assumptions** holds a separate column for each scenario. **Customer Forecast** projects acquisitions, churn, and active customers. **Financial Forecast** turns those customer counts into revenue, expenses, profit, and cash. **Summary** feeds the executive and comparison dashboards.

The forecast rounds acquisition and churn to whole customers each month and carries the full precision of monetary calculations. For example, row 26 is month 1 of the Base Case on the Financial Forecast sheet. These formulas calculate revenue, operating profit, margin, and ending cash:

```text
C26  ='Customer Forecast'!F26*Assumptions!C2
J26  =C26-I26
K26  =IFERROR(J26/C26,0)
L26  =Assumptions!C12+J26
```

Cash rolls forward from month to month using operating profit as a proxy for cash flow. The model excludes taxes, financing, capital spending, and working-capital timing. If the selected month has an operating loss, the runway estimate uses that loss and the remaining cash. The sustained-profit indicator finds the first month from which operating profit stays positive through month 24.

  ![Financial Forecast sheet with the Base Case operating profit formula selected and positive and negative values highlighted](https://s1-www.textcontrol.com/assets/dist/blog/2026/11/16/a/assets/simulator-formulas.webp "Financial Forecast sheet with the Base Case operating profit formula selected and positive and negative values highlighted") The formula bar shows the calculation for operating profit. Conditional formatting makes gains, losses, and negative cash balances easy to spot. 

### Connect the Controls to Worksheet Cells

The slider and numeric field write to the same cell in the selected scenario. With the Base Case selected, for example, a 20% price increase changes the subscription price from $79 to $94.80 in `Assumptions!C2`. The core workbook update looks like this:

```
const book = editor.workbook;
const assumptions = book.sheets.get("Assumptions");

assumptions.cell("C2").setValue(94.8);
await book.calculation.recalculateAsync();
```

The demo listens to `Workbook.onChange()` so an edit made directly in the worksheet also updates the scenario controls. It coalesces changes on an animation frame before asking the workbook to recalculate. The controls use the existing forecast and dashboard definitions throughout.

### Query Formula-Backed Tables from the Dashboard

The Summary sheet exposes the selected scenario’s monthly results through a table named `ScenarioTrend`. The example below uses the workbook analytics API to resolve the table’s field IDs and add a native revenue chart to the executive dashboard.

```
const source = book.analytics.sources()
    .find(item => item.name === "ScenarioTrend");
const fields = Object.fromEntries(book.analytics.profile(source.id)
    .fields.map(field => [field.name, field.id]));

dashboard.addWidget({
    id: "revenue",
    type: "line",
    title: "Revenue growth",
    placement: { x: 0, y: 6, width: 6, height: 9 },
    query: {
        sourceId: source.id,
        dimensions: [fields.Month],
        measures: [{ field: fields.Revenue, alias: "Revenue", aggregation: "SUM" }],
        sort: { field: fields.Month }
    }
});
```

The other widgets use the same approach to display profitability, customer growth, projected cash, and the operating cost breakdown. When an assumption changes, those widgets query the updated worksheet values.

### Compare Three Business Scenarios

The Base Case, Conservative, and Optimistic scenarios run through the same forecast formulas. Each keeps its own assumptions when you switch away. The comparison dashboard puts month-24 revenue and operating profit on side-by-side charts and shows ARR, active customers, and cash in the accompanying table.

  ![Scenario Comparison dashboard with month-24 revenue and operating profit charts and a table for all three scenarios](https://s1-www.textcontrol.com/assets/dist/blog/2026/11/16/a/assets/simulator-comparison.webp "Scenario Comparison dashboard with month-24 revenue and operating profit charts and a table for all three scenarios") With the starting assumptions, the Conservative scenario still shows an operating loss in month 24. The Base Case and Optimistic scenarios show a profit. 

Try doubling churn or increasing the subscription price, then switch to **Compare** to see what changed. Doubling marketing adds expense while acquisition stays at its configured rate. Download the workbook as **TXWB** to retain the native dashboards, or as **XLSX** to take the worksheet formulas into Excel. Reopen the exported XLSX in the simulator to rebuild its standard dashboards from the worksheet tables.

[Try the What-If Business Simulator](https://demos.textcontrol.com/demos/sheet-control/business-simulator)

---

## About Bjoern Meyer

As CEO, Bjoern is the visionary behind our strategic direction and business development, bridging the gap between our customers and engineering teams. His deep passion for coding and web technologies drives the creation of innovative products. If you're at a tech conference, be sure to stop by our booth - you'll most likely meet Bjoern in person. With an advanced graduate degree (Dipl. Inf.) in Computer Science, specializing in AI, from the University of Bremen, Bjoern brings significant expertise to his role. In his spare time, Bjoern enjoys running, paragliding, mountain biking, and playing the piano.

- [LinkedIn](https://www.linkedin.com/in/bjoernmeyer/)
- [X](https://x.com/txbjoern)
- [GitHub](https://github.com/bjoerntx)

---

## Related Posts

- [Live Stock Quotes in a C# .NET App with TX Sheet Control](https://www.textcontrol.com/blog/2026/11/13/live-stock-market-updates-with-tx-sheet-control/llms.txt)
- [How to Embed a DOCX Editor in a Web Application (ASP.NET Core)](https://www.textcontrol.com/blog/2026/10/30/how-to-embed-docx-editor-aspnet-core/llms.txt)
- [DOCX Editor SDK: A Complete Evaluation Guide and Checklist](https://www.textcontrol.com/blog/2026/10/28/docx-editor-sdk-complete-evaluation-guide-and-checklist/llms.txt)
- [Build a Custom Backstage View in ASP.NET Core with TX Text Control](https://www.textcontrol.com/blog/2026/02/17/build-a-custom-backstage-view-in-aspnet-core-with-tx-text-control/llms.txt)
- [5 Document Workflows You Can Automate With JavaScript Rich Text Editor](https://www.textcontrol.com/blog/2026/01/14/five-document-workflows-you-can-automate-with-javascript-rich-text-editor/llms.txt)
- [Format Painter in ASP.NET Core: Building Custom Text Formatting with TX Text Control](https://www.textcontrol.com/blog/2025/09/09/format-painter-in-asp-dotnet-core-building-custom-text-formatting-with-tx-text-control/llms.txt)
- [Add JavaScript to PDFs with TX Text Control in C# .NET: Time-Based Alerts Made Easy](https://www.textcontrol.com/blog/2025/06/13/add-javascript-to-pdfs-with-tx-text-control-in-c-dot-net-time-based-alerts-made-easy/llms.txt)
- [Observe When the Reporting Preview Tab is Active Using MutationObserver](https://www.textcontrol.com/blog/2024/07/23/observe-when-the-reporting-preview-tab-is-active-using-mutationobserver/llms.txt)
- [Loading Documents from Azure Blob Storage into the TX Text Control Document Editor using pure JavaScript](https://www.textcontrol.com/blog/2024/04/08/loading-documents-from-azure-blob-storage-into-tx-text-control-document-editor-using-pure-javascript/llms.txt)
- [Building an ASP.NET Core Backend Application to Host the Document Editor and Document Viewer](https://www.textcontrol.com/blog/2024/03/14/building-an-asp-net-core-backend-application-to-host-the-document-editor-and-document-viewer/llms.txt)
- [Getting Started: Document Viewer with JavaScript](https://www.textcontrol.com/blog/2023/09/15/getting-started-document-viewer-with-javascript/llms.txt)
- [Getting Started: Document Editor with JavaScript](https://www.textcontrol.com/blog/2023/09/15/getting-started-document-editor-with-javascript/llms.txt)
- [Updating SubTextParts using JavaScript Promises](https://www.textcontrol.com/blog/2022/12/23/updating-subtextparts-using-javascript-promises/llms.txt)
- [MailMerge: Working with Image Placeholders](https://www.textcontrol.com/blog/2022/12/22/mailmerge-working-with-image-placeholders/llms.txt)
- [JavaScript: Avoid Flickering and Visual Updates by Grouping Undo Steps](https://www.textcontrol.com/blog/2022/07/25/javascript-avoid-flickering-and-visual-updates-by-grouping-undo-steps/llms.txt)
- [DS Server Released: On-Premise Document Services](https://www.textcontrol.com/blog/2021/01/21/ds-server-released-on-premise-document-services/llms.txt)
- [Merging Templates using DS Server in ASP.NET Core](https://www.textcontrol.com/blog/2021/01/07/merging-templates-using-ds-server-in-aspnet-core/llms.txt)
- [Synchronizing Editable Regions with SignalR Broadcasting](https://www.textcontrol.com/blog/2020/05/12/synchronizing-editable-regions-with-signalr/llms.txt)
