Budget-Plan-Express - harmony planning
Strategic-Line
Download demo
First project
For Partners
Personal account

Skip to content


Financial planning

Structure plans in the Finance plan
Credit products. Planning tools
Credit products. Practical planning
Credit products. Methods and algorithms of calculation
Operating and financial leases. Practical planning
Reserves for future expenses. Planning Tools
Reserves for future expenses. Practical planning
Placed equity instruments. Planning Tools
Placed equity instruments. Practical planning

Operating and financial leases. Practical planning


Method for calculating leasing payments

In IFRS 17, leases are classified into financial and operating leases:

    1. Finance lease – provides for the transfer of substantially all risks and rewards associated with the use of the asset from the lessor to the lessee. Over time, the right of ownership of the leased asset can be transferred or not be transferred to the lessee.

    2. Operating leases is a lease other than financial lease.
In the settings of the program interface, financial lease differs from operating flag is set to "Redemption of asset". In addition, a Finance lease involves accounting asset (see "fixed assets and other assets").

Lease accounting in the financial statements varies depending on the type of lease:

Type of lease The order of reflection in the financial statements Implementation in Budget-Plan Express
Financial leases It is reflected in the balance sheet as an asset (leased property) and an obligation (lease obligation).

Initial costs are included in the cost of the leased asset.

During the lease period, depreciation is charged on the leased property.

Financial costs are reflected in the statement of cash flows in the line "Payment of finance leases."
Financial plan → Operating and financial leases → Settings Tab → to Set the flag "Redemption of the asset.". Tools leasing payment calculations.

Investment plan → fixed assets and other assets → Planning and accounting of assets: accumulated depreciation, cost, salvage, purchase, other transactions with the assets.

Investment plan → Investment assets → Investment property: reflection and accounting of investment property.
Operating leases Lease payments are accounted for and recognised in the statement of profit and loss as expenses over the term of the lease as incurred. Financial plan → Operating and financial leases. Tools leasing payment calculations.


The methodology for calculating leasing payments and scheduling their payments is almost the same as the methodology for calculating loans.
To account for financial leases, you need to set the flag " Redemption of an asset ".

Both for financial and operational leasing, a standard interface is used, described in the section: «Credit products. Planning tools», а также – алгоритмы расчетов и формулы, приведенные в разделе «Credit products. Methods and algorithms of calculation».


Purpose of the "payments" table

Each specific rental product includes its own "payment table". The "payment table" provides two modes - "calculation" and "data editing". Modes are switched depending on the setting of the flag "Payments, in accordance with the schedule":

  1. If the flag is disabled, the "Payment Table" will be blocked for editing, and is available for calculations.
  2. If the flag is set, the "payments" table will be available for editing, and vice versa, it is blocked for calculations.

Regardless of the flag setting, the lines "plan-factual deviations" are always available for editing.

If you use the edited table (that is, the "Payments, according to the schedule" flag is set), you must specify 2 parameters for the calculation:

  1. Amount of financing.
  2. If the amount of financing does not coincide with the amount of repayment of debt, the program will warn about the error: "Payments on the product do not correspond to the amount of debt."

  3. Funding period (start month, end month and duration).
  4. From the "Payment Table" only those payments that are included in the specified period will be considered.

    Other parameters for the edited table do not matter.


Planning of leasing (rental) products

The parameters of the product, in most cases, include:

  1. Amount of financing,
  2. Lease Term,
  3. Advance payment (% of the amount of financing),
  4. Leasing interest (% per annum),
  5. The amount of depreciation of leased property for the entire period (usually a percentage of the contract),
  6. Commission.
  7. Payment calculation formula (annuity, standard) and other settlement conditions,
  8. Periodicity of payments (month, quarter, half year, year),
  9. Payment Schedule .
Additionally, in planning a Finance lease, it is necessary to specify the costs associated with the use of the asset (depreciation and other costs): "Investment plan → fixed assets and other assets". In this case, the method proceeds of asset is considered as "other income" (switch).

The program can take into account the various options and conditions for the provision of leasing: the term of leasing, down payment, leasing interest, calculation formula, etc. At the stage of concluding a lease agreement, you can consider different scenarios of leasing payments and try to optimize costs.

If the contract is already concluded, and a payment schedule is drawn up, the ready schedule should be entered in the "payments" table.
VAT calculation of the lease payments is not taken into account and corrected in "the Plan of settlement with creditors".


Examples of scheduling payments. Finance lease

Example 1. Example of calculating the schedule of payments under a financial leasing agreement.

Conditions on the financial leasing contract: the contract terms, the equipment recorded on the balance sheet of the lessee, and at the end of the term of the agreement ownership passes to the lessee. The cost of the equipment 4 356 284, the term of the loan is 24 months, payment monthly. Designed schedule of payments during the whole period of the agreement: first payment is 20% of the amount of funding that is 856 871. The following months payments up 7/225 of the principal amount of debt (133 291), the sum of the last four payments is calculated as 10/225 (190 416) of the principal amount of the debt, and in the last month – 20/225 (380 832) of the principal amount of the debt.

Payment schedule for 1 and 2 years, by months:

Financial leasing – planning Budget-Plan Express



  1. step. Add new product: the item "add" (F2).

  2. step. Set the amount of "Rental product → Amount = 4 284 356".
  3. step. Set the period start – "product Rental → period"
  4. step. Set loan term – "product Rental → Duration = 24"

  5. step. Go to the "table of payments" and check the box to access the editing table: "Table of payments → flag Payments in accordance with the schedule"
  6. step. Make the payment schedule in a table as shown:

  7. Make the payment schedule in a table as shown


    Data can also be imported from a named range.

  8. step. Clear (reset) the table from the previous calculations. "Clear button → the Final table → ОК"
  9. step. Calculate. The "Calculation button → list box item Selected → ОК"
  10. A fragment of the calculation result table in the "financial plan":

    Schedule of payments for the entire period of the lease – Budget planning-Plan Express

    Total debt payments for a specified period should coincide with the amount of the contract, otherwise, this product will be ignored by the program with the error message: "Payment for the product does not correspond to the amount of the debt"!


Example 2. Example of calculation of the uniform payments under the contract of financial leasing.

Conditions on the financial leasing contract: the contract terms, the equipment recorded on the balance sheet of the lessee, and at the end of the term of the agreement ownership passes to the lessee. The cost of equipment 15 432 000, the term of the contract is 37 months at the rate 13,40%, first payment – 35% of the funding, then the payment of monthly annuities. Calculate annuities using different formulas for complex percent.

  1. step. Add new product: the item "add" (F2).
  2. step. Select a product from the list – "product Rental → product Type → Annuity".

  3. step. Set complex percent – the "General Settings → the Estimated percentage → complex".
  4. step. Set the amount of "Rental product → Amount = 15 432 000".
  5. step. Set rate – "Lease product → Rate = 13,40%"
  6. step. Set loan term – "product Rental → Duration = 37"

  7. step. Set the frequency of payments – the "Principal payments → payment Frequency → month"
  8. step. Calculate the amount of the first payment – "15 432 000 * 0,134 = 5 401 200"
  9. step. Set the amount of the first payment – "Principal payments → fixed amount → 5 401 200"

  10. step. Clear (reset) the table from the previous calculations. "Clear button → the Final table → ОК"
  11. step. Calculate. The "Calculation button → list box item Selected → ОК"

  12. Result: Interest paid for the whole period of the contract = 2 378 398, total payments = 17 810 398, annuity payment = 339 913.

    A fragment of the calculation result table in the "financial plan":

    A fragment of the calculation

    The same conditions is calculated according to the formula of "consumer" credit, when not accounted for interest money, less favorable for the tenant:

    Result - the interest Paid over the entire period of the contract = 7 309 165 total payment = 22 741 165, annuity payment = 476 178.


Example 3. Example of the calculation of annuities, taking into account interest money when advance payment are not included in the calculation of interest.

Conditions on the financial leasing contract: the contract terms, the equipment recorded on the balance sheet of the lessee, and at the end of the term of the agreement ownership passes to the lessee. The cost of equipment 500 000, at the rate of 15.00%, the contract period is 30 months, down payment – 15% of the funding. The payment of monthly annuities. In addition to interest payments, the insurance premium is 1.5% and the monthly amortization and depreciation of 3.45%. To calculate the annuities for complex percent.

  1. step. Add new product: the item "add" (F2).
  2. step. Select a product from the list – "product Rental → product Type → Annuity".
  3. step. Set complex percent – the "General Settings → the Estimated percentage → complex".

  4. step. Calculate the amount. As an advance, paid prior to the transfer of the product into rent, interest and money and other benefits will be calculated with the remaining amount. Advance (15%) = 500 000 * 0,15 = 75 000. The remaining amount = 500 000 - 75 000 = 425 000
  5. step. Set the amount of the debt is "Rental product → Amount = 425 000".
  6. step. Set the amount of the advance – "table of payments → "PAD – duty" in the first month of the contract = 75 000".

  7. step. Set loan term – "product Rental → Duration = 30"
  8. step. Set rate – "Lease product → Rate = 15,00%"
  9. step. Set the frequency of payments – the "Principal payments → payment Frequency → month"

  10. step. Set the insurance premium is 1.5% of "other payments → one-time payment → Rate = 1,50%"
  11. step. Set the monthly depreciation of 3.45% – "other payments → recurring payments → Rate = 3,45%"


  12. Specify other payments, as shown in the picture:

    Specify other payments, as shown in the picture


    Note you can specify both the payout percentage and payment amount.

  13. step. Clear (reset) the table from the previous calculations. "Clear button → the Final table → ОК"
  14. step. Calculate. The "Calculation button → list box item Selected → ОК"


  15. Interest money and other benefits will be calculated with the remaining amount


    Result: Interest paid for the entire period of the contract = 87 275, other payments = 24 045 total payments = 611 320, annuity payment = 17 665.





Help about the program "Budget-Plan Express", © Strategiс-Line, LLC | Help contents


© 2007-2019,  «Strategiс-Line», LLC,  support@strategic-line.ru, send a message ✉
   Home | Product | Buy | Reading | Contacts  
Рейтинг@Mail.ru