Stmts Summ & Stmts Monthly tabs contain detailed & summary monthly & quarterly Income Statements, Balance Sheets and Cash Flows for 2 years; future years more summarized & uses general % change cells

Stmts Monthly tab contains several calculations at bottom that provide support to certain items on Income Stmt & Balance Sheet

Revenues & Deal Profiles tabs contain a pretty straightforward revenue model - a "named" forecast by customer & product; many situations are more complex and will require more build up calculations

Use "Toggle Cell" in Revenues tab to run "What If" bookings attainment scenarios - What happens to results & cash if we hit revenues of 90%, 75%, etc.

Emp Input tab contains detail of all current and To Be Hired (TBH) positions by month for 2 years; costs & headcount updated through rest of model

Op Exp Summ auto rolls up all Operating Exps for all Depts by month for 2 years

Individual Depts auto roll up into Eng Summ and Sales & Mktg Summ as appropriate, which then roll up into Op Exp Summ tab

There are 4 hidden dept tabs that can be used for easy expansion - plus they're already built into summarizing formulas so simply unhide them to use

Each Dept tab contains very detailed monthly exps for 2 years plus rows at bottom to list & calculate range of expense items

Many individual expense line items are contained in Dept tabs so you think more about the changes you are making

Keep Dept structure (rows) the same in all tabs - to maintain current summarizing formulas

Cap Ex tab details all Cap Expenditures & related Depreciation by month for 2 years, auto-updates Income Stmt, Balance Sheet & Cash Flow

Variable input cells are blue text with green background, allows for sensitivity testing; many inputs for individual expense line items are contained in Dept tabs so you think more about & see the changes you are making

See Deal Profiles & Revenue tabs; Revenues start to be recognized 1 Qtr after Booking

Revenues recognized over annual / 12 month periods

Revenues recognized in 3rd month / 1 Qtr after Booking

Assumed to be minimal / immaterial

Used average costs of providing software & services for each year in Deal Profiles tab

Used estimated % costs to provide hosting for customer

Used estimated % costs to provide services for customer

See Emp Input tab, contains sections for both Employees & Contractors

see Sales dept tab, assumed 10% in 2020 & 8% in 2021 on Bookings, pay sales reps 30 days after end of quarter in which comms are earned

see Exp Assumps tab

Benefits - Health Insurance & Retirement Plan

see Exp Assumps tab

Team ramps us as reflected in Emp Input tab

Ave trip @ $1,200; can insert # of projected trips in each dept tab to customize

Emp Input tab allows for entry of Contractor resources & costs

General allowance for accounting & tax prep by external service providers

includes contract & corporate work and guidance

Assumed modest level for now

Lots of cells at bottom of Mktg tab to list & calculate whole range of possible activities

Placeholder to engage external firm(s) for certain product development - None assumed

See calculations at bottom of G & A tab

General monthly estimates

Assumed modest levels for now, will depend on customer contractual requirements

No income taxes reflected as the entity is an LLC and profits & losses pass through to members

No funding yet inserted into model - to allow you to see the raw cash balance - to help determine amount of funding needed

Assumed to send invoice at Go Live date (90 days after Booking), then collect 2 months after invoice / DSO = 60 days

Common funding vehicle for early stage - punts valuation of company to later / first round of external funding

External fundraise beyond angel round is typically sale of Preferred Stock (Series A/B/C Preferred)

Legal fees for Convertible Note fundraise (a debt) should be amortized over (expected) term of notes

Legal fees for a Preferred Stock fundraise (an equity) should be netted against its proceeds & recorded as contra amount in Equity section

Assume notes will eventually be converted into preferred stock fundraise at some conversion formula to be negotiated

Accrue interest on any Convertible Notes and / or Preferred Stock offerings

Pursue Venture Debt & economic development funding if viable

Pursue bank Line of Credit based on level of Accounts Receivable when viable - will likely be at least 2 years after start

While comm expense is recognized in month of sale, payout to Sales Rep delayed to 30 days after end of Qtr in which Booking is achieved

Cap Ex tab includes detail capital purchases and related depreciation for first 2 years, flows into Income Stmt, Balance Sheet & Cash Flow