ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Transmedia Studio
2
Financial Model Guide
3
January 7, 2026
4
5
6
7
8
9
COLOR CODING
10
11
Inputs/assumptionsBLUE
Inputs, or any hard-coded data, such as historical values, assumptions, and drivers.
12
Formulas/resultsBLACK
Formulas, calculations, or references deriving from inputs
13
14
15
CONTENTS
16
17
18
Settings
General settings
19
Salaries
A summary of salaries and team members
20
Projections
Use this sheet to summarize the variables that directly affect the business projections
21
Charts & KPIs
A summary of P&L charts, capital requirements and other KPIs relevant to the business
22
CapTable
Capitalization table including estimated Round A clossing
23
FS-Annual
Projected annual financial statements
24
FS-Month
Projected monthly financial statements
25
Revenue
Detailed monthly revenue assumptions & projections
26
COGS
Detailed monthly cost of goods sold (COGS) assumptions & projections
27
SG&A
Detailed monthly selling, general & administrative expenses (SG&A) assumptions & projections
28
WK+CAPEX
Detailed monthly working capital (WK) & capital expenditures (CAPEX) assumptions & projections
29
Funding - Equity Round Estimation
A simple calculator to estimate the stock that needs to be issued on a (priced) round of funding
30
Funding - Convertible Note Estimation
A simple calculator to estimate the stock that needs to be issued on a convertible note funding round
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100