Whether you need financial analysis expertise for your own business planning, to assess a potential partner/investee/grantee, or to understand the cost-benefits of a more complex scenario, David provides services oriented towards transparency and decision making.

 

CFA charterholder

David Wedick is a holder of the right to use the Chartered Financial Analyst® designation.

Relevant DWFS client work, 2024 to present

Maine Connectivity Authority (MCA) - Quasi-governmental state broadband authority

• Program level financial risk analysis & design
• MCA organizational business model planning and multi-year program deployment projections
• Financial review frameworks for evaluating funding applicants
• Standalone project model for a middle-mile fiber build, consolidated into an agency-wide view

Four Directions Development Corporation (FDDC) - Native CDFI

• Master financial model integrating twenty years of financial statements with detailed notes receivable and notes payable models
• Chart of accounts redesign to enable audited financial statements, quarterly board reporting and lender reporting to all run off one accounting backbone
• Quarterly financial reporting package for the board and finance committee, including a CAMELS-based ratio dashboard and peer comparison
• Multi-year budget and three-year financial projections

CEI-Boulos - Impact and community development real estate fund manager

• Reusable project model template adopted across the manager’s funds, plus project-level and fund-level models for two funds
• Investor cash flow projections, scenario analysis and downside stress testing
• Model review against fund Operating Agreement terms, including distribution waterfall, management fee and reserve mechanics
• Support for annual project valuations and for auditor questions on fair value

Wild Ocean Aquaculture (dba Bangs Island Mussels) - Aquaculture company

• Five-year strategic and financial plan, and a master financial model integrating fifteen years of financial history with full financial statements, debt schedule and cash forecasting
• Annual budget, quarterly finance and operations reporting, and an investor and lender reporting package
• Return on investment analysis on capital equipment and on acquisition opportunities
• Production and inventory planning model, built with the client’s operations team and handed over with a written user guide

New Hampshire Community Loan Fund - CDFI

• Master financial model built on a driver-based architecture: two decades of audited history, quarterly and annual, feeding five years of projections
• Scenario testing across lending volume, cost of funds, portfolio yield, credit losses and staffing costs, all run from a single assumptions tab
• Financial covenant dashboard covering the full lender group, each covenant built to its contractual definition
• Model, user guide and scenario documentation transferred to the client’s finance team to own and operate

Blaze Partners - Marketing and advertising agency

• Chart of accounts designed and implemented with the company’s bookkeeper
• Multi-year financial projections and supporting metrics prepared for the valuation partner in an employee ownership transition
• Gross margin analysis by product line, and a draft pricing tool for new business
• Auditor and tax firm selection run as a full RFP, ahead of a first-time audit

 

Relevant prior career experience

Coastal Enterprises Inc. (CEI) - CDFI

• CDFI business model - investing, lending, advising
• New Product Development Committee - subsidiary concept design & implementation

MicroVest Capital Management - Microfinance Investment Vehicle (MIV)

• Comprehensive investment fund design at investee, investor and manager level, covering market and business model assessment, risk, return, liquidity, impact, fee and carried interest structure, and fund structure

Trade Aid - Non-Governmental Organization (NGO)

• Due diligence on micro enterprises across an array of industries; portfolio management; risk management

JPMorgan - Investment Banking

• Valuations; financial modeling; public company analysis; sector & macro-economic analysis

 

Please contact David with any questions.