Building a Foreign Exchange Hedging Tracker in Excel

A hands-on build for treasury and finance teams, growth-stage founders with import or export exposure, and strategy teams who need to see what a rupee move does to the plan. Starts with how FX risk actually hits an Indian company's P&L, the three types of exposure, the hedging instruments available onshore, and the RBI framework that governs who can hedge what. Then builds a working Excel tracker from a blank workbook: an exposure register, a forward contract hedge book, and reference rates from FBIL and forward premium data. From there it covers mark-to-market valuation, hedge ratios, currency options and NSE/BSE currency futures, and realised versus unrealised gains on settlement, before closing with a treasury dashboard, rupee stress scenarios, Ind AS 109 hedge accounting basics, and the controls that keep the tracker audit-ready.