Last version published: 05/05/2019 07:56
Publication number: ELQ-62835-6
View all versions & Certificate
3-way Banking Financial Model converted into an App
Demonstration tool of a 3-way banking financial model converted into an interactive visualisation App
Acquire business license for $9.50
Add to cart
Add to bookmarks
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.
4.9 / 5 (16 votes)
Write a review
- Great 3 way model!
People using this Best Practice also downloaded
Financial Modeling Institute (AFM) Exam SolutionThis is our FMI Exam solution created by Model Citizn. The model demonstrates other alternatives to the exam solution.2,352add_shopping_cart$185.00by Lance Rubin
Powerful Dynamic Arrays Model with Monte Carlo SimulationNewly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!661add_shopping_cart$299.00by Lance Rubin
Property Valuations ModelingSimple Property Valuation Model showing the 3 primary methods for valuing property assets with an interactive visual.3,102add_shopping_cart$9.50by Lance Rubin
Hedging Policy Tool & SimulationForeign Exchange Hedging Policy Tool to enable simulation of hedged and unhedged exposures using derivatives.286add_shopping_cart
3-way Financial Model with PowerBI visualisation including Google AnalyticsExcel with structured table export from 3-way model to PowerBI already transformed. Google Analytics Data included too.1,637add_shopping_cart
Yield Curve Simulation Excel Model & Automated CommentaryYield Curve Simulation Model (automated commentary) showing global impacts of yield curves on bond valuations442add_shopping_cart
PowerBI Financial data for learning and growth mindset.Use the files provided to create your own dashboards in PowerBI and learn for free. Take advantage today.2,202add_shopping_cart$35.00by Lance Rubin
1 Way Cash Flow Excel ModelBusiness & Cash Flow Scenario Model built to help small to medium sized businesses in the current COVID19 crisis (V3.0)4,587add_shopping_cart
Debt Modeling Workbook (Training)Train yourself at generating loan schedules for personal loans1,787add_shopping_cart
Future of Finance (FOF) CourseA 4 Part Course on the Future of Finance and where it is headed.196add_shopping_cart
First Basic Modeler Project File demonstrating how to create a simply interactive app with Excel and PowerpointThis is a simple example of how to connect Excel and Powerpoint using Modeler which then enables interactive visuals.808add_shopping_cart
Data analysis & dynamic reporting for cloud accounting Xero and QBO using ExcelUSING EXCEL TO AUTOMATE PROCESS IN XERO AND QBO? YES YOU CAN Using DataDear you are able to both pull and push data.534add_shopping_cart
Any questions on 3-way Banking Financial Model Converted Into An App?
The user community and author are here to help. Go ahead!