Bank Business Model (UNLOCKED)
Originally published: 24/07/2019 21:07
Last version published: 08/08/2019 20:37
Publication number: ELQ-53204-3
View all versions & Certificate

Bank Business Model (UNLOCKED)

Forecast model for Bank or Credit Officer

NOTE: A free DEMO version of this model can be found at:

● Stacked P&Ls of both lines of business plus a consolidated version, and calculations of KPI summary, as well as by Channel, Product, and Revenue Source
● "Top-down" financial model of Business Unit-level performance of a commercial bank with 2 major lines of business, based on a handful of global assumptions
● "Bottom-up" financial model that accepts revenue and cost inputs at very low levels of granularity for both lines of business, including:
- Variable Cost tab, which accepts input of assumptions of each line of business by Distribution Channel, Product, average loan duration, and primary Revenue Source (interest or sale)
- Fixed Cost input tab, which allows for a modified sliding scale for fixed cost assumptions, by Distribution Channel, according to 8 tranches of loan origination volume

This template contains clearly-labeled input cells. All other cells are locked for calculation, labeling, or are otherwise unavailable for the user to change. This focuses the user on the Key Assumptions they have control over, and prompts an accurate forecast.

We also provide model customization and build-out on an hourly or project basis. Please contact us for more information. Thanks for stopping by.

This Best Practice includes
1 Excel file

Acquire business license for $39.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...