Banking Sector Financial Analysis & Hedging

Job ID: 38767357

Budget: $10 – $300 USD

I'm in need of a thorough financial analysis of a single banking company. The analysis will primarily focus on assessing interest rate risks and identifying possible hedging strategies.
Key requirements:
- Construction of tables summarizing IRR, liquidity gaps, calculation of Macaulay duration gap, and net interest income simulation.
- Use of provided Excel files for all calculations.
- Calculation of potential IRR hedging strategies, primarily utilizing interest rate swaps. This should include assessments of how these strategies will perform in various scenarios.

The ideal freelancer for this job should have:
- Extensive experience in financial analysis, particularly within the banking sector.
- Proficiency in using Excel for complex calculations.
- Familiarity with interest rate risk assessment and hedging strategies.
- Ability to perform Duration/Convexity analysis.

Please note, I will provide all necessary Excel files for this project.