Financial Modeling; Excel and VBA

PROFILE SUMMARY

• Primary Capability:
  1. Financial Modeling with Microsoft Excel and Programming with VBA.

• Experience: Over 8 years of Financial Modeling & Financial Analysis across industries, particularly,
  1. Banking,
  2. Energy (Oil & Gas),
  3. Autos, and
  4. Real Estate.

• Education:
  1. CFA Charter holder,
  2. MBA, Finance & Investment, and
  3. CFI-certified Financial Modeling and Valuation Analyst (FMVA®).

WHAT I DO & CAN DO FOR YOU

Using Excel & VBA, I build: 

• Decision-useful investment proformas, cashflow and financing models (including scenario/sensitivity analysis), with varying levels of complexity (from the simple/high-level to the complex/detailed). This I currently do for:
  1. Land Development (with several stages of development) projects,
  2. For-sale Multifamily (condos, duplexes, townhomes, etc.) projects,
  3. Rental Multifamily (apartments, duplexes, townhomes, etc.) projects,
  4. Single Family (for-sale & rental) projects, and
  5. Seniors/Retirement Living projects.

• Project and Corporate Finance models for the assessment of other forms of Capital projects, such as: 
  1. Reserve-based oil and gas development, and CAPEX activities,
  2. Equipment / Machinery acquisition,
  3. Solar Power projects, and a lot more.

• Business Valuation & Credit Analysis models that can be used for the purposes of:
  1. Raising capital (debt, equity, mezzanine, or any combinations),
  2. Mergers and Acquisition.

• Operations models for day-to-day decision-making within businesses.

• Business Budgets with the capacity to capture Actuals and carry out Variance Analyses.

• 3-Statement models (Income statement, Balance sheet & Cashflow statement) for use by all classes of stakeholders and for growth/expansion projections.

• General Business models/templates for any sort of ad-hoc business analysis.