Investment Analyst
Tucson Und Umgebung, Arizona
• Develop and improve financial reports for upper management (i.e., returns, exposure, daily cash projections etc.) • Create MS Excel models and run Monte Carlo analysis by using advanced functions (Regression analysis, solver, pivot tables, Bloomberg Excel, V/H look-up) and VBA Coding• Creating pro-forma financial statements (sensitivity and scenario analysis, discounted cash-flow valuation)• Completed portfolio analysis on credit risk exposure, cost/benefit analysis, duration analysis, liquidity analysis, performance assessment and attribution, and other as needed• Work effectively with various accounting departments and understand their operations as it relates to treasury