Investment Banking
Typical Investment Banking analyses and how to run them 10x faster with Fontics.
Valuation Drivers
Valuation Drivers
Which inputs drive Enterprise Value?
Find the 3 to 5 inputs that drive [80]% of the Enterprise Value.
Excel only: Takes 20 to 30 minutes.
Excel + Fontics: Takes 3 minutes with the Pareto Drivers Module.
Sensitivity - Tornado Chart
Sensitivity - Tornado Chart
Can we run a sensitivity on Enterprise Value?
Run upside / downside EV 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 Enterprise Value
Create multiple data tables with key inputs to review the sensitivity of Enterprise Value.
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 5 EBITDA value achieves a 240 EV?
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 leverage impact EV?
Create various leverage scenarios and visualize the impact on Enterprise Value.
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 prevent covenant breaches?
Optimizing debt debt structure requires iterative scenario analysis on key inputs.
Excel only: Takes 45 to 60 minutes.
Excel + Fontics: Takes 3 minutes with the Optimize - Scenarios Module.
Multi-Factor Solver
Multi-Factor Solver
How can we improve Enterprise Value?
Goal seek to target EV 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 Enterprise Value 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 Enterprise Value?
Simulate 1,000+ scenarios to estimate the range and probability of Enterprise Value 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.