Associate
CurrentDeveloped and managed large-scale financial models in Excel, used to gain approval from regulators (NCUA) to raise subordinated debt • Modeled pro-forma balance sheet, income, and cash flow statements, including models for both announced and hypothetical bank acquisitions • Prepared stress tests for pro-forma financials; analyzed the outcome of these stress tests to ensure ability to meet financial and regulatory obligations • Ensured comprehensibility of models for submission to regulators and investors; optimized model to improve performanceReg. D Private Placements – Has taken part in multiple debt offerings totaling over $500 million: • Prepared Investor Materials; organized and managed data rooms • Composed questions for and took part in underwriter due diligenceM&A - Has prepared materials for both buy-side and sell-side M&A materials for financial groups including: • Preparing and stress testing pro-forma modeling for earn back periods and return on investments • Performing due diligence on loan portfolios and adjusting portfolio valuations for yield and credit adjustments • Initiated income simulation modeling using sophisticated asset-liability management software• Prepared and tested code to automate analysis of credit union loan files and membership files for production of reports in compliance with the U.S. Treasury’s Emergency Capital Investment Program and the National Credit Union Administration’s Low-Income Designation
