Custom Hedge Proposal
This sheet is a reusable spreadsheet created for a client that wanted hedge proposals using options for large equity positions. Inputs are at the top including stock and the deal structure, the hedge details are placed in the middle and P/L data populates in th bottom section. P/L graphs are also created automatically for the presentation to the client.
Excel specialist with significant background in finance and capital markets. I enjoy spreadsheet development and design in an effort to efficiently process data and display it in an easily digestible format for key decision makers and senior leadership. I also have experience in data mining and manipulation to draw usable and actionable conclusions. I am a beliver in graphical representation of data in order to visualize results. Advanced skills in excel include: complex formula creation, dynamic dashboards, intelligent calculators, V/H Lookup, Index(Match)(Match), Conditional Formatting, Data Validation Boxes, Pivot Tables (including calculated fields and slicers).