CFP data processing - Create object events

FX hedging¶

The system processes hedges, not excluded from the calculation, which have expiry dates between the estimate start and end date.

If the “Option” field is active for the processed object, the system only creates the FX rate hedge if the budget FX rate is more advantageous than the contract FX rate, otherwise the FX rate hedge is always created.

For every hedge, the system creates the following events with origin “CFP - FX hedging” (CFP_EXCHRATE_COVERAGE):

event “$C04” - FX hedging event in original currency, with the following characteristics:
currency equal to the hedge currency;
currency amount equal to the amount of the hedge;
countervalue equal to the amount of the hedge converted into the entity currency at the budget FX rate
event “$C03” - FX hedging event in entity currency, with the following characteristics:
currency equal to the entity currency
currency amount equal to the amount of the hedge converted into the entity currency, and changing sign, at the reference FX rate
countervalue equal to the currency amount
event “$C01” - FX hedging debit FX rate difference or “$C02” - FX hedging credit FX rate difference, with the following characteristics:
currency equal to the entity currency;
currency amount 0
countervalue equal to the difference between the countervalues of the two previous events

L/T Financing¶

The system processes the L/T financing not excluded from the calculation, with a L/T financing start date or preamortisation start date prior or equal to the estimate end date.

The origin of all events is “CFP - L/T financing” (CFP_LT_FINANCING).

The system:

creates the L/T financing opening events. The opening date of these events is the L/T financing start date or, in cases of preamortisation, the preamortisation start date.

If the L/T financing opening date falls between the estimate start and end date the system also creates the following events:

event “$F01” - Opening with currency amount being the initial value of the L/T financing
event “$F03” - Matured with currency amount being the matured coupon accrual
event “$F02” - “Commission with currency amount being the value obtained from the following expression “initial value * commission percentage / 100”
calculates the value of the financing as the sum of the initial value and the project financing total
if the instalment type is “Fixed capital”, it performs the calculation of the capital instalment amount or number of instalments
if the instalment type is “Fixed total managed by rate”, it performs the calculation of the total instalment amount or number of instalments
processes the preamortisation. In particular:
it determines the interest payment dates by adding the interest payment frequency multiples to the preamortisation start date; if the interest payment frequency is zero, the payment is made at the L/T financing start date;
it determines the interest capitalisation dates by adding the interest capitalisation frequency multiples to the preamortisation start date; if the interest capitalisation frequency is zero, the capitalisation is performed at the L/T financing start date
it calculates the rate to be used for generating interest. In particular:
if a rate type is not indicated, it uses the fixed rate as the value
if a rate type is indicated, it uses that rate type plus the spread as the value. If the rate is “Periodic variable interest rate”, it uses the relative rate for each month, otherwise it uses the rate of the instalment start month for the whole period
it calculates the rate to be used for the hedging of rates. In particular:
if a rate type is not indicated, it uses the fixed rate as the value
if a rate type is indicated, it uses that rate type (calculated following the lower and upper limit rules, if defined), plus the spread, as the value. If the rate is “Periodic variable interest rate”, it uses the relative rate for each month, otherwise it uses the rate of the instalment start month for the whole period
it creates the following events at the interest payment date:
event “$F08” - Interest payment with the currency amount being the value of the interest payable (this is the sum of the interest payable from the previous payment date to the current date)
event “$F10” - Interest payment write off with the currency amount being the value of the interest payable (this is the sum of the interest payable from the previous payment date to the current date) * -1 only if the interest rate hedging calculation is set:
if the interest rate hedging calculation is set, then, at the hedging interest payment date, it creates event “$F09” - Interest rate hedging interest payment, with the currency amount being the value of the interest payable (this is the sum of the interest payable from the previous payment date to the current date)
at the interest capitalisation date, it increases the value of the L/T financing by an amount equal to the sum of the interest to be capitalised from the previous capitalisation date to the current date
at the project financing date, it increases the value of the L/T financing and creates event “$F13” - Project financing with the currency amount being the project financing amount
at every month-end, it creates:
an accrued interest billing event “$F04” - Accrued interest with the currency amount being the result of the expression indicated in the following table

Calculation type - interest months	Calculation type - interest days	Expression
Calendar Year	Calendar Year	Effective month numbers * rate / 36500
Calendar Year	Commercial	Effective month numbers * rate / 36000
Commercial	Calendar Year	Numbers of 30 days * rate / 36500
Commercial	Commercial	Numbers of 30 days * rate / 36000

If the interest rate hedging calculation is set, it also creates the following events:

event “$F07” - Accrued interest write off with currency amount being the amount of event P&L interest * -1
event “$F06” - Interest rate hedging interest with the currency amount being the result of the expression indicated in the following table

Calculation type - interest months	Calculation type - interest days	Expression
Calendar Year	Calendar Year	Effective month numbers * rate / 36500
Calendar Year	Commercial	Effective month numbers * rate / 36000
Commercial	Calendar Year	Numbers of 30 days * rate / 36500
Commercial	Commercial	Numbers of 30 days * rate / 36000

at every month-end, it performs the calculation of the short-term portion and creates event “$F14” – Transfer to current portion with the currency amount being the amount of the portion to be repaid within 12 months from the current date, subtracting the amounts calculated previously
at every month-end, it creates write off event “$F15” from the current amount if capital amounts have been repaid in the period with the currency amount being the amount of the capital portion repaid in the period
processes the L/T financing. In particular:
it determines the interest payment dates by adding multiples of the interest payment frequency to the L/T financing start date
it determines the interest capitalisation dates by adding multiples of the interest capitalisation frequency to the L/T financing start date
it determines the capital repayment dates by adding multiples of the interest capitalisation frequency to the L/T financing start date
it calculates the rate to be used for generating interest. In particular:
if a rate type is not indicated, it uses the fixed rate as the value
if a rate type is indicated, it uses that rate type plus the spread as the value. If the rate is “Periodic variable interest rate”, it uses the relative rate for each month, otherwise it uses the rate of the instalment start month for the whole period
it calculates the rate to be used for the hedging of rates. In particular:
if a rate type is not indicated, it uses the fixed rate as the value
if a rate type is indicated, it uses that rate type (calculated following the lower and upper limit rules, if defined), plus the spread, as the value. If the rate is “Periodic variable interest rate”, it uses the relative rate for each month, otherwise it uses the rate of the instalment start month for the whole period
at the interest payment date, it creates event “$F08” - Interest payment with the currency amount being the value of the interest payable (this is the sum of the interest payable from the previous payment date to the current date)
at the interest capitalisation date, it creates a capitalisation event: “$F05” - Interest capitalisation with the currency amount being an amount equal to the sum of the interest to be capitalised from the date of the previous capitalisation to the current date and increases the value of the L/T financing by that amount
at the capital repayment date, it creates a capital repayment event: “$F11” - Repayment of capital amount with the currency amount being the amount of the instalment
at the early repayment date, it creates a capital repayment event: “$F11” - Repayment of the capital amount with the currency amount being the amount of the early repayment or total repayment of the L/T financing if the “total repayment” option is active
at the interest payment date, creates an interest payment event: “$F08” - Interest payment with the currency amount being the amount of interest payable (this is the sum of the interest payable from the previous payment date to the current date)
If the interest rate hedging calculation is set, it creates event “$F10” – Write off of interest payments with the currency date being the amount of interest payable (this is the sum of the interest payable from the previous payment date to the current date) * -1
at the hedging interest payment date, if the interest rate hedging calculation is active, it creates the event: “$F09” - interest rate hedging interest payment with the currency amount being the amount of interest payable (this is the sum of the interest payable from the previous payment date to the current date)
at every month-end, it creates:
an accrued interest recognition event: “$F04” - Accrued interest with the currency amount being the result of the expression indicated in the following table

Calculation type - interest months	Calculation type - interest days	Expression
Calendar Year	Calendar Year	Effective month numbers * rate / 36500
Calendar Year	Commercial	Effective month numbers * rate / 36000
Commercial	Calendar Year	Numbers of 30 days * rate / 36500
Commercial	Commercial	Numbers of 30 days * rate / 36000

If the interest rate hedging calculation is set, it also creates the following events:

event “$F07” - Accrued interest write off with the currency amount being the amount of the “Accrued Interest” event * -1
event “$F06” - Interest rate hedging interest with the currency amount being the result of the expression indicated in the following table

Calculation type - interest months	Calculation type - interest days	Expression
Calendar Year	Calendar Year	Effective month numbers * rate / 36500
Calendar Year	Commercial	Effective month numbers * rate / 36000
Commercial	Calendar Year	Numbers of 30 days * rate / 36500
Commercial	Commercial	Numbers of 30 days * rate / 36000

at every month-end, it performs the calculation of the short-term portion and creates event “$F14” – Transfer to current portion with the currency amount being the amount to be repaid within 12 months from the current date, subtracting the amounts calculated previously
at every month-end, it creates the write off event from the current amount if capital amounts have been repaid in the event period: “$F15” - Write off from current amount with the currency amount being the capital amount repaid in the period

Assets¶

The origin of all events created by this process is “CFP - assets” - (CFP_FIXED_ASSET).

The system:

performs the processing of the leasing (only for assets with “Funding type” equal to Leasing). The method that the system uses to calculate the leasing is that which is specified in the asset class and if the FP Leasing calculation type is different from the Financial statement leasing calculation type, the system performs both calculations to generate entity journals

CASE 1: leasing calculation using the Financial (IAS) method

if the purchase date is between the estimate start and end date, it creates the following events:
recognises the asset for the assets calculation
event “$A20” - Enter into leasing contract, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the Contract value amount indicated in the leasing definition
event date equal to the Contract date indicated in the leasing definition
event “$A31” - Leasing contract deposit payment, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the value obtained by applying the Deposit percentage to the Contract value indicated in the leasing definition if the Deposit percentage has been entered, otherwise equal to the Deposit value
event date equal to the Contract date indicated in the leasing definition
tax rate equal to the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
monthly interest recognition:
in cases of Instalment type - In arrears, it creates event “$A29” - Monthly leasing interest in arrears, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the value of the portion of the month calculated on the basis of the leasing fee interest
event date equal to the last day of the month
in cases of Instalment type - Advanced, it creates event “$A27” - Advanced monthly leasing interest, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the value of the portion of the month calculated on the basis of the leasing fee interest
event date equal to the first day of the month
periodic fees recognition. The system determines the interest payment dates and capital amounts by adding the multiples of the Frequency of instalments payment to the Contract date indicated in the leasing definition.
in cases of Instalment type - In arrears, it creates event “$A30” - Leasing interest payment in arrears with the amount being the amount of the fee interest and the currency being the Contract currency indicated in the leasing definition
it creates event “$A26” - Capital amount payment, with the following characteristics
currency equal to the Contract currency indicated in the leasing definition
amount equal to the value of the capital amount of the fee
tax rate equal to the value of the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
buyback payment. The system determines the buyback date by adding multiples of the Frequency of instalments payment to the Contract date indicated in the leasing definition the same amount of times as the number of fees to be paid, and:
creates event “$A26” - Capital amount payment, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
amount equal to the value of the buyback amount indicated in the leasing definition
tax rate equal to the value of the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
makes the asset disposable in cases where sales are envisaged for the reference object

CASE 2: leasing calculation using the Balance sheet (civil code) method

if the purchase date is between the estimate start and end date, it creates the following events:
event “$A24” - Advanced periodic leasing fee, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount if the Deposit percentage is defined, the amount is calculated by applying that percentage to the Contract value indicated in the leasing definition. Otherwise, the amount is defined using the Deposit value
event date equal to the Contract date indicated in the leasing definition
tax rate equal to the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
event “$A23” - Leasing fee payment, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the value obtained by applying the Deposit percentage to the Contract value indicated in the leasing definition if the Deposit percentage has been entered, otherwise equal to the Deposit value
event date equal to the Contract date indicated in the leasing definition
tax rate equal to the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
for all period-ends from the contract start date to the contract end date, it recognises the monthly portion of the fee by creating event “$A21” - Advanced monthly leasing fee, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the portion of the month calculated on the basis of the deposit calculated previously
event date equal to the Contract date indicated in the leasing definition
periodic fee recognition. The system determines the fee recognition and payment dates by adding the multiples of the Frequency of instalments payment to the Contract date indicated in the leasing definition.
in cases of Instalment type - In arrears, it creates event “$A25” Monthly leasing fee in arrears, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the amount of the fee (interest + capital)
tax rate equal to the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
in cases of Instalment type - Advanced, it creates event “$A24” Advanced periodic leasing fee, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
currency amount equal to the amount of the fee (interest + capital)
tax rate equal to the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
it creates event “$A23” - Leasing fee payment, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
amount equal to the amount of the fee (interest + capital)
tax rate equal to the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
for all period-ends from the contract start date to the contract end date, it bills the monthly portion of the fees:
in cases of Instalment type - In arrears it creates event “$A22” - Monthly leasing fee in arrears with the currency being the Contract currency indicated in the leasing definition and the currency amount being the portion of the month calculated with reference to the total amount of the fee
in cases of Instalment type - Advanced it creates event “$A21” - Advanced monthly leasing fee with the currency being the Contract currency indicated in the leasing definition and the currency amount being the portion of the month calculated with reference to the total amount of the fee
buyback payment. The system determines the buyback date by adding multiples of the Frequency of instalments payment to the Contract date indicated in the leasing definition the same amount of times as the number of fees to be paid, and:
creates event “$A01” - Assets purchase, with the following characteristics:
currency equal to the Contract currency indicated in the leasing definition
amount equal to the value of the Redemption amount indicated in the leasing definition
tax rate equal to the value of the Tax Rate indicated in the leasing definition
non-deductible percentage equal to the Non-deductible percentage indicated in the leasing definition
other tax rate equal to the Other tax rate indicated in the leasing definition
credit terms equal to the asset purchase credit terms
payment calendar equal to the asset purchase payment calendar
weight equal to the asset purchase weight
recognises the asset for the assets calculation
performs data processing on assets in progress. The system analyses all events that take place during the life of an asset in chronological order
if the purchase date is between the estimate start and end date, it creates the following events:
event “$A03” Purchase of assets in progress, with the following characteristics:
currency equal to the purchase currency
currency amount equal to the asset purchase amount
tax rate equal to the asset purchase tax rate
non-deductible percentage equal to the asset purchase non-deductible percentage
other tax rate equal to the asset purchase other tax rate
credit terms equal to the asset purchase credit terms
payment calendar equal to the asset purchase payment calendar
weight equal to the asset purchase weight
event “$A08” - Purchase down payment write off with the currency amount being the amount of any down payments generated previously
if the sale date is between the estimate start and end date, it creates the following events:
event “$A11” - Sale of assets in progress, with the following characteristics:
currency equal to the sale currency
currency amount equal to the asset sale amount
tax rate equal to the asset sale tax rate
non-deductible percentage equal to the asset sale non-deductible percentage
other tax rate equal to the asset sale other tax rate
credit terms equal to the asset sale credit terms
payment calendar equal to the asset sale payment calendar
weight equal to the asset sale weight
event “$A17” - Assets under construction write off with the currency being the entity currency and the currency amount being the gross amount of the asset in progress
event “$A16” - Capital gain from asset currency / “$A15” - Capital loss from asset sale with the currency being the entity currency and the currency amount being the amount of the capital gain or loss from the sale of the asset
event “$A14” - Sale down payment write off with the currency amount being the amount of any down payments generated previously
if the date on which an asset in progress is transferred to assets is between the estimation start and end dates, it creates an event “$A04” - Transfer from in progress to asset with the currency being the entity currency and the currency amount being the amount of the transfer from in progress to asset
if the payment date is between the estimate start and end dates and prior to the purchase date, it creates an event “$A07” - Purchases down payment with the currency being the payment currency and the currency amount being the amount of the down payment
if the payment date is between the estimate start and end dates and subsequent to the purchase date, it creates event “$A05” - Asset purchase payment with the currency being the payment currency and the currency amount being the payment amount
if the collection date is between the estimate start and end dates and prior to the sale date, it creates an event “$A13” - Sales down payment collection with the currency being the collection currency and the currency amount being the down payment amount
if the collection date is between the estimate start and end dates and subsequent to the sale date, it creates an event “$A12” - Asset sales collection with the currency being the collection currency and the currency amount being the collection amount
processes assets. The system analyses all events that take place during the life of an asset in chronological order and calculates the value of an asset on the basis of an initial situation or purchase or a transfer from assets in progress to assets.
if the purchase date is between the estimate start and end date, it creates the following events:
event “$A01” - Assets purchase, with the following characteristics:
currency equal to the purchase currency
currency amount equal to the asset purchase amount
tax rate equal to the asset purchase tax rate
non-deductible percentage equal to the asset purchase non-deductible percentage
other tax rate equal to the asset purchase other tax rate
credit terms equal to the asset purchase credit terms
payment calendar equal to the asset purchase payment calendar
weight equal to the asset purchase weight
event “$A08” - Purchase down payment write off with the currency amount being the amount of any down payments generated previously
if the payment date is between the estimate start and end dates and prior to the purchase date, it creates event “$A07” - Purchases down payment with the currency being the payment currency and the currency amount being the amount of the down payment
if the payment date is between the estimate start and end dates and subsequent to the purchase date, it creates event “$A05” - Asset purchase payment with the currency being the payment currency and the currency amount being the payment amount
if the purchase billing date is between the estimate start and end dates, it creates event “$A02” - Asset purchase billing, with the currency being the billing currency and the currency amount being the billing amount
if the sale date is between the estimate start and end dates, the following events are created:
event “$A09” - Assets sale, with the following characteristics
currency equal to the sale currency
currency amount equal to the asset sale amount
tax rate equal to the asset sale tax rate
non-deductible percentage equal to the asset sale non-deductible percentage
other tax rate equal to the asset sale other tax rate
credit terms equal to the asset sale credit terms
payment calendar equal to the asset sale payment calendar
weight equal to the asset sale weight
event “$A19” - Assets in progress write off with the currency being the entity currency and the currency amount being the gross amount of the asset
event “$A18” - Assets fund write off with the currency being the entity currency and the currency amount being the gross amount of the fund
event “$A16” - Capital gain from asset sale / event “$A15” - Capital loss from asset sale with the currency being the entity currency and the currency amount being the amount of the capital gain or loss from the sale of the asset
event “$A14” - Sale down payment write off with the currency amount being the amount of any down payments generated previously
if the collection date is between the estimate start and end dates and prior to the sale date, it creates an event “$A13” - Sales down payment collection with the currency being the collection currency and the currency amount being the down payment amount
if the collection date is between the estimate start and end dates and subsequent to the sale date, it creates an event “$A12” - Asset sales collection with the currency being the collection currency and the currency amount being the amount of the collection
if the sale billing date is between the estimate start and end dates, it creates event “$A10” - Asset purchase billing, with the currency being the billing currency and the currency amount being the billing amount
depreciation calculation. If a reference date is specified for an asset purchase event or initial situation event, the system uses the average depreciation rates calculation, not the standard calculation.
standard depreciation rates calculation
for the purchase year, if the “purchase year depreciation rate” is equal to the “reduced rate”, then the reduced rate is applied, or the accelerated reduced rate if the object calculates accelerated depreciation; otherwise, the standard rate is applied, or the accelerated standard rate if the object calculates accelerated depreciation.
for standard years, the standard rate is applied, or the accelerated standard rate if the object calculates accelerated depreciation
for the sale year, if the “sale year depreciation rate” is equal to the “pro quote standard rate”, then the standard rate is applied, or the accelerated standard rate if the object calculates accelerated depreciation; otherwise, depreciation is not calculated
the values of the rates are retrieved from the asset class; if the object manages “customised rates” then they are retrieved from the object itself
average depreciation rates calculation:
calculates the year in which the asset would be fully depreciated using a standard rates calculation, replacing the purchase sate with the reference date.
calculates an average rate from the effective purchase date to the asset disposal date calculated previously so as to fully depreciate the asset
the value to be depreciated (based on the depreciation calculation) is always the asset’s period-end value
if the monthly splitting is in twelfths, every period counts as 1; if it is based on a weight for every period, the value of the weight is calculated. The total for the year is the sum of all periods in the year; in cases of portions, it is the total of the significant periods
creates, for every period, event “$A06” Asset depreciation with the currency being the entity currency and the currency amount being the value to be depreciated * depreciation rate * period weight / total weight
the depreciation calculation uses the tax rates if the FP Depreciation type defined for the asset class is set to Fiscal while it uses the statutory rates if the FP Depreciation type defined for the asset class is set to statutory
if the FP Depreciation type is different from the Financial statement depreciation type, the system calculates both depreciation types to create entity journals
if, in the general cash flow planning rules, the “Asset depreciation on actual data calculation” information is active, then the system also processes the actual assets by creating forecast depreciation. In such cases, it is necessary to open the actual scenarios / periods and link them together through the “previous scenario” and “actual scenario” attributes; it is not compulsory to relate them to the process being performed.
the system only processes assets that have not been excluded from the calculation.