Real Estate
Typical Real Estate analyses and how to run them 10x faster with Fontics.
Equity Multiple Drivers
Equity Multiple Drivers
Which inputs drive Equity Multiple?
Find the 3 to 5 inputs that drive [80]% of the Equity Multiple.
Excel only: Takes 45 to 60 minutes.
Excel + Fontics: Takes 3 minutes with the Pareto Drivers Module.
Sensitivity - Tornado Chart
Sensitivity - Tornado Chart
Can we run a sensitivity on Equity Multiple?
Run upside / downside Equity Multiple scenarios using key inputs and plot a tornado chart.
Excel only: Takes 20 to 30 minutes.
Excel + Fontics: Takes 3 minutes with the Sensitivity Analysis Module.
Sensitivity - Data Tables
Sensitivity - Data Tables
Build a sensitivity table for Equity Multiple
Create multiple data tables with key inputs to review the sensitivity of Equity Multiple.
Excel only: Takes 20 to 30 minutes and slows down Excel (due to recalculations).
Excel + Fontics: Takes 3 minutes with the Data Tables Module.
What-If Analysis
What-If Analysis
What Yr 10 NOI achieves a 2.5 Equity Multiple?
Goal seek on any cell (including formula cells).
Excel only: Not supported. Goal seek input must be a static value.
Excel + Fontics: Takes 1 minute with the What If - Find Any [Goal Seek] Module.
Stress Testing
Stress Testing
Hows does LTV impact Equity Multiple?
Create various leverage scenarios and visualize the impact on Equity Multiple.
Excel only: Takes 10 to 15 minutes.
Excel + Fontics: Takes 2 minutes with the Scenarios - Custom Values Module.
Debt Structuring
Debt Structuring
How do we stress-test Debt Capacity?
Stress-testing Debt Capacity requires iterative scenario analysis on key inputs.
Excel only: Takes 30 to 60 minutes.
Excel + Fontics: Takes 3 minutes with the Optimize - Scenarios Module.
Multi-Factor Solver
Multi-Factor Solver
How can we improve Equity Multiple?
Goal seek to target Equity Multiple and evaluate how multiple inputs should change together.
Excel only: Not supported. Goal seek only works on one assumption at a time.
Excel + Fontics: Takes 3 minutes with the Optimize - What Ifs Module.
Football Field Analysis
Football Field Analysis
Can we compare the valuation ranges?
Run football field analysis to compare ranges from various methods side by side.
Excel only: Takes 10 to 15 minutes.
Excel + Fontics: Takes 1 minute with the Football Field Analysis Module.
Monte Carlo Simulation
Monte Carlo Simulation
What is the most likely Equity Multiple?
Simulate 1,000+ scenarios to estimate the range and probability of Equity Multiple outcomes.
Excel only: Not supported. Requires proprietary tools that costs over $2,400/yr.
Excel + Fontics: Takes 3 to 5 minutes with the Scenarios - Monte Carlo Module.