Show TOC

Procedure documentationDisplaying Interest and Capital Amounts

 

You can display the interest and capital amounts for a loan account.

Prerequisites

You have fulfilled the prerequisites of the Display Cash Flow function, which apply for the calculation and display of interest and capital amounts. For more information, see the Displaying Cash Flows in the section Prerequisites.

In Customizing for Account Management (FS-AM) under Start of the navigation path Product Management Next navigation step Product Definition Next navigation step Account Products Next navigation step Create or Change Account Product End of the navigation path, you have selected the relevant product attributes such as Work Rule.

Procedure

  1. On the SAP Easy Access screen, choose Start of the navigation path Account Management Next navigation step Account Next navigation step Turnovers, Balances and Key Figures Next navigation step Display Balances and Key Figures End of the navigation path.

  2. Enter the bank account details for the loan account and choose the Interest and Capital Amts tab page.

  3. Enter the To Date until which the system is to consider the account values. If you leave the Capital Amounts for Display field empty, the report displays the SAP standard capital amounts that can be selected in the input help (see below). However, you can select the individual capital amounts your defined for display.

  4. Choose Start of the navigation path Program Next navigation step Execute End of the navigation path.

Note Note

In the Customizing activity Define Customer-Specific Capital Amounts, you can define your own capital amounts. You can use the Display Capital Amount field to control whether the report can display the capital amount.

End of the note.

Result

The system displays the product according to the following values:

Header
  • Key date

    Date on which the system calculates the capital amounts The key date is the same as the To Date entered.

  • Next installment

    Amount that is or was to be paid on or after the key date as the next Receivable Installment.

  • Next payment

    Date of the next installment

  • Interest percentage each day

    Interest each day divided by the calculation basis amount on the key date

  • Interest per day

    Interest amount on the key date

  • Contract currency

    Interest currency

SAP Capital Amounts
  • Contract capital

    The committed limit of the contract.

  • Current contract capital

    Amount that corresponds to the contract capital, taking into account all capital reductions and capital increases whose value date is not after the key date.

  • Commitment capital

    Amount for which the bank and account holder have a binding agreement for a fixed condition period.

  • Current commitment capital

    Amount that corresponds to the commitment capital, taking into account all capital reductions and capital increases whose value date is not after the key date.

  • Disbursed capital

    Total of posted and planned disbursements whose value date is not after the key date.

  • Disbursement obligation

    Amount resulting from the difference between the current contract capital and the disbursed capital.

  • Available amount

    Amount that an authorized drawer can withdraw freely from an account.

    • Accounts

      The system calculates the amount as follows:

      + Account Balance

      - Balance Subject to Final Payment (only for a credit balance)

      + Balance of prenotes subject to posting control

      + total limit or

      - Minimum deposit

      ------------------------------------------------------------

      =available amount

      The total of items in the future is contained in the account balance and is not excluded from it. For payment items that are transferred automatically to the system, the available amount can be increased by the tolerance amount. The available amount is not specific to one key date. The available amount includes all posted payment items, prenotes - irrespective of their posting or value date, and all limits that are valid on the current posting date for payment transactions.

    • Loan

      The system calculates the amount as follows:

      + Contract Capital (= committed and tolerated limit), adjusted for increases and reductions to capital

      - Outpayment total

      - Total of capital amounts scheduled for disbursement (= future disbursements)

      -------------------------------------------------------------

      =available amount

    • Revolving Loan

      The system calculates the available amount as follows:

      + Contract capital (= committed and tolerated limit)

      - Outpayment total

      - Total of capital amounts scheduled for disbursement (= future disbursements)

      + Payoffs that increase disbursement obligation

      ------------------------------------------------------------

      =available amount

  • Available amount without tolerated limit

    Amount that an authorized drawer can withdraw freely from an account.

    • Loan

      The system calculates the available amount as follows:

      + Contract Capital (= committed limit), adjusted for increases and reductions to capital

      - Outpayment total

      - Total of capital amounts scheduled for disbursement (= future disbursements)

      -----------------------------------------------------------

      =available amount

    • Revolving Loan

      The system calculates the available amount as follows:

      + Contract Capital (= committed limit), adjusted for increases and reductions to capital

      - Outpayment total

      - Total of capital amounts scheduled for disbursement (= future disbursements)

      + Payoffs that increase disbursement obligation

      -----------------------------------------------------------

      =available amount

  • Interest calculation capital

    Total of all posted disbursements plus posted, capitalized interest, charges, and insurance less posted repayments The system calculates the posted repayments as follows:

    • For loans that use the payment plan principle, the system includes posted repayment settlements.

    • For loans that use the incoming payment principle, the system includes posted repayments. The system posts the repayments with settlement after the installment is received.

  • Planned capital

    Total of all scheduled disbursements plus scheduled , capitalized interest, charges, and insurance less scheduled repayments The positions can be posted and paid already. The system supports planned capital only for loans that use the payment plan principle. The system calculates and displays the planned capital dependent on the working rule of the product.

  • Remaining capital

    Total of all posted disbursements plus posted, capitalized interest, charges, and insurance less posted repayment settlements The positions can be paid already. The system supports remaining capital only for loans that use the payment plan principle. The system calculates and displays the remaining capital dependent on the working rule of the product.

  • Effective capital

    Total of all posted disbursements plus posted, capitalized interest, charges, and insurance less paid repayments

    The system calculates the paid repayments as follows:

    • For loans that use the payment plan principle, the system includes turnovers of the category Repayment Payments and Curtailment Payments that have posted status.

    • For loans that use the incoming payment principle, the system includes the repayment share of turnovers of the category Repayment Payments and Curtailment Payments that have posted status.

    To make the repayment share of an installment payment immediately visible in the effective capital, the system executes a settlement simulation when calculating the effective capital. The system executes the settlement simulation up to the date on which incoming payments exist already. Settlement simulation includes interest-, charge-, and insurance capitalizations. It is executed without payment simulation.

  • Incurred interest for the current month

    Posted interest plus the pro rata interest not yet posted for the analysis period from the first day of the key date month until the key date.

  • Incurred interest for the current year

    Posted interest plus the pro rata interest not yet posted for the analysis period from the first day of the key date year until the key date.

  • Posted outstanding interest for the current month

    Interest to be paid minus the paid interest for the analysis period from the first day of the key date month until the key date. The system includes the turnovers of Interest to Pay posted by the settlement minus the posted and paid interest, that is the turnovers of Interest Paid (Cleared with Installment Payment) or Interest Payments (Planned Principle). The turnovers of Interest to be Capitalized are not included in the calculation. Prepayments made for interest reduce the amount of outstanding interest.

  • Posted outstanding interest for the current year

    Interest to be paid minus the paid interest for the analysis period from the first day of the key date year until the key date. The system includes the turnovers of Interest to Pay posted by the settlement minus the posted and paid interest, that is the turnovers of Interest Paid (Cleared with Installment Payment) or Interest Payments (Planned Principle). The turnovers of Interest to be Capitalized are not included in the calculation. Prepayments made for interest reduce the amount of outstanding interest.

  • Settled interest

    Posted interest for the period being considered from the contract start date to the key date. The turnovers of Interest to be Capitalized are included in the calculation. Unposted interest is not included in the calculation.

  • Paid interest

    Amount of paid interest from start of contract to the key date that has posted status.

  • Outstanding interest

    Interest to be paid minus paid interest The system includes the posted and proportional, not yet paid turnovers of Interest to Pay posted by the settlement minus the posted and paid interest, that is the turnovers of Interest Paid (Cleared with Installment Payment) or Interest Payments (Planned Principle). The turnovers of Interest to be Capitalized are not included in the calculation. Prepayments made for interest reduce the amount of outstanding interest.

  • Accrued interest, not settled

    Interest that the system has not yet posted, for the analysis period from the contract start until the key date.

  • Incurred interest on arrears, not settled

    Pro rata interest on arrears that the system has not yet posted, for the analysis period from the contract start until the key date. The system supports accrued interest on arrears only for loans that use the payment plan principle. The system calculates and displays the accrued interest on arrearsl dependent on the working rule of the product.

Example

The following contract arises from the loan origination:

Contract start date

27. 01. 1986

Contract capital:

EUR 300,000

1. Fixing phase:

28. 09. 1986 until 09/27/1991

Reference date for condition fixing:

31. 07. 1986

Commitment capital (1):

EUR 300,000

Fixed interest rate:

9% p.a.

Annuity repayment:

1% p.a.

Commitment interest:

1.5% p.a.

Annuity calculation:

Quarterly: Calculation date on last day of each quarter

Annuity payment:

Quarterly; due date on last 15th of each quarter; working day shift

Commitment interest calculation:

Monthly

Commitment interest payment:

Quarterly on 31st; working day shift

After five years, the contract is extended for another 10 years:

2. Fixing phase:

28. 09. 1991 until 09/27/2001

Reference date for condition fixing:

03. 10. 1990

Commitment capital (1):

EUR 220,000

Fixed interest rate:

10 % p.a.

Annuity repayment:

3 %

Annuity calculation:

Quarterly: Calculation date on last day of each quarter

Annuity payment:

Quarterly; Due date on 5th of next month; working day shift

The following events took place during this time:

Manual charge:

EUR 3,000 on 06/11/1986, paid at the start

1. Disbursement:

EUR 100,000 on 06/26/1987

Capital reduction:

EUR 50,000 on 08/26/1988

2. Disbursement:

EUR 100,000 on 12/22/1989

Capital increase:

EUR 150,000 on 07/26/1993

Last disbursement:

EUR 200,000 on 09/17/1993