Bank Business Model (UNLOCKED)

Forecast model for Bank or Credit Officer

by ExcelModels
Finance professor & Excel masterFollow 51

195 views|Start the discussion!|Bookmark Add to cart - $59.00

Description
NOTE: A free DEMO version of this model can be found at:
https://www.eloquens.com/tool/YmKQfBMN/finance/bank-financial-model-templates/bank-business-model-demo

● 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