Modeler - convert a financial model into an App

This tool is used to convert any financial model into a dynamic app using only Excel and Powerpoint.

app with no codingbankingdynamic influencingfinancial modellingmodel citiznmodelervisualisation

This is effectively the world's first platform that enables the development of an App with no coding and only Excel and Powerpoint.

By using Modeler one is able to convert any Excel file combined with any Powerpoint slide to create an interactive visualisation surface that enables the user to zoom in and out of content and dynamically change the assumptions in the model.

With Modeler one is able to amend the assumptions and see the outcomes of multiple scenarios without amending the Excel file directly.

This allows others (not just the modeler) to use it to make a decision in a much more user friendly interface.

Models can be complex and often rely on the modeler to operate as many people are scared to break the model.

By using Modeler the key assumptions can be changed without impacting the potential integrity of the model.

The Modeler tool along with the underlying model was demonstrated at the Modeloff Global Training Camp in Sydney. Images now included showing different banking divisions demonstrated in the tool and included in the Excel model.

Attached are the slides from the workshop, the assumption book and the completed model.

You can view a live video demonstration of the tool in the video attached.

For more information on how this might be applicable to you or if you want to know how you can convert your model into an App contact myself or visit

This business tool includes
1. Assumption Book, 2. Overview of workshop and 3. Excel Financial Model Solution

Lance Rubin offers you this business tool for free!

Download for free


Further information

To show how it is possible to transform even the most complex of models (this being of an entire bank) including dynamic simulations of mark to market valuation adjustments in the trading book, deposits, lending, funds management etc into a simple app.

When needing to convince key stakeholders who are not necessarily as close to the detail or as technical as the modeler but are nonetheless a key stakeholder to influence. Influencing someone who does not have a technical background is not always easy on a topic that is often fairly technical and detailed and things are not always as simple as they appear.

Now the tool can help transform what would be a static powerpoint presentation into a dynamic conversation.

Large data visualisations or slicing and dicing data similar to Power BI, Pivot tables, Tableau and the like. The visualisations are there to enable a dynamic editiing of underlying assumptions and extraction, its both ways therefore any form of 1-way large data flow is not applicable or useful.


Any questions on Modeler - Convert A Financial Model Into An App?

The user community and author are here to help. Go ahead!

please wait...