1. Finance Active
  2. Fairways Debt
  3. Reporting & Distribution
  4. Reports
  5. Indicators

Accrued Rent

  • Public

Updated .

Spot Reports

Accrued Rent (in advance)

Aggregated amount of rents to pay on the report date, based on the actual payment date, in the currency applied to the report:

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

Note: The Accrued Rent (in advance) indicator only applies to leases in advance.

 

Example 1 - Unadjusted Payment Date - Different Report Date

On 10 May 2021, the accrued rent of 0041 is EUR 83 972,07.

Rent_Accrued_Advance_EN.png

  • The report date is 10 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 120,54.
  • The period lasts 31 days.
  • There are 26 days between the report date on 10 May 2021 and the end date of the schedule period on 5 June 2021.

0041_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 120,54 / 31 * 26

= 83 972,07

 

Example 2 - Unadjusted Payment Date - Same Report Date

On 5 May 2021, the accrued rent of 0041 is EUR 100 120,54.

Rent_Accrued_Advance_2_EN.png

  • The report date is 5 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 120,54.
  • The period lasts 31 days.
  • There are 31 days between the report date on 5 May 2021 and the end date of the schedule period on 5 June 2021.

0041_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 120,54 / 31 * 31

= 100 120,54

 

Example 3 - Following Payment Date

On 3 May 2021, the accrued rent of 0042 is EUR 8 010,66.

Rent_Accrued_Advance_3_EN.png

  • The report date is 3 May 2021, corresponding to the 5 April - 5 May 2021 period of the transaction.
  • The payment amount for the 5 April - 5 May 2021 period is EUR 100 133,31.
  • The payment date of the 5 April - 5 May 2021 period is 10 April 2021, reducing the 5 April - 5 May 2021 period to a 10 April - 5 May 2021 period.
  • The 10 April - 5 May 2021 period lasts 25 days.
  • There are 2 days between the report date on 3 May 2021 and the end date of the schedule period on 5 May 2021.

0042_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 133,31 / 25 * 2

= 8 010,66

 

Example 4 - Following Payment Date

On 5 May 2021, the accrued rent of 0042 is EUR 0.

Rent_Accrued_Advance_4_EN.png

  • The report date is 5 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment date of the 5 May - 5 June 2021 period is 10 May 2021, reducing the 5 May - 5 June 2021 period to a 10 May - 5 June 2021 period.
  • 5, 6, 7, 8, and 9 May 2021 do not belong to any period, the accrued rent is therefore 0.

0042_EN.png

 

Example 5 - Preceding Payment Date

On 17 May 2021, the accrued rent of 0046 is EUR 52 841,40.

Rent_Accrued_Advance_5.png

  • The report date is 17 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for the 5 May - 5 June 2021 period is EUR 100 120,54.
  • The payment date of the 5 May - 5 June 2021 period is 30 April 2021, increasing the 5 May - 5 June 2021 period to a 30 April - 5 June 2021 period.
  • The 30 April - 5 June 2021 period lasts 36 days.
  • There are 19 days between the report date on 17 May 2021 and the end date of the schedule period on 5 June 2021.

0046_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 120,54 / 36 * 19

= 52 841,40

 

Example 6 - Interest Manually Updated

On 17 May 2021, the accrued rent of 0047 is EUR 61 294,73.

Rent_Accrued_Advance_6_EN.png

  • The report date is 17 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 300.
  • The period lasts 31 days.
  • There are 19 days between the report date on 17 May 2021 and the end date of the schedule period on 5 June 2021.

0047_EN.png

  • The interest amount for that period has been manually updated, from EUR 120,54 to EUR 300.

0047_Audit_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period - (current interest amount of the schedule period - initial interest amount of the schedule period)

= 100 300 / 31 * 19 - (300 - 120,54)

= 61 294,73

 

Accrued Rent (in arrears)

Aggregated amount of rents to pay on the report date, based on the actual payment date, in the currency applied to the report:

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

Note: The Accrued Rent (in arrears) indicator only applies to leases in arrears.

 

Example 1 - Unadjusted Payment Date - Different Report Date

On 10 May 2021, the accrued rent of 0043 is EUR 16 151,25.

Rent_Accrued_Arrears_EN.png

  • The report date is 10 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 137,78.
  • The period lasts 31 days.
  • There are 5 days between the start date of the schedule period on 5 May 2021 and the report date on 10 May 2021.

0043_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 5

= 16 151,25

 

Example 2 - Unadjusted Payment Date - Same Report Date

On 5 May 2021, the accrued rent of 0043 is EUR 0.

Rent_Accrued_Arrears_2_EN.png

  • The report date is 5 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 137,78.
  • The period lasts 31 days.
  • There are 0 days between the start date of the schedule period on 5 May 2021 and the report date on 5 May 2021.

0043_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 0

= 0

 

Example 3 - Following Payment Date

On 7 May 2021, the accrued rent of 0044 is EUR 106 610,50.

Rent_Accrued_Arrears_3_EN.png

  • The report date is 7 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for the 5 May - 5 June 2021 period is EUR 100 137,78.
  • The 5 May - 5 June 2021 period lasts 31 days.
  • There are 2 days between the start date of the schedule period on 5 May 2021 and the report date on 7 May 2021.
  • The next payment date is 10 May 2021, belonging to the 5 April - 5 May 2021 period of the transaction.
  • The payment amount for the 5 April - 5 May 2021 period is EUR 100 150.
  • The 5 April - 5 May 2021 period lasts 30 days.
  • There are 30 days between the start date of the schedule period on 5 April 2021 and the report date on 5 May 2021.

0044_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 2 + 100 150 / 30 * 30

= 106 610,50

 

Example 4 - Preceding Payment Date

On 17 May 2021, the accrued rent of 0045 is EUR 38 763,01.

Rent_Accrued_Arrears_4.png

  • The report date is 17 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 137,78.
  • The period lasts 31 days.
  • There are 12 days between the start date of the schedule period on 5 May 2021 and the report date on 17 May 2021.

0045_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 12

= 38 763,01

 

Example 5 - Preceding Payment Date

On 2 May 2021, the accrued rent of 0045 is EUR 0.

Rent_Accrued_Arrears_4_EN.png

  • The report date is 2 May 2021, corresponding to the 5 April - 5 May 2021 period.
  • The payment date of the 5 April - 5 May 2021 period is 30 April 2021, reducing the 5 April - 5 May 2021 period to a 5 April - 30 April 2021 period.
  • 30 April, and 1, 2, 3, and 4 May 2021 do not belong to any period, the accrued rent is therefore 0.

0045_EN.png

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more