Lender Business Model (DEMO)
Originally published: 16/07/2019 12:59
Last version published: 27/03/2020 20:11
Publication number: ELQ-56887-7
View all versions & Certificate

Lender Business Model (DEMO)

Enables Lender or Creditor to compute loan originations, payouts, and loan sales. Displays up to 4 borrower profiles.

NOTE: An UNLOCKED version of this model can be purchased at: https://www.eloquens.com/tool/Mq55Ckgg/excelmodels/lender-business-model-unlocked

At ExcelModels we create world-class templates that produce multi-year forecasts by month.
We value form and function equally. Our models are powerful and highly intuitive, built for new users and experts alike.

We color-code cells to prompt for inputs which drive financial formulas that produce Board-ready, GAAP-compliant Pro Forma financials.

Each business model produces a forecasted Income Statement, Balance Sheet, and Statement of Cash Flows.

This Lender Business Model describes a Lending Company which uses invested cash and monthly cash flows to fund loans for up to 4 types of borrowers.

Features include:
● Centralized input sheet for rates, fees, bounties, & repayments
● 4 color-coded borrower risk profiles presented side-by-side for easy comparison
● A revenue stream for aftermarket Sales, if any
● Loan originations worksheet
● Amortization schedules
● Cash Flows generated from Interest Income and secondary market sales
● Worksheets for COGS, Headcount, Payroll, Overhead, and Operating Expense
● Capitalization schedule including Revenue Participation Notes, if any
● 10-year Pro Forma Income Statement, Balance Sheet, and Statement of Cash Flows

As with all models at ExcelModels, checks and balances are in-place, highlighting areas (such as a negative cash balance) where the user needs to adjust assumptions elsewhere.

This template contains clearly-labeled input cells, focusing the user on key assumptions they control, prompting an accurate forecast.

We provide customization and build-out for an additional fee.
Please contact us for more information.

This Best Practice includes
1 Excel file

ExcelModels offers you this Best Practice for free!

download for free

Add to bookmarks


4.7 / 5 (18 votes)

please wait...