Description: We are seeking an experienced freelance financial analyst or investment banking professional to update and build a robust financial model to support our acquisition of a fastener manufacturing and distribution business in Chicago (“Chicago Fastener”). The model will be used to: • Generate detailed financial projections (5+ years) • Perform return analysis including IRR and MOIC scenarios • Model capital structure scenarios including debt, equity, seller notes, earn-outs, etc. • Analyze investor return waterfalls based on preferred returns and carried interest • Provide summary outputs and visuals suitable for investor pitch decks Deliverables include: • 3-statement integrated model (Income Statement, Balance Sheet, Cash Flow) • Detailed cap table and investor return scenarios • Multiple financing structure sensitivities • Break-even and payback period analysis • Outputs formatted for pitch decks (charts, tables, key metrics) Ideal Candidate: • Background in private equity, investment banking, or FP&A • Proficient in Excel modeling and scenario analysis • Able to work with limited data and build clear, investor-ready outputs • Experience with small/mid-size M&A transactions, especially in manufacturing or distribution, is a plus Project Timeline: We are looking to move quickly and expect a turnaround in 1-3 days for the first draft. To apply, please include: 1. A sample of a prior financial model (feel free to anonymize it) 2. A brief description of your experience with investor-focused modeling 3. Availability to start and estimated delivery timeframe
Keyword: Data Analysis
Financial Analysis Financial Modeling Financial Projection Forecasting
Data Visualization for plant yield and agronomic data in R Shiny. Our team is looking for a developer to create data visualization tools for our customers and sales team. These would include stability charts, geographic heat maps, and scatter plots comparing several dif...
View JobNeed help understanding options for creating a dashboard from survey data. I have created one with slicers for data items that are standard variables (survey questions that have one response from a list of options). I need help with a visualizing a Top 5 items questions...
View JobWe are looking for an experienced Pentaho developer to extract job and product related attributes and measures from a number of ERP systems and assemble those into a planning datamart. We have an existing data warehouse environment using Postgresql databases and Pentaho...
View Job