Leasing Company Financial Model – 5 Year Forecast

Description
Financial leasing companies engage in financing the purchase of several types of assets. Though leasing company is the legal owner of the goods, the ownership and possession is 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-knows 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.