MNC Intra-Group Exclusions — only used since 'Foreign MNC's Indian Subsidiary?' is Y
Per RBI guidance, intra-group exposure (e.g. borrowing from parent) may be excluded from UFCE if the bank is satisfied it is hedged/managed by the parent. Only rows marked Bank Satisfied = Y are excluded.
Category
Maturity Bucket
INR Amount (Cr)
Bank Satisfied (Y/N)
FCY Exposures
Enter your INR-crore total directly (already converted at the quarter-end closing rate). Pick the maturity date with the calendar icon.
FCY RECEIVABLES (Assets)
Category
Currency
INR Amount (Cr)
Maturity Date
Bucket
FCY PAYABLES (Liabilities)
Category
Currency
INR Amount (Cr)
Maturity Date
Bucket
Financial Hedges
No need to match a hedge to a specific exposure line — RBI permits hedging on an anticipated-exposure basis. Just say whether it covers your Receivables or Payables side. Every hedge entered is treated as effective.
Currency
Instrument
INR Amount (Cr)
Maturity Date
Hedges
Bucket
Natural Hedges
No need to link this to a specific category — e.g. export proceeds used to directly fund an import payment is shown against both your Receivables and Payables side at once. Shown for disclosure only — it does not reduce the certified TOTAL UFCE, only a financial hedge does.
Currency
INR Amount (Cr)
Offsetting Cash-Flow Type
Expected Cash-Flow Date
Accounting Year of Offset
Eligible?
Bucket
Accounting year is compared to Entity_Info's Reporting Financial Year — spacing and case don't matter, but the year numbers must match.
UFCE Format in line with FEDAI & RBI Guidelines
Quarterly Data on Foreign Currency Exposures
@ Residual unhedged receivables & payables after netting off financial hedge in full — a negative figure means the financial hedge on that side exceeds the exposure it covers. Natural Hedge above is shown for disclosure and is not deducted here.
Financial and Natural hedges are booked against the Receivable/Payable side as a whole, not a specific category — shown against a category only when it's the sole one with exposure in that bucket (unambiguous); otherwise shown only at the TOTAL rows.
Yours Sincerely, Authorised Signatory
Name: ___________
Designation: ___________
Executive Summary
Net Exposure Cross-Check (Kotak-style methodology) — NOT a substitute for the certificate
Kotak's own format has no Natural Hedge column and deducts only Financial Hedge from net (Receivables−Payables) exposure.
Daily / Management Snapshot
Recalculates instantly as Exposures/Financial Hedges/Natural Hedges change — usable as a daily snapshot for management even though the certificate itself is only submitted quarterly.
Gross Asset Exposure (net of financial hedges)
0.00
Gross Liability Exposure (net of financial hedges)
0.00
Net Open Exposure
0.00
Sensitivity — Risk of Loss (Rs Cr)
1% INR move
0.00
3% INR move
0.00
5% INR move
0.00
Positive Net Open Exposure = net long foreign currency (asset side bigger, INR depreciation risk). Negative = net short (liability side bigger, INR appreciation risk).
Validation & Exceptions
Clear every REVIEW item below before treating the certificate as final.