CONFIDENTIAL: This document contains proprietary information and intellectual property of Asset Lenz. Do not share, distribute, or reproduce without explicit permission. Unauthorized use or disclosure is strictly prohibited.

Asset Lenz is designed to accept fully customizable Excel Deal Model that takes the form of a valuation or underwrite model. By adding 4 sheets to the model (file type needs to be “.xlsx” format) with go-forward financial statement projections, the Deal Model should have the necessary information from revenue, expenses, balances of accounts to CAPEX and free cash flow draw link up with the macroeconomic and industry drivers that generate the plausible outcomes and scenarios of risks and return for business. Described in details below are what needs to be setup by the user prior to uploading an Excel Deal Model file to the platform so that it can run smoothly without any hiccups.

Before jumping into the details, here are a couple high-level rules of thumb to keep in mind when building a model to ingest into Asset Lenz:

• High-level rules of thumb:

Meeting Excel Deal Model Requirements

How to Build Required Sheets

As long as the Excel file has these required tabs of the same name: “Forecasted Financials”, “Forecasted Schedules”, “Model Drivers” and “Model Parameters”; Asset Lenz should be able to ingest those tabs to run the Deal Model. For all sheets, validation of these inputs with the corresponding deal type is being implemented so that if there is user feedback at ingestion.

Model Parameters

This sheet is dedicated to all of the high-level inputs and core assumptions, that may depend on the deal type (i.e., asset class) that is being modelled. For instance, a real estate model type would have assumptions like the cap-rate at entry and exit whereas a private equity model may have its value being based on entry and exit multiples. Asset Lenz expects to see the corresponding model parameters to the deal type.

• Required Keys
• Optional Keys

<aside> 🏗️

Coming soon to Asset Lenz

• [ ] In V2 of Asset Lenz, all of these keys, both optional and required will be validated and shown on a user-friendly UI where the user will not need to know the naming conventions above.
• [ ] New deal types that will be in Asset Lenz are: Private Credit, LP Stake, GP Stake, Public Equity, Fixed Income, Venture Capital, etc. </aside>

Model Drivers

The Model Drivers sheet allows for the dynamic modelling of any business line documented on the “Forecasted Financials” sheet. Say a business has a revenue line that is expected to be highly correlated with inflation or the industry revenue growth rate, the user can create that mapping on this sheet.

Optional Keys

There is no set of required keys for the Model Drivers sheet, since the keys should only match those keys defined in “Forecasted Financials”, “Forecasted Schedules” and the macro-industry model generated.