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