Sensitivity Analysis
Cap rate, rent growth, exit timing — scenario tables that show the real range of outcomes.
Your analyst builds a two-way sensitivity table, hardcodes the ranges, and formats it for the IC deck. If someone asks 'what about a different exit year?' it's another hour. Every scenario is manual, every change ripples through a fragile spreadsheet.
Describe the variables in chat. Apers generates multi-dimensional sensitivity tables — cap rate vs. rent growth, exit year vs. leverage, hold period vs. expense inflation. Any combination, instantly updated. Approve the output and open it in Google Sheets. Save the tables to your Library or run them against a Playbook to flag scenarios that break your return threshold.
Four Steps to Scenario Clarity
Define your variables
Tell Apers which assumptions to stress — cap rate, rent growth, exit year, leverage, expense inflation. Pick two for a 2-way table or three for a 3-way matrix.
Apers builds the tables
Sensitivity tables generate with IRR, equity multiple, and cash-on-cash shown simultaneously. Every cell is formula-driven and linked to the underlying pro forma.
Review and approve
Before populating cells, Apers shows the ranges and output metrics it plans to use. Approve, adjust the ranges, or attach a Playbook to highlight which scenarios meet your criteria.
Export and share
Tables open in Google Sheets with full formula transparency. Download as .xlsx for IC decks, save to your Library, or share a link with your team.
Base, Upside, Downside
Three scenarios with internally consistent assumptions. Not just rent growth up and down — expense ratios, vacancy, and cap rates all move together.
Multi-Variable Sensitivity
Two-way and three-way tables across any combination of assumptions. IRR, equity multiple, and cash-on-cash shown simultaneously.
Break-Even Analysis
What rent growth makes this deal break even? What cap rate expansion kills the return? Know exactly where the edge is.
Approve Every Step
Apers shows its plan before writing a single cell — which ranges it will use, which metrics it will output, and how the tables link to the pro forma. Approve one table at a time or switch to Fast Mode.
Google Sheets + Library
Sensitivity tables live in Google Sheets with full version history. Save to your Library for future deals, download as .xlsx for IC presentations, or share a link with your investment committee.
Models
Frequently Asked Questions
What types of sensitivity analysis can Apers run?
Apers generates multi-dimensional sensitivity tables — cap rate vs. rent growth, exit year vs. leverage, hold period vs. expense inflation. You can define any two variables and Apers builds the table with IRR, equity multiple, or any other metric as the output.
How does Apers build sensitivity tables?
Describe the variables and ranges in chat. The XL-2 engine generates the full table in your Excel model, with each cell linked to the underlying pro forma assumptions. Change the ranges and the table regenerates automatically.
Can I flag scenarios that break my return threshold?
Yes. Apply a Playbook with your minimum return requirements and Apers highlights which cells in the sensitivity table fall below your threshold. This makes it easy to identify the boundary conditions for your investment.
How many variables can I test at once?
Apers supports two-way sensitivity tables natively and can build multiple tables in the same model. For more complex analysis, run different variable combinations in parallel sub-chats and consolidate the results.
Can I export sensitivity tables for my IC deck?
Yes. Sensitivity tables open in Google Sheets with full formatting and can be downloaded as .xlsx. The tables are built as live formulas, so they update automatically if you change the underlying assumptions in the model.