Advertisement
Guest User

Untitled

a guest
Aug 25th, 2019
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.40 KB | None | 0 0
  1. {
  2. "nodes": [
  3. {
  4. "id": "ec41c847fea94f48a5ed5fd9a17b4d62",
  5. "name": "Churned Subscribers",
  6. "description": "",
  7. "createdAt": "2019-08-16T15:30:54.626Z",
  8. "scenarios": {},
  9. "format": {
  10. "type": "Number"
  11. },
  12. "modelSection": "Output",
  13. "type": "Function",
  14. "value": {
  15. "type": "Recursive",
  16. "startValue": "{{ec72596279f54c56bf886b11e55d5576[t]}}*{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}",
  17. "nextFunction": "{{823a4711cf1946a19d67502695a02c61[t-1]}}*{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}+{{beee2d4283e244b19219eaccf7624283[t-1]}}*{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}"
  18. }
  19. },
  20. {
  21. "id": "ece8e7e0420c42659eb0b00a7e31cf30",
  22. "name": "SG&A, % of Revenue",
  23. "description": "",
  24. "createdAt": "2019-08-17T03:23:50.742Z",
  25. "scenarios": {},
  26. "format": {
  27. "type": "Percent"
  28. },
  29. "modelSection": "Output",
  30. "type": "Distribution",
  31. "value": [
  32. {
  33. "mean": 0.2,
  34. "variance": 0.00152218640094436
  35. },
  36. {
  37. "mean": 0.2,
  38. "variance": 0.00152218640094436
  39. },
  40. {
  41. "mean": 0.2,
  42. "variance": 0.00152218640094436
  43. },
  44. {
  45. "mean": 0.2,
  46. "variance": 0.00152218640094436
  47. },
  48. {
  49. "mean": 0.2,
  50. "variance": 0.00152218640094436
  51. },
  52. {
  53. "mean": 0.2,
  54. "variance": 0.00152218640094436
  55. },
  56. {
  57. "mean": 0.2,
  58. "variance": 0.00152218640094436
  59. },
  60. {
  61. "mean": 0.2,
  62. "variance": 0.00152218640094436
  63. },
  64. {
  65. "mean": 0.2,
  66. "variance": 0.00152218640094436
  67. },
  68. {
  69. "mean": 0.2,
  70. "variance": 0.00152218640094436
  71. },
  72. {
  73. "mean": 0.2,
  74. "variance": 0.00152218640094436
  75. },
  76. {
  77. "mean": 0.2,
  78. "variance": 0.00152218640094436
  79. },
  80. {
  81. "mean": 0.2,
  82. "variance": 0.00152218640094436
  83. },
  84. {
  85. "mean": 0.2,
  86. "variance": 0.00152218640094436
  87. },
  88. {
  89. "mean": 0.2,
  90. "variance": 0.00152218640094436
  91. },
  92. {
  93. "mean": 0.2,
  94. "variance": 0.00152218640094436
  95. },
  96. {
  97. "mean": 0.2,
  98. "variance": 0.00152218640094436
  99. },
  100. {
  101. "mean": 0.2,
  102. "variance": 0.00152218640094436
  103. },
  104. {
  105. "mean": 0.2,
  106. "variance": 0.00152218640094436
  107. },
  108. {
  109. "mean": 0.2,
  110. "variance": 0.00152218640094436
  111. },
  112. {
  113. "mean": 0.2,
  114. "variance": 0.00152218640094436
  115. },
  116. {
  117. "mean": 0.2,
  118. "variance": 0.00152218640094436
  119. },
  120. {
  121. "mean": 0.2,
  122. "variance": 0.00152218640094436
  123. },
  124. {
  125. "mean": 0.2,
  126. "variance": 0.00152218640094436
  127. }
  128. ]
  129. },
  130. {
  131. "id": "319ef851499d467b8a9ecd4439be7f76",
  132. "name": "Average Monthly Revenue",
  133. "description": "",
  134. "createdAt": "2019-08-13T21:19:51.947Z",
  135. "scenarios": {},
  136. "format": {
  137. "type": "Currency",
  138. "symbol": "$"
  139. },
  140. "modelSection": "Input",
  141. "type": "Distribution",
  142. "value": [
  143. {
  144. "mean": 25,
  145. "variance": 0
  146. }
  147. ]
  148. },
  149. {
  150. "id": "7d30dcc0659648c0a0f13fdb5a515e62",
  151. "name": "Billings",
  152. "description": "",
  153. "createdAt": "2019-08-17T03:16:05.027Z",
  154. "scenarios": {},
  155. "format": {
  156. "type": "Currency",
  157. "symbol": "$"
  158. },
  159. "modelSection": "Output",
  160. "type": "Function",
  161. "value": {
  162. "type": "Basic",
  163. "value": "{{319ef851499d467b8a9ecd4439be7f76[t]}}*{{ac4952ef0c6442b9986409c3c8dcb1e9[t]}}"
  164. }
  165. },
  166. {
  167. "id": "9786a60554954237a7d439dd2d07d3ca",
  168. "name": "New Subscribers (month 1)",
  169. "description": "",
  170. "createdAt": "2019-08-16T15:29:38.164Z",
  171. "scenarios": {},
  172. "format": {
  173. "type": "Number"
  174. },
  175. "modelSection": "Input",
  176. "type": "Constant",
  177. "value": [
  178. 10
  179. ]
  180. },
  181. {
  182. "id": "89151b92eb6b4ceda7cc926f40169fc8",
  183. "name": "Acquisition Costs",
  184. "description": "",
  185. "createdAt": "2019-08-17T03:32:35.015Z",
  186. "scenarios": {},
  187. "format": {
  188. "type": "Currency",
  189. "symbol": "$"
  190. },
  191. "modelSection": "Output",
  192. "type": "Function",
  193. "value": {
  194. "type": "Basic",
  195. "value": "{{823a4711cf1946a19d67502695a02c61[t]}}*{{19ad297c706243e8a75b4f26ad4f29e7[t]}}"
  196. }
  197. },
  198. {
  199. "id": "ec72596279f54c56bf886b11e55d5576",
  200. "name": "Beginning Subscribers, month 1",
  201. "description": "",
  202. "createdAt": "2019-08-16T15:33:59.845Z",
  203. "scenarios": {},
  204. "format": {
  205. "type": "Number"
  206. },
  207. "modelSection": "Input",
  208. "type": "Constant",
  209. "value": [
  210. 0
  211. ]
  212. },
  213. {
  214. "id": "fd0a79dabc17466bbf88890680076211",
  215. "name": "Cash, first month",
  216. "description": "",
  217. "createdAt": "2019-08-17T03:27:48.926Z",
  218. "scenarios": {},
  219. "format": {
  220. "type": "Currency",
  221. "symbol": "$"
  222. },
  223. "modelSection": "Input",
  224. "type": "Constant",
  225. "value": [
  226. 0
  227. ]
  228. },
  229. {
  230. "id": "ea7f96c573d343d2a31c533f3b3c0e7f",
  231. "name": "Churn",
  232. "description": "",
  233. "createdAt": "2019-08-13T21:17:37.048Z",
  234. "scenarios": {},
  235. "format": {
  236. "type": "Percent"
  237. },
  238. "modelSection": "Input",
  239. "type": "Distribution",
  240. "value": [
  241. {
  242. "mean": 0.05,
  243. "variance": 0.001522186400944361
  244. }
  245. ]
  246. },
  247. {
  248. "id": "823a4711cf1946a19d67502695a02c61",
  249. "name": "New Subscribers",
  250. "description": "",
  251. "createdAt": "2019-08-16T15:28:13.758Z",
  252. "scenarios": {},
  253. "format": {
  254. "type": "Number"
  255. },
  256. "modelSection": "Output",
  257. "type": "Function",
  258. "value": {
  259. "type": "Recursive",
  260. "startValue": "{{9786a60554954237a7d439dd2d07d3ca[t]}}",
  261. "nextFunction": "{{823a4711cf1946a19d67502695a02c61[t-1]}}*(1+{{4a18ea632e65419ab28bd8192097bf20[t]}})"
  262. }
  263. },
  264. {
  265. "id": "e30b4dedec7e4ac39f40c69e8ff276d6",
  266. "name": "ARR",
  267. "description": "",
  268. "createdAt": "2019-08-21T19:02:04.978Z",
  269. "scenarios": {},
  270. "format": {
  271. "type": "Number",
  272. "symbol": "$"
  273. },
  274. "modelSection": "Output",
  275. "type": "Function",
  276. "value": {
  277. "type": "Recursive",
  278. "startValue": "0",
  279. "nextFunction": "{{492a928444a44ef8a57c623e2d657d5b[t]}}*12"
  280. }
  281. },
  282. {
  283. "id": "19ad297c706243e8a75b4f26ad4f29e7",
  284. "name": "CAC",
  285. "description": "",
  286. "createdAt": "2019-08-16T18:33:40.547Z",
  287. "scenarios": {},
  288. "format": {
  289. "type": "Currency",
  290. "symbol": "$"
  291. },
  292. "modelSection": "Input",
  293. "type": "Distribution",
  294. "value": [
  295. {
  296. "mean": 55,
  297. "variance": 547.98710433997
  298. }
  299. ]
  300. },
  301. {
  302. "id": "5cbd2bbab4bf400a8609c4a78ddb25e4",
  303. "name": "SG&A",
  304. "description": "",
  305. "createdAt": "2019-08-17T03:26:32.855Z",
  306. "scenarios": {},
  307. "format": {
  308. "type": "Currency",
  309. "symbol": "$"
  310. },
  311. "modelSection": "Output",
  312. "type": "Function",
  313. "value": {
  314. "type": "Basic",
  315. "value": "{{ece8e7e0420c42659eb0b00a7e31cf30[t]}}*{{810bd3504bb74629b8c16b2c0a80fdf2[t]}}"
  316. }
  317. },
  318. {
  319. "id": "beee2d4283e244b19219eaccf7624283",
  320. "name": "Renewed Subscribers",
  321. "description": "",
  322. "createdAt": "2019-08-21T14:10:16.656Z",
  323. "scenarios": {},
  324. "format": {
  325. "type": "Number"
  326. },
  327. "modelSection": "Output",
  328. "type": "Function",
  329. "value": {
  330. "type": "Recursive",
  331. "startValue": "0",
  332. "nextFunction": "{{823a4711cf1946a19d67502695a02c61[t-1]}}*(1-{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}})+{{beee2d4283e244b19219eaccf7624283[t-1]}}*(1-{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}})"
  333. }
  334. },
  335. {
  336. "id": "fd06bb3289af4a7089e82d62f219f383",
  337. "name": "Contract Length (months)",
  338. "description": "",
  339. "createdAt": "2019-08-16T17:27:43.390Z",
  340. "scenarios": {},
  341. "format": {
  342. "type": "Number"
  343. },
  344. "modelSection": "Input",
  345. "type": "Constant",
  346. "value": [
  347. 1
  348. ]
  349. },
  350. {
  351. "id": "17c14cd6077a4ec78c1b194bf9985005",
  352. "name": "Bookings",
  353. "description": "",
  354. "createdAt": "2019-08-16T17:28:38.768Z",
  355. "scenarios": {},
  356. "format": {
  357. "type": "Currency",
  358. "symbol": "$"
  359. },
  360. "modelSection": "Output",
  361. "type": "Function",
  362. "value": {
  363. "type": "Basic",
  364. "value": "{{823a4711cf1946a19d67502695a02c61[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}*{{fd06bb3289af4a7089e82d62f219f383[t]}}"
  365. }
  366. },
  367. {
  368. "id": "26f14e665db245aba86840a5decdafab",
  369. "name": "COGS",
  370. "description": "",
  371. "createdAt": "2019-08-17T03:25:57.651Z",
  372. "scenarios": {},
  373. "format": {
  374. "type": "Currency",
  375. "symbol": "$"
  376. },
  377. "modelSection": "Output",
  378. "type": "Function",
  379. "value": {
  380. "type": "Basic",
  381. "value": "{{78c9c36460c24152945fd08a41792180[t]}}*{{810bd3504bb74629b8c16b2c0a80fdf2[t]}}"
  382. }
  383. },
  384. {
  385. "id": "26a39f4feebb4b829557f843eece4217",
  386. "name": "LTV / CAC",
  387. "description": "",
  388. "createdAt": "2019-08-17T01:28:28.987Z",
  389. "scenarios": {},
  390. "format": {
  391. "type": "Number"
  392. },
  393. "modelSection": "Output",
  394. "type": "Function",
  395. "value": {
  396. "type": "Basic",
  397. "value": "{{dfc8752585eb497c83545d59e4ba9df4[t]}} / {{19ad297c706243e8a75b4f26ad4f29e7[t]}}"
  398. }
  399. },
  400. {
  401. "id": "1b6fe78280544e328a638f80476830b3",
  402. "name": "Churned MRR",
  403. "description": "",
  404. "createdAt": "2019-08-16T17:28:09.208Z",
  405. "scenarios": {},
  406. "format": {
  407. "type": "Currency",
  408. "symbol": "$"
  409. },
  410. "modelSection": "Output",
  411. "type": "Function",
  412. "value": {
  413. "type": "Basic",
  414. "value": "{{ec41c847fea94f48a5ed5fd9a17b4d62[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}"
  415. }
  416. },
  417. {
  418. "id": "02478e9a53a6472c94692ee36f64af57",
  419. "name": "Net Income",
  420. "description": "",
  421. "createdAt": "2019-08-17T03:27:21.817Z",
  422. "scenarios": {},
  423. "format": {
  424. "type": "Currency",
  425. "symbol": "$"
  426. },
  427. "modelSection": "Output",
  428. "type": "Function",
  429. "value": {
  430. "type": "Basic",
  431. "value": "{{810bd3504bb74629b8c16b2c0a80fdf2[t]}}-{{5cbd2bbab4bf400a8609c4a78ddb25e4[t]}}-{{26f14e665db245aba86840a5decdafab[t]}}"
  432. }
  433. },
  434. {
  435. "id": "810bd3504bb74629b8c16b2c0a80fdf2",
  436. "name": "Revenues",
  437. "description": "",
  438. "createdAt": "2019-08-17T03:25:18.198Z",
  439. "scenarios": {},
  440. "format": {
  441. "type": "Currency",
  442. "symbol": "$"
  443. },
  444. "modelSection": "Output",
  445. "type": "Function",
  446. "value": {
  447. "type": "Basic",
  448. "value": "{{319ef851499d467b8a9ecd4439be7f76[t]}}*{{ac4952ef0c6442b9986409c3c8dcb1e9[t]}}"
  449. }
  450. },
  451. {
  452. "id": "dfc8752585eb497c83545d59e4ba9df4",
  453. "name": "LTV",
  454. "description": "",
  455. "createdAt": "2019-08-16T18:34:58.852Z",
  456. "scenarios": {},
  457. "format": {
  458. "type": "Currency",
  459. "symbol": "$"
  460. },
  461. "modelSection": "Output",
  462. "type": "Function",
  463. "value": {
  464. "type": "Basic",
  465. "value": "Math.max(0,1/{{ea7f96c573d343d2a31c533f3b3c0e7f[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}})"
  466. }
  467. },
  468. {
  469. "id": "ac4952ef0c6442b9986409c3c8dcb1e9",
  470. "name": "Ending Subscribers",
  471. "description": "",
  472. "createdAt": "2019-08-16T15:30:42.786Z",
  473. "scenarios": {},
  474. "format": {
  475. "type": "Number"
  476. },
  477. "modelSection": "Output",
  478. "type": "Function",
  479. "value": {
  480. "type": "Recursive",
  481. "startValue": "{{ec72596279f54c56bf886b11e55d5576[t]}}+{{9786a60554954237a7d439dd2d07d3ca[t]}}",
  482. "nextFunction": "{{ac4952ef0c6442b9986409c3c8dcb1e9[t-1]}}+{{823a4711cf1946a19d67502695a02c61[t]}}-{{ec41c847fea94f48a5ed5fd9a17b4d62[t]}}"
  483. }
  484. },
  485. {
  486. "id": "492a928444a44ef8a57c623e2d657d5b",
  487. "name": "MRR",
  488. "description": "",
  489. "createdAt": "2019-08-16T15:36:04.340Z",
  490. "scenarios": {},
  491. "format": {
  492. "type": "Currency",
  493. "symbol": "$"
  494. },
  495. "modelSection": "Output",
  496. "type": "Function",
  497. "value": {
  498. "type": "Basic",
  499. "value": "{{ac4952ef0c6442b9986409c3c8dcb1e9[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}"
  500. }
  501. },
  502. {
  503. "id": "4a18ea632e65419ab28bd8192097bf20",
  504. "name": "Growth Rate in New Subscribers",
  505. "description": "",
  506. "createdAt": "2019-08-13T21:16:19.321Z",
  507. "scenarios": {},
  508. "format": {
  509. "type": "Percent"
  510. },
  511. "modelSection": "Input",
  512. "type": "Distribution",
  513. "value": [
  514. {
  515. "mean": 0.025,
  516. "variance": 0.00038054660023609027
  517. },
  518. {
  519. "mean": 0.025,
  520. "variance": 0.00038054660023609027
  521. },
  522. {
  523. "mean": 0.025,
  524. "variance": 0.00038054660023609027
  525. },
  526. {
  527. "mean": 0.025,
  528. "variance": 0.00038054660023609027
  529. },
  530. {
  531. "mean": 0.025,
  532. "variance": 0.00038054660023609027
  533. },
  534. {
  535. "mean": 0.025,
  536. "variance": 0.00038054660023609027
  537. },
  538. {
  539. "mean": 0.025,
  540. "variance": 0.00038054660023609027
  541. },
  542. {
  543. "mean": 0.025,
  544. "variance": 0.00038054660023609027
  545. },
  546. {
  547. "mean": 0.025,
  548. "variance": 0.00038054660023609027
  549. },
  550. {
  551. "mean": 0.025,
  552. "variance": 0.00038054660023609027
  553. },
  554. {
  555. "mean": 0.025,
  556. "variance": 0.00038054660023609027
  557. },
  558. {
  559. "mean": 0.025,
  560. "variance": 0.00038054660023609027
  561. },
  562. {
  563. "mean": 0.025,
  564. "variance": 0.00038054660023609027
  565. },
  566. {
  567. "mean": 0.025,
  568. "variance": 0.00038054660023609027
  569. },
  570. {
  571. "mean": 0.025,
  572. "variance": 0.00038054660023609027
  573. },
  574. {
  575. "mean": 0.025,
  576. "variance": 0.00038054660023609027
  577. },
  578. {
  579. "mean": 0.025,
  580. "variance": 0.00038054660023609027
  581. },
  582. {
  583. "mean": 0.025,
  584. "variance": 0.00038054660023609027
  585. },
  586. {
  587. "mean": 0.025,
  588. "variance": 0.00038054660023609027
  589. },
  590. {
  591. "mean": 0.025,
  592. "variance": 0.00038054660023609027
  593. },
  594. {
  595. "mean": 0.025,
  596. "variance": 0.00038054660023609027
  597. },
  598. {
  599. "mean": 0.025,
  600. "variance": 0.00038054660023609027
  601. },
  602. {
  603. "mean": 0.025,
  604. "variance": 0.00038054660023609027
  605. },
  606. {
  607. "mean": 0.025,
  608. "variance": 0.00038054660023609027
  609. }
  610. ]
  611. },
  612. {
  613. "id": "1147f855df0a4978a00258a5160d8e21",
  614. "name": "Cash",
  615. "description": "",
  616. "createdAt": "2019-08-17T03:28:51.904Z",
  617. "scenarios": {},
  618. "format": {
  619. "type": "Currency",
  620. "symbol": "$"
  621. },
  622. "modelSection": "Output",
  623. "type": "Function",
  624. "value": {
  625. "type": "Recursive",
  626. "startValue": "{{fd0a79dabc17466bbf88890680076211[t]}}",
  627. "nextFunction": "{{1147f855df0a4978a00258a5160d8e21[t-1]}}+{{02478e9a53a6472c94692ee36f64af57[t]}}"
  628. }
  629. },
  630. {
  631. "id": "0acb393cd181491ab172908aa146c01c",
  632. "name": "Cumulative MRR",
  633. "description": "",
  634. "createdAt": "2019-08-16T15:44:18.834Z",
  635. "scenarios": {},
  636. "format": {
  637. "type": "Currency",
  638. "symbol": "$"
  639. },
  640. "modelSection": "Output",
  641. "type": "Function",
  642. "value": {
  643. "type": "Recursive",
  644. "startValue": "0",
  645. "nextFunction": "{{492a928444a44ef8a57c623e2d657d5b[t-1]}}+{{492a928444a44ef8a57c623e2d657d5b[t]}}"
  646. }
  647. },
  648. {
  649. "id": "1332850cc9634fb38aa3b1f449e045e2",
  650. "name": "New MRR",
  651. "description": "",
  652. "createdAt": "2019-08-16T17:27:24.041Z",
  653. "scenarios": {},
  654. "format": {
  655. "type": "Currency",
  656. "symbol": "$"
  657. },
  658. "modelSection": "Output",
  659. "type": "Function",
  660. "value": {
  661. "type": "Basic",
  662. "value": "{{823a4711cf1946a19d67502695a02c61[t]}}*{{319ef851499d467b8a9ecd4439be7f76[t]}}"
  663. }
  664. },
  665. {
  666. "id": "78c9c36460c24152945fd08a41792180",
  667. "name": "COGS, % of Revenue",
  668. "description": "",
  669. "createdAt": "2019-08-17T03:22:59.648Z",
  670. "scenarios": {},
  671. "format": {
  672. "type": "Percent"
  673. },
  674. "modelSection": "Output",
  675. "type": "Distribution",
  676. "value": [
  677. {
  678. "mean": 0.030000000000000002,
  679. "variance": 0.00024354982415109779
  680. }
  681. ]
  682. }
  683. ],
  684. "charts": [
  685. {
  686. "id": "e3b5280053bb4b59ae3b66d547bb1c4b",
  687. "type": "TimeSeriesChart",
  688. "name": "Subscribers, End of Period",
  689. "description": "# of subscribers at the end of the period",
  690. "createdAt": "2019-08-16T15:35:33.280Z",
  691. "variables": [
  692. "ac4952ef0c6442b9986409c3c8dcb1e9"
  693. ]
  694. },
  695. {
  696. "id": "0aedb9a9531348b5aa512a1475f36950",
  697. "type": "TimeSeriesChart",
  698. "name": "MRR",
  699. "description": "marginal recurring revenue, per period",
  700. "createdAt": "2019-08-16T15:38:13.480Z",
  701. "variables": [
  702. "492a928444a44ef8a57c623e2d657d5b"
  703. ]
  704. },
  705. {
  706. "id": "7178dc108c76408db1df39295148f021",
  707. "type": "DistributionChart",
  708. "name": "Cumulative MRR",
  709. "description": "cumulative MRR",
  710. "createdAt": "2019-08-16T15:49:01.252Z",
  711. "variables": [
  712. "0acb393cd181491ab172908aa146c01c"
  713. ]
  714. },
  715. {
  716. "id": "0af5043104cb42f78610e0da103a02a9",
  717. "type": "TimeSeriesChart",
  718. "name": "New and Churned MRR",
  719. "description": "",
  720. "createdAt": "2019-08-16T18:31:33.487Z",
  721. "variables": [
  722. "1332850cc9634fb38aa3b1f449e045e2",
  723. "1b6fe78280544e328a638f80476830b3"
  724. ]
  725. },
  726. {
  727. "id": "19df4ef037ce4d32aa579c9bfa670242",
  728. "type": "TimeSeriesChart",
  729. "name": "Cash, end of period",
  730. "description": "cash at end of period",
  731. "createdAt": "2019-08-17T03:34:45.169Z",
  732. "variables": [
  733. "1147f855df0a4978a00258a5160d8e21"
  734. ]
  735. }
  736. ],
  737. "scenarios": []
  738. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement