Feature release notes: Scenarios Improvements
![](https://cdn.prod.website-files.com/6668c62be93acd9d52f687ef/6684833cc744d12bd805412c_scenarios-thumbnail.png)
This month, we released powerful improvements to Scenarios’ Round Modeling tool and Exit Waterfall template. These updates will help you model future rounds and exit waterfalls with more precision from both the Aumni platform and Excel.
New this month:
Round Modeling
- Results Summary tab: Summarizes ownership and next-round information in a rollup view
- Target ownership percentage calculator: Enter in next-round ownership goals to determine participation amount
Exit Waterfall
- Facts and Exit Equity Calculator: A simple calculator to help you factor in outstanding debt and fees when determining exit equity value
- Common, Warrants, and Participating Preferred accommodation
- Fund performance section: See waterfall details by fund
In case you missed it:
- Add or import multiple convertible notes or SAFEs with varying terms to your round model
- New pre- and post-deal cap table format
- Quick-fill calculations that populate the check size needed to maintain ownership or pro rata
Round modeling
You can now toggle between a new Results Summary tab and a post-deal capitalization table so it’s simpler to visualize dilution and understand next-round economics at a glance.
The post-deal cap table itemizes pre- and post-deal ownership by share class so you can determine the impact of a deal scenario and compare economics, a feature that was released earlier this year.
![](https://cdn.prod.website-files.com/6668c62be93acd9d52f687ef/667fb80c00741aee889a00f9_667096d793dddd88a659ca33_AD_4nXcD7-klFR0Dj744qkxvE-qOjyiD0Csz2vmN2WCLxmsbdVGHjYijjFkZ0mZM7OwG28CLQEIV9trFUOoOk5xOQpv4AaOtxsq0dmWL7kvjNCC11hESiGmBA4PA4UBOhNy9lDBIcmKEfckxkfeEzWgewqqmL_fj.gif)
Add a Target Ownership Percentage to the ‘My Investment’ section to calculate the exact participation amount needed for your ownership goals. The percentage will automatically include any equity converting in the round from convertible notes and SAFEs held. Earlier this year, we also released Quick-fill Investment Amount in Pro Rata Calculations to auto-populate the check size needed to maintain ownership or pro rata.
![](https://cdn.prod.website-files.com/6668c62be93acd9d52f687ef/667fb80c00741aee889a00ce_66709714a19273a130880891_AD_4nXdBdVqjyATpA3w_jqTnEfpu25f2zXMgq4kDwnI04PJgYxxI5zNxDkSeVn2MWugzye5LTJlTObKicHc1t0pTHIy8xIu-y4vfyDtP3-hR7Gr6SkOBKaVtoP1I2silmVlsI9MEAo7jrupvqnvX7RHtvPfC6m8.png)
Exit Waterfall
We’ve added a new sheet–the Facts & Exit Equity Calculator–to the Exit Waterfall Excel template that summarizes company details like current post-money valuation and close date, and includes formulas for non-convertible debt and other fees that help you revise total exit equity value in your waterfall.
![](https://cdn.prod.website-files.com/6668c62be93acd9d52f687ef/667fb80c00741aee889a00ca_66709727d40209da402599ff_AD_4nXd9cxeLkhT0O7vSBw4W1l7CLjrDs7nKePNAIu187iHQ8Xm87t0jRwEClNCIPu0_-S796392vR0MfFflSBqFGE3SlwW-sr_r89CcXQlihIOwIAmv2ehZGf2VLpiSp8ttw6-5UwVmMDzhir2WV7s4RVSpqhQ.png)
The model now accommodates common stock, warrant holdings, participating preferred stock (uncapped or capped), enhancing distribution calculation precision in more complex capital structures.
![](https://cdn.prod.website-files.com/6668c62be93acd9d52f687ef/667fb80c00741aee889a00d1_6670972729918ac436b81d5c_AD_4nXdGTGtenWVvAKe9zs5-SW0sWX0YYMoOIfsAhJfAxfsnZ4JCz8up32PXYJJ8hcCFeKPHdIIJ3ysV6EhfhamMqpfQennBzr5Ln1ZPzmpKfAATaiv2e1snvcD0B7LLGk6ml7XjmSDf8TR1HWbFm-7S6JkqcA6e.png)
We’ve also released fund-level economic breakouts within the model so you can compare distributions and MOIC between your participating funds.
![](https://cdn.prod.website-files.com/6668c62be93acd9d52f687ef/667fb80c00741aee889a00c0_6670972765292a87d257e0d7_AD_4nXcDzyANCvuvVb3wX93ESFqZKFhFNSGum1u0yOmQbIWe7UXZduI8gZcvZBvwa8xFs-3xtdTC1yiQGSPkNSc2ohRHXUt563yC1cMglrvYiKMQa-652c8gfxTkXCq-uHI3p22AUtfbSfBLeb-OgLQI6TiXoO6K.png)
In case you missed it:
Aumni now accounts for common stock, warrants, convertible notes, and SAFEs in your round model. Available data will automatically populate in a round or exit model, and is customizable in the platform and Excel. Easily add unlimited convertible notes with any variety of terms to your model, held by you or a co-investor.
©2023 JPMorgan Chase & Co. All rights reserved. JPMorgan Chase Bank, N.A. Member FDIC.
This material is not the product of J.P. Morgan’s Research Department. It is not a research report and is not intended as such. This material is provided for informational purposes only and is subject to change without notice. It is not intended as research, a recommendation, advice, offer or solicitation to buy or sell any financial product or service, or to be used in any way for evaluating the merits of participating in any transaction. Please consult your own advisors regarding legal, tax, accounting or any other aspects including suitability implications, for your particular circumstances or transactions. J.P. Morgan and its third-party suppliers disclaim any responsibility or liability whatsoever for the quality, fitness for a particular purpose, non-infringement, accuracy, currency or completeness of the information herein, and for any reliance on, or use of this material in any way. Any information or analysis in this material purporting to convey, summarize, or otherwise rely on data may be based on a sample or normalized set thereof. This material is provided on a confidential basis and may not be reproduced, redistributed or transmitted, in whole or in part, without the prior written consent of J.P. Morgan. Any unauthorized use is strictly prohibited. Any product names, company names and logos mentioned or included herein are trademarks or registered trademarks of their respective owners.
Aumni, Inc. (“Aumni”) is a wholly-owned subsidiary of JPMorgan Chase & Co. Access to the Aumni platform is subject to execution of an applicable platform agreement and order form and access will be granted by J.P. Morgan in its sole discretion. J.P. Morgan is the global brand name for JPMorgan Chase & Co. and its subsidiaries and affiliates worldwide. Aumni does not provide any accounting, regulatory, tax, insurance, investment, or legal advice. The recipient of any information provided by Aumni must make an independent assessment of any legal, credit, tax, insurance, regulatory and accounting issues with its own professional advisors in the context of its particular circumstances. Aumni is neither a broker-dealer nor a member of any exchanges or self-regulatory organizations.
383 Madison Ave, New York, NY 10017