| |
. |
 |
|
Consultant EC, MBA, CPA, CFA
| |
| . |
. |
| |
Project Clients & Past Employers
- International Rectifier (Power Management Technology company with $1 billion in revenue)
- F&A Cheese ($160 million cheese manufacturing company)
- Ameriquest / Citi Residential Lending (Leading subprime mortgage lender with over $80 billion origination in 2005)
- Countrywide (Leading mortgage lender, with over $240 billion in origination)
- Trinity Capital (Boutique investment banking firm specialized in restaurant franchises)
- Taco Bell (Subsidiary of Yum! Brands with over 5,800 quick service restaurant chains)
- National Golf (REIT specialized in golf courses management)
- Targus International (Leading computer peripheral design and distribution)
- Trizec Hahn (Multi-national property management and development)
- Alexandria Real Estate Equities (over $3.6B in assets)
- Master Protection Corporation (revenues over $75M)
Functional Finance & Accounting
Experience
Financial Reporting & General Accounting
- Analyzed income reasonableness, loan loss reserve for both portfolio and repurchases.
- Development of supplemental schedules such as same-store comparison, asset summary, revenue allocation and debt analysis for required SEC filings, including 10K, 10Q and 8K.
- Fixed Assets accounting, including the creation of schedules to track depreciation, acquisition, transfer and disposal of assets to correctly reflect valuation.
- Performed general accounting functions including G/L account reconciliation and financial statement preparation.
- Re-engineered the close cycle to reduce monthly closing process by two days.
- Extensive experience creating reporting and analysis tools and spreadsheets to automate functions.
- Developed analysis program to consolidate financial reports and assess inter-company balances.
- Analyzed and reconciled pipeline loans to ensure proper recording of third party fees.
- Researched and analyzed leases for FASB compliance.
Financial Planning & Analysis
- Produced annual operating budgets and calculated overhead to cost centers. Analyzed monthly budget to actual variances and developed reports to consolidate budgeted expenses.
- Forecasted net operating income for existing portfolios and potential acquisitions.
- Evaluated Lease Vs. Buy and Sell Vs. Hold asset options. Built cash flow models to compute the NPV and IRR of possible alternatives.
- Built models linking Pro-Forma financial statements under various assumptions based on discounted cash flow method, utilizing cutting edge valuation techniques such as EVA and Real Options.
- Conducted correlation and regression analysis to test relationships between multiple variables used in forecasting and capacity planning and constructed scenario analysis models to test sensitivity of assumed parameters by sampling different inputs.
- Analyzed and summarized lease terms for use by senior management in strategic planning.
- Participated in major franchisee refinancing project at Taco Bell (more than 15 franchisees with 250 stores) to assess franchisees' financial health, investigate irregularities, implement due diligence procedure and recommend potential workout solutions.
- Partnered with workout points to create financial valuation models and develop 10-year strategic plan to determine appropriate debt restructuring (re-amortization, interest only payments for stated time and claw-back notes), business reorganization between lenders and the franchiser (sale/leaseback, store closure, brand extension etc.) and absorption of write-offs.
- Developed cash flow forecast under different scenarios to identify a comfortable debt level.
Systems Expertise: Selected Detail
Excel
- Microsoft certified Excel expert; pivot tables, macros, advanced charting, Analysis ToolPak, goal seeker and solver, shared data, database linking and customization of toolbars using controls and Add-ins.
Access
- Microsoft certified Access expert; Creation of custom databases, allowing users to access, categorize and print customer information.
- Usage of forms, custom queries, multiple reports and data linkage.
Financial Modeling & Reporting Systems
- Argus & DYNA
- Hyperion Pillar and Enterprise- Utilized for budgeting, inter-company reconciliation and consolidation for 20 entities.
- PeopleSoft Financials
- Great Plains
Statistical Applications
- SPSS & JMP
Education & Credentials
- USC, Marshall School of Business, Los Angeles, CA, MBA, Finance
- University of Utah, Salt Lake City, UT, MS, Economics
- University of Utah, Salt Lake City, UT, BA, Economics
- CPA, State of California
- Chartered Financial Analyst
Contact
us at
888.595.5600 | |