Financial Forecasting Templates:
Startup Model (48-mo)
Startup Model (48-mo)
Startup Model (48-mo)
● Perfect for pre-money companies
● 48 months, 5 revenue streams
● Roadmap for multiple equity rounds
Basic Model (10-yr)
Startup Model (48-mo)
Startup Model (48-mo)
● 10-year integrated P&L, Balance Sheet, & Cash Flow Statements
● Sales, expense, debt, & KPI tabs
Mini Model (60-mo)
Startup Model (48-mo)
Mini Model (60-mo)
● Simplicity in a 60-month forecast
● Graphs for each section: sales, P&L, KPIs, capitalization, & valuation
Professional Business Models:
Brand Manager
Lender / Creditor
Brand Manager
● Robust template for views, subs, sponsors, media & offline sales
● 3 P&Ls: rollup, cumulative, unit
Manufacturer
Lender / Creditor
Brand Manager
● Integrated financials for multiple businss units & consolidated rollup
● Business drivers, debt, KPIs, WACC, DCF & peer group valuations
Lender / Creditor
Lender / Creditor
Lender / Creditor
● 4 color-coded borrower risk profiles
● Input rates, fees, bounties, & repays
● CF from interest & aftermarket sales
Property Project
Social Media Manager
Property Project
● Input Panel aids with Assumptions
● Color-coded 60-mo Pro Formas
● Track building costs & lease revenue
(other)
Social Media Manager
Property Project
● Top-down P&L by loan type, channel, product, & source
● Bottom-up P&L by branch
Social Media Manager
Social Media Manager
Social Media Manager
● Tracks channel's users, events, ad revenue, COGS, payroll, & overhead
● 36-mo EBITDA & FCF calculations
Startup CEO
Client Service Provider
Client Service Provider
● Ideal for fundraising startups
● 48-mo, 5 product P&L/Bal/CF
● Valuation roadmap for fundraising
Client Service Provider
Client Service Provider
Client Service Provider
● 5 annual inputs spread to 60 mos
● Rev, OpEx, CapEx, P&L, Balance
● Input panel for sensitivity analysis
Retailer
Client Service Provider
Retailer
● 60-mo CapEx & captz'n schedules
● Cash Budget: 3 A/R,A/P term blocks
● Analysis: ratios, DCF, stress test
Project Manager
● Simple 60-month forecast
● Input panel for sensitivity analysis
● Graphs: Sales, P&L, KPIs, Capz'n, & Valuation
Financial Reporting Templates:
GAAP-compliant
Shares Outstanding
GAAP-compliant
● Focus on Adj. EBITDA & intangibles
● Displays Y/Y, Q/Q, ∆'s in % and $
● Line items reflect GAAP Earnings
Cash Budget
Shares Outstanding
GAAP-compliant
● 60-mo integrated financials
● Cash Budget w/ 3 AR/AP tranches
● Analysis tab: ratios, DCF, stress test
Shares Outstanding
Shares Outstanding
Shares Outstanding
● Calculate F-D shares outstanding
● For Quarterly or Annual reporting
● Tracks unlimited # of share blocks
Tools for Excel Enthusiasts:
Sales Comparison
Sales Comparison
Sales Comparison
● Optimize Excel's storage, formula, form, & output tools
● Separate tabs for data & logic
● Select a Name to repopulate graphs
Dynamic Graphing
Sales Comparison
Sales Comparison
● Dynamically rescales x-Axis for selected dates
● 4 bifurcated curves show A/B test results
● 27 graphs: 3 levels x 3 metrics x (#,%,∆)
Decision Maker
Personal Finances
Personal Finances
● Objective inputs = surprising results
● Alternatives scored in a single chart
● Abide the Decision!
Personal Finances
Personal Finances
Personal Finances
● A personal Balance Sheet, clear & simple
● Tracks assets, loans, income, & expenses
● Budget & balances drive Net Worth calculation
