top of page

Advanced Leasing Mathematics and Applications (Excel-based)

Duration: 2 days

Instructor: Fatih KURAN

Objective

This course aims to develop participants' advanced reasoning and calculation skills in complex leasing transactions. By the end of the program, participants will be able to calculate lease payments, installments, and costs for leasing and alternative investment loans, gaining a competitive edge in sales.

Who Should Attend

• Leasing professionals

• Machinery and equipment vendors

• Lessees

• Finance and accounting professionals

• Anyone interested in learning advanced leasing calculation techniques

Purpose

• Prepare all types of leasing payment plans.

• Understand how to handle VAT offsets for fixed assets.

• Analyze the cost of alternative investment financing loans and compare them with leasing.

• Gain insights into different leasing applications and calculations.

Content

1. Variable and Non-Uniform Lease Payment Schedules

• Non-Uniform Lease Structures

• Hybrid Lease Structures with Intermittent Payments

2. Advanced Amortization Schedules

• Amortization Schedules for Increasing Payment Lease Plans

• Cash Flow-Based Amortization Schedules

3. Vendor Credit Transactions in Leasing

• Discount Method

• Net Value Offset Approach

• Prepayment with Interest Approach

• Calculating Partial Vendor Payments

4. Fixed Asset VAT Offsetting in Financial Leasing

• Definition of VAT Offsetting for Fixed Assets

• Risks in Offsetting Transactions

• Offsetting VAT on Leases

• VAT Pool Offsetting Approach

• TL-Based Interest Offset

• Foreign Currency-Based Interest Offset

5. Alternative Investment Financing Tools and Interest Calculations

• Bank Loans

• ECA Loans

• Forfaiting

6. Lease Plan Restructuring and VAT Offset Impact

• Calculating Efficiency in Leasing Transactions

7. Value-Adding Alternatives

• Fixing Investment Costs

• Exchange Rate and Parity Fixing

• Currency Baskets

8. Special Leasing Applications

• Balloon Payments and Extension Options

• Variable Interest Transactions with Fixed Principal Offsetting

• Lease Calculation Tables Using Actual Day Counts


* 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