Work Samples: Financial & Business Models

Business Model – Bank
  • “Top-down” financial model of Business Unit-level performance of a commercial bank with 2 major lines of business, based on a handful of global assumptions
  • “Bottom-up” financial model that accepts revenue and cost inputs at very low levels of granularity for both lines of business, including:
  • Variable Cost tab accepting input of assumptions of each line of business by Distribution Channel, Product, average loan duration, and primary Revenue Source (interest or sale)
  • Fixed Cost input tab allowing modified sliding scale for fixed cost assumptions, by Distribution Channel, according to 8 tranches of loan origination volume
  • Stacked P&Ls of both lines of business plus consolidated, and calculations of Key Performance Indicator (KPI) summary, as well as by Channel, Product, Revenue Source
Business Model – Digital Media Company
  • Comprehensive model of Digital Media company with multiple sources of online and offline Revenue: Subscription, Advertising, Sponsorships, Events, Licensing, and Sales
  • In addition to P&L, Balance Sheet, and Cash Flows, model includes Cash Budget, Depreciation Schedule, Capital Structure, Valuation, Financial Ratios, & Economic Profit
Business Model – Manufacturer
  • Integrated Financial Statements, Business Drivers, and debt schedule for billion dollar manufacturing company with 5 Operating Units and one for Corporate overhead
  • 5-year historicals and 5-year forecast of financials and free cash flow, for each Operating Unit, culminating in Discounted Cash Flow (DCF) Valuation
  • EV/EBITDA multiple Valuation using a 7-company Peer Group divided among client’s three major lines of business: Manufacturing, Leasing, and Services
  • Bottom-up Cost of Capital (WACC) calculation, 15-slide summary Presentation, and side-by-side analysis of client’s Share Price, Book Value, and two intrinsic Valuations
  • Methodology HERE
Business Model – Lender
  • Financial model describing a Lending Company making amortizing loans
  • Model calculates loan originations for each of 4 specific borrower profiles, as well as Cash Flows generated from Interest Income and secondary market sales
  • Color-coded and footnoted global assumptions sheet accepts inputs for Rates, Fees, loan Repayment, and Commissions for each Distribution Channel
  • Originations and assumptions drive tabs for Revenue, COGS, Headcount assumptions, Payroll, Overhead, OpEx, P&L, Balance Sheet, and Cash Flow Statement
Business Model – Social Network
  • Business model of an online and offline organization, comprised of two “Clubs”, both catering to elite members of a specific demographic
  • “Membership” worksheet contains powerful Dashboards for forecasting membership subscription revenue for one 4-tier club and another 3-tier club
  • Additional “Analysis” worksheet tabulates key performance indicators (KPI), including lifetime value (LTV) & acquisition costs, and churn rate
  • Modular construction of this model facilitates plug-in for additional Clubs, which are then automatically rolled into the Consolidated P&L
Business Model – VIP Concierge Service
  • Financial model crafted to accompany an RFP submission for a high-end concierge service for traveling VIPs
  • Simple dashboard distributes a few assumptions across comprehensive 5-year financial statement forecast: starting month, starting amount, growth by calendar year, prices, quantities
Business Model – Loyalty Company
  • Standard financial statements, plus Intangibles & Depreciation schedules
  • Includes two Balance Sheets: one for an S1 filing and one for SEC-compliance
Business Model – simple
  • One-year monthly Gross Margin summary of a website with various sources of Revenue
  • Extensive use of Excel’s Formatting functionality demonstrates our ability to create an alternative environment, or “look-and-feel” to the typical spreadsheet
GAAP-Compliant Financial Model
  • Robust, no-frills financial model for use by hedge fund or private equity firm, to track an SEC filed quarterly or annual statement
  • Includes highly-developed panels to show deltas on Q/Q, Y/Y, and sequential Quarter bases
  • This allows for strong emphasis and call-outs for important cells (for user input or to show results), in a distinguishing way that is consistent throughout
Decision Maker
  • Let Excel help make an important decision for you, by quantifying the qualitative
  • This tool prompts the User can specify the various Alternatives and Key Factors (KF) that lead to a Decision
  • It then requests a ranking KFs by relative importance to the decision, and then rate each Alternative against each KF
  • The output is a Scored ranking of the Alternatives and graphs that illustrate the Scores for a visual perspective
Demand Curve
  • An illustration of the elusive ‘downward-sloping Demand Curve’ for a company selling domain names at all price points
  • Company had rare distinction of infinite zero-cost inventory, where no two products were identical. Pricing was a challenge
  • Curve gave Company unparalleled insight into consumer demand, and a definitive pricing policy
Financial Model
  • Very simple 12-month financial model with Income Statement, Balance Sheet, Cash Flow Statement, and Debt & Depreciation Schedules
Flash Report
  • Basic monthly Sales Report, with 3 years of history overlaid on the graphs to track both M/M and Y/Y progress
Franchise Comparison
  • Demonstrating Excel’s User Interface features, a change in the drop-down menu populates cells and graphs with relevant data from another tab
Insource vs. Outsource
  • An analysis for use in determining whether a change from Full-Time Employee to Contractor status will benefit Company, Employee, or both
  • Three scenarios are used to estimate impact on Employee: high, medium, or low performer. Graphs on the next tab illustrate the difference
Share Count
  • Estimates average number of fully-diluted shares outstanding for a publicly-held corporation, both Quarterly and Annually
  • Quarterly Options, Repurchases, Employee purchases, and Share Price are factored into dilution/accretion algorithm
Valuation – Incremental Revenue Method
  • Specialized valuation created to assess incremental added revenue of potential acquisition
  • Model only relevant to this particular acquirer, uniquely positioned to increase acquisition’s sales by virtue of acquirer’s infrastructure and channels of distribution
Portfolio Valuation Rollup
  • Highly customized valuation tracker for holder of up to 13 portfolio companies
  • Owned securities of portfolio companies are programmed down the vertical axis so all 13 can be compared side-by-side, by debt instrument, equity instrument, and return measures
Personal Finances
  • Track your net worth with this slick summary of your income, expenses, assets, and debts
  • Mark-to-market with a simple upload of your positions and cash balances.
  • Perfectly constructed graphs display your performance and annualized return at a glance.
  • Enter your debt balances and interest rate, and see a monthly payment schedule instantly.