Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "nodes": [
- {
- "id": "ec41c847fea94f48a5ed5fd9a17b4d62",
- "name": "Churned Subscribers",
- "description": "",
- "createdAt": "2019-08-16T15:30:54.626Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "{{ec72596279f54c56bf886b11e55d5576[t]}}*{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}",
- "nextFunction": "{{823a4711cf1946a19d67502695a02c61[t-1]}}*{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}+{{beee2d4283e244b19219eaccf7624283[t-1]}}*{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}"
- }
- },
- {
- "id": "ece8e7e0420c42659eb0b00a7e31cf30",
- "name": "SG&A, % of Revenue",
- "description": "",
- "createdAt": "2019-08-17T03:23:50.742Z",
- "scenarios": {},
- "format": {
- "type": "Percent"
- },
- "modelSection": "Output",
- "type": "Distribution",
- "value": [
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- },
- {
- "mean": 0.2,
- "variance": 0.00152218640094436
- }
- ]
- },
- {
- "id": "319ef851499d467b8a9ecd4439be7f76",
- "name": "Average Monthly Revenue",
- "description": "",
- "createdAt": "2019-08-13T21:19:51.947Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Input",
- "type": "Distribution",
- "value": [
- {
- "mean": 25,
- "variance": 0
- }
- ]
- },
- {
- "id": "7d30dcc0659648c0a0f13fdb5a515e62",
- "name": "Billings",
- "description": "",
- "createdAt": "2019-08-17T03:16:05.027Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{319ef851499d467b8a9ecd4439be7f76[t]}}*{{ac4952ef0c6442b9986409c3c8dcb1e9[t]}}"
- }
- },
- {
- "id": "9786a60554954237a7d439dd2d07d3ca",
- "name": "New Subscribers (month 1)",
- "description": "",
- "createdAt": "2019-08-16T15:29:38.164Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Input",
- "type": "Constant",
- "value": [
- 10
- ]
- },
- {
- "id": "89151b92eb6b4ceda7cc926f40169fc8",
- "name": "Acquisition Costs",
- "description": "",
- "createdAt": "2019-08-17T03:32:35.015Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{823a4711cf1946a19d67502695a02c61[t]}}*{{19ad297c706243e8a75b4f26ad4f29e7[t]}}"
- }
- },
- {
- "id": "ec72596279f54c56bf886b11e55d5576",
- "name": "Beginning Subscribers, month 1",
- "description": "",
- "createdAt": "2019-08-16T15:33:59.845Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Input",
- "type": "Constant",
- "value": [
- 0
- ]
- },
- {
- "id": "fd0a79dabc17466bbf88890680076211",
- "name": "Cash, first month",
- "description": "",
- "createdAt": "2019-08-17T03:27:48.926Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Input",
- "type": "Constant",
- "value": [
- 0
- ]
- },
- {
- "id": "ea7f96c573d343d2a31c533f3b3c0e7f",
- "name": "Churn",
- "description": "",
- "createdAt": "2019-08-13T21:17:37.048Z",
- "scenarios": {},
- "format": {
- "type": "Percent"
- },
- "modelSection": "Input",
- "type": "Distribution",
- "value": [
- {
- "mean": 0.05,
- "variance": 0.001522186400944361
- }
- ]
- },
- {
- "id": "823a4711cf1946a19d67502695a02c61",
- "name": "New Subscribers",
- "description": "",
- "createdAt": "2019-08-16T15:28:13.758Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "{{9786a60554954237a7d439dd2d07d3ca[t]}}",
- "nextFunction": "{{823a4711cf1946a19d67502695a02c61[t-1]}}*(1+{{4a18ea632e65419ab28bd8192097bf20[t]}})"
- }
- },
- {
- "id": "e30b4dedec7e4ac39f40c69e8ff276d6",
- "name": "ARR",
- "description": "",
- "createdAt": "2019-08-21T19:02:04.978Z",
- "scenarios": {},
- "format": {
- "type": "Number",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "0",
- "nextFunction": "{{492a928444a44ef8a57c623e2d657d5b[t]}}*12"
- }
- },
- {
- "id": "19ad297c706243e8a75b4f26ad4f29e7",
- "name": "CAC",
- "description": "",
- "createdAt": "2019-08-16T18:33:40.547Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Input",
- "type": "Distribution",
- "value": [
- {
- "mean": 55,
- "variance": 547.98710433997
- }
- ]
- },
- {
- "id": "5cbd2bbab4bf400a8609c4a78ddb25e4",
- "name": "SG&A",
- "description": "",
- "createdAt": "2019-08-17T03:26:32.855Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{ece8e7e0420c42659eb0b00a7e31cf30[t]}}*{{810bd3504bb74629b8c16b2c0a80fdf2[t]}}"
- }
- },
- {
- "id": "beee2d4283e244b19219eaccf7624283",
- "name": "Renewed Subscribers",
- "description": "",
- "createdAt": "2019-08-21T14:10:16.656Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "0",
- "nextFunction": "{{823a4711cf1946a19d67502695a02c61[t-1]}}*(1-{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}})+{{beee2d4283e244b19219eaccf7624283[t-1]}}*(1-{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}})"
- }
- },
- {
- "id": "fd06bb3289af4a7089e82d62f219f383",
- "name": "Contract Length (months)",
- "description": "",
- "createdAt": "2019-08-16T17:27:43.390Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Input",
- "type": "Constant",
- "value": [
- 1
- ]
- },
- {
- "id": "17c14cd6077a4ec78c1b194bf9985005",
- "name": "Bookings",
- "description": "",
- "createdAt": "2019-08-16T17:28:38.768Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{823a4711cf1946a19d67502695a02c61[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}*{{fd06bb3289af4a7089e82d62f219f383[t]}}"
- }
- },
- {
- "id": "26f14e665db245aba86840a5decdafab",
- "name": "COGS",
- "description": "",
- "createdAt": "2019-08-17T03:25:57.651Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{78c9c36460c24152945fd08a41792180[t]}}*{{810bd3504bb74629b8c16b2c0a80fdf2[t]}}"
- }
- },
- {
- "id": "26a39f4feebb4b829557f843eece4217",
- "name": "LTV / CAC",
- "description": "",
- "createdAt": "2019-08-17T01:28:28.987Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{dfc8752585eb497c83545d59e4ba9df4[t]}} / {{19ad297c706243e8a75b4f26ad4f29e7[t]}}"
- }
- },
- {
- "id": "1b6fe78280544e328a638f80476830b3",
- "name": "Churned MRR",
- "description": "",
- "createdAt": "2019-08-16T17:28:09.208Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{ec41c847fea94f48a5ed5fd9a17b4d62[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}"
- }
- },
- {
- "id": "02478e9a53a6472c94692ee36f64af57",
- "name": "Net Income",
- "description": "",
- "createdAt": "2019-08-17T03:27:21.817Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{810bd3504bb74629b8c16b2c0a80fdf2[t]}}-{{5cbd2bbab4bf400a8609c4a78ddb25e4[t]}}-{{26f14e665db245aba86840a5decdafab[t]}}"
- }
- },
- {
- "id": "810bd3504bb74629b8c16b2c0a80fdf2",
- "name": "Revenues",
- "description": "",
- "createdAt": "2019-08-17T03:25:18.198Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{319ef851499d467b8a9ecd4439be7f76[t]}}*{{ac4952ef0c6442b9986409c3c8dcb1e9[t]}}"
- }
- },
- {
- "id": "dfc8752585eb497c83545d59e4ba9df4",
- "name": "LTV",
- "description": "",
- "createdAt": "2019-08-16T18:34:58.852Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "Math.max(0,1/{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}})"
- }
- },
- {
- "id": "ac4952ef0c6442b9986409c3c8dcb1e9",
- "name": "Ending Subscribers",
- "description": "",
- "createdAt": "2019-08-16T15:30:42.786Z",
- "scenarios": {},
- "format": {
- "type": "Number"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "{{ec72596279f54c56bf886b11e55d5576[t]}}+{{9786a60554954237a7d439dd2d07d3ca[t]}}",
- "nextFunction": "{{ac4952ef0c6442b9986409c3c8dcb1e9[t-1]}}+{{823a4711cf1946a19d67502695a02c61[t]}}-{{ec41c847fea94f48a5ed5fd9a17b4d62[t]}}"
- }
- },
- {
- "id": "492a928444a44ef8a57c623e2d657d5b",
- "name": "MRR",
- "description": "",
- "createdAt": "2019-08-16T15:36:04.340Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{ac4952ef0c6442b9986409c3c8dcb1e9[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}"
- }
- },
- {
- "id": "4a18ea632e65419ab28bd8192097bf20",
- "name": "Growth Rate in New Subscribers",
- "description": "",
- "createdAt": "2019-08-13T21:16:19.321Z",
- "scenarios": {},
- "format": {
- "type": "Percent"
- },
- "modelSection": "Input",
- "type": "Distribution",
- "value": [
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- },
- {
- "mean": 0.025,
- "variance": 0.00038054660023609027
- }
- ]
- },
- {
- "id": "1147f855df0a4978a00258a5160d8e21",
- "name": "Cash",
- "description": "",
- "createdAt": "2019-08-17T03:28:51.904Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "{{fd0a79dabc17466bbf88890680076211[t]}}",
- "nextFunction": "{{1147f855df0a4978a00258a5160d8e21[t-1]}}+{{02478e9a53a6472c94692ee36f64af57[t]}}"
- }
- },
- {
- "id": "0acb393cd181491ab172908aa146c01c",
- "name": "Cumulative MRR",
- "description": "",
- "createdAt": "2019-08-16T15:44:18.834Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Recursive",
- "startValue": "0",
- "nextFunction": "{{492a928444a44ef8a57c623e2d657d5b[t-1]}}+{{492a928444a44ef8a57c623e2d657d5b[t]}}"
- }
- },
- {
- "id": "1332850cc9634fb38aa3b1f449e045e2",
- "name": "New MRR",
- "description": "",
- "createdAt": "2019-08-16T17:27:24.041Z",
- "scenarios": {},
- "format": {
- "type": "Currency",
- "symbol": "$"
- },
- "modelSection": "Output",
- "type": "Function",
- "value": {
- "type": "Basic",
- "value": "{{823a4711cf1946a19d67502695a02c61[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}"
- }
- },
- {
- "id": "78c9c36460c24152945fd08a41792180",
- "name": "COGS, % of Revenue",
- "description": "",
- "createdAt": "2019-08-17T03:22:59.648Z",
- "scenarios": {},
- "format": {
- "type": "Percent"
- },
- "modelSection": "Output",
- "type": "Distribution",
- "value": [
- {
- "mean": 0.030000000000000002,
- "variance": 0.00024354982415109779
- }
- ]
- }
- ],
- "charts": [
- {
- "id": "e3b5280053bb4b59ae3b66d547bb1c4b",
- "type": "TimeSeriesChart",
- "name": "Subscribers, End of Period",
- "description": "# of subscribers at the end of the period",
- "createdAt": "2019-08-16T15:35:33.280Z",
- "variables": [
- "ac4952ef0c6442b9986409c3c8dcb1e9"
- ]
- },
- {
- "id": "0aedb9a9531348b5aa512a1475f36950",
- "type": "TimeSeriesChart",
- "name": "MRR",
- "description": "marginal recurring revenue, per period",
- "createdAt": "2019-08-16T15:38:13.480Z",
- "variables": [
- "492a928444a44ef8a57c623e2d657d5b"
- ]
- },
- {
- "id": "7178dc108c76408db1df39295148f021",
- "type": "DistributionChart",
- "name": "Cumulative MRR",
- "description": "cumulative MRR",
- "createdAt": "2019-08-16T15:49:01.252Z",
- "variables": [
- "0acb393cd181491ab172908aa146c01c"
- ]
- },
- {
- "id": "0af5043104cb42f78610e0da103a02a9",
- "type": "TimeSeriesChart",
- "name": "New and Churned MRR",
- "description": "",
- "createdAt": "2019-08-16T18:31:33.487Z",
- "variables": [
- "1332850cc9634fb38aa3b1f449e045e2",
- "1b6fe78280544e328a638f80476830b3"
- ]
- },
- {
- "id": "19df4ef037ce4d32aa579c9bfa670242",
- "type": "TimeSeriesChart",
- "name": "Cash, end of period",
- "description": "cash at end of period",
- "createdAt": "2019-08-17T03:34:45.169Z",
- "variables": [
- "1147f855df0a4978a00258a5160d8e21"
- ]
- }
- ],
- "scenarios": []
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement