FINANCIAL PLANNING & ANALYSIS
Improve your enterprise through structured and strategic financial planning & analysis.
Our financial planning & analysis services are designed to help our clients forecast more accurately, analyze results and make better business decisions.
We believe in applying the tools of financial planning & analysis to every aspect of business operations.
Our diagnostic approach to FP&A ensures we can identify what your company needs, so we can deliver precisely that.
some of the things we do:
- Fully Integrated Financial Modeling to Support Key Decision Making
- Cost/Benefit Analysis
- Business Case Development
- Long-Term Strategic Planning
- Forecasting, Including Balance Sheet, Cash Flow and P&L Forecasts
- Budgeting, Including Establishment of Ground-up Budgeting Process and Methodology and Template Development
- Pricing, Profitability and Gross Margin Analysis
- Evaluation of Salesforce Effectiveness and Compensation Plans
- KPI Development, Benchmarking and Competitive Analysis
- Assessment of Effectiveness of Finance Team and Process Improvement
- Development of Cost Accounting Standards for Manufacturing Companies
Past Financial Planning and Analysis Projects
Model for PE-Backed B2C SaaS Company
Developed complex model for private-equity-backed B2C SaaS company to support analysis of variable free trial, attachment, bill through, retention, product elimination and pricing modeling at the product and cohort levels.
Ground-Up Revenue Forecasting Model for $300M SaaS Company
Built ground-up revenue forecasting model for a $300M SaaS company based on unique inputs and adjusted GAAP revenue recognition for 1-, 3-, 6- and 12-month subscription packages for 4 months of transactions. Model provided over 40 permutations for subscriptions based on Sales Assisted, Standalone and Bundled subscription services. Each permutation required waterfall analysis and GAAP-compliant forecasts. Additionally, the new model calculated Average Item Value (AIV) and Average Order Value (AOV), utilizing last 12 months historical data, adjusting for discounts, refunds and promotional credits both post and prior to check out.
Finance Team Assessment
Advised CFO on reorganization of Finance team by conducting interviews and assessment of 10 Finance team members for a large entertainment service provider.
Business Case for Entertainment Partnership
Built a business case to evaluate an international distribution partnership deal for the publishing division of a major entertainment studio.
Cost/Benefit Analysis for U.S. Apparel Company
Led a strategic cost/benefit analysis project for a large U.S.-based apparel company, assessing the total costs and potential benefits of relocating operations to another state.
Strategic Financial Planning
Created a 5-year strategic financial plan by partnering with various departments such as sales, marketing, product development, HR, IT and finance for VC-backed SaaS company. Utilized the product roadmap, historical trends, contractual obligations, partnerships, comparable companies benchmarking and GAAP rules.
Excel-Based Allocation Models
Developed dynamic Excel-based allocation models for multichannel consumer products marketer to streamline the calculation of shared expenses across sales channels and product lines, using various allocation methodologies, including sales and headcount.
Variable Sales Compensation Planning
Built variable Sales compensation plan for a newly acquired business, including model creation of automated calculations in NetSuite for a content delivery network company.
Black Friday Modeling and Sales Strategy for Publisher
Modeled past Black Friday sales performance and recommended specific changes in sales strategy for a publishing company.
Utilization and Forecasting Model
Developed complex rolling 18-month capacity utilization and forecasting model, factoring in such variables as anticipated demand, on-hand inventory, shipping lead times, productivity by machine type and tool and plant closure schedules for US and China for packaging company.
Planful Implementation Management for Digital Media Company
Managed the implementation of Planful (formerly Host Analytics) financial budgeting and forecasting software, including building a hierarchy for actual and budget data and developing budget templates and KPI reporting for a digital media company.
Impact Assessment for Restaurant Operator
Assessed the 7-year impact of a substantial remodel of both the franchisees and company-owned locations for a publicly held restaurant operator.
Cash Flow Projection Model for TV Production Company
Created and maintained a 5-year cash flow projection model which contained detailed cash flows by show for a TV production company.
Annual Planning for PE-Backed Entertainment Company
Built annual budget, forecast and operating plan, including creating budget templates from scratch for a formerly PE-backed entertainment company prior to its sale.
Excel-based Marketing Model for Advertising Campaigns
Constructed Excel-based model to estimate marketing spend and efficacy around potential national and local advertising campaigns for multi-location, multi-state restaurant company.
Cost and Profit Center Annual Budgeting
Created a company’s first formal set of cost and profit center annual budget Excel templates for a multi-channel network operator and content producer, including pre-built, driver-based forecast tools.
Chief Strategy Officer Support
Advised Chief Strategy Officer on transforming a $100M, privately held holding company involved in the financial services and energy industry into a high-growth corporate entity well positioned for strategic transactions.
Sales Report and Consolidation Tool
Built Excel-based weekly sales report template and consolidation tool, including automated budget, forecast comparisons and graphical dashboards for a large entertainment service company.
Performed profitability analysis by customer and workflow for a Digital Services business.
Cash Flow and Forecasting for Entertinament Company
Constructed annual cash flow, production cost forecast, capex budget and five-year financial forecast for formerly PE-backed entertainment company prior to its sale.
Modeling and Project Planning for Retail Company
Constructed model that estimated synergies, one-time charges and ongoing expenses related to interstate headcount move of a retail company with over 500 employees. Created 12-month project plan to facilitate execution including actions related to statutory employee notices, employee backfill, capital expenditures, facility sublease and new facility search.
Deal Model Consolidation and Standardization for PE Firm
Consolidated and standardized 50+ legacy deal models for private equity firm with over $6B in assets under management into 2 (debt + equity), leveraging VBA automations, advanced Excel modeling and centralized data extraction.
PE Portfolio Quarterly Reporting Dashboard
Implemented quarterly reporting dashboard for a private equity firm portfolio management department to analyze debt financing; automated variance reporting and time weighted returns for various groups using VBA and macros.
Cash Flow Forecasting for Food Service Company
Created a streamlined cash flow forecast model incorporating rates driven tabs, including information regarding headcount, building, equipment and vehicle loans and a revenue model for a food service company.
Pricing Model for IT Service Provider
Developed a Pricing Model for a new product and service for an IT Service provider using market / industry research for comparable offerings.
Contribution Margin and Customer Profitability Analyses
Developed contribution margin and customer profitability analyses enabling targeted price increases that resulted in addition revenue for a small, privately held industrial company.
Backhaul Optimization Tool
Developed Backhaul Optimization Tool used by shipping, purchasing and sales to provide more visibility into actual backhaul costs, more strategic backhaul pricing and yielding substantial savings in shipping and delivery costs for container manufacturer.
Demand Forecasting Model for Beauty Product Company
Built a demand forecasting model to provide a sales trend over time, the inventory position at a point in time, and forecast upcoming sales with reasonable accuracy. The model also alerted the user regarding potential fulfillment issues due to inadequate inventory for a distributor and wholesaler of beauty products.
Mobile Virtual Network Operator Planning
Led strategic planning of a company’s MVNO product, built business models, product pricing and supported negotiations with providers.
Discount, Markdown and Returns Analysis
Created analysis and reporting around discounts, markdown and returns at a customer, segment and product level to help identify opportunities to improve margin for a consumer products appliance company.
Analysis of Manufacturing Relocation
Prepared an in-depth analysis of financial implications of relocating manufacturing within the US for a well-known Apparel manufacturer.
Annual Compensation Budgeting
Prepared $83M annual compensation budget, including quarterly forecasts through the creation of models to capture equity compensation plans, departmental allocations and financial system uploads.
Get familiar with our unique perspective in the content below, or visit our Insights page for more.
All businesses set revenue targets as a common practice. However, the real challenge lies in understanding what it takes to meet those targets. This is where the concept of Sales Capacity Modeling comes into play.
A 3-statement model is a comprehensive financial model that integrates the income statement, balance sheet and statement of cash flows. It provides a holistic view of a company’s financial performance and future projections. By automating the relationships between these statements, changes in one statement automatically impact the others, providing a more accurate and dynamic representation of the company’s financial position.
Drawing from more than two decades of experience in corporate finance, much of which was devoted to refining processes for generating precise forecasts, I’ve distilled key insights that have not only elevated forecasting accuracy, but also saved substantial time and effort along the way.
Our partnership with the Aerospace & Defense client empowered teams for future success and yielded exceptional results, including successful project closures, improved financial accuracy and streamlined processes. Download our case study to learn more.
get in touch.
Move your company’s Financial Planning & Analysis function from compliance fulfillment reporting and incremental budgeting activity to critical analysis. Fill out this form to learn more about how 8020 can help you with your next Financial Planning & Analysis project.
Join our mailing list.
Join our mailing list for exclusive content. No spam, just great insight.