(Created page with "{| class="wikitable" |+Key assumptions !Input name !Input value !Commentary |- ! colspan="3" |Growth stage 1 |- |Accounts receivable (days) |51 | |- |Inventory (days) |32 | |- |Accounts payable (days) |32 | |- |Capital expenditure as a proportion of revenue (%) |10% | |- |Depreciation rate (%) |10% | |- |Equity issued/repurchased ($000) |$8,000,000 | |- |Debt issuance/repayment ($000) |$8,000,000 | |- |Interest rate (%) |4.00% | |- ! colspan="3" |Growth stage 3 |- |Accou...")
 
No edit summary
 
Line 605: Line 605:
|$2,275,550,081
|$2,275,550,081
|-
|-
|
|Liabilities
|
|
|
|
Line 667: Line 667:
|
|
|-
|-
|Liabilities
|Accounts payable ($000)
|
|$35
|
|$87
|
|$208
|
|$484
|
|$1,092
|
|$2,387
|
|$5,062
|
|$10,409
|
|$20,756
|
|$40,135
|
|$75,259
|
|$136,853
|
|$241,326
|
|$412,677
|
|$684,342
|
|$1,100,506
|
|$1,716,201
|
|$3,727,905
|
|$5,467,055
|
|$7,774,965
|
|$10,722,594
|
|$14,340,282
|
|$18,598,243
|
|$23,390,664
|
|$20,944,523
|
|$24,771,591
|
|$28,411,471
|
|$31,600,208
|
|$34,083,373
|
|$35,649,348
|
|$36,159,051
|
|$35,566,313
|
|$33,924,782
|
|$31,379,910
|
|$28,147,687
|
|$24,484,438
|
|$35,253,413
|
|$28,837,751
|
|$22,875,891
|
|$17,597,503
|
|$13,127,453
|
|$9,496,559
|
|$6,662,060
|
|$4,532,180
|
|$2,989,938
|
|$1,912,818
|
|$1,186,701
|
|$713,946
|
|$416,530
|
|$235,659
|
|$129,294
|
|$68,790
|
|$35,492
|
|$17,758
|
|$8,616
|
|$4,054
|
|$1,850
|
|$818
|
|$351
|
|$146
|-
|-
|Accounts payable ($000)
|Debt ($000)
|$35
|$8,000,000
|$87
|$16,000,000
|$208
|$24,000,000
|$484
|$32,000,000
|$1,092
|$40,000,000
|$2,387
|$48,000,000
|$5,062
|$56,000,000
|$10,409
|$64,000,000
|$20,756
|$72,000,000
|$40,135
|$80,000,000
|$75,259
|$88,000,000
|$136,853
|$96,000,000
|$241,326
|$104,000,000
|$412,677
|$112,000,000
|$684,342
|$120,000,000
|$1,100,506
|$128,000,000
|$1,716,201
|$136,000,000
|$3,727,905
|$144,000,000
|$5,467,055
|$152,000,000
|$7,774,965
|$160,000,000
|$10,722,594
|$168,000,000
|$14,340,282
|$176,000,000
|$18,598,243
|$184,000,000
|$23,390,664
|$192,000,000
|$20,944,523
|$200,000,000
|$24,771,591
|$208,000,000
|$28,411,471
|$216,000,000
|$31,600,208
|$224,000,000
|$34,083,373
|$232,000,000
|$35,649,348
|$240,000,000
|$36,159,051
|$248,000,000
|$35,566,313
|$256,000,000
|$33,924,782
|$264,000,000
|$31,379,910
|$272,000,000
|$28,147,687
|$280,000,000
|$24,484,438
|$288,000,000
|$35,253,413
|$296,000,000
|$28,837,751
|$304,000,000
|$22,875,891
|$312,000,000
|$17,597,503
|$320,000,000
|$13,127,453
|$328,000,000
|$9,496,559
|$336,000,000
|$6,662,060
|$344,000,000
|$4,532,180
|$352,000,000
|$2,989,938
|$360,000,000
|$1,912,818
|$368,000,000
|$1,186,701
|$376,000,000
|$713,946
|$384,000,000
|$416,530
|$392,000,000
|$235,659
|$400,000,000
|$129,294
|$408,000,000
|$68,790
|$416,000,000
|$35,492
|$424,000,000
|$17,758
|$432,000,000
|$8,616
|$440,000,000
|$4,054
|$448,000,000
|$1,850
|$456,000,000
|$818
|$464,000,000
|$351
|$472,000,000
|$146
|$480,000,000
|-
|-
|Debt ($000)
|Total liabilities ($000)
|$8,000,000
|$8,000,035
|$16,000,000
|$16,000,087
|$24,000,000
|$24,000,208
|$32,000,000
|$32,000,484
|$40,000,000
|$40,001,092
|$48,000,000
|$48,002,387
|$56,000,000
|$56,005,062
|$64,000,000
|$64,010,409
|$72,000,000
|$72,020,756
|$80,000,000
|$80,040,135
|$88,000,000
|$88,075,259
|$96,000,000
|$96,136,853
|$104,000,000
|$104,241,326
|$112,000,000
|$112,412,677
|$120,000,000
|$120,684,342
|$128,000,000
|$129,100,506
|$136,000,000
|$137,716,201
|$144,000,000
|$147,727,905
|$152,000,000
|$157,467,055
|$160,000,000
|$167,774,965
|$168,000,000
|$178,722,594
|$176,000,000
|$190,340,282
|$184,000,000
|$202,598,243
|$192,000,000
|$215,390,664
|$200,000,000
|$220,944,523
|$208,000,000
|$232,771,591
|$216,000,000
|$244,411,471
|$224,000,000
|$255,600,208
|$232,000,000
|$266,083,373
|$240,000,000
|$275,649,348
|$248,000,000
|$284,159,051
|$256,000,000
|$291,566,313
|$264,000,000
|$297,924,782
|$272,000,000
|$303,379,910
|$280,000,000
|$308,147,687
|$288,000,000
|$312,484,438
|$296,000,000
|$331,253,413
|$304,000,000
|$332,837,751
|$312,000,000
|$334,875,891
|$320,000,000
|$337,597,503
|$328,000,000
|$341,127,453
|$336,000,000
|$345,496,559
|$344,000,000
|$350,662,060
|$352,000,000
|$356,532,180
|$360,000,000
|$362,989,938
|$368,000,000
|$369,912,818
|$376,000,000
|$377,186,701
|$384,000,000
|$384,713,946
|$392,000,000
|$392,416,530
|$400,000,000
|$400,235,659
|$408,000,000
|$408,129,294
|$416,000,000
|$416,068,790
|$424,000,000
|$424,035,492
|$432,000,000
|$432,017,758
|$440,000,000
|$440,008,616
|$448,000,000
|$448,004,054
|$456,000,000
|$456,001,850
|$464,000,000
|$464,000,818
|$472,000,000
|$472,000,351
|$480,000,000
|$480,000,146
|-
|-
|Total liabilities ($000)
|Equity capital ($000)
|$8,000,035
|$8,000,000
|$16,000,087
|$8,000,000
|$24,000,208
|$8,000,000
|$32,000,484
|$8,000,000
|$40,001,092
|$8,000,000
|$48,002,387
|$8,000,000
|$56,005,062
|$8,000,000
|$64,010,409
|$8,000,000
|$72,020,756
|$8,000,000
|$80,040,135
|$8,000,000
|$88,075,259
|$8,000,000
|$96,136,853
|$8,000,000
|$104,241,326
|$8,000,000
|$112,412,677
|$8,000,000
|$120,684,342
|$8,000,000
|$129,100,506
|$8,000,000
|$137,716,201
|$8,000,000
|$147,727,905
|$8,000,000
|$157,467,055
|$8,000,000
|$167,774,965
|$8,000,000
|$178,722,594
|$8,000,000
|$190,340,282
|$8,000,000
|$202,598,243
|$8,000,000
|$215,390,664
|$8,000,000
|$220,944,523
|$8,000,000
|$232,771,591
|$8,000,000
|$244,411,471
|$8,000,000
|$255,600,208
|$8,000,000
|$266,083,373
|$8,000,000
|$275,649,348
|$8,000,000
|$284,159,051
|$8,000,000
|$291,566,313
|$8,000,000
|$297,924,782
|$8,000,000
|$303,379,910
|$8,000,000
|$308,147,687
|$8,000,000
|$312,484,438
|$8,000,000
|$331,253,413
|$8,000,000
|$332,837,751
|$8,000,000
|$334,875,891
|$8,000,000
|$337,597,503
|$8,000,000
|$341,127,453
|$8,000,000
|$345,496,559
|$8,000,000
|$350,662,060
|$8,000,000
|$356,532,180
|$8,000,000
|$362,989,938
|$8,000,000
|$369,912,818
|$8,000,000
|$377,186,701
|$8,000,000
|$384,713,946
|$8,000,000
|$392,416,530
|$8,000,000
|$400,235,659
|$8,000,000
|$408,129,294
|$8,000,000
|$416,068,790
|$8,000,000
|$424,035,492
|$8,000,000
|$432,017,758
|$8,000,000
|$440,008,616
|$8,000,000
|$448,004,054
|$8,000,000
|$456,001,850
|$8,000,000
|$464,000,818
|$8,000,000
|$472,000,351
|$8,000,000
|$480,000,146
|$8,000,000
|-
|-
|
|Retained earnings ($000)
|
|$173
|
|$600
|
|$1,623
|
|$4,004
|
|$9,370
|
|$21,105
|
|$45,986
|
|$97,148
|
|$199,164
|
|$396,429
|
|$766,332
|
|$1,438,971
|
|$2,625,099
|
|$4,653,428
|
|$8,017,006
|
|$13,426,055
|
|$21,861,281
|
|$24,735,513
|
|$28,950,638
|
|$34,945,173
|
|$43,212,344
|
|$54,268,770
|
|$68,608,103
|
|$86,642,416
|
|$197,730,202
|
|$329,116,396
|
|$479,808,175
|
|$647,412,717
|
|$828,187,733
|
|$1,017,268,533
|
|$1,209,052,748
|
|$1,397,693,136
|
|$1,577,627,001
|
|$1,744,063,101
|
|$1,893,355,796
|
|$2,023,218,960
|
|$1,966,355,027
|
|$1,919,839,589
|
|$1,882,940,661
|
|$1,854,555,800
|
|$1,833,381,152
|
|$1,818,063,154
|
|$1,807,317,218
|
|$1,800,006,789
|
|$1,795,184,004
|
|$1,792,098,619
|
|$1,790,184,464
|
|$1,789,032,865
|
|$1,788,361,000
|
|$1,787,980,881
|
|$1,787,772,330
|
|$1,787,661,371
|
|$1,787,604,122
|
|$1,787,575,478
|
|$1,787,561,580
|
|$1,787,555,041
|
|$1,787,552,057
|
|$1,787,550,737
|
|$1,787,550,171
|
|$1,787,549,935
|-
|-
|Equity capital ($000)
|Shareholders' equity ($000)
|$8,000,000
|$8,000,173
|$8,000,000
|$8,000,600
|$8,000,000
|$8,001,623
|$8,000,000
|$8,004,004
|$8,000,000
|$8,009,370
|$8,000,000
|$8,021,105
|$8,000,000
|$8,045,986
|$8,000,000
|$8,097,148
|$8,000,000
|$8,199,164
|$8,000,000
|$8,396,429
|$8,000,000
|$8,766,332
|$8,000,000
|$9,438,971
|$8,000,000
|$10,625,099
|$8,000,000
|$12,653,428
|$8,000,000
|$16,017,006
|$8,000,000
|$21,426,055
|$8,000,000
|$29,861,281
|$8,000,000
|$32,735,513
|$8,000,000
|$36,950,638
|$8,000,000
|$42,945,173
|$8,000,000
|$51,212,344
|$8,000,000
|$62,268,770
|$8,000,000
|$76,608,103
|$8,000,000
|$94,642,416
|$8,000,000
|$205,730,202
|$8,000,000
|$337,116,396
|$8,000,000
|$487,808,175
|$8,000,000
|$655,412,717
|$8,000,000
|$836,187,733
|$8,000,000
|$1,025,268,533
|$8,000,000
|$1,217,052,748
|$8,000,000
|$1,405,693,136
|$8,000,000
|$1,585,627,001
|$8,000,000
|$1,752,063,101
|$8,000,000
|$1,901,355,796
|$8,000,000
|$2,031,218,960
|$8,000,000
|$1,974,355,027
|$8,000,000
|$1,927,839,589
|$8,000,000
|$1,890,940,661
|$8,000,000
|$1,862,555,800
|$8,000,000
|$1,841,381,152
|$8,000,000
|$1,826,063,154
|$8,000,000
|$1,815,317,218
|$8,000,000
|$1,808,006,789
|$8,000,000
|$1,803,184,004
|$8,000,000
|$1,800,098,619
|$8,000,000
|$1,798,184,464
|$8,000,000
|$1,797,032,865
|$8,000,000
|$1,796,361,000
|$8,000,000
|$1,795,980,881
|$8,000,000
|$1,795,772,330
|$8,000,000
|$1,795,661,371
|$8,000,000
|$1,795,604,122
|$8,000,000
|$1,795,575,478
|$8,000,000
|$1,795,561,580
|$8,000,000
|$1,795,555,041
|$8,000,000
|$1,795,552,057
|$8,000,000
|$1,795,550,737
|$8,000,000
|$1,795,550,171
|$8,000,000
|$1,795,549,935
|-
|-
|Retained earnings ($000)
|Total liabilities & shareholders' equity ($000)
|$173
|$16,000,208
|$600
|$24,000,687
|$1,623
|$32,001,832
|$4,004
|$40,004,488
|$9,370
|$48,010,462
|$21,105
|$56,023,492
|$45,986
|$64,051,049
|$97,148
|$72,107,557
|$199,164
|$80,219,920
|$396,429
|$88,436,564
|$766,332
|$96,841,591
|$1,438,971
|$105,575,823
|$2,625,099
|$114,866,425
|$4,653,428
|$125,066,105
|$8,017,006
|$136,701,348
|$13,426,055
|$150,526,561
|$21,861,281
|$167,577,482
|$24,735,513
|$180,463,417
|$28,950,638
|$194,417,693
|$34,945,173
|$210,720,138
|$43,212,344
|$229,934,938
|$54,268,770
|$252,609,052
|$68,608,103
|$279,206,346
|$86,642,416
|$310,033,080
|$197,730,202
|$426,674,724
|$329,116,396
|$569,887,987
|$479,808,175
|$732,219,646
|$647,412,717
|$911,012,925
|$828,187,733
|$1,102,271,106
|$1,017,268,533
|$1,300,917,882
|$1,209,052,748
|$1,501,211,798
|$1,397,693,136
|$1,697,259,449
|$1,577,627,001
|$1,883,551,783
|$1,744,063,101
|$2,055,443,011
|$1,893,355,796
|$2,209,503,483
|$2,023,218,960
|$2,343,703,399
|$1,966,355,027
|$2,305,608,440
|$1,919,839,589
|$2,260,677,340
|$1,882,940,661
|$2,225,816,552
|$1,854,555,800
|$2,200,153,303
|$1,833,381,152
|$2,182,508,605
|$1,818,063,154
|$2,171,559,713
|$1,807,317,218
|$2,165,979,278
|$1,800,006,789
|$2,164,538,969
|$1,795,184,004
|$2,166,173,942
|$1,792,098,619
|$2,170,011,437
|$1,790,184,464
|$2,175,371,165
|$1,789,032,865
|$2,181,746,811
|$1,788,361,000
|$2,188,777,530
|$1,787,980,881
|$2,196,216,540
|$1,787,772,330
|$2,203,901,624
|$1,787,661,371
|$2,211,730,161
|$1,787,604,122
|$2,219,639,614
|$1,787,575,478
|$2,227,593,236
|$1,787,561,580
|$2,235,570,197
|$1,787,555,041
|$2,243,559,095
|$1,787,552,057
|$2,251,553,907
|$1,787,550,737
|$2,259,551,556
|$1,787,550,171
|$2,267,550,522
|$1,787,549,935
|$2,275,550,081
|-
|}
|Shareholders' equity ($000)
{| class="wikitable"
|$8,000,173
|+Cash flow statement
|$8,000,600
!Year
|$8,001,623
!'''1'''
|$8,004,004
!'''2'''
|$8,009,370
!'''3'''
|$8,021,105
!'''4'''
|$8,045,986
!'''5'''
|$8,097,148
!'''6'''
|$8,199,164
!'''7'''
|$8,396,429
!'''8'''
|$8,766,332
!'''9'''
|$9,438,971
!'''10'''
|$10,625,099
!'''11'''
|$12,653,428
!'''12'''
|$16,017,006
!'''13'''
|$21,426,055
!'''14'''
|$29,861,281
!'''15'''
|$32,735,513
!'''16'''
|$36,950,638
!'''17'''
|$42,945,173
!18
|$51,212,344
!19
|$62,268,770
!20
|$76,608,103
!21
|$94,642,416
!22
|$205,730,202
!23
|$337,116,396
!24
|$487,808,175
!25
|$655,412,717
!26
|$836,187,733
!27
|$1,025,268,533
!28
|$1,217,052,748
!29
|$1,405,693,136
!30
|$1,585,627,001
!31
|$1,752,063,101
!32
|$1,901,355,796
!33
|$2,031,218,960
!34
|$1,974,355,027
!35
|$1,927,839,589
!36
|$1,890,940,661
!37
|$1,862,555,800
!38
|$1,841,381,152
!39
|$1,826,063,154
!40
|$1,815,317,218
!41
|$1,808,006,789
!42
|$1,803,184,004
!43
|$1,800,098,619
!44
|$1,798,184,464
!45
|$1,797,032,865
!46
|$1,796,361,000
!47
|$1,795,980,881
!48
|$1,795,772,330
!49
|$1,795,661,371
!50
|$1,795,604,122
!51
|$1,795,575,478
!52
|$1,795,561,580
!53
|$1,795,555,041
!54
|$1,795,552,057
!55
|$1,795,550,737
!56
|$1,795,550,171
!57
|$1,795,549,935
!58
!59
!60
|-
|-
|Total liabilities & shareholders' equity ($000)
|'''Year end date'''
|$16,000,208
|'''31/12/2005'''
|$24,000,687
|'''31/12/2006'''
|$32,001,832
|'''31/12/2007'''
|$40,004,488
|'''31/12/2008'''
|$48,010,462
|'''31/12/2009'''
|$56,023,492
|'''31/12/2010'''
|$64,051,049
|'''31/12/2011'''
|$72,107,557
|'''31/12/2012'''
|$80,219,920
|'''31/12/2013'''
|$88,436,564
|'''31/12/2014'''
|$96,841,591
|'''31/12/2015'''
|$105,575,823
|'''31/12/2016'''
|$114,866,425
|'''31/12/2017'''
|$125,066,105
|'''31/12/2018'''
|$136,701,348
|'''31/12/2019'''
|$150,526,561
|'''31/12/2020'''
|$167,577,482
|'''31/12/2021'''
|$180,463,417
|'''31/12/2022'''
|$194,417,693
|'''31/12/2023'''
|$210,720,138
|'''31/12/2024'''
|$229,934,938
|'''31/12/2025'''
|$252,609,052
|'''31/12/2026'''
|$279,206,346
|'''31/12/2027'''
|$310,033,080
|'''31/12/2028'''
|$426,674,724
|'''31/12/2029'''
|$569,887,987
|'''31/12/2030'''
|$732,219,646
|'''31/12/2031'''
|$911,012,925
|'''31/12/2032'''
|$1,102,271,106
|'''31/12/2033'''
|$1,300,917,882
|'''31/12/2034'''
|$1,501,211,798
|'''31/12/2035'''
|$1,697,259,449
|'''31/12/2036'''
|$1,883,551,783
|'''31/12/2037'''
|$2,055,443,011
|'''31/12/2038'''
|$2,209,503,483
|'''31/12/2039'''
|$2,343,703,399
|'''31/12/2040'''
|$2,305,608,440
|'''31/12/2041'''
|$2,260,677,340
|'''31/12/2042'''
|$2,225,816,552
|'''31/12/2043'''
|$2,200,153,303
|'''31/12/2044'''
|$2,182,508,605
|'''31/12/2045'''
|$2,171,559,713
|'''31/12/2046'''
|$2,165,979,278
|'''31/12/2047'''
|$2,164,538,969
|'''31/12/2048'''
|$2,166,173,942
|'''31/12/2049'''
|$2,170,011,437
|'''31/12/2050'''
|$2,175,371,165
|'''31/12/2051'''
|$2,181,746,811
|'''31/12/2052'''
|$2,188,777,530
|'''31/12/2053'''
|$2,196,216,540
|'''31/12/2054'''
|$2,203,901,624
|'''31/12/2055'''
|$2,211,730,161
|'''31/12/2056'''
|$2,219,639,614
|'''31/12/2057'''
|$2,227,593,236
|'''31/12/2058'''
|$2,235,570,197
|'''31/12/2059'''
|$2,243,559,095
|'''31/12/2060'''
|$2,251,553,907
|'''31/12/2061'''
|$2,259,551,556
|'''31/12/2062'''
|$2,267,550,522
|'''31/12/2063'''
|$2,275,550,081
|'''31/12/2064'''
|}
|-
{| class="wikitable"
|Operating cash flow
|+Cash flow statement
|
!Year
|
!'''1'''
|
!'''2'''
|
!'''3'''
|
!'''4'''
|
!'''5'''
|
!'''6'''
|
!'''7'''
|
!'''8'''
|
!'''9'''
|
!'''10'''
|
!'''11'''
|
!'''12'''
|
!'''13'''
|
!'''14'''
|
!'''15'''
|
!'''16'''
|
!'''17'''
|
!18
|
!19
|
!20
|
!21
|
!22
|
!23
|
!24
|
!25
|
!26
|
!27
|
!28
|
!29
|
!30
|
!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
|-
|-
|'''Year end date'''
|Net earnings ($000)
|'''31/12/2005'''
|$173
|'''31/12/2006'''
|$427
|'''31/12/2007'''
|$1,024
|'''31/12/2008'''
|$2,380
|'''31/12/2009'''
|$5,367
|'''31/12/2010'''
|$11,735
|'''31/12/2011'''
|$24,881
|'''31/12/2012'''
|$51,162
|'''31/12/2013'''
|$102,016
|'''31/12/2014'''
|$197,265
|'''31/12/2015'''
|$369,903
|'''31/12/2016'''
|$672,638
|'''31/12/2017'''
|$1,186,129
|'''31/12/2018'''
|$2,028,329
|'''31/12/2019'''
|$3,363,578
|'''31/12/2020'''
|$5,409,049
|'''31/12/2021'''
|$8,435,226
|'''31/12/2022'''
|$2,874,232
|'''31/12/2023'''
|$4,215,125
|'''31/12/2024'''
|$5,994,535
|'''31/12/2025'''
|$8,267,171
|'''31/12/2026'''
|$11,056,426
|'''31/12/2027'''
|$14,339,334
|'''31/12/2028'''
|$18,034,313
|'''31/12/2029'''
|$111,087,786
|'''31/12/2030'''
|$131,386,195
|'''31/12/2031'''
|$150,691,779
|'''31/12/2032'''
|$167,604,542
|'''31/12/2033'''
|$180,775,016
|'''31/12/2034'''
|$189,080,801
|'''31/12/2035'''
|$191,784,214
|'''31/12/2036'''
|$188,640,389
|'''31/12/2037'''
|$179,933,864
|'''31/12/2038'''
|$166,436,101
|'''31/12/2039'''
|$149,292,695
|'''31/12/2040'''
|$129,863,165
|'''31/12/2041'''
| -$56,863,933
|'''31/12/2042'''
| -$46,515,439
|'''31/12/2043'''
| -$36,898,928
|'''31/12/2044'''
| -$28,384,861
|'''31/12/2045'''
| -$21,174,648
|'''31/12/2046'''
| -$15,317,998
|'''31/12/2047'''
| -$10,745,936
|'''31/12/2048'''
| -$7,310,429
|'''31/12/2049'''
| -$4,822,785
|'''31/12/2050'''
| -$3,085,385
|'''31/12/2051'''
| -$1,914,155
|'''31/12/2052'''
| -$1,151,599
|'''31/12/2053'''
| -$671,865
|'''31/12/2054'''
| -$380,119
|'''31/12/2055'''
| -$208,551
|'''31/12/2056'''
| -$110,959
|'''31/12/2057'''
| -$57,249
|'''31/12/2058'''
| -$28,644
|'''31/12/2059'''
| -$13,898
|'''31/12/2060'''
| -$6,539
|'''31/12/2061'''
| -$2,984
|'''31/12/2062'''
| -$1,320
|'''31/12/2063'''
| -$566
|'''31/12/2064'''
| -$236
|-
|-
|Operating cash flow
|Depreciation and amortisaiton ($000)
|
|0
|
|$11
|
|$27
|
|$65
|
|$151
|
|$340
|
|$743
|
|$1,575
|
|$3,238
|
|$6,457
|
|$12,485
|
|$23,412
|
|$42,572
|
|$75,071
|
|$128,375
|
|$212,885
|
|$342,345
|
|$533,875
|
|$538,246
|
|$789,349
|
|$1,122,572
|
|$1,548,159
|
|$2,070,492
|
|$2,685,268
|
|$3,377,212
|
|$1,235,682
|
|$1,461,470
|
|$1,676,216
|
|$1,864,344
|
|$2,010,846
|
|$2,103,235
|
|$2,133,306
|
|$2,098,336
|
|$2,001,489
|
|$1,851,347
|
|$1,660,653
|
|$1,444,529
|
|$406,171
|
|$332,253
|
|$263,564
|
|$202,749
|
|$151,247
|
|$109,414
|
|$76,757
|
|$52,217
|
|$34,448
|
|$22,038
|
|$13,673
|
|$8,226
|
|$4,799
|
|$2,715
|
|$1,490
|
|$793
|
|$409
|
|$205
|
|$99
|
|$47
|
|$21
|
|$9
|
|$4
|-
|-
|Net earnings ($000)
|Changes in working capital ($000)
|$173
|$102
|$427
|$150
|$1,024
|$352
|$2,380
|$800
|$5,367
|$1,761
|$11,735
|$3,754
|$24,881
|$7,751
|$51,162
|$15,494
|$102,016
|$29,982
|$197,265
|$56,155
|$369,903
|$101,781
|$672,638
|$178,481
|$1,186,129
|$302,734
|$2,028,329
|$496,529
|$3,363,578
|$787,211
|$5,409,049
|$1,205,931
|$8,435,226
|$1,784,117
|$2,874,232
|$2,547,611
|$4,215,125
|$3,508,570
|$5,994,535
|$4,655,990
|$8,267,171
|$5,946,562
|$11,056,426
|$7,298,342
|$14,339,334
|$8,590,032
|$18,034,313
|$9,668,254
|$111,087,786
|$10,363,855
|$131,386,195
|$10,516,189
|$150,691,779
|$10,001,826
|$167,604,542
|$8,762,155
|$180,775,016
|$6,823,352
|$189,080,801
|$4,303,056
|$191,784,214
|$1,400,583
|$188,640,389
| -$1,628,751
|$179,933,864
| -$4,510,671
|$166,436,101
| -$6,992,914
|$149,292,695
| -$8,881,646
|$129,863,165
| -$10,066,040
| -$56,863,933
| -$10,526,783
| -$46,515,439
| -$10,328,243
| -$36,898,928
| -$9,597,692
| -$28,384,861
| -$8,497,405
| -$21,174,648
| -$7,196,103
| -$15,317,998
| -$5,845,188
| -$10,745,936
| -$4,563,115
| -$7,310,429
| -$3,428,784
| -$4,822,785
| -$2,482,776
| -$3,085,385
| -$1,734,000
| -$1,914,155
| -$1,168,937
| -$1,151,599
| -$761,064
| -$671,865
| -$478,795
| -$380,119
| -$291,176
| -$208,551
| -$171,232
| -$110,959
| -$97,401
| -$57,249
| -$53,605
| -$28,644
| -$28,549
| -$13,898
| -$14,717
| -$6,539
| -$7,344
| -$2,984
| -$3,549
| -$1,320
| -$1,660
| -$566
| -$752
| -$236
| -$330
|-
|-
|Depreciation and amortisaiton ($000)
|Cash from operations ($000)
|0
|$71
|$11
|$288
|$27
|$699
|$65
|$1,645
|$151
|$3,757
|$340
|$8,320
|$743
|$17,873
|$1,575
|$37,243
|$3,238
|$75,272
|$6,457
|$147,567
|$12,485
|$280,608
|$23,412
|$517,569
|$42,572
|$925,967
|$75,071
|$1,606,872
|$128,375
|$2,704,742
|$212,885
|$4,416,003
|$342,345
|$6,993,454
|$533,875
|$860,496
|$538,246
|$1,244,801
|$789,349
|$2,127,894
|$1,122,572
|$3,443,181
|$1,548,159
|$5,306,243
|$2,070,492
|$7,819,793
|$2,685,268
|$11,051,328
|$3,377,212
|$104,101,142
|$1,235,682
|$122,105,688
|$1,461,470
|$142,151,423
|$1,676,216
|$160,518,602
|$1,864,344
|$175,816,008
|$2,010,846
|$186,788,590
|$2,103,235
|$192,486,866
|$2,133,306
|$192,402,446
|$2,098,336
|$186,542,871
|$2,001,489
|$175,430,504
|$1,851,347
|$160,025,688
|$1,660,653
|$141,589,858
|$1,444,529
| -$44,892,621
|$406,171
| -$35,781,025
|$332,253
| -$26,968,983
|$263,564
| -$19,623,892
|$202,749
| -$13,775,796
|$151,247
| -$9,321,563
|$109,414
| -$6,073,406
|$76,757
| -$3,804,889
|$52,217
| -$2,287,792
|$34,448
| -$1,316,936
|$22,038
| -$723,179
|$13,673
| -$376,863
|$8,226
| -$184,844
|$4,799
| -$84,144
|$2,715
| -$34,604
|$1,490
| -$12,068
|$793
| -$2,852
|$409
|$314
|$205
|$1,024
|$99
|$904
|$47
|$612
|$21
|$361
|$9
|$195
|$4
|$98
|-
|-
|Changes in working capital ($000)
|Investing cash flow
|$102
|
|$150
|
|$352
|
|$800
|
|$1,761
|
|$3,754
|
|$7,751
|
|$15,494
|
|$29,982
|
|$56,155
|
|$101,781
|
|$178,481
|
|$302,734
|
|$496,529
|
|$787,211
|
|$1,205,931
|
|$1,784,117
|
|$2,547,611
|
|$3,508,570
|
|$4,655,990
|
|$5,946,562
|
|$7,298,342
|
|$8,590,032
|
|$9,668,254
|
|$10,363,855
|
|$10,516,189
|
|$10,001,826
|
|$8,762,155
|
|$6,823,352
|
|$4,303,056
|
|$1,400,583
|
| -$1,628,751
|
| -$4,510,671
|
| -$6,992,914
|
| -$8,881,646
|
| -$10,066,040
|
| -$10,526,783
|
| -$10,328,243
|
| -$9,597,692
|
| -$8,497,405
|
| -$7,196,103
|
| -$5,845,188
|
| -$4,563,115
|
| -$3,428,784
|
| -$2,482,776
|
| -$1,734,000
|
| -$1,168,937
|
| -$761,064
|
| -$478,795
|
| -$291,176
|
| -$171,232
|
| -$97,401
|
| -$53,605
|
| -$28,549
|
| -$14,717
|
| -$7,344
|
| -$3,549
|
| -$1,660
|
| -$752
|
| -$330
|
|-
|-
|Cash from operations ($000)
|Investment in PP&E ($000)
|$71
|$109
|$288
|$270
|$699
|$648
|$1,645
|$1,506
|$3,757
|$3,397
|$8,320
|$7,427
|$17,873
|$15,748
|$37,243
|$32,381
|$75,272
|$64,567
|$147,567
|$124,851
|$280,608
|$234,116
|$517,569
|$425,720
|$925,967
|$750,714
|$1,606,872
|$1,283,753
|$2,704,742
|$2,128,847
|$4,416,003
|$3,423,449
|$6,993,454
|$5,338,751
|$860,496
|$5,382,457
|$1,244,801
|$7,893,493
|$2,127,894
|$11,225,721
|$3,443,181
|$15,481,594
|$5,306,243
|$20,704,917
|$7,819,793
|$26,852,685
|$11,051,328
|$33,772,121
|$104,101,142
|$12,356,817
|$122,105,688
|$14,614,705
|$142,151,423
|$16,762,156
|$160,518,602
|$18,643,442
|$175,816,008
|$20,108,456
|$186,788,590
|$21,032,347
|$192,486,866
|$21,333,061
|$192,402,446
|$20,983,358
|$186,542,871
|$20,014,890
|$175,430,504
|$18,513,471
|$160,025,688
|$16,606,529
|$141,589,858
|$14,445,291
| -$44,892,621
|$4,061,710
| -$35,781,025
|$3,322,531
| -$26,968,983
|$2,635,638
| -$19,623,892
|$2,027,490
| -$13,775,796
|$1,512,475
| -$9,321,563
|$1,094,143
| -$6,073,406
|$767,567
| -$3,804,889
|$522,174
| -$2,287,792
|$344,485
| -$1,316,936
|$220,385
| -$723,179
|$136,725
| -$376,863
|$82,257
| -$184,844
|$47,990
| -$84,144
|$27,151
| -$34,604
|$14,897
| -$12,068
|$7,926
| -$2,852
|$4,089
|$314
|$2,046
|$1,024
|$993
|$904
|$467
|$612
|$213
|$361
|$94
|$195
|$40
|$98
|$17
|-
|-
|Cash from investing ($000)
|$109
|$270
|$648
|$1,506
|$3,397
|$7,427
|$15,748
|$32,381
|$64,567
|$124,851
|$234,116
|$425,720
|$750,714
|$1,283,753
|$2,128,847
|$3,423,449
|$5,338,751
|$5,382,457
|$7,893,493
|$11,225,721
|$15,481,594
|$20,704,917
|$26,852,685
|$33,772,121
|$12,356,817
|$14,614,705
|$16,762,156
|$18,643,442
|$20,108,456
|$21,032,347
|$21,333,061
|$20,983,358
|$20,014,890
|$18,513,471
|$16,606,529
|$14,445,291
|$4,061,710
|$3,322,531
|$2,635,638
|$2,027,490
|$1,512,475
|$1,094,143
|$767,567
|$522,174
|$344,485
|$220,385
|$136,725
|$82,257
|$47,990
|$27,151
|$14,897
|$7,926
|$4,089
|$2,046
|$993
|$467
|$213
|$94
|$40
|$17
|-
|Finacing cash flow
|
|
|
|
Line 1,721: Line 1,784:
|
|
|
|
|
|-
|Investing cash flow
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|Investment in PP&E ($000)
|$109
|$270
|$648
|$1,506
|$3,397
|$7,427
|$15,748
|$32,381
|$64,567
|$124,851
|$234,116
|$425,720
|$750,714
|$1,283,753
|$2,128,847
|$3,423,449
|$5,338,751
|$5,382,457
|$7,893,493
|$11,225,721
|$15,481,594
|$20,704,917
|$26,852,685
|$33,772,121
|$12,356,817
|$14,614,705
|$16,762,156
|$18,643,442
|$20,108,456
|$21,032,347
|$21,333,061
|$20,983,358
|$20,014,890
|$18,513,471
|$16,606,529
|$14,445,291
|$4,061,710
|$3,322,531
|$2,635,638
|$2,027,490
|$1,512,475
|$1,094,143
|$767,567
|$522,174
|$344,485
|$220,385
|$136,725
|$82,257
|$47,990
|$27,151
|$14,897
|$7,926
|$4,089
|$2,046
|$993
|$467
|$213
|$94
|$40
|$17
|-
|-
|Cash from investing ($000)
|Issuance/repayment of debt
|$109
|$8,000,000.00
|$270
|$8,000,000.00
|$648
|$8,000,000.00
|$1,506
|$8,000,000.00
|$3,397
|$8,000,000.00
|$7,427
|$8,000,000.00
|$15,748
|$8,000,000.00
|$32,381
|$8,000,000.00
|$64,567
|$8,000,000.00
|$124,851
|$8,000,000.00
|$234,116
|$8,000,000.00
|$425,720
|$8,000,000.00
|$750,714
|$8,000,000.00
|$1,283,753
|$8,000,000.00
|$2,128,847
|$8,000,000.00
|$3,423,449
|$8,000,000.00
|$5,338,751
|$8,000,000.00
|$5,382,457
|$8,000,000.00
|$7,893,493
|$8,000,000.00
|$11,225,721
|$8,000,000.00
|$15,481,594
|$8,000,000.00
|$20,704,917
|$8,000,000.00
|$26,852,685
|$8,000,000.00
|$33,772,121
|$8,000,000.00
|$12,356,817
|$8,000,000.00
|$14,614,705
|$8,000,000.00
|$16,762,156
|$8,000,000.00
|$18,643,442
|$8,000,000.00
|$20,108,456
|$8,000,000.00
|$21,032,347
|$8,000,000.00
|$21,333,061
|$8,000,000.00
|$20,983,358
|$8,000,000.00
|$20,014,890
|$8,000,000.00
|$18,513,471
|$8,000,000.00
|$16,606,529
|$8,000,000.00
|$14,445,291
|$8,000,000.00
|$4,061,710
|$8,000,000.00
|$3,322,531
|$8,000,000.00
|$2,635,638
|$8,000,000.00
|$2,027,490
|$8,000,000.00
|$1,512,475
|$8,000,000.00
|$1,094,143
|$8,000,000.00
|$767,567
|$8,000,000.00
|$522,174
|$8,000,000.00
|$344,485
|$8,000,000.00
|$220,385
|$8,000,000.00
|$136,725
|$8,000,000.00
|$82,257
|$8,000,000.00
|$47,990
|$8,000,000.00
|$27,151
|$8,000,000.00
|$14,897
|$8,000,000.00
|$7,926
|$8,000,000.00
|$4,089
|$8,000,000.00
|$2,046
|$8,000,000.00
|$993
|$8,000,000.00
|$467
|$8,000,000.00
|$213
|$8,000,000.00
|$94
|$8,000,000.00
|$40
|$8,000,000.00
|$17
|$8,000,000.00
|-
|Issuance/repayment of equity
|$8,000,000
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|-
|-
|
|Cash from financing
|
|$16,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|
|$8,000,000
|-
|Finacing cash flow
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|Issuance/repayment of debt
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|$8,000,000.00
|-
|Issuance/repayment of equity
|$8,000,000
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|0
|-
|Cash from financing
|$16,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|$8,000,000
|-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
|-
|Net increase/decrease in cash
|Net increase/decrease in cash

Latest revision as of 23:43, 6 October 2022

Key assumptions
Input name Input value Commentary
Growth stage 1
Accounts receivable (days) 51
Inventory (days) 32
Accounts payable (days) 32
Capital expenditure as a proportion of revenue (%) 10%
Depreciation rate (%) 10%
Equity issued/repurchased ($000) $8,000,000
Debt issuance/repayment ($000) $8,000,000
Interest rate (%) 4.00%
Growth stage 3
Accounts receivable (days) 51
Inventory (days) 32
Accounts payable (days) 32
Capital expenditure as a proportion of revenue (%) 10%
Depreciation rate (%) 10%
Equity issued/repurchased ($000) $8,000,000
Debt issuance/repayment ($000) $8,000,000
Interest rate (%) 4.00%
Growth stage 4
Accounts receivable (days) 51
Inventory (days) 32
Accounts payable (days) 32
Capital expenditure as a proportion of revenue (%) 10%
Depreciation rate (%) 10%
Equity issued/repurchased ($000) $8,000,000
Debt issuance/repayment ($000) $8,000,000
Interest rate (%) 4.00%
Balance sheet
Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 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
Year end date 31/12/2005 31/12/2006 31/12/2007 31/12/2008 31/12/2009 31/12/2010 31/12/2011 31/12/2012 31/12/2013 31/12/2014 31/12/2015 31/12/2016 31/12/2017 31/12/2018 31/12/2019 31/12/2020 31/12/2021 31/12/2022 31/12/2023 31/12/2024 31/12/2025 31/12/2026 31/12/2027 31/12/2028 31/12/2029 31/12/2030 31/12/2031 31/12/2032 31/12/2033 31/12/2034 31/12/2035 31/12/2036 31/12/2037 31/12/2038 31/12/2039 31/12/2040 31/12/2041 31/12/2042 31/12/2043 31/12/2044 31/12/2045 31/12/2046 31/12/2047 31/12/2048 31/12/2049 31/12/2050 31/12/2051 31/12/2052 31/12/2053 31/12/2054 31/12/2055 31/12/2056 31/12/2057 31/12/2058 31/12/2059 31/12/2060 31/12/2061 31/12/2062 31/12/2063 31/12/2064
Assets
Cash ($000) $15,999,962 $23,999,979 $32,000,030 $40,000,169 $48,000,529 $56,001,422 $64,003,548 $72,008,409 $80,019,115 $88,041,830 $96,088,322 $104,180,170 $112,355,423 $120,678,542 $129,254,437 $138,246,991 $147,901,695 $151,379,734 $152,731,042 $151,633,215 $147,594,802 $140,196,129 $129,163,237 $114,442,444 $214,186,769 $329,677,752 $463,067,019 $612,942,180 $776,649,732 $950,405,975 $1,129,559,781 $1,308,978,869 $1,483,506,850 $1,648,423,883 $1,799,843,042 $1,934,987,609 $1,894,033,278 $1,862,929,722 $1,841,325,102 $1,827,673,720 $1,820,385,450 $1,817,969,744 $1,819,128,771 $1,822,801,709 $1,828,169,432 $1,834,632,112 $1,841,772,207 $1,849,313,087 $1,857,080,253 $1,864,968,958 $1,872,919,457 $1,880,899,463 $1,888,892,522 $1,896,890,790 $1,904,890,821 $1,912,891,259 $1,920,891,657 $1,928,891,924 $1,936,892,079 $1,944,892,161
Accounts receivable ($000) $102 $252 $604 $1,403 $3,164 $6,918 $14,669 $30,163 $60,145 $116,300 $218,080 $396,562 $699,296 $1,195,824 $1,983,035 $3,188,966 $4,973,083 $7,520,694 $11,029,264 $15,685,254 $21,631,816 $28,930,158 $37,520,190 $47,188,443 $57,552,299 $68,068,487 $78,070,314 $86,832,469 $93,655,821 $97,958,877 $99,359,460 $97,730,709 $93,220,037 $86,227,123 $77,345,477 $67,279,437 $56,752,653 $46,424,410 $36,826,718 $28,329,313 $21,133,210 $15,288,022 $10,724,907 $7,296,123 $4,813,347 $3,079,347 $1,910,409 $1,149,346 $670,550 $379,375 $208,143 $110,742 $57,137 $28,588 $13,871 $6,526 $2,978 $1,318 $565 $235
Inventory ($000) $35 $87 $208 $484 $1,092 $2,387 $5,062 $10,409 $20,756 $40,135 $75,259 $136,853 $241,326 $412,677 $684,342 $1,100,506 $1,716,201 $3,727,905 $5,467,055 $7,774,965 $10,722,594 $14,340,282 $18,598,243 $23,390,664 $20,944,523 $24,771,591 $28,411,471 $31,600,208 $34,083,373 $35,649,348 $36,159,051 $35,566,313 $33,924,782 $31,379,910 $28,147,687 $24,484,438 $35,253,413 $28,837,751 $22,875,891 $17,597,503 $13,127,453 $9,496,559 $6,662,060 $4,532,180 $2,989,938 $1,912,818 $1,186,701 $713,946 $416,530 $235,659 $129,294 $68,790 $35,492 $17,758 $8,616 $4,054 $1,850 $818 $351 $146
Propery, plant and equipment ($000) $109 $369 $989 $2,431 $5,677 $12,764 $27,769 $58,575 $119,905 $238,299 $459,930 $862,239 $1,570,381 $2,779,062 $4,779,534 $7,990,098 $12,986,503 $17,835,085 $25,190,333 $35,626,704 $49,985,726 $69,142,483 $93,924,676 $125,011,529 $133,991,134 $147,370,157 $162,670,842 $179,638,068 $197,882,180 $216,903,681 $236,133,507 $254,983,559 $272,900,114 $289,412,095 $304,167,277 $316,951,915 $319,569,095 $322,485,456 $324,788,840 $326,552,767 $327,862,492 $328,805,388 $329,463,540 $329,908,957 $330,201,224 $330,387,161 $330,501,847 $330,570,432 $330,610,197 $330,632,549 $330,644,730 $330,651,166 $330,654,463 $330,656,100 $330,656,888 $330,657,256 $330,657,422 $330,657,495 $330,657,526 $330,657,539
Total assets ($000) $16,000,208 $24,000,687 $32,001,832 $40,004,488 $48,010,462 $56,023,492 $64,051,049 $72,107,557 $80,219,920 $88,436,564 $96,841,591 $105,575,823 $114,866,425 $125,066,105 $136,701,348 $150,526,561 $167,577,482 $180,463,417 $194,417,693 $210,720,138 $229,934,938 $252,609,052 $279,206,346 $310,033,080 $426,674,724 $569,887,987 $732,219,646 $911,012,925 $1,102,271,106 $1,300,917,882 $1,501,211,798 $1,697,259,449 $1,883,551,783 $2,055,443,011 $2,209,503,483 $2,343,703,399 $2,305,608,440 $2,260,677,340 $2,225,816,552 $2,200,153,303 $2,182,508,605 $2,171,559,713 $2,165,979,278 $2,164,538,969 $2,166,173,942 $2,170,011,437 $2,175,371,165 $2,181,746,811 $2,188,777,530 $2,196,216,540 $2,203,901,624 $2,211,730,161 $2,219,639,614 $2,227,593,236 $2,235,570,197 $2,243,559,095 $2,251,553,907 $2,259,551,556 $2,267,550,522 $2,275,550,081
Liabilities
Accounts payable ($000) $35 $87 $208 $484 $1,092 $2,387 $5,062 $10,409 $20,756 $40,135 $75,259 $136,853 $241,326 $412,677 $684,342 $1,100,506 $1,716,201 $3,727,905 $5,467,055 $7,774,965 $10,722,594 $14,340,282 $18,598,243 $23,390,664 $20,944,523 $24,771,591 $28,411,471 $31,600,208 $34,083,373 $35,649,348 $36,159,051 $35,566,313 $33,924,782 $31,379,910 $28,147,687 $24,484,438 $35,253,413 $28,837,751 $22,875,891 $17,597,503 $13,127,453 $9,496,559 $6,662,060 $4,532,180 $2,989,938 $1,912,818 $1,186,701 $713,946 $416,530 $235,659 $129,294 $68,790 $35,492 $17,758 $8,616 $4,054 $1,850 $818 $351 $146
Debt ($000) $8,000,000 $16,000,000 $24,000,000 $32,000,000 $40,000,000 $48,000,000 $56,000,000 $64,000,000 $72,000,000 $80,000,000 $88,000,000 $96,000,000 $104,000,000 $112,000,000 $120,000,000 $128,000,000 $136,000,000 $144,000,000 $152,000,000 $160,000,000 $168,000,000 $176,000,000 $184,000,000 $192,000,000 $200,000,000 $208,000,000 $216,000,000 $224,000,000 $232,000,000 $240,000,000 $248,000,000 $256,000,000 $264,000,000 $272,000,000 $280,000,000 $288,000,000 $296,000,000 $304,000,000 $312,000,000 $320,000,000 $328,000,000 $336,000,000 $344,000,000 $352,000,000 $360,000,000 $368,000,000 $376,000,000 $384,000,000 $392,000,000 $400,000,000 $408,000,000 $416,000,000 $424,000,000 $432,000,000 $440,000,000 $448,000,000 $456,000,000 $464,000,000 $472,000,000 $480,000,000
Total liabilities ($000) $8,000,035 $16,000,087 $24,000,208 $32,000,484 $40,001,092 $48,002,387 $56,005,062 $64,010,409 $72,020,756 $80,040,135 $88,075,259 $96,136,853 $104,241,326 $112,412,677 $120,684,342 $129,100,506 $137,716,201 $147,727,905 $157,467,055 $167,774,965 $178,722,594 $190,340,282 $202,598,243 $215,390,664 $220,944,523 $232,771,591 $244,411,471 $255,600,208 $266,083,373 $275,649,348 $284,159,051 $291,566,313 $297,924,782 $303,379,910 $308,147,687 $312,484,438 $331,253,413 $332,837,751 $334,875,891 $337,597,503 $341,127,453 $345,496,559 $350,662,060 $356,532,180 $362,989,938 $369,912,818 $377,186,701 $384,713,946 $392,416,530 $400,235,659 $408,129,294 $416,068,790 $424,035,492 $432,017,758 $440,008,616 $448,004,054 $456,001,850 $464,000,818 $472,000,351 $480,000,146
Equity capital ($000) $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000
Retained earnings ($000) $173 $600 $1,623 $4,004 $9,370 $21,105 $45,986 $97,148 $199,164 $396,429 $766,332 $1,438,971 $2,625,099 $4,653,428 $8,017,006 $13,426,055 $21,861,281 $24,735,513 $28,950,638 $34,945,173 $43,212,344 $54,268,770 $68,608,103 $86,642,416 $197,730,202 $329,116,396 $479,808,175 $647,412,717 $828,187,733 $1,017,268,533 $1,209,052,748 $1,397,693,136 $1,577,627,001 $1,744,063,101 $1,893,355,796 $2,023,218,960 $1,966,355,027 $1,919,839,589 $1,882,940,661 $1,854,555,800 $1,833,381,152 $1,818,063,154 $1,807,317,218 $1,800,006,789 $1,795,184,004 $1,792,098,619 $1,790,184,464 $1,789,032,865 $1,788,361,000 $1,787,980,881 $1,787,772,330 $1,787,661,371 $1,787,604,122 $1,787,575,478 $1,787,561,580 $1,787,555,041 $1,787,552,057 $1,787,550,737 $1,787,550,171 $1,787,549,935
Shareholders' equity ($000) $8,000,173 $8,000,600 $8,001,623 $8,004,004 $8,009,370 $8,021,105 $8,045,986 $8,097,148 $8,199,164 $8,396,429 $8,766,332 $9,438,971 $10,625,099 $12,653,428 $16,017,006 $21,426,055 $29,861,281 $32,735,513 $36,950,638 $42,945,173 $51,212,344 $62,268,770 $76,608,103 $94,642,416 $205,730,202 $337,116,396 $487,808,175 $655,412,717 $836,187,733 $1,025,268,533 $1,217,052,748 $1,405,693,136 $1,585,627,001 $1,752,063,101 $1,901,355,796 $2,031,218,960 $1,974,355,027 $1,927,839,589 $1,890,940,661 $1,862,555,800 $1,841,381,152 $1,826,063,154 $1,815,317,218 $1,808,006,789 $1,803,184,004 $1,800,098,619 $1,798,184,464 $1,797,032,865 $1,796,361,000 $1,795,980,881 $1,795,772,330 $1,795,661,371 $1,795,604,122 $1,795,575,478 $1,795,561,580 $1,795,555,041 $1,795,552,057 $1,795,550,737 $1,795,550,171 $1,795,549,935
Total liabilities & shareholders' equity ($000) $16,000,208 $24,000,687 $32,001,832 $40,004,488 $48,010,462 $56,023,492 $64,051,049 $72,107,557 $80,219,920 $88,436,564 $96,841,591 $105,575,823 $114,866,425 $125,066,105 $136,701,348 $150,526,561 $167,577,482 $180,463,417 $194,417,693 $210,720,138 $229,934,938 $252,609,052 $279,206,346 $310,033,080 $426,674,724 $569,887,987 $732,219,646 $911,012,925 $1,102,271,106 $1,300,917,882 $1,501,211,798 $1,697,259,449 $1,883,551,783 $2,055,443,011 $2,209,503,483 $2,343,703,399 $2,305,608,440 $2,260,677,340 $2,225,816,552 $2,200,153,303 $2,182,508,605 $2,171,559,713 $2,165,979,278 $2,164,538,969 $2,166,173,942 $2,170,011,437 $2,175,371,165 $2,181,746,811 $2,188,777,530 $2,196,216,540 $2,203,901,624 $2,211,730,161 $2,219,639,614 $2,227,593,236 $2,235,570,197 $2,243,559,095 $2,251,553,907 $2,259,551,556 $2,267,550,522 $2,275,550,081
Cash flow statement
Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 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
Year end date 31/12/2005 31/12/2006 31/12/2007 31/12/2008 31/12/2009 31/12/2010 31/12/2011 31/12/2012 31/12/2013 31/12/2014 31/12/2015 31/12/2016 31/12/2017 31/12/2018 31/12/2019 31/12/2020 31/12/2021 31/12/2022 31/12/2023 31/12/2024 31/12/2025 31/12/2026 31/12/2027 31/12/2028 31/12/2029 31/12/2030 31/12/2031 31/12/2032 31/12/2033 31/12/2034 31/12/2035 31/12/2036 31/12/2037 31/12/2038 31/12/2039 31/12/2040 31/12/2041 31/12/2042 31/12/2043 31/12/2044 31/12/2045 31/12/2046 31/12/2047 31/12/2048 31/12/2049 31/12/2050 31/12/2051 31/12/2052 31/12/2053 31/12/2054 31/12/2055 31/12/2056 31/12/2057 31/12/2058 31/12/2059 31/12/2060 31/12/2061 31/12/2062 31/12/2063 31/12/2064
Operating cash flow
Net earnings ($000) $173 $427 $1,024 $2,380 $5,367 $11,735 $24,881 $51,162 $102,016 $197,265 $369,903 $672,638 $1,186,129 $2,028,329 $3,363,578 $5,409,049 $8,435,226 $2,874,232 $4,215,125 $5,994,535 $8,267,171 $11,056,426 $14,339,334 $18,034,313 $111,087,786 $131,386,195 $150,691,779 $167,604,542 $180,775,016 $189,080,801 $191,784,214 $188,640,389 $179,933,864 $166,436,101 $149,292,695 $129,863,165 -$56,863,933 -$46,515,439 -$36,898,928 -$28,384,861 -$21,174,648 -$15,317,998 -$10,745,936 -$7,310,429 -$4,822,785 -$3,085,385 -$1,914,155 -$1,151,599 -$671,865 -$380,119 -$208,551 -$110,959 -$57,249 -$28,644 -$13,898 -$6,539 -$2,984 -$1,320 -$566 -$236
Depreciation and amortisaiton ($000) 0 $11 $27 $65 $151 $340 $743 $1,575 $3,238 $6,457 $12,485 $23,412 $42,572 $75,071 $128,375 $212,885 $342,345 $533,875 $538,246 $789,349 $1,122,572 $1,548,159 $2,070,492 $2,685,268 $3,377,212 $1,235,682 $1,461,470 $1,676,216 $1,864,344 $2,010,846 $2,103,235 $2,133,306 $2,098,336 $2,001,489 $1,851,347 $1,660,653 $1,444,529 $406,171 $332,253 $263,564 $202,749 $151,247 $109,414 $76,757 $52,217 $34,448 $22,038 $13,673 $8,226 $4,799 $2,715 $1,490 $793 $409 $205 $99 $47 $21 $9 $4
Changes in working capital ($000) $102 $150 $352 $800 $1,761 $3,754 $7,751 $15,494 $29,982 $56,155 $101,781 $178,481 $302,734 $496,529 $787,211 $1,205,931 $1,784,117 $2,547,611 $3,508,570 $4,655,990 $5,946,562 $7,298,342 $8,590,032 $9,668,254 $10,363,855 $10,516,189 $10,001,826 $8,762,155 $6,823,352 $4,303,056 $1,400,583 -$1,628,751 -$4,510,671 -$6,992,914 -$8,881,646 -$10,066,040 -$10,526,783 -$10,328,243 -$9,597,692 -$8,497,405 -$7,196,103 -$5,845,188 -$4,563,115 -$3,428,784 -$2,482,776 -$1,734,000 -$1,168,937 -$761,064 -$478,795 -$291,176 -$171,232 -$97,401 -$53,605 -$28,549 -$14,717 -$7,344 -$3,549 -$1,660 -$752 -$330
Cash from operations ($000) $71 $288 $699 $1,645 $3,757 $8,320 $17,873 $37,243 $75,272 $147,567 $280,608 $517,569 $925,967 $1,606,872 $2,704,742 $4,416,003 $6,993,454 $860,496 $1,244,801 $2,127,894 $3,443,181 $5,306,243 $7,819,793 $11,051,328 $104,101,142 $122,105,688 $142,151,423 $160,518,602 $175,816,008 $186,788,590 $192,486,866 $192,402,446 $186,542,871 $175,430,504 $160,025,688 $141,589,858 -$44,892,621 -$35,781,025 -$26,968,983 -$19,623,892 -$13,775,796 -$9,321,563 -$6,073,406 -$3,804,889 -$2,287,792 -$1,316,936 -$723,179 -$376,863 -$184,844 -$84,144 -$34,604 -$12,068 -$2,852 $314 $1,024 $904 $612 $361 $195 $98
Investing cash flow
Investment in PP&E ($000) $109 $270 $648 $1,506 $3,397 $7,427 $15,748 $32,381 $64,567 $124,851 $234,116 $425,720 $750,714 $1,283,753 $2,128,847 $3,423,449 $5,338,751 $5,382,457 $7,893,493 $11,225,721 $15,481,594 $20,704,917 $26,852,685 $33,772,121 $12,356,817 $14,614,705 $16,762,156 $18,643,442 $20,108,456 $21,032,347 $21,333,061 $20,983,358 $20,014,890 $18,513,471 $16,606,529 $14,445,291 $4,061,710 $3,322,531 $2,635,638 $2,027,490 $1,512,475 $1,094,143 $767,567 $522,174 $344,485 $220,385 $136,725 $82,257 $47,990 $27,151 $14,897 $7,926 $4,089 $2,046 $993 $467 $213 $94 $40 $17
Cash from investing ($000) $109 $270 $648 $1,506 $3,397 $7,427 $15,748 $32,381 $64,567 $124,851 $234,116 $425,720 $750,714 $1,283,753 $2,128,847 $3,423,449 $5,338,751 $5,382,457 $7,893,493 $11,225,721 $15,481,594 $20,704,917 $26,852,685 $33,772,121 $12,356,817 $14,614,705 $16,762,156 $18,643,442 $20,108,456 $21,032,347 $21,333,061 $20,983,358 $20,014,890 $18,513,471 $16,606,529 $14,445,291 $4,061,710 $3,322,531 $2,635,638 $2,027,490 $1,512,475 $1,094,143 $767,567 $522,174 $344,485 $220,385 $136,725 $82,257 $47,990 $27,151 $14,897 $7,926 $4,089 $2,046 $993 $467 $213 $94 $40 $17
Finacing cash flow
Issuance/repayment of debt $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00
Issuance/repayment of equity $8,000,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cash from financing $16,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000 $8,000,000
Net increase/decrease in cash $15,999,962 $8,000,018 $8,000,051 $8,000,139 $8,000,360 $8,000,893 $8,002,125 $8,004,862 $8,010,705 $8,022,715 $8,046,492 $8,091,848 $8,175,252 $8,323,119 $8,575,895 $8,992,554 $9,654,703 $3,478,039 $1,351,308 -$1,097,827 -$4,038,413 -$7,398,674 -$11,032,891 -$14,720,794 $99,744,325 $115,490,983 $133,389,267 $149,875,161 $163,707,553 $173,756,243 $179,153,805 $179,419,088 $174,527,981 $164,917,033 $151,419,159 $135,144,567 -$40,954,330 -$31,103,556 -$21,604,620 -$13,651,382 -$7,288,271 -$2,415,705 $1,159,027 $3,672,938 $5,367,724 $6,462,679 $7,140,095 $7,540,880 $7,767,166 $7,888,705 $7,950,499 $7,980,006 $7,993,059 $7,998,268 $8,000,031 $8,000,437 $8,000,398 $8,000,267 $8,000,155 $8,000,082