Investment model
Investment models in Weissr Capex are essential tools for analyzing the expected cash flow impact of an investment. These models provide a structured framework for financial projections, enabling decision-makers to assess the financial feasibility of requests.
Each request can be tied to a single investment model selected from the Model Library, which is configured with customer-specific models. These models are tailored to match your organization’s existing Excel-based business models, ensuring consistency and ease of use.
Key Features of Investment Models
Time Resolution and Time Horizon
Time Resolution: Yearly.
Time Horizon: Flexible, ranging from 5 to 50 years.
Analysis Start Year: Defined by the system property "Analysis Start Year," a static project property used across all models.
Model Structure
Investment models consist exclusively of numerical values, including integers and decimals (formatted as percentages if needed).
The first column serves as a row label and cannot be used in calculations.
Excel Compatibility
Models can be exported to and edited in Excel.
Users with edit permissions can override default expressions with Excel formulas.
A comprehensive list of supported Excel functions for Weissr models is available in Appendix X.
Automatically Inserted Expenditure Data
Data entered in the Expenditures section of a request is automatically displayed in corresponding rows within the investment model.
Key expenditure-related data, such as total capex, total opex, and combined totals, is automatically retrieved and displayed.
Tax-related calculations (e.g., tax shield from depreciation) are performed automatically based on expenditures, the tax depreciation period, and the tax rate for the associated site.
Info: The use of tax depreciation calculations is optional and customizable by the customer.
Grouping of Rows
To simplify navigation in large datasets, the model includes a grouping feature, similar to Excel.
Rows can be grouped for easier management.
Groups can be expanded or collapsed with a single click.
Configuration of groups is done in the Model Generator by Weissr consultants.
Audit and Cell Log
Weissr maintains a detailed cell log for every manual data entry made in the investment model, ensuring traceability and accountability.
Logged data includes:
Old value
New value
Date & time of the change
User name of the individual who made the change
Users with edit permissions can view the cell log and restore any cell to a historical value directly from the model.
Working with Investment Models
Importing Investment Model Data
Users can import data into an investment model from the Investment Model tab.
Models can be imported both pre-decision and post-decision.
The imported Excel sheet must match the format of the Weissr model.
Internal vs. External Investment Models
For extensive and complex models requiring advanced calculations and references, Weissr supports combining internal and external investment models:
External Excel Model: Used for background calculations and detailed references.
Internal Weissr Model: Contains aggregated data.
By linking the cells and sheets of the external Excel model to the Weissr model, users can import aggregated data while maintaining access to the detailed calculations in Excel.
Weissr’s investment models provide flexibility, transparency, and robust analysis tools, enabling users to align financial projections with business goals effectively.