Spreadsheet: 467720d1466870352-break-even-analysis-related-to-initial-investment-break-even-analysis
Sheet: Break-even analysis

Production
A | 231 | 242.9888884374689 | 255.9868619532748 | 269.7466685336281 | 270.0618234376144 | 267.9498526738723 | 274.2768245374303 | 282.7322027188688 | 285.4312418196506 | 301.4740436719611 | 307.9292893637444 | 319.7409086980505 | 324.2494219053915 | 327.9789643312368 | 340.6591717906927
B | 120 | 122.7543513434712 | 128.9299766001022 | 134.6639093032706 | 190.1109247045625 | 201.4147235542318 | 206.2459466412353 | 213.2901788564679 | 218.3984638289539 | 221.698422230311 | 229.9091363972782 | 242.0899729539208 | 250.578711943549 | 197.4206679143606 | 207.3519333855656
C | 400 | 416.0667982279041 | 429.3571818790697 | 445.9708228462147 | 452.0343001714049 | 440.7960894678302 | 459.755064489583 | 471.6654918317936 | 491.2383154606042 | 496.2616216784261 | 532.3607161421806 | 547.7108210849369 | 589.812173196637 | 607.587780072918 | 619.134545070973
D | 200 | 205.542770389952 | 222.9190222303454 | 233.5740990451949 | 240.42139417509 | 238.9406362311219 | 248.7318468901502 | 258.7936417539447 | 263.6247480920898 | 267.1052393441569 | 268.1038352847188 | 272.9103084740165 | 278.1649634725078 | 283.0966294355533 | 291.6874231017092
E | 654 | 698.8743013023354 | 716.9720492662659 | 727.0979872627654 | 727.8158375207103 | 747.6394210910988 | 759.436771419943 | 759.6396746938377 | 780.4803857781418 | 777.8470079872488 | 820.9356404638545 | 901.9332834779962 | 926.2048818414884 | 964.9132786401377 | 983.9417679846758
Scaled Production
A
B
C
D
E
Margins
A | 0.3 | 0.3034126445888459 | 0.3029714918454366 | 0.3017519322277469 | 0.300931247145319 | 0.2962226732485869 | 0.2943562996643445 | 0.2877851467715598 | 0.2906027083755408 | 0.2958116421077465 | 0.2941946261151041 | 0.2985994140970299 | 0.2949582617635647 | 0.2887950122400277 | 0.2940776314989461
B | 0.21 | 0.2135539883140874 | 0.2111964673038345 | 0.2087288086134409 | 0.2034569635644508 | 0.2001779294298614 | 0.2039640701946595 | 0.2078413177169555 | 0.2108509122480452 | 0.2108785430817316 | 0.2121062442790296 | 0.2153443143145073 | 0.2183072702436427 | 0.2242935686705645 | 0.2243656793450955
C | 0.2 | 0.1987579211531854 | 0.1985932930136712 | 0.2021145796523234 | 0.2034129362883486 | 0.1994456038640803 | 0.2018043817539213 | 0.2029140652394729 | 0.2001287702558906 | 0.2032605211772519 | 0.2016934505571444 | 0.2059313555911931 | 0.2075062889437088 | 0.2112338834626833 | 0.2161555996112806
D | 0.3 | 0.2961341218124657 | 0.2910068436263561 | 0.2882783087937089 | 0.2859343742597581 | 0.2864958969747743 | 0.2839715060893013 | 0.2900365999028826 | 0.2863991285093249 | 0.2904663137734409 | 0.289325554983669 | 0.291212871919162 | 0.2845516974642691 | 0.2842706325014197 | 0.2794254182142808
E | 0.1 | 0.1002490839622296 | 0.1001027901056202 | 0.1021560718106318 | 0.1026344737610874 | 0.1036734102997232 | 0.1042655278311518 | 0.1019894857279118 | 0.1015510936299976 | 0.09934768489248455 | 0.09761753596816125 | 0.09624500270222308 | 0.09528094464236901 | 0.09329164965857618 | 0.09106707030846113
Investments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Investments
A | 122.5951522737573 |  |  | 20 |  |  | 50 |  |  |  |  |  | 5 |  |  |  | 500
B | 258.2937590603452 |  |  |  | 100 |  | 90 |  |  | 9 |  |  |  |  | 80 |  | 200
C | 311.2506652335313 | 100 |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  | 600
D | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400
E | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
Profit
A
B
C
D
E
Cash flow
A
B
C
D
E
NPVs at
0.1 | Cash Flow
A
B
C
D
E