Lending Business Template Bundle (4 Total Financial Models)

Description
Templates Included:

General Lending Business - This is for a lender that originates more traditional loans. They could be three types: 1) principal and interest 2) interest only 3) interest only for a given period and then principal and interest thereafter. Scale the volumes of each loan type according to your strategy. Note, a full 3-statement model was integrated into this as well. Recently, this was upgraded to include a credit facility option to fund some or all of the lending activity. In that case, profits would be driven from the margin of interest paid vs interest collected less defaults. There are also full assumptions for fixed operating expenses, customer service reps, and sales reps.
https://www.eloquens.com/tool/jDaKIwme/startups/financial-models/10-year-lending-business-startup-model-scaling-3-loan-types

Seller Financing - Includes up to 3 loan types and the resulting amortization and tax basis calculations per month over the term of the loan. This measures the amount that is return of basis vs capital gain vs earned income.
https://www.eloquens.com/tool/GDjwiYmQ/finance/amortization-depreciation-excel-templates/investment-analysis-seller-financing-amortization-tax-basis-calculator

Flat Fee Lending - Loans are originated and customers repay a fixed fee percentage of the borrowed amount. There are granular configurations for up to four loan types differentiated by terms/volume/fee rate. Fully integrated three statement model and cap table included. The user can configure repayment + fee to either happen all at the end of the term or evenly over the term.
https://www.eloquens.com/tool/NbqrHPlZ/jason-varner/flat-fee-lending-business-startup-financial-model

Lending-as-a-Service - This model is for the operator of a peer-to-peer (P2P) lending platform that facilitates the connection of borrowers that need capital and investors who want to lend money out to other individuals or businesses. The platform takes a fee on all activity. These are interest only loans where all principal is repaid at the end of the term.
https://www.eloquens.com/tool/4ejHpl/startups/marketplaces/lending-as-a-service-laas-running-and-exit-financial-excel-model-10-year

Mortgage Repayment (extra payment calculator) - A model to see the effects of making extra payments over time. Includes interest savings and months of payment saved. The user can edit the extra payment by month.
https://www.eloquens.com/tool/GDQAcY5x/finance/real-estate/mortgage-savings-calculator-extra-payments

P2P Lending Participant - This model was built for someone who specifically wants to invest in P2P lending. The purpose was to see the affects of compounding interest based on certain cash drag and origination assumptions as well as deposit / withdrawal activity and defaults.
https://www.eloquens.com/tool/vkwQsGMz/finance/loan-amortization-schedule-excel-templates/lending-model-for-peer-to-peer-platform-participation

Loan Portfolio Analysis - This template makes it easy to drop in your loan tape and get automated reports about that loan tape. This includes data on average interest rate, average loan amounts settled by risk category, count of loans settled by risk category, loans defaulted by risk rating, and more. Additionaly, it included a foreward monthly summary of expected future principal and interest collections. 
https://www.eloquens.com/tool/5aybCZ12/finance/loan-amortization-schedule-excel-templates/loan-portfolio-analysis-template

Interest Rate Swap - Template not uploaded to Eloquens, but is included in bundle. It lets the user see the resulting effect of each leg based on expected future interest rates and starting interest rates. Present value calculations included.

Want more templates? Check out all the financial models I've built:
- All Templates: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic