top of page

Leasing Sales and Differentiation Techniques (Excel Applied)

Duration: 1 day

Instructor: Fatih KURAN

Objective

In leasing transactions, the calculation of lease payments varies based on the Lessee's needs and demands, the payment methods to vendors, and the funding structure of the leasing company. For leasing professionals, it is crucial to accurately calculate basic lease structures, conduct efficiency assessments, and prepare and interpret amortization schedules.


This course aims to provide participants with the foundational knowledge required to perform leasing calculations, enabling them to create lease payment plans effectively.

Who Should Attend

• Leasing professionals

• Machinery and equipment vendors

• Lessees

• Finance and accounting professionals

• Anyone involved in leasing or investment financing

Purpose

• Master the fundamental concepts of financial mathematics.

• Gain expertise in preparing various lease payment plans.

• Acquire knowledge about different leasing applications and calculations.

Content

1. Time Value of Money

• Calculating Future Value

• Calculating the Net Future Value of Cash Flows

o Calculating Present Value

o Calculating the Net Present Value (NPV) of Cash Flows

2. Interest Rates

• Nominal Interest Rate

• Compound Interest Rate

3. Fixed Lease Payment Calculations

• Payments at the Beginning of the Period

• Payments at the End of the Period

• Payments with Down Payments

• Payments with Grace Periods

4. Internal Rate of Return (IRR)

5. Amortization Schedules

• Handling Letters of Credit Payments and Import Expenses in Lease Plans

6. Introduction to Operating Leasing Pricing

* The course involves Excel applications, and participants are required to bring laptops with Excel 2013 or a higher version installed.

©2024, founded by Dinamo Consulting.

bottom of page