Financial leasing companies engage in financing the purchase of several types of assets. Though a leasing company is the legal owner of the goods, the ownership and possession are effectively conveyed to the lessee, who earns all benefits, costs, and risks linked to ownership of these assets.
The leasing company finances the asset and leases it for use or ownership. Lessees pay a monthly amount (lease installment) to the leasing company for the use of the business asset. Depending on the lease form, lessees become the owner of the asset directly, or they determine this at the end of the lease period. The best-known forms of leasing are financial lease and operational lease.
This Financial model template presents a business scenario of a financial leasing corporation. The model can be fully modified and applied to any type of leasing company and its main purpose is to enable users to get into details of every step of the operating cycle and forecast 5 years of financials, including company’s business valuation and returns of investors.
The model assumes that the company provides 2 types of leases (Financial and Operating) as well as the option to include 3 Types of loans. It includes assumptions and calculations of Leases and Loans Terms, Analysis of Financial and Operating Leases, Loans Received and Issued schedules, Interest Rates & Interest Income, OpEx, Payroll, and Capital Costs.
The structure of the template follows Financial Modeling Best Practices principles and is fully customizable.
Detailed instructions for the functionality of the model are included in the Excel file.
Model Inputs and Setup Reports:
• General Setup Assumptions, incl. Starting Expenses (in case the business is a startup), Leases & Loans Transactions and Terms and Financing
• Payroll, OpEx, and Annual Capex
• Transactions volume assumptions
• Forecast Scenarios
• Analysis of Financial Leases, Operating Leases, Loas Issued and Loans Received
Output Reports:
• Monthly Budget (incl. Monthly P&L summary per Year) and 5-Year Financial Forecast (3 Statement model)
• Interest Earning Assets Report
• KPI’s and Financial Ratios Report
• Performance Dashboard
• Business Valuation, including DCF Model, Return Metrics (NPV, EV, IRR, MOIC, ROI, etc.), and Sensitivity Analysis
• Investors Returns Report
• Professional Executive Summary
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best-practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
Whether you have no experience or are well-versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you experience any difficulty while using this template and cannot find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
Similar Products
Other customers were also interested in...
Debt Fund Excel Model
Explore the Debt Fund Excel Model, a comprehensive tool for evaluating new credit fund opportunities... Read more
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Collateralized Mortgage Obligations Model
Collateralized Mortgage Obligations Model presents a simple model where mortgage backed securities a... Read more
Crowdlending (P2P) Platform – 5 Year Financi...
Financial Model providing an advanced 5-year financial plan for a startup Crowdlending (Peer-to-Peer... Read more
Buy Now Pay Later (BNPL) Platform – 5 Year F...
Financial Model presenting an advanced 5-year financial plan for a startup BNPL Platform which provi... Read more
Microfinance Platform – 5 Year Financial Model
Financial Model presenting an advanced 5-year financial plan for a Microfinance Lending Platform pro... Read more
Lending Company Financial Model – 5 Year Forecas...
This Financial model template presents a business scenario of a corporation engaged in granting loan... Read more
Commercial Bank Financial Model – Dynamic 10...
Financial model presenting an operating and valuation scenario for a Commercial Bank The model ca... Read more
Asset Management Company – Closed End Fund M...
Financial Model presenting a scenario of a Closed-End Fund managed by an Asset Management Compan... Read more
Fintech Financial Models Bundle
Financial technology (better known as fintech) is used to describe new technology that seeks to impr... Read more
You must log in to submit a review.