Lender Business Model (UNLOCKED)
  • Lender Business Model (UNLOCKED)
Originally published: 09/08/2019 18:09
Publication number: ELQ-75503-1
View all versions & Certificate
certified

Lender Business Model (UNLOCKED)

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

Description
NOTE: A free DEMO version of this model can be found at:
https://www.eloquens.com/tool/1z9QUGMA/finance/debt-schedule-financial-excel-models/lender-creditor-excel-model-template-demo

● 4 color-coded borrower risk profiles
● Input rates, fees, bounties, & repays
● CF from interest & aftermarket sales

Model contains:
● Financial model describing a Lending Company licensed (through the SBA) to make government-guaranteed loans of up to 75% of face value
● Model calculates loan originations for each of 4 specific borrower profiles, as well as Cash Flows generated from Interest Income and secondary market sales
● Color-coded and footnoted global assumptions sheet accepts inputs for Rates, Fees, loan Repayment, and Commissions for each Distribution Channel
● Originations and assumptions drive tabs for Revenue, COGS, Headcount assumptions, Payroll, Overhead, OpEx, P&L, Balance Sheet, and Cash Flow Statement

As with all models at ExcelModels, this workbook contains separate tabs containing integrated financial statements: Income Statement, Balance Sheet, and Cash Flow Statement. All 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. All other cells are locked for calculation, labeling, or other use. 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.

This business tool includes
1 Excel file

Acquire business license for $79.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • No review yet!

More tools from ExcelModels

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Lender Business Model (UNLOCKED)?

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

please wait...