Leasing Company Financial Projection Model   Excel template (XLSX)
$99.00

Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Log in to unlock full preview.
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Leasing Company Financial Projection Model (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

Leasing Company Financial Projection Model (Excel XLSX)

Excel (XLSX) + Excel (XLSX)

$99.00
This financial model is built by former Deloitte financial modeling professionals, accountants, and CFA charterholders. Their financial models have been used by over 4,000+ clients worldwide.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

VIDEO DEMO

BENEFITS OF THIS EXCEL DOCUMENT

  1. Prepare financial projection for a leasing business
  2. Visualise projection outputs on dashboard
  3. Value leasing business

REAL ESTATE EXCEL DESCRIPTION

This product (Leasing Company Financial Projection Model) is an Excel template (XLSX) with a supplemental Excel document, which you can download immediately upon purchase.

MODEL OVERVIEW

A leasing company specializes in providing assets or property to individuals or businesses for a specified period, typically in exchange for regular payments. These assets can include vehicles, equipment, real estate, or even technology. Rather than purchasing an item outright, leasing allows the lessee (the person or entity using the asset) to use it for an agreed-upon duration by making regular payments to the lessor (the leasing company). At the end of the lease term, the lessee can often choose to return the asset, renew the lease, or sometimes even purchase the asset at an agreed-upon price.

Our highly versatile and user-friendly Excel model allows for the preparation a of 5-year rolling 3 statement (Income Statement, Balance Sheet and Cash flow Statement) financial projection with a monthly timeline for a startup or existing business leasing company borrowing funds to purchase assets to lease, leasing out these assets and investing any surplus funds in financial investments.
The model applies IFRS 16 methodology to project both finance leases (10 categories) and operating leases (10 categories) each with their own lease volumes, costs, fair values, direct costs, monthly lease payments, durations, credit losses, residual values and useful life.
The model also includes interest-bearing liabilities, financial investments, fixed assets, other borrowings, staff costs, marketing costs, other administrative costs, taxes, equity additions and dividend distributions.

The model follows good practice financial modelling principles and includes instructions, line-item explanations, checks and input validations.


KEY OUTPUTS

•  Projected full financial statements (Income Statement, Balance Sheet and Cash flow Statement) presented on a monthly basis across 5 years and summarised on an annual basis.
•  Dashboard with:
•  Summarised projected Income Statement and Balance Sheet;
•  Compounded Annual Growth rate (CAGR) for each summarised income statement and Balance Sheet line item;
•  List of key ratios including average return on assets and equity, average debt to equity ratio and equity to liability ratios.
•  Bar charts summarising income statement and Balance Sheet projections;
•  Chart/tables presenting income, expenses, balances and volumes by leasing category.

KEY INPUTS

Setup Inputs:
•  Name of business;
•  Currency;
•  First projection year and month;
•  Naming for finance and operating lease categories, interest-bearing liabilities, financial investments, staff cost categories, marketing cost categories, admin expense categories, fixed asset categories and borrowings;

Actuals Inputs:
•  Opening balance sheet (for existing businesses);
•  Income Statement actuals (for trend analysis);

Projection Inputs:
•  Finance Leases
•  Cost of leased asset at commencement
•  Fair value of leased asset
•  Initial direct costs of lease
•  Residual value of leased asset
•  Monthly lease payments
•  Duration of lease
•  Expected credit losses
•  Volume of lease additions
•  Operating Leases
•  Cost of leased asset at commencement
•  Useful Life
•  Monthly lease payments
•  Average lease utilisation over useful life
•  Expected credit losses
•  Volume of lease additions
•  Interest-bearing liability expenses
•  Additions/repayments
•  Interest rates
•  Financial investments
•  Target cash balances
•  Investment return per annum
•  Investment allocation percentages
•  Staff Costs including:
•  Staff numbers;
•  Average Annual cost per staff member;
•  Average employer's payroll taxes as % of salary;
•  Average annual bonus;
•  Average healthcare benefits per staff member;
•  Other cost inputs including
•  Marketing costs;
•  Staff costs;
•  Admin expenses.
•  Sales tax and corporate tax inputs including rate and payment periods;
•  Dividend inputs including amount or percentage of retained earnings and frequency;
•  Fixed Assets including addition amounts and useful life;
•  Borrowings including addition/redemption amounts and interest rate;
•  Share Capital additions.


MODEL STRUCTURE

The model comprises of 9 tabs split into input ('i_'), calculation ('c_'), output ('o_') and system tabs. The tabs to be populated by the user are the input tabs ('i_Setup', ‘i_Actuals' and 'i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in 'o_Fin Stats', ‘o_Dashboard' and ‘o_DCF'.


KEY FEATURES

•  The model follows best practice financial modelling guidelines and includes instructions, line-item explanations, checks and input validations;
•  The model is not password protected and can be modified as required following download;
•  The model contains a dynamic timeline that allows for a mix of actual and forecast period across a 5-year period allowing projections to be rolled forward from month to month;
•  Timeline is split on a monthly basis and summarised on an annual basis;
•  Costs are split into: direct and non-direct for better driver-based forecasting;
•  The model allows for the following number of underlying categories for each line item (these can be easily expanded if required):
•  Finance lease categories – 10 categories;
•  Operating lease categories – 10 categories
•  Interest-bearing liability categories – 10 categories;
•  Financial investments – 5 categories;
•  Staff costs – 8 categories;
•  Marketing costs – 5 categories;
•  Admin expenses – 15 categories;
•  Fixed Assets – 5 categories;
•  Borrowings – 3 facilities;
•  Apart from projecting revenue and costs the model includes the possibility model fixed assets, borrowings, dividends, corporate tax and sales tax;
•  The model included an integrated discounted cash flow valuation using the projected cash flow outputs;
•  Business name, currency, starting projection period are fully customisable;
•  Revenue, cost, fixed asset and borrowing category descriptions are fully customisable;
•  The model includes instructions, checks and input validations to help ensure input fields are populated accurately;
•  The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors.

MODIFICATIONS

If you require any be-spoke modifications to the tool, we are more than happy to assist with this. Please send us a message via the website or contact us on:

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Real Estate, Integrated Financial Model Excel: Leasing Company Financial Projection Model Excel (XLSX) Spreadsheet, Projectify


$99.00
This financial model is built by former Deloitte financial modeling professionals, accountants, and CFA charterholders. Their financial models have been used by over 4,000+ clients worldwide.
Add to Cart
  

ABOUT THE AUTHOR

Author: Projectify
Additional documents from author: 119
Terms of usage (for all documents from this author)

We are financial modelling professionals, accountants and CFA charterholders with experience working within Deloitte supporting clients with their financial planning and decision support needs. Our aim is to provide robust and easy-to-use financial models that follow good practice financial modelling guidelines and assist individuals and businesses with key financial planning and analysis ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials

 
"Flevy is now a part of my business routine. I visit Flevy at least 3 times each month.

Flevy has become my preferred learning source, because what it provides is practical, current, and useful in this era where the business world is being rewritten.

In today's environment where there are so "

– Omar Hernán Montes Parra, CEO at Quantum SFE
 
"As a consulting firm, we had been creating subject matter training materials for our people and found the excellent materials on Flevy, which saved us 100's of hours of re-creating what already exists on the Flevy materials we purchased."

– Michael Evans, Managing Director at Newport LLC
 
"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.

Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I "

– Nishi Singh, Strategist and MD at NSP Consultants
 
"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy
 
"Flevy.com has proven to be an invaluable resource library to our Independent Management Consultancy, supporting and enabling us to better serve our enterprise clients.

The value derived from our [FlevyPro] subscription in terms of the business it has helped to gain far exceeds the investment made, making a subscription a no-brainer for any growing consultancy – or in-house strategy team."

– Dean Carlton, Chief Transformation Officer, Global Village Transformations Pty Ltd.
 
"As an Independent Management Consultant, I find Flevy to add great value as a source of best practices, templates and information on new trends. Flevy has matured and the quality and quantity of the library is excellent. Lastly the price charged is reasonable, creating a win-win value for "

– Jim Schoen, Principal at FRC Group
 
"FlevyPro has been a brilliant resource for me, as an independent growth consultant, to access a vast knowledge bank of presentations to support my work with clients. In terms of RoI, the value I received from the very first presentation I downloaded paid for my subscription many times over! The "

– Roderick Cameron, Founding Partner at SGFE Ltd
 
"I like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Senior Executive Director at Technology Transformation Advisory


Your Recently Viewed Documents


Customers Also Like These Documents

Related Management Topics


Integrated Financial Model Real Estate Financial Analysis M&A (Mergers & Acquisitions)

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more.