Bank Business Model (DEMO)
Originally published: 12/07/2019 09:15
Last version published: 31/10/2019 09:51
Publication number: ELQ-65925-9
View all versions & Certificate

Bank Business Model (DEMO)

Forecast model for Bank or Credit Officer

NOTE: An UNLOCKED version of this model can be purchased 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

ExcelModels offers you this Best Practice for free!

download for free

Add to bookmarks



keyboard_arrow_downShow all


More Best Practices from ExcelModels

See all

Any questions on Bank Business Model (DEMO)?

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

4.7 / 5 (21 votes)

please wait...