|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
Mini Buses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Mini buses |
|
|
|
|
|
|
|
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
50 |
50 |
50 |
50 |
60 |
60 |
60 |
60 |
70 |
70 |
70 |
70 |
80 |
80 |
80 |
80 |
90 |
90 |
90 |
90 |
95 |
95 |
95 |
95 |
100 |
100 |
100 |
100 |
102 |
102 |
102 |
102 |
105 |
105 |
105 |
105 |
106 |
106 |
106 |
106 |
Conservative |
|
25 |
25 |
25 |
25 |
40 |
40 |
40 |
40 |
50 |
50 |
50 |
50 |
60 |
60 |
60 |
60 |
70 |
70 |
70 |
70 |
80 |
80 |
80 |
80 |
90 |
90 |
90 |
90 |
95 |
95 |
95 |
95 |
100 |
100 |
100 |
100 |
102 |
102 |
102 |
102 |
105 |
105 |
105 |
105 |
106 |
106 |
106 |
106 |
Base |
|
|
|
|
|
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
50 |
50 |
50 |
50 |
60 |
60 |
60 |
60 |
70 |
70 |
70 |
70 |
80 |
80 |
80 |
80 |
90 |
90 |
90 |
90 |
95 |
95 |
95 |
95 |
100 |
100 |
100 |
100 |
102 |
102 |
102 |
102 |
105 |
105 |
105 |
105 |
106 |
106 |
106 |
106 |
Aggressive |
|
|
|
|
|
35 |
35 |
35 |
35 |
40 |
40 |
40 |
40 |
50 |
50 |
50 |
50 |
60 |
60 |
60 |
60 |
70 |
70 |
70 |
70 |
80 |
80 |
80 |
80 |
90 |
90 |
90 |
90 |
95 |
95 |
95 |
95 |
100 |
100 |
100 |
100 |
102 |
102 |
102 |
102 |
105 |
105 |
105 |
105 |
106 |
106 |
106 |
106 |
Earnings Per Quarter |
|
|
|
|
|
|
|
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
83959.858048801543 |
84992.25661411749 |
86037.3498983436 |
87095.29399999998 |
88166.246937046468 |
89250.36867048475 |
90347.82112825058 |
91458.768229399939 |
92583.375908592454 |
93721.812140875991 |
94874.2469667759 |
96040.852517692838 |
97221.803041612904 |
98417.27492913384 |
99627.446739811334 |
100852.49922882921 |
102092.61537399767 |
103347.98040308341 |
104618.78182147583 |
105905.2094401935 |
107207.4554042349 |
108525.71422127784 |
109860.18279073173 |
111211.06043314717 |
112578.54891998705 |
113962.85250376383 |
115364.17794854737 |
116782.73456084781 |
Conservative |
|
|
|
|
|
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
83959.858048801543 |
84992.25661411749 |
86037.3498983436 |
87095.29399999998 |
88166.246937046468 |
89250.36867048475 |
90347.82112825058 |
91458.768229399939 |
92583.375908592454 |
93721.812140875991 |
94874.2469667759 |
96040.852517692838 |
97221.803041612904 |
98417.27492913384 |
99627.446739811334 |
100852.49922882921 |
102092.61537399767 |
103347.98040308341 |
104618.78182147583 |
105905.2094401935 |
107207.4554042349 |
108525.71422127784 |
109860.18279073173 |
111211.06043314717 |
112578.54891998705 |
113962.85250376383 |
115364.17794854737 |
116782.73456084781 |
Base |
|
|
|
|
|
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
83959.858048801543 |
84992.25661411749 |
86037.3498983436 |
87095.29399999998 |
88166.246937046468 |
89250.36867048475 |
90347.82112825058 |
91458.768229399939 |
92583.375908592454 |
93721.812140875991 |
94874.2469667759 |
96040.852517692838 |
97221.803041612904 |
98417.27492913384 |
99627.446739811334 |
100852.49922882921 |
102092.61537399767 |
103347.98040308341 |
104618.78182147583 |
105905.2094401935 |
107207.4554042349 |
108525.71422127784 |
109860.18279073173 |
111211.06043314717 |
112578.54891998705 |
113962.85250376383 |
115364.17794854737 |
116782.73456084781 |
Aggressive |
|
|
|
|
|
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
82940 |
83959.858048801543 |
84992.25661411749 |
86037.3498983436 |
87095.29399999998 |
88166.246937046468 |
89250.36867048475 |
90347.82112825058 |
91458.768229399939 |
92583.375908592454 |
93721.812140875991 |
94874.2469667759 |
96040.852517692838 |
97221.803041612904 |
98417.27492913384 |
99627.446739811334 |
100852.49922882921 |
102092.61537399767 |
103347.98040308341 |
104618.78182147583 |
105905.2094401935 |
107207.4554042349 |
108525.71422127784 |
109860.18279073173 |
111211.06043314717 |
112578.54891998705 |
113962.85250376383 |
115364.17794854737 |
116782.73456084781 |
Insurance Cost per Mini Bus ('000s) |
|
|
|
|
|
|
|
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
Conservative |
|
|
|
|
|
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
Base |
|
|
|
|
|
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
Aggressive |
|
|
|
|
|
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
2.9580000000000002 |
New Registration Cost per Mini Bus ('000s) |
|
|
|
|
|
|
|
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0550104818848887 |
2.0803291037718044 |
2.1059596620794361 |
2.1295676556533225 |
2.1534402969175801 |
2.1775805525961625 |
2.2019914226702593 |
2.2290678475051062 |
2.2564772131381279 |
2.2842236135210094 |
2.3123111929460389 |
2.3407441466651115 |
2.3695267215163471 |
2.3986632165584107 |
2.4281579837126341 |
2.4580154284130327 |
2.4882400102643154 |
2.5188362437079865 |
2.5498086986966362 |
2.5811620013765246 |
2.6129008347785567 |
2.6450299395177557 |
2.6775541145013371 |
2.7104782176454876 |
2.7438071666009614 |
2.7775459394875943 |
2.8116995756378529 |
2.8462731763495257 |
2.8812719056476688 |
2.9167009910559218 |
2.9525657243773082 |
2.9888714624846355 |
3.0256236281206155 |
3.0628277107078219 |
3.10048926716861 |
3.1386139227551144 |
3.1772073718894571 |
3.2162753790142826 |
3.2558237794537561 |
3.2958584802851445 |
3.3363854612211177 |
3.3774107755028973 |
3.4189405508043884 |
3.4609809901474295 |
Conservative |
|
|
|
|
|
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0550104818848887 |
2.0803291037718044 |
2.1059596620794361 |
2.1295676556533225 |
2.1534402969175801 |
2.1775805525961625 |
2.2019914226702593 |
2.2290678475051062 |
2.2564772131381279 |
2.2842236135210094 |
2.3123111929460389 |
2.3407441466651115 |
2.3695267215163471 |
2.3986632165584107 |
2.4281579837126341 |
2.4580154284130327 |
2.4882400102643154 |
2.5188362437079865 |
2.5498086986966362 |
2.5811620013765246 |
2.6129008347785567 |
2.6450299395177557 |
2.6775541145013371 |
2.7104782176454876 |
2.7438071666009614 |
2.7775459394875943 |
2.8116995756378529 |
2.8462731763495257 |
2.8812719056476688 |
2.9167009910559218 |
2.9525657243773082 |
2.9888714624846355 |
3.0256236281206155 |
3.0628277107078219 |
3.10048926716861 |
3.1386139227551144 |
3.1772073718894571 |
3.2162753790142826 |
3.2558237794537561 |
3.2958584802851445 |
3.3363854612211177 |
3.3774107755028973 |
3.4189405508043884 |
3.4609809901474295 |
Base |
|
|
|
|
|
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0550104818848887 |
2.0803291037718044 |
2.1059596620794361 |
2.1295676556533225 |
2.1534402969175801 |
2.1775805525961625 |
2.2019914226702593 |
2.2290678475051062 |
2.2564772131381279 |
2.2842236135210094 |
2.3123111929460389 |
2.3407441466651115 |
2.3695267215163471 |
2.3986632165584107 |
2.4281579837126341 |
2.4580154284130327 |
2.4882400102643154 |
2.5188362437079865 |
2.5498086986966362 |
2.5811620013765246 |
2.6129008347785567 |
2.6450299395177557 |
2.6775541145013371 |
2.7104782176454876 |
2.7438071666009614 |
2.7775459394875943 |
2.8116995756378529 |
2.8462731763495257 |
2.8812719056476688 |
2.9167009910559218 |
2.9525657243773082 |
2.9888714624846355 |
3.0256236281206155 |
3.0628277107078219 |
3.10048926716861 |
3.1386139227551144 |
3.1772073718894571 |
3.2162753790142826 |
3.2558237794537561 |
3.2958584802851445 |
3.3363854612211177 |
3.3774107755028973 |
3.4189405508043884 |
3.4609809901474295 |
Aggressive |
|
|
|
|
|
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0299999999999998 |
2.0550104818848887 |
2.0803291037718044 |
2.1059596620794361 |
2.1295676556533225 |
2.1534402969175801 |
2.1775805525961625 |
2.2019914226702593 |
2.2290678475051062 |
2.2564772131381279 |
2.2842236135210094 |
2.3123111929460389 |
2.3407441466651115 |
2.3695267215163471 |
2.3986632165584107 |
2.4281579837126341 |
2.4580154284130327 |
2.4882400102643154 |
2.5188362437079865 |
2.5498086986966362 |
2.5811620013765246 |
2.6129008347785567 |
2.6450299395177557 |
2.6775541145013371 |
2.7104782176454876 |
2.7438071666009614 |
2.7775459394875943 |
2.8116995756378529 |
2.8462731763495257 |
2.8812719056476688 |
2.9167009910559218 |
2.9525657243773082 |
2.9888714624846355 |
3.0256236281206155 |
3.0628277107078219 |
3.10048926716861 |
3.1386139227551144 |
3.1772073718894571 |
3.2162753790142826 |
3.2558237794537561 |
3.2958584802851445 |
3.3363854612211177 |
3.3774107755028973 |
3.4189405508043884 |
3.4609809901474295 |
Fuel Cost per Mini Bus per Quarter ('000s) |
|
|
|
|
|
|
|
40 |
40 |
40 |
40 |
40.492817377042144 |
40.991706478262159 |
41.496742109939632 |
41.961924249326557 |
42.43232112152868 |
42.907991184160842 |
43.388993550152897 |
43.922519162662198 |
44.462605184987744 |
45.009332286128263 |
45.562782127015538 |
46.123037372711558 |
46.690181704755616 |
47.264299833663273 |
47.845477511579006 |
48.433801545084393 |
49.029359808163854 |
49.632241255329788 |
50.242535934909093 |
50.860335002493102 |
51.485730734552845 |
52.118816542221793 |
52.759686985248024 |
53.408437786117986 |
54.06516584435392 |
54.729969250987082 |
55.402947303208926 |
56.084200519202476 |
56.773830653156033 |
57.47194071046151 |
58.178634963099668 |
58.894018965214492 |
59.61819956887912 |
60.351284940055606 |
61.093384574750935 |
61.844609315371713 |
62.60507136727994 |
63.374884315552364 |
64.154163141945929 |
64.943024242071814 |
65.741585442780647 |
66.549966019761527 |
67.368286715357414 |
68.196669756599604 |
Conservative |
|
|
|
|
|
40 |
40 |
40 |
40 |
40.492817377042144 |
40.991706478262159 |
41.496742109939632 |
41.961924249326557 |
42.43232112152868 |
42.907991184160842 |
43.388993550152897 |
43.922519162662198 |
44.462605184987744 |
45.009332286128263 |
45.562782127015538 |
46.123037372711558 |
46.690181704755616 |
47.264299833663273 |
47.845477511579006 |
48.433801545084393 |
49.029359808163854 |
49.632241255329788 |
50.242535934909093 |
50.860335002493102 |
51.485730734552845 |
52.118816542221793 |
52.759686985248024 |
53.408437786117986 |
54.06516584435392 |
54.729969250987082 |
55.402947303208926 |
56.084200519202476 |
56.773830653156033 |
57.47194071046151 |
58.178634963099668 |
58.894018965214492 |
59.61819956887912 |
60.351284940055606 |
61.093384574750935 |
61.844609315371713 |
62.60507136727994 |
63.374884315552364 |
64.154163141945929 |
64.943024242071814 |
65.741585442780647 |
66.549966019761527 |
67.368286715357414 |
68.196669756599604 |
Base |
|
|
|
|
|
40 |
40 |
40 |
40 |
40.492817377042144 |
40.991706478262159 |
41.496742109939632 |
41.961924249326557 |
42.43232112152868 |
42.907991184160842 |
43.388993550152897 |
43.922519162662198 |
44.462605184987744 |
45.009332286128263 |
45.562782127015538 |
46.123037372711558 |
46.690181704755616 |
47.264299833663273 |
47.845477511579006 |
48.433801545084393 |
49.029359808163854 |
49.632241255329788 |
50.242535934909093 |
50.860335002493102 |
51.485730734552845 |
52.118816542221793 |
52.759686985248024 |
53.408437786117986 |
54.06516584435392 |
54.729969250987082 |
55.402947303208926 |
56.084200519202476 |
56.773830653156033 |
57.47194071046151 |
58.178634963099668 |
58.894018965214492 |
59.61819956887912 |
60.351284940055606 |
61.093384574750935 |
61.844609315371713 |
62.60507136727994 |
63.374884315552364 |
64.154163141945929 |
64.943024242071814 |
65.741585442780647 |
66.549966019761527 |
67.368286715357414 |
68.196669756599604 |
Aggressive |
|
|
|
|
|
40 |
40 |
40 |
40 |
40.492817377042144 |
40.991706478262159 |
41.496742109939632 |
41.961924249326557 |
42.43232112152868 |
42.907991184160842 |
43.388993550152897 |
43.922519162662198 |
44.462605184987744 |
45.009332286128263 |
45.562782127015538 |
46.123037372711558 |
46.690181704755616 |
47.264299833663273 |
47.845477511579006 |
48.433801545084393 |
49.029359808163854 |
49.632241255329788 |
50.242535934909093 |
50.860335002493102 |
51.485730734552845 |
52.118816542221793 |
52.759686985248024 |
53.408437786117986 |
54.06516584435392 |
54.729969250987082 |
55.402947303208926 |
56.084200519202476 |
56.773830653156033 |
57.47194071046151 |
58.178634963099668 |
58.894018965214492 |
59.61819956887912 |
60.351284940055606 |
61.093384574750935 |
61.844609315371713 |
62.60507136727994 |
63.374884315552364 |
64.154163141945929 |
64.943024242071814 |
65.741585442780647 |
66.549966019761527 |
67.368286715357414 |
68.196669756599604 |
Servicing Cost per Mini Bus ('000s) |
|
|
|
|
|
|
|
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.41100209637697782 |
0.41606582075436099 |
0.42119193241588732 |
0.4259135311306646 |
0.43068805938351618 |
0.43551611051923261 |
0.440398284534052 |
0.44581356950102141 |
0.45129544262762572 |
0.45684472270420201 |
0.46246223858920787 |
0.46814882933302243 |
0.47390534430326958 |
0.47973264331168231 |
0.48563159674252698 |
0.49160308568260663 |
0.49764800205286319 |
0.5037672487415974 |
0.50996173973932735 |
0.51623240027530504 |
0.52258016695571141 |
0.52900598790355124 |
0.53551082290026752 |
0.54209564352909767 |
0.54876143332019245 |
0.55550918789751902 |
0.56233991512757076 |
0.56925463526990527 |
0.57625438112953387 |
0.58334019821118455 |
0.5905131448754618 |
0.59777429249692726 |
0.60512472562412323 |
0.61256554214156456 |
0.62009785343372215 |
0.62772278455102304 |
0.63544147437789156 |
0.64325507580285668 |
0.6511647558907514 |
0.65917169605702908 |
0.66727709224422371 |
0.67548215510057963 |
0.68378811016087782 |
0.69219619802948595 |
Conservative |
|
|
|
|
|
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.41100209637697782 |
0.41606582075436099 |
0.42119193241588732 |
0.4259135311306646 |
0.43068805938351618 |
0.43551611051923261 |
0.440398284534052 |
0.44581356950102141 |
0.45129544262762572 |
0.45684472270420201 |
0.46246223858920787 |
0.46814882933302243 |
0.47390534430326958 |
0.47973264331168231 |
0.48563159674252698 |
0.49160308568260663 |
0.49764800205286319 |
0.5037672487415974 |
0.50996173973932735 |
0.51623240027530504 |
0.52258016695571141 |
0.52900598790355124 |
0.53551082290026752 |
0.54209564352909767 |
0.54876143332019245 |
0.55550918789751902 |
0.56233991512757076 |
0.56925463526990527 |
0.57625438112953387 |
0.58334019821118455 |
0.5905131448754618 |
0.59777429249692726 |
0.60512472562412323 |
0.61256554214156456 |
0.62009785343372215 |
0.62772278455102304 |
0.63544147437789156 |
0.64325507580285668 |
0.6511647558907514 |
0.65917169605702908 |
0.66727709224422371 |
0.67548215510057963 |
0.68378811016087782 |
0.69219619802948595 |
Base |
|
|
|
|
|
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.41100209637697782 |
0.41606582075436099 |
0.42119193241588732 |
0.4259135311306646 |
0.43068805938351618 |
0.43551611051923261 |
0.440398284534052 |
0.44581356950102141 |
0.45129544262762572 |
0.45684472270420201 |
0.46246223858920787 |
0.46814882933302243 |
0.47390534430326958 |
0.47973264331168231 |
0.48563159674252698 |
0.49160308568260663 |
0.49764800205286319 |
0.5037672487415974 |
0.50996173973932735 |
0.51623240027530504 |
0.52258016695571141 |
0.52900598790355124 |
0.53551082290026752 |
0.54209564352909767 |
0.54876143332019245 |
0.55550918789751902 |
0.56233991512757076 |
0.56925463526990527 |
0.57625438112953387 |
0.58334019821118455 |
0.5905131448754618 |
0.59777429249692726 |
0.60512472562412323 |
0.61256554214156456 |
0.62009785343372215 |
0.62772278455102304 |
0.63544147437789156 |
0.64325507580285668 |
0.6511647558907514 |
0.65917169605702908 |
0.66727709224422371 |
0.67548215510057963 |
0.68378811016087782 |
0.69219619802948595 |
Aggressive |
|
|
|
|
|
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.40600000000000003 |
0.41100209637697782 |
0.41606582075436099 |
0.42119193241588732 |
0.4259135311306646 |
0.43068805938351618 |
0.43551611051923261 |
0.440398284534052 |
0.44581356950102141 |
0.45129544262762572 |
0.45684472270420201 |
0.46246223858920787 |
0.46814882933302243 |
0.47390534430326958 |
0.47973264331168231 |
0.48563159674252698 |
0.49160308568260663 |
0.49764800205286319 |
0.5037672487415974 |
0.50996173973932735 |
0.51623240027530504 |
0.52258016695571141 |
0.52900598790355124 |
0.53551082290026752 |
0.54209564352909767 |
0.54876143332019245 |
0.55550918789751902 |
0.56233991512757076 |
0.56925463526990527 |
0.57625438112953387 |
0.58334019821118455 |
0.5905131448754618 |
0.59777429249692726 |
0.60512472562412323 |
0.61256554214156456 |
0.62009785343372215 |
0.62772278455102304 |
0.63544147437789156 |
0.64325507580285668 |
0.6511647558907514 |
0.65917169605702908 |
0.66727709224422371 |
0.67548215510057963 |
0.68378811016087782 |
0.69219619802948595 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
EXISTING VEHICLES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Existing Vehicles |
|
|
|
|
|
|
|
29 |
29 |
29 |
29 |
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 |
Conservative |
|
29 |
29 |
29 |
29 |
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 |
Base |
|
|
|
|
|
29 |
29 |
29 |
29 |
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 |
Aggressive |
|
|
|
|
|
29 |
29 |
29 |
29 |
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 |
Earnings Per Quarter |
|
|
|
|
|
|
|
15080 |
15080 |
15080 |
15080 |
15265.792151144889 |
15453.873342304834 |
15644.27177544724 |
15819.64544199611 |
15996.985062816311 |
16176.312676428635 |
16357.65056840764 |
16558.789724323648 |
16762.402154740379 |
16968.518271870355 |
17177.168861884857 |
17388.385089512256 |
17602.198502692863 |
17818.64103729105 |
18037.745021865281 |
18259.543182496811 |
18484.068647677766 |
18711.354953259324 |
18941.436047460724 |
19174.346295939893 |
19410.120486926415 |
19648.793836417608 |
19890.401993438496 |
20134.981045366472 |
20382.567523321421 |
20633.198407622123 |
20886.911133309757 |
21143.743595739325 |
21403.734156239814 |
21666.921647843981 |
21933.345381088566 |
22203.045149885857 |
22476.06123746742 |
22752.434422400955 |
23032.205984681095 |
23315.41771189513 |
23602.111905464531 |
23892.331386963237 |
24186.119504513612 |
24483.520139261069 |
24784.577711928298 |
25089.337189450089 |
25397.844091689738 |
25710.144498238042 |
Conservative |
|
|
|
|
|
15080 |
15080 |
15080 |
15080 |
15265.792151144889 |
15453.873342304834 |
15644.27177544724 |
15819.64544199611 |
15996.985062816311 |
16176.312676428635 |
16357.65056840764 |
16558.789724323648 |
16762.402154740379 |
16968.518271870355 |
17177.168861884857 |
17388.385089512256 |
17602.198502692863 |
17818.64103729105 |
18037.745021865281 |
18259.543182496811 |
18484.068647677766 |
18711.354953259324 |
18941.436047460724 |
19174.346295939893 |
19410.120486926415 |
19648.793836417608 |
19890.401993438496 |
20134.981045366472 |
20382.567523321421 |
20633.198407622123 |
20886.911133309757 |
21143.743595739325 |
21403.734156239814 |
21666.921647843981 |
21933.345381088566 |
22203.045149885857 |
22476.06123746742 |
22752.434422400955 |
23032.205984681095 |
23315.41771189513 |
23602.111905464531 |
23892.331386963237 |
24186.119504513612 |
24483.520139261069 |
24784.577711928298 |
25089.337189450089 |
25397.844091689738 |
25710.144498238042 |
Base |
|
|
|
|
|
15080 |
15080 |
15080 |
15080 |
15265.792151144889 |
15453.873342304834 |
15644.27177544724 |
15819.64544199611 |
15996.985062816311 |
16176.312676428635 |
16357.65056840764 |
16558.789724323648 |
16762.402154740379 |
16968.518271870355 |
17177.168861884857 |
17388.385089512256 |
17602.198502692863 |
17818.64103729105 |
18037.745021865281 |
18259.543182496811 |
18484.068647677766 |
18711.354953259324 |
18941.436047460724 |
19174.346295939893 |
19410.120486926415 |
19648.793836417608 |
19890.401993438496 |
20134.981045366472 |
20382.567523321421 |
20633.198407622123 |
20886.911133309757 |
21143.743595739325 |
21403.734156239814 |
21666.921647843981 |
21933.345381088566 |
22203.045149885857 |
22476.06123746742 |
22752.434422400955 |
23032.205984681095 |
23315.41771189513 |
23602.111905464531 |
23892.331386963237 |
24186.119504513612 |
24483.520139261069 |
24784.577711928298 |
25089.337189450089 |
25397.844091689738 |
25710.144498238042 |
Aggressive |
|
|
|
|
|
15080 |
15080 |
15080 |
15080 |
15265.792151144889 |
15453.873342304834 |
15644.27177544724 |
15819.64544199611 |
15996.985062816311 |
16176.312676428635 |
16357.65056840764 |
16558.789724323648 |
16762.402154740379 |
16968.518271870355 |
17177.168861884857 |
17388.385089512256 |
17602.198502692863 |
17818.64103729105 |
18037.745021865281 |
18259.543182496811 |
18484.068647677766 |
18711.354953259324 |
18941.436047460724 |
19174.346295939893 |
19410.120486926415 |
19648.793836417608 |
19890.401993438496 |
20134.981045366472 |
20382.567523321421 |
20633.198407622123 |
20886.911133309757 |
21143.743595739325 |
21403.734156239814 |
21666.921647843981 |
21933.345381088566 |
22203.045149885857 |
22476.06123746742 |
22752.434422400955 |
23032.205984681095 |
23315.41771189513 |
23602.111905464531 |
23892.331386963237 |
24186.119504513612 |
24483.520139261069 |
24784.577711928298 |
25089.337189450089 |
25397.844091689738 |
25710.144498238042 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
CORPORATE TRANSPORT SERVICES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Corp. Transport Vehicles |
|
|
|
|
|
|
|
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
65 |
65 |
65 |
65 |
70 |
70 |
70 |
70 |
75 |
75 |
75 |
75 |
80 |
80 |
80 |
80 |
82 |
82 |
82 |
82 |
85 |
85 |
85 |
85 |
87 |
87 |
87 |
87 |
90 |
90 |
90 |
90 |
Conservative |
|
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
65 |
65 |
65 |
65 |
70 |
70 |
70 |
70 |
75 |
75 |
75 |
75 |
80 |
80 |
80 |
80 |
82 |
82 |
82 |
82 |
85 |
85 |
85 |
85 |
87 |
87 |
87 |
87 |
90 |
90 |
90 |
90 |
Base |
|
|
|
|
|
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
65 |
65 |
65 |
65 |
70 |
70 |
70 |
70 |
75 |
75 |
75 |
75 |
80 |
80 |
80 |
80 |
82 |
82 |
82 |
82 |
85 |
85 |
85 |
85 |
87 |
87 |
87 |
87 |
90 |
90 |
90 |
90 |
Aggressive |
|
|
|
|
|
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
65 |
65 |
65 |
65 |
70 |
70 |
70 |
70 |
75 |
75 |
75 |
75 |
80 |
80 |
80 |
80 |
82 |
82 |
82 |
82 |
85 |
85 |
85 |
85 |
87 |
87 |
87 |
87 |
90 |
90 |
90 |
90 |
Earnings Per Quarter |
|
|
|
|
|
|
|
45500 |
45500 |
45500 |
45500 |
46060.579766385439 |
46628.066119023206 |
47202.544150056325 |
47731.688833608947 |
48266.765275738864 |
48807.839971982947 |
49354.980163298911 |
49961.865547528243 |
50576.213397923551 |
51198.115475470891 |
51827.664669480168 |
52464.955011459388 |
53110.081689159502 |
53763.141060791968 |
54424.230669421107 |
55093.449257533488 |
55770.896781786374 |
56456.674427937622 |
57150.884625959086 |
57853.631065335896 |
58565.018710553857 |
59285.153816777281 |
60014.143945719617 |
60752.097981709201 |
61499.126147952578 |
62255.3400229978 |
63020.852557400147 |
63795.778090592808 |
64580.232367964978 |
65374.332558149959 |
66178.197270525867 |
66991.946572931483 |
67815.702009600005 |
68649.586619313253 |
69493.724953779194 |
70348.243096235325 |
71213.268680280933 |
72088.93090894082 |
72975.360573963495 |
73872.690075356688 |
74781.053441162978 |
75700.586347478718 |
76631.426138719034 |
77573.711848132021 |
Conservative |
|
|
|
|
|
39000 |
39000 |
39000 |
39000 |
39480.496942616097 |
39966.913816305612 |
40459.323557191143 |
40912.876143093396 |
41371.513093490466 |
41835.291404556825 |
42304.268711399083 |
42824.456183595648 |
43351.040055363053 |
43884.09897897506 |
44423.712573840152 |
44969.961438393766 |
45522.927162136722 |
46082.692337821689 |
46649.340573789523 |
47222.956506457274 |
47803.625812959748 |
48391.43522394653 |
48986.472536536356 |
49588.826627430761 |
50198.587466189012 |
50815.846128666235 |
51440.694810616813 |
52073.226841465032 |
52713.536698245072 |
53361.720019712404 |
54017.873620628699 |
54682.095506222409 |
55354.484886827129 |
56035.142192699976 |
56724.16908902218 |
57421.668491084136 |
58127.744579657148 |
58842.502816554224 |
59566.049960382174 |
60298.494082487436 |
61039.94458309796 |
61790.512207663574 |
62550.309063397304 |
63319.448636020039 |
64098.045806711147 |
64886.216869267497 |
65684.079547473477 |
66491.75301268461 |
Base |
|
|
|
|
|
45500 |
45500 |
45500 |
45500 |
46060.579766385439 |
46628.066119023206 |
47202.544150056325 |
47731.688833608947 |
48266.765275738864 |
48807.839971982947 |
49354.980163298911 |
49961.865547528243 |
50576.213397923551 |
51198.115475470891 |
51827.664669480168 |
52464.955011459388 |
53110.081689159502 |
53763.141060791968 |
54424.230669421107 |
55093.449257533488 |
55770.896781786374 |
56456.674427937622 |
57150.884625959086 |
57853.631065335896 |
58565.018710553857 |
59285.153816777281 |
60014.143945719617 |
60752.097981709201 |
61499.126147952578 |
62255.3400229978 |
63020.852557400147 |
63795.778090592808 |
64580.232367964978 |
65374.332558149959 |
66178.197270525867 |
66991.946572931483 |
67815.702009600005 |
68649.586619313253 |
69493.724953779194 |
70348.243096235325 |
71213.268680280933 |
72088.93090894082 |
72975.360573963495 |
73872.690075356688 |
74781.053441162978 |
75700.586347478718 |
76631.426138719034 |
77573.711848132021 |
Aggressive |
|
|
|
|
|
39000 |
39000 |
39000 |
39000 |
39480.496942616097 |
39966.913816305612 |
40459.323557191143 |
40912.876143093396 |
41371.513093490466 |
41835.291404556825 |
42304.268711399083 |
42824.456183595648 |
43351.040055363053 |
43884.09897897506 |
44423.712573840152 |
44969.961438393766 |
45522.927162136722 |
46082.692337821689 |
46649.340573789523 |
47222.956506457274 |
47803.625812959748 |
48391.43522394653 |
48986.472536536356 |
49588.826627430761 |
50198.587466189012 |
50815.846128666235 |
51440.694810616813 |
52073.226841465032 |
52713.536698245072 |
53361.720019712404 |
54017.873620628699 |
54682.095506222409 |
55354.484886827129 |
56035.142192699976 |
56724.16908902218 |
57421.668491084136 |
58127.744579657148 |
58842.502816554224 |
59566.049960382174 |
60298.494082487436 |
61039.94458309796 |
61790.512207663574 |
62550.309063397304 |
63319.448636020039 |
64098.045806711147 |
64886.216869267497 |
65684.079547473477 |
66491.75301268461 |
Fuel Cost per Vehicle per Quarter ('000s) |
|
|
|
|
|
|
|
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.707412754327976 |
28.048780116283279 |
28.394353272436746 |
28.712656477222946 |
29.03452788901161 |
29.360007507717981 |
29.689135781659875 |
30.054203349647427 |
30.423759910853793 |
30.797860663444698 |
31.176561484321024 |
31.559918937464751 |
31.947990282387558 |
32.340833482683266 |
32.738507214685491 |
33.141070876231716 |
33.548584595535154 |
33.961109240165676 |
34.378706426141214 |
34.801438527130905 |
35.229368683771447 |
35.662560813097961 |
36.101079618090871 |
36.544990597340146 |
36.994360054828377 |
37.449255109834148 |
37.909743706957208 |
38.375894626266877 |
38.847777493575265 |
39.325462790836824 |
39.809021866675749 |
40.298526947042831 |
40.794051146003369 |
41.295668476657731 |
41.803453862196186 |
42.317483147089654 |
42.837833108418117 |
43.364581467338269 |
43.897806900692196 |
44.437589052758831 |
44.984008547149848 |
45.537146998851895 |
46.097087026416858 |
46.663912264302027 |
Conservative |
|
|
|
|
|
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.707412754327976 |
28.048780116283279 |
28.394353272436746 |
28.712656477222946 |
29.03452788901161 |
29.360007507717981 |
29.689135781659875 |
30.054203349647427 |
30.423759910853793 |
30.797860663444698 |
31.176561484321024 |
31.559918937464751 |
31.947990282387558 |
32.340833482683266 |
32.738507214685491 |
33.141070876231716 |
33.548584595535154 |
33.961109240165676 |
34.378706426141214 |
34.801438527130905 |
35.229368683771447 |
35.662560813097961 |
36.101079618090871 |
36.544990597340146 |
36.994360054828377 |
37.449255109834148 |
37.909743706957208 |
38.375894626266877 |
38.847777493575265 |
39.325462790836824 |
39.809021866675749 |
40.298526947042831 |
40.794051146003369 |
41.295668476657731 |
41.803453862196186 |
42.317483147089654 |
42.837833108418117 |
43.364581467338269 |
43.897806900692196 |
44.437589052758831 |
44.984008547149848 |
45.537146998851895 |
46.097087026416858 |
46.663912264302027 |
Base |
|
|
|
|
|
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.707412754327976 |
28.048780116283279 |
28.394353272436746 |
28.712656477222946 |
29.03452788901161 |
29.360007507717981 |
29.689135781659875 |
30.054203349647427 |
30.423759910853793 |
30.797860663444698 |
31.176561484321024 |
31.559918937464751 |
31.947990282387558 |
32.340833482683266 |
32.738507214685491 |
33.141070876231716 |
33.548584595535154 |
33.961109240165676 |
34.378706426141214 |
34.801438527130905 |
35.229368683771447 |
35.662560813097961 |
36.101079618090871 |
36.544990597340146 |
36.994360054828377 |
37.449255109834148 |
37.909743706957208 |
38.375894626266877 |
38.847777493575265 |
39.325462790836824 |
39.809021866675749 |
40.298526947042831 |
40.794051146003369 |
41.295668476657731 |
41.803453862196186 |
42.317483147089654 |
42.837833108418117 |
43.364581467338269 |
43.897806900692196 |
44.437589052758831 |
44.984008547149848 |
45.537146998851895 |
46.097087026416858 |
46.663912264302027 |
Aggressive |
|
|
|
|
|
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.370200000000001 |
27.707412754327976 |
28.048780116283279 |
28.394353272436746 |
28.712656477222946 |
29.03452788901161 |
29.360007507717981 |
29.689135781659875 |
30.054203349647427 |
30.423759910853793 |
30.797860663444698 |
31.176561484321024 |
31.559918937464751 |
31.947990282387558 |
32.340833482683266 |
32.738507214685491 |
33.141070876231716 |
33.548584595535154 |
33.961109240165676 |
34.378706426141214 |
34.801438527130905 |
35.229368683771447 |
35.662560813097961 |
36.101079618090871 |
36.544990597340146 |
36.994360054828377 |
37.449255109834148 |
37.909743706957208 |
38.375894626266877 |
38.847777493575265 |
39.325462790836824 |
39.809021866675749 |
40.298526947042831 |
40.794051146003369 |
41.295668476657731 |
41.803453862196186 |
42.317483147089654 |
42.837833108418117 |
43.364581467338269 |
43.897806900692196 |
44.437589052758831 |
44.984008547149848 |
45.537146998851895 |
46.097087026416858 |
46.663912264302027 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
VEHICLE MANAGEMENT REVENUE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Managed Vehicles |
|
|
|
|
|
|
|
150 |
150 |
150 |
150 |
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 |
Conservative |
|
150 |
150 |
150 |
150 |
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 |
Base |
|
|
|
|
|
150 |
150 |
150 |
150 |
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 |
Aggressive |
|
|
|
|
|
150 |
150 |
150 |
150 |
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 |
Earnings Per Quarter |
|
|
|
|
|
|
|
30160 |
30160 |
30160 |
30160 |
30531.584302289779 |
30907.746684609669 |
31288.543550894479 |
31639.29088399222 |
31993.970125632623 |
32352.625352857271 |
32715.30113681528 |
33117.579448647295 |
33524.804309480758 |
33937.036543740709 |
34354.337723769713 |
34776.770179024512 |
35204.397005385727 |
35637.282074582101 |
36075.490043730562 |
36519.086364993622 |
36968.137295355533 |
37422.709906518648 |
37882.872094921448 |
38348.692591879786 |
38820.240973852829 |
39297.587672835216 |
39780.803986876992 |
40269.962090732944 |
40765.135046642841 |
41266.396815244247 |
41773.822266619514 |
42287.487191478649 |
42807.468312479628 |
43333.843295687962 |
43866.690762177132 |
44406.090299771713 |
44952.12247493484 |
45504.868844801909 |
46064.411969362191 |
46630.83542379026 |
47204.223810929063 |
47784.662773926473 |
48372.239009027224 |
48967.040278522138 |
49569.155423856595 |
50178.674378900178 |
50795.688183379476 |
51420.288996476083 |
Conservative |
|
|
|
|
|
|
|
30160 |
30160 |
30160 |
30160 |
30531.584302289779 |
30907.746684609669 |
31288.543550894479 |
31639.29088399222 |
31993.970125632623 |
32352.625352857271 |
32715.30113681528 |
33117.579448647295 |
33524.804309480758 |
33937.036543740709 |
34354.337723769713 |
34776.770179024512 |
35204.397005385727 |
35637.282074582101 |
36075.490043730562 |
36519.086364993622 |
36968.137295355533 |
37422.709906518648 |
37882.872094921448 |
38348.692591879786 |
38820.240973852829 |
39297.587672835216 |
39780.803986876992 |
40269.962090732944 |
40765.135046642841 |
41266.396815244247 |
41773.822266619514 |
42287.487191478649 |
42807.468312479628 |
43333.843295687962 |
43866.690762177132 |
44406.090299771713 |
44952.12247493484 |
45504.868844801909 |
46064.411969362191 |
46630.83542379026 |
47204.223810929063 |
47784.662773926473 |
48372.239009027224 |
48967.040278522138 |
49569.155423856595 |
50178.674378900178 |
50795.688183379476 |
51420.288996476083 |
Base |
|
30160 |
30160 |
30160 |
30160 |
30531.584302289779 |
30907.746684609669 |
31288.543550894479 |
31639.29088399222 |
31993.970125632623 |
32352.625352857271 |
32715.30113681528 |
33117.579448647295 |
33524.804309480758 |
33937.036543740709 |
34354.337723769713 |
34776.770179024512 |
35204.397005385727 |
35637.282074582101 |
36075.490043730562 |
36519.086364993622 |
36968.137295355533 |
37422.709906518648 |
37882.872094921448 |
38348.692591879786 |
38820.240973852829 |
39297.587672835216 |
39780.803986876992 |
40269.962090732944 |
40765.135046642841 |
41266.396815244247 |
41773.822266619514 |
42287.487191478649 |
42807.468312479628 |
43333.843295687962 |
43866.690762177132 |
44406.090299771713 |
44952.12247493484 |
45504.868844801909 |
46064.411969362191 |
46630.83542379026 |
47204.223810929063 |
47784.662773926473 |
48372.239009027224 |
48967.040278522138 |
49569.155423856595 |
50178.674378900178 |
50795.688183379476 |
51420.288996476083 |
Aggressive |
|
|
|
|
|
30160 |
30160 |
30160 |
30160 |
30531.584302289779 |
30907.746684609669 |
31288.543550894479 |
31639.29088399222 |
31993.970125632623 |
32352.625352857271 |
32715.30113681528 |
33117.579448647295 |
33524.804309480758 |
33937.036543740709 |
34354.337723769713 |
34776.770179024512 |
35204.397005385727 |
35637.282074582101 |
36075.490043730562 |
36519.086364993622 |
36968.137295355533 |
37422.709906518648 |
37882.872094921448 |
38348.692591879786 |
38820.240973852829 |
39297.587672835216 |
39780.803986876992 |
40269.962090732944 |
40765.135046642841 |
41266.396815244247 |
41773.822266619514 |
42287.487191478649 |
42807.468312479628 |
43333.843295687962 |
43866.690762177132 |
44406.090299771713 |
44952.12247493484 |
45504.868844801909 |
46064.411969362191 |
46630.83542379026 |
47204.223810929063 |
47784.662773926473 |
48372.239009027224 |
48967.040278522138 |
49569.155423856595 |
50178.674378900178 |
50795.688183379476 |
51420.288996476083 |
Management Commission |
|
|
|
|
|
|
|
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
Conservative |
|
|
|
|
|
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
Base |
|
|
|
|
|
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
Aggressive |
|
|
|
|
|
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
0.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
OFFICE VEHICLES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Office Vehicles |
|
|
|
|
|
|
|
1 |
1 |
1 |
1 |
2 |
2 |
2 |
2 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
Conservative |
|
1 |
1 |
1 |
1 |
2 |
2 |
2 |
2 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
Base |
|
|
|
|
|
1 |
1 |
1 |
1 |
2 |
2 |
2 |
2 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
Aggressive |
|
|
|
|
|
1 |
1 |
1 |
1 |
2 |
2 |
2 |
2 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
Insurance Cost per Office Vehicle ('000s) |
|
|
|
|
|
|
|
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.85503114692710558 |
0.86556550210505445 |
0.87622964511519397 |
0.88605225672718602 |
0.89598498068177901 |
0.90602905134804623 |
0.91618571693244721 |
0.92745144369408894 |
0.9388556976092568 |
0.95040018205427712 |
0.96208662135076251 |
0.97391676102316249 |
0.98589236805948022 |
0.99801523117519597 |
1.0102871610804354 |
1.0227099907504225 |
1.0352855756992598 |
1.0480157942570729 |
1.0609025478505647 |
1.0739477612870183 |
1.0871533830417923 |
1.1005213855493519 |
1.1140537654978777 |
1.1277525441274976 |
1.1416197675321857 |
1.1556575069653741 |
1.169867859149321 |
1.1842529465882847 |
1.1988149178855478 |
1.213555948064339 |
1.2284782388927016 |
1.2435840192123575 |
1.2588755452716134 |
1.2743551010623619 |
1.2900249986612256 |
1.3058875785748962 |
1.3219452100897209 |
1.3382002916255857 |
1.3546552510941523 |
1.3713125462614979 |
1.3881746651152154 |
1.4052441262360271 |
1.4225234791739689 |
1.4400153048291984 |
Conservative |
|
|
|
|
|
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.85503114692710558 |
0.86556550210505445 |
0.87622964511519397 |
0.88605225672718602 |
0.89598498068177901 |
0.90602905134804623 |
0.91618571693244721 |
0.92745144369408894 |
0.9388556976092568 |
0.95040018205427712 |
0.96208662135076251 |
0.97391676102316249 |
0.98589236805948022 |
0.99801523117519597 |
1.0102871610804354 |
1.0227099907504225 |
1.0352855756992598 |
1.0480157942570729 |
1.0609025478505647 |
1.0739477612870183 |
1.0871533830417923 |
1.1005213855493519 |
1.1140537654978777 |
1.1277525441274976 |
1.1416197675321857 |
1.1556575069653741 |
1.169867859149321 |
1.1842529465882847 |
1.1988149178855478 |
1.213555948064339 |
1.2284782388927016 |
1.2435840192123575 |
1.2588755452716134 |
1.2743551010623619 |
1.2900249986612256 |
1.3058875785748962 |
1.3219452100897209 |
1.3382002916255857 |
1.3546552510941523 |
1.3713125462614979 |
1.3881746651152154 |
1.4052441262360271 |
1.4225234791739689 |
1.4400153048291984 |
Base |
|
|
|
|
|
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.85503114692710558 |
0.86556550210505445 |
0.87622964511519397 |
0.88605225672718602 |
0.89598498068177901 |
0.90602905134804623 |
0.91618571693244721 |
0.92745144369408894 |
0.9388556976092568 |
0.95040018205427712 |
0.96208662135076251 |
0.97391676102316249 |
0.98589236805948022 |
0.99801523117519597 |
1.0102871610804354 |
1.0227099907504225 |
1.0352855756992598 |
1.0480157942570729 |
1.0609025478505647 |
1.0739477612870183 |
1.0871533830417923 |
1.1005213855493519 |
1.1140537654978777 |
1.1277525441274976 |
1.1416197675321857 |
1.1556575069653741 |
1.169867859149321 |
1.1842529465882847 |
1.1988149178855478 |
1.213555948064339 |
1.2284782388927016 |
1.2435840192123575 |
1.2588755452716134 |
1.2743551010623619 |
1.2900249986612256 |
1.3058875785748962 |
1.3219452100897209 |
1.3382002916255857 |
1.3546552510941523 |
1.3713125462614979 |
1.3881746651152154 |
1.4052441262360271 |
1.4225234791739689 |
1.4400153048291984 |
Aggressive |
|
|
|
|
|
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.85503114692710558 |
0.86556550210505445 |
0.87622964511519397 |
0.88605225672718602 |
0.89598498068177901 |
0.90602905134804623 |
0.91618571693244721 |
0.92745144369408894 |
0.9388556976092568 |
0.95040018205427712 |
0.96208662135076251 |
0.97391676102316249 |
0.98589236805948022 |
0.99801523117519597 |
1.0102871610804354 |
1.0227099907504225 |
1.0352855756992598 |
1.0480157942570729 |
1.0609025478505647 |
1.0739477612870183 |
1.0871533830417923 |
1.1005213855493519 |
1.1140537654978777 |
1.1277525441274976 |
1.1416197675321857 |
1.1556575069653741 |
1.169867859149321 |
1.1842529465882847 |
1.1988149178855478 |
1.213555948064339 |
1.2284782388927016 |
1.2435840192123575 |
1.2588755452716134 |
1.2743551010623619 |
1.2900249986612256 |
1.3058875785748962 |
1.3219452100897209 |
1.3382002916255857 |
1.3546552510941523 |
1.3713125462614979 |
1.3881746651152154 |
1.4052441262360271 |
1.4225234791739689 |
1.4400153048291984 |
Fuel Cost per Vehicle per Quarter ('000s) |
|
|
|
|
|
|
|
19.9056 |
19.9056 |
19.9056 |
19.9056 |
20.150845639511253 |
20.399112811842382 |
20.650438743590357 |
20.881931983434864 |
21.116020282917528 |
21.352732732885798 |
21.592098750298085 |
21.857602436107214 |
22.126370844257298 |
22.398444118868866 |
22.673862897688011 |
22.952668318156178 |
23.234902023554582 |
23.520606169224191 |
23.809823428862174 |
24.102597000895795 |
24.398970614934658 |
24.698988538302313 |
25.002695582648158 |
25.310137110640664 |
25.621359042742874 |
25.936407864071249 |
26.255330631338822 |
26.578174979883752 |
26.904989130784283 |
27.235821898061207 |
27.570722695968886 |
27.909741546375916 |
28.252929086236563 |
28.600336575154063 |
28.952015903036916 |
29.308019597849338 |
29.668400833457003 |
30.03321343756927 |
30.402511899779054 |
30.776351379701577 |
31.154787715213185 |
31.537877430791475 |
31.925677745957969 |
32.31824658382461 |
32.715642579745349 |
33.11792509007411 |
33.525154201030446 |
33.937390737674207 |
Conservative |
|
|
|
|
|
19.9056 |
19.9056 |
19.9056 |
19.9056 |
20.150845639511253 |
20.399112811842382 |
20.650438743590357 |
20.881931983434864 |
21.116020282917528 |
21.352732732885798 |
21.592098750298085 |
21.857602436107214 |
22.126370844257298 |
22.398444118868866 |
22.673862897688011 |
22.952668318156178 |
23.234902023554582 |
23.520606169224191 |
23.809823428862174 |
24.102597000895795 |
24.398970614934658 |
24.698988538302313 |
25.002695582648158 |
25.310137110640664 |
25.621359042742874 |
25.936407864071249 |
26.255330631338822 |
26.578174979883752 |
26.904989130784283 |
27.235821898061207 |
27.570722695968886 |
27.909741546375916 |
28.252929086236563 |
28.600336575154063 |
28.952015903036916 |
29.308019597849338 |
29.668400833457003 |
30.03321343756927 |
30.402511899779054 |
30.776351379701577 |
31.154787715213185 |
31.537877430791475 |
31.925677745957969 |
32.31824658382461 |
32.715642579745349 |
33.11792509007411 |
33.525154201030446 |
33.937390737674207 |
Base |
|
|
|
|
|
19.9056 |
19.9056 |
19.9056 |
19.9056 |
20.150845639511253 |
20.399112811842382 |
20.650438743590357 |
20.881931983434864 |
21.116020282917528 |
21.352732732885798 |
21.592098750298085 |
21.857602436107214 |
22.126370844257298 |
22.398444118868866 |
22.673862897688011 |
22.952668318156178 |
23.234902023554582 |
23.520606169224191 |
23.809823428862174 |
24.102597000895795 |
24.398970614934658 |
24.698988538302313 |
25.002695582648158 |
25.310137110640664 |
25.621359042742874 |
25.936407864071249 |
26.255330631338822 |
26.578174979883752 |
26.904989130784283 |
27.235821898061207 |
27.570722695968886 |
27.909741546375916 |
28.252929086236563 |
28.600336575154063 |
28.952015903036916 |
29.308019597849338 |
29.668400833457003 |
30.03321343756927 |
30.402511899779054 |
30.776351379701577 |
31.154787715213185 |
31.537877430791475 |
31.925677745957969 |
32.31824658382461 |
32.715642579745349 |
33.11792509007411 |
33.525154201030446 |
33.937390737674207 |
Aggressive |
|
|
|
|
|
19.9056 |
19.9056 |
19.9056 |
19.9056 |
20.150845639511253 |
20.399112811842382 |
20.650438743590357 |
20.881931983434864 |
21.116020282917528 |
21.352732732885798 |
21.592098750298085 |
21.857602436107214 |
22.126370844257298 |
22.398444118868866 |
22.673862897688011 |
22.952668318156178 |
23.234902023554582 |
23.520606169224191 |
23.809823428862174 |
24.102597000895795 |
24.398970614934658 |
24.698988538302313 |
25.002695582648158 |
25.310137110640664 |
25.621359042742874 |
25.936407864071249 |
26.255330631338822 |
26.578174979883752 |
26.904989130784283 |
27.235821898061207 |
27.570722695968886 |
27.909741546375916 |
28.252929086236563 |
28.600336575154063 |
28.952015903036916 |
29.308019597849338 |
29.668400833457003 |
30.03321343756927 |
30.402511899779054 |
30.776351379701577 |
31.154787715213185 |
31.537877430791475 |
31.925677745957969 |
32.31824658382461 |
32.715642579745349 |
33.11792509007411 |
33.525154201030446 |
33.937390737674207 |
Servicing Cost per Vehicle ('000s) |
|
|
|
|
|
|
|
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.837766516657058 |
1.8604085985159284 |
1.8833296406596103 |
1.9044419320556858 |
1.9257908941005792 |
1.9473791798931399 |
1.9692094722736895 |
1.9934235321974241 |
2.0179353363206691 |
2.0427485458059316 |
2.0678668668346005 |
2.0932940511605143 |
2.1190338966703339 |
2.145090247950808 |
2.1714669968630136 |
2.1981680831236554 |
2.2251974948935169 |
2.2525592693731427 |
2.2802574934058497 |
2.3082963040881497 |
2.336679889387681 |
2.3654124887687362 |
2.3944983938254816 |
2.4239419489229648 |
2.4537475518460026 |
2.4839196544560487 |
2.5144627633561369 |
2.5453814405640043 |
2.5766803041934865 |
2.6083640291442958 |
2.6404373478002787 |
2.6729050507362602 |
2.7057719874335793 |
2.7390430670044239 |
2.7727232589250717 |
2.8068175937781459 |
2.8413311640040009 |
2.876269124661345 |
2.9116366941972172 |
2.9474391552264301 |
2.9836818553206004 |
3.0203702078068773 |
3.0575096925764966 |
3.0951058569032734 |
Conservative |
|
|
|
|
|
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.837766516657058 |
1.8604085985159284 |
1.8833296406596103 |
1.9044419320556858 |
1.9257908941005792 |
1.9473791798931399 |
1.9692094722736895 |
1.9934235321974241 |
2.0179353363206691 |
2.0427485458059316 |
2.0678668668346005 |
2.0932940511605143 |
2.1190338966703339 |
2.145090247950808 |
2.1714669968630136 |
2.1981680831236554 |
2.2251974948935169 |
2.2525592693731427 |
2.2802574934058497 |
2.3082963040881497 |
2.336679889387681 |
2.3654124887687362 |
2.3944983938254816 |
2.4239419489229648 |
2.4537475518460026 |
2.4839196544560487 |
2.5144627633561369 |
2.5453814405640043 |
2.5766803041934865 |
2.6083640291442958 |
2.6404373478002787 |
2.6729050507362602 |
2.7057719874335793 |
2.7390430670044239 |
2.7727232589250717 |
2.8068175937781459 |
2.8413311640040009 |
2.876269124661345 |
2.9116366941972172 |
2.9474391552264301 |
2.9836818553206004 |
3.0203702078068773 |
3.0575096925764966 |
3.0951058569032734 |
Base |
|
|
|
|
|
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.837766516657058 |
1.8604085985159284 |
1.8833296406596103 |
1.9044419320556858 |
1.9257908941005792 |
1.9473791798931399 |
1.9692094722736895 |
1.9934235321974241 |
2.0179353363206691 |
2.0427485458059316 |
2.0678668668346005 |
2.0932940511605143 |
2.1190338966703339 |
2.145090247950808 |
2.1714669968630136 |
2.1981680831236554 |
2.2251974948935169 |
2.2525592693731427 |
2.2802574934058497 |
2.3082963040881497 |
2.336679889387681 |
2.3654124887687362 |
2.3944983938254816 |
2.4239419489229648 |
2.4537475518460026 |
2.4839196544560487 |
2.5144627633561369 |
2.5453814405640043 |
2.5766803041934865 |
2.6083640291442958 |
2.6404373478002787 |
2.6729050507362602 |
2.7057719874335793 |
2.7390430670044239 |
2.7727232589250717 |
2.8068175937781459 |
2.8413311640040009 |
2.876269124661345 |
2.9116366941972172 |
2.9474391552264301 |
2.9836818553206004 |
3.0203702078068773 |
3.0575096925764966 |
3.0951058569032734 |
Aggressive |
|
|
|
|
|
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.837766516657058 |
1.8604085985159284 |
1.8833296406596103 |
1.9044419320556858 |
1.9257908941005792 |
1.9473791798931399 |
1.9692094722736895 |
1.9934235321974241 |
2.0179353363206691 |
2.0427485458059316 |
2.0678668668346005 |
2.0932940511605143 |
2.1190338966703339 |
2.145090247950808 |
2.1714669968630136 |
2.1981680831236554 |
2.2251974948935169 |
2.2525592693731427 |
2.2802574934058497 |
2.3082963040881497 |
2.336679889387681 |
2.3654124887687362 |
2.3944983938254816 |
2.4239419489229648 |
2.4537475518460026 |
2.4839196544560487 |
2.5144627633561369 |
2.5453814405640043 |
2.5766803041934865 |
2.6083640291442958 |
2.6404373478002787 |
2.6729050507362602 |
2.7057719874335793 |
2.7390430670044239 |
2.7727232589250717 |
2.8068175937781459 |
2.8413311640040009 |
2.876269124661345 |
2.9116366941972172 |
2.9474391552264301 |
2.9836818553206004 |
3.0203702078068773 |
3.0575096925764966 |
3.0951058569032734 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
Wages and Salaries as a % of Rev. |
|
|
|
|
|
|
|
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
Conservative |
|
|
|
|
|
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
Base |
|
2.176096831378398E-2 |
2.3005244373652523E-2 |
3.1308910704242562E-2 |
3.3031027688790626E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
2.7E-2 |
Aggressive |
|
|
|
|
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Commissions a % of Rev. |
|
|
|
|
|
|
|
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
Conservative |
|
|
|
|
|
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
1.2E-2 |
Base |
|
8.4425931514122299E-3 |
7.5063896835358378E-3 |
6.9186327587659026E-3 |
6.3463630575483661E-3 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
Aggressive |
|
|
|
|
|
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
8.0000000000000002E-3 |
Other Expenses as a % of Rev. |
|
|
|
|
|
|
|
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
Conservative |
|
|
|
|
|
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
3.2000000000000001E-2 |
Base |
|
3.3098107026374925E-2 |
3.0208723006087013E-2 |
3.0093429228093455E-2 |
4.9300134859400303E-2 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
0.03 |
Aggressive |
|
|
|
|
|
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
2.8000000000000001E-2 |
Tax Rate |
|
|
|
|
|
|
|
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
Conservative |
|
|
|
|
|
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
Base |
|
0.2499999675030303 |
0.25000002933768534 |
0.24999997383865877 |
0.81256488524548098 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
Aggressive |
|
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
Dividend Payout Ratio |
|
|
|
|
|
|
|
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 |
Conservative |
|
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 |
Base |
|
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 |
Aggressive |
|
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 |
BALANCE SHEET ASSUMPTIONS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Days Sales Outstanding |
|
|
|
|
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
Conservative |
|
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 |
Base |
|
30.136350140591667 |
31.242663575678971 |
81.394414666540868 |
79.749185579569556 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
150 |
Aggressive |
|
|
|
|
|
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 |
Days Inventory Outstanding |
|
|
|
|
|
|
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
Conservative |
|
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 |
Base |
|
75.274752578333079 |
82.724871335900133 |
90.469601517943005 |
61.138641903716426 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
Aggressive |
|
|
|
|
|
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 |
Days Payables Outstanding |
|
|
|
|
|
|
|
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
Conservative |
|
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 |
Base |
|
12.634796752021344 |
10.567424396301206 |
25.392388199067 |
8.947439621352272 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
Aggressive |
|
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 |
Land Capex (in GHS'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 |
Conservative |
|
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 |
Base |
|
|
|
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 |
Aggressive |
|
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 |
Sale/Disposal of Land as a % of Op. Bal. |
|
|
|
|
|
|
|
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 |
Conservative |
|
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 |
Base |
|
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 |
Aggressive |
|
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 |
Buildings Capex (in GHS'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 |
Conservative |
|
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 |
Base |
952.00800000000004 |
1920.8 |
165.87100000000001 |
|
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 |
Aggressive |
|
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 |
Sale/Disposal of Buildings as a % of Op. Bal. |
|
|
|
|
|
|
|
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 |
Conservative |
|
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 |
Base |
|
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 |
Aggressive |
|
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 |
Depreciation of Buildings as a % of Op. Bal. |
|
|
|
|
|
|
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Conservative |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Base |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Aggressive |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Furniture and Equip. Capex (in GHS'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 |
Conservative |
|
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 |
Base |
19.87 |
5.8360000000000003 |
6.5860000000000003 |
|
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 |
Aggressive |
|
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 |
Sale/Disposal of Furniture and Equip. as a % of Op. Bal. |
|
|
|
|
|
|
|
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 |
Conservative |
|
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 |
Base |
|
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 |
Aggressive |
|
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 |
Depreciation of Furniture and Equip. as a % of Op. Bal. |
|
|
|
|
|
|
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Conservative |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Base |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Aggressive |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Motor Vehicles Capex (in GHS'000) |
|
|
|
|
|
|
|
178.64 |
0 |
0 |
0 |
259.83999999999997 |
0 |
0 |
0 |
470.96 |
0 |
0 |
0 |
324.79999999999995 |
0 |
0 |
0 |
568.4 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
162.39999999999998 |
0 |
0 |
0 |
113.67999999999999 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
64.959999999999994 |
0 |
0 |
0 |
Conservative |
|
178.64 |
0 |
0 |
0 |
259.83999999999997 |
0 |
0 |
0 |
470.96 |
0 |
0 |
0 |
324.79999999999995 |
0 |
0 |
0 |
568.4 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
162.39999999999998 |
0 |
0 |
0 |
113.67999999999999 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
64.959999999999994 |
0 |
0 |
0 |
Base |
7.0289999999999999 |
81.5 |
40.271000000000001 |
|
178.64 |
0 |
0 |
0 |
259.83999999999997 |
0 |
0 |
0 |
470.96 |
0 |
0 |
0 |
324.79999999999995 |
0 |
0 |
0 |
568.4 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
162.39999999999998 |
0 |
0 |
0 |
113.67999999999999 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
64.959999999999994 |
0 |
0 |
0 |
Aggressive |
|
178.64 |
0 |
0 |
0 |
259.83999999999997 |
0 |
0 |
0 |
470.96 |
0 |
0 |
0 |
324.79999999999995 |
0 |
0 |
0 |
568.4 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
243.59999999999997 |
0 |
0 |
0 |
162.39999999999998 |
0 |
0 |
0 |
113.67999999999999 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
81.199999999999989 |
0 |
0 |
0 |
64.959999999999994 |
0 |
0 |
0 |
Sale/Disposal of Motor Vehicles as a % of Op. Bal. |
|
|
|
|
|
|
|
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 |
Conservative |
|
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 |
Base |
|
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 |
Aggressive |
|
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 |
Depreciation of Motor Vehicles as a % of Op. Bal. |
|
|
|
|
|
|
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Conservative |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Base |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Aggressive |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Computers & Printers Capex (in GHS'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 |
Conservative |
|
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 |
Base |
2000 |
0 |
0.16700000000000001 |
|
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 |
Aggressive |
|
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 |
Sale/Disposal of Computers & Printers as a % of Op. Bal. |
|
|
|
|
|
|
|
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 |
Conservative |
|
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 |
Base |
|
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 |
Aggressive |
|
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 |
Depreciation of Computers & Printers as a % of Op. Bal. |
|
|
|
|
|
|
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Conservative |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Base |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
Aggressive |
|
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
2.5000000000000001E-2 |
DEBT ASSUMPTIONS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(Values in '000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Facility Name |
|
|
Debt Structure |
|
|
|
Disbursement Options |
|
|
|
|
|
|
|
|
Prepayment Options |
|
|
|
|
|
Fees (in LCU) |
|
|
|
Supporting Calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Principal |
Interest |
Moratorium |
Total Tenure |
Disbursement |
Date |
% of Principal |
Disbursement |
Date |
% of Principal |
Disbursement |
Date |
% of Principal |
Prepayment |
Date |
Prepayment |
Date |
Prepayment |
Date |
Off Closing |
Review |
Prepayment |
Admin |
Repayments |
Repayments |
Principal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USD |
(%/q) |
(in q) |
(in q) |
(#1, LCU) |
(#1) |
(#1) |
(#2, LCU) |
(#2) |
(#2) |
(#3, LCU) |
(#3) |
(#3) |
(#1, LCU) |
(#1) |
(#2, LCU) |
(#2) |
(#3, LCU) |
(#3) |
(one time) |
(annual, %) |
(on prepaid amt.) |
(annual, absol.) |
(periods) |
(start date) |
(LCU) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Vital Capital Loan |
|
|
500 |
2.6433327247938676E-2 |
1 |
12 |
2918.8217300440156 |
2021-03-31T00:00:00.000 |
1 |
0 |
NA |
0 |
0 |
NA |
0 |
0 |
NA |
0 |
NA |
0 |
NA |
0.01 |
0.01 |
0 |
0 |
11 |
2021-09-30T00:00:00.000 |
2918.8217300440156 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revolver |
|
Limit (in GHS'000) |
Int. (% per qtr.) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
500 |
0.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXCHANGE RATES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
From |
To |
|
Rate |
Date |
GHS |
USD |
|
0.17130200000000001 |
2021-01-15T00:00:00.000 |
GHS |
EUR |
|
0.15 |
GHS |
GBP |
|
0.14000000000000001 |
|
|
|
|
|
|
|
|
|
Inflation Forecasts |
|
|
Year |
GHS |
|
|
USD |
|
|
EUR |
|
|
GBP |
|
|
|
|
|
|
Annual |
Quarterly |
Monthly |
Annual |
Quarterly |
Monthly |
Annual |
Quarterly |
Monthly |
Annual |
Quarterly |
Monthly |
|
|
|
2020 |
5.3100000000000001E-2 |
1.3018561961216868E-2 |
4.3208242423642407E-3 |
2.7300000000000001E-2 |
6.7562212918501618E-3 |
2.2470208793048396E-3 |
0.05 |
1.2272234429039353E-2 |
4.0741237836483535E-3 |
0.06 |
1.4673846168659299E-2 |
4.8675505653430484E-3 |
|
|
|
2021 |
5.0200000000000002E-2 |
1.2320434426053684E-2 |
|
2.2700000000000001E-2 |
5.6273214306179486E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2022 |
4.5600000000000002E-2 |
1.1210088207755931E-2 |
|
2.23E-2 |
5.5289763782044865E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2023 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.23E-2 |
5.5289763782044865E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2024 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2025 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2026 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2027 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2028 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2029 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2030 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2031 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
2032 |
5.0099999999999999E-2 |
1.2296335288178639E-2 |
|
2.24E-2 |
5.5535653465523804E-3 |
|
0.05 |
1.2272234429039353E-2 |
|
0.06 |
1.4673846168659299E-2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GHS Inflation |
|
%/q |
|
|
|
|
1.3018561961216868E-2 |
0 |
0 |
0 |
0 |
1.2320434426053684E-2 |
1.2320434426053684E-2 |
1.2320434426053684E-2 |
1.1210088207755931E-2 |
1.1210088207755931E-2 |
1.1210088207755931E-2 |
1.1210088207755931E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
1.2296335288178639E-2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USD Inflation |
|
%/q |
|
|
|
|
6.7562212918501618E-3 |
0 |
0 |
0 |
5.6273214306179486E-3 |
5.6273214306179486E-3 |
5.6273214306179486E-3 |
5.6273214306179486E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5289763782044865E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
5.5535653465523804E-3 |
USD Inflation Differential |
|
%/q |
|
|
|
|
6.2203148457637969E-3 |
0 |
0 |
0 |
-5.5958318859241629E-3 |
6.6556594603197627E-3 |
6.6556594603197627E-3 |
6.6556594603197627E-3 |
5.649873810712247E-3 |
5.649873810712247E-3 |
5.649873810712247E-3 |
5.649873810712247E-3 |
6.73014808021688E-3 |
6.73014808021688E-3 |
6.73014808021688E-3 |
6.73014808021688E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
6.7055303406959865E-3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EUR Inflation |
|
%/q |
|
|
|
|
1.2272234429039353E-2 |
0 |
0 |
0 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
1.2272234429039353E-2 |
EUR Inflation Differential |
|
%/q |
|
|
|
|
7.3727946573431957E-4 |
0 |
0 |
0 |
-1.212345257692593E-2 |
4.7615646636245401E-5 |
4.7615646636245401E-5 |
4.7615646636245401E-5 |
-1.0492693419399401E-3 |
-1.0492693419399401E-3 |
-1.0492693419399401E-3 |
-1.0492693419399401E-3 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
2.3808673516478862E-5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GBP Inflation |
|
%/q |
|
|
|
|
1.4673846168659299E-2 |
0 |
0 |
0 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
1.4673846168659299E-2 |
GBP Inflation Differential |
|
%/q |
|
|
|
|
-1.6313460859296303E-3 |
0 |
0 |
0 |
-1.4461638312711744E-2 |
-2.3193775531831218E-3 |
-2.3193775531831218E-3 |
-2.3193775531831218E-3 |
-3.4136663460699879E-3 |
-3.4136663460699879E-3 |
-3.4136663460699879E-3 |
-3.4136663460699879E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
-2.3431281780426083E-3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USD/GHS |
|
|
|
|
|
|
0.17130200000000001 |
0.17130200000000001 |
0.17130200000000001 |
0.17130200000000001 |
0.17034342280627743 |
0.17147717061978127 |
0.17261846427264568 |
0.17376735398740778 |
0.17474911760985801 |
0.17573642807288703 |
0.17672931671544415 |
0.17772781505353979 |
0.1789239495668235 |
0.18012813424250548 |
0.18134042325937072 |
0.1825608711608355 |
0.18378503862142836 |
0.18501741477407033 |
0.18625805466239498 |
0.18750701369913267 |
0.18876434766858549 |
0.19003011272911888 |
0.19130436541566986 |
0.19258716264227224 |
0.19387856170459855 |
0.19517862028251923 |
0.19648739644267885 |
0.19780494864108958 |
0.19913133572574221 |
0.20046661693923448 |
0.20181085192141721 |
0.20316410071205798 |
0.2045264237535229 |
0.20589788189347619 |
0.20727853638759794 |
0.20866844890232003 |
0.21006768151758051 |
0.21147629672959631 |
0.21289435745365465 |
0.2143219270269231 |
0.21575906921127858 |
0.21720584819615513 |
0.21866232860141105 |
0.22012857548021506 |
0.22160465432195181 |
0.22309063105514709 |
0.22458657205041241 |
0.22609254412340934 |
0.22760861453783401 |
0.22913485100842124 |
0.23067132170396906 |
0.23221809525038348 |
0.17205160292152805 |
0.17623566936293222 |
0.1807383445573838 |
0.18564188043925658 |
0.19067149711391163 |
0.19583738176772156 |
0.20114322632461296 |
0.20659282273422927 |
0.21219006568193863 |
0.21793895537226496 |
0.22384360038773016 |
0.22990822062515195 |
EUR/GHS |
|
|
|
|
|
|
0.15 |
0.15 |
0.15 |
0.15 |
0.1481814821134611 |
0.14818853787055145 |
0.14819559396360624 |
0.14820265039264147 |
0.14804714589519022 |
0.14789180456384068 |
0.14773662622738767 |
0.14758161071480563 |
0.14758512443719218 |
0.14758863824323579 |
0.14759215213293847 |
0.1475956661063022 |
0.14759918016332899 |
0.14760269430402079 |
0.14760620852837963 |
0.1476097228364075 |
0.14761323722810638 |
0.14761675170347824 |
0.14762026626252511 |
0.14762378090524897 |
0.14762729563165181 |
0.14763081044173562 |
0.14763432533550241 |
0.14763784031295415 |
0.14764135537409284 |
0.14764487051892047 |
0.14764838574743905 |
0.14765190105965054 |
0.14765541645555696 |
0.1476589319351603 |
0.14766244749846255 |
0.14766596314546568 |
0.14766947887617171 |
0.14767299469058262 |
0.1476765105887004 |
0.14768002657052706 |
0.14768354263606459 |
0.14768705878531496 |
0.1476905750182802 |
0.14769409133496228 |
0.1476976077353632 |
0.14770112421948492 |
0.14770464078732948 |
0.14770815743889884 |
0.14771167417419503 |
0.15 |
0.15 |
0.15 |
0.14819206608506508 |
0.14781429685030606 |
0.14759039522991715 |
0.14760445145803425 |
0.14761850902483967 |
0.14763256793046101 |
0.14764662817502572 |
0.14766068975866137 |
0.14767475268149546 |
0.14768881694365552 |
0.14770288254526912 |
0.14942791854354875 |
GBP/GHS |
|
|
|
|
|
|
0.14000000000000001 |
0.14000000000000001 |
0.14000000000000001 |
0.14000000000000001 |
0.13797537063622037 |
0.1376553536586746 |
0.13733607892132318 |
0.13701754470263089 |
0.13654981252145837 |
0.1360836770218917 |
0.1356191327533926 |
0.13515617428402915 |
0.1348394860436278 |
0.13452353984436619 |
0.1342083339475468 |
0.13389386661854616 |
0.13358013612680517 |
0.13326714074581969 |
0.132954878753131 |
0.1326433484303163 |
0.13233254806297931 |
0.13202247594074076 |
0.13171313035722906 |
0.13140450961007083 |
0.1310966120008816 |
0.13078943583525643 |
0.13048297942276055 |
0.13017724107692014 |
0.12987221911521296 |
0.12956791185905919 |
0.1292643176338121 |
0.12896143476874886 |
0.1286592615970614 |
0.12835779645584716 |
0.12805703768609999 |
0.12775698363270102 |
0.12745763264440951 |
0.12715898307385379 |
0.12686103327752218 |
0.12656378161575402 |
0.1262672264527305 |
0.12597136615646581 |
0.12567619909879807 |
0.12538172365538039 |
0.12508793820567191 |
0.12479484113292895 |
0.12450243082419603 |
0.12421070567029706 |
0.12391966406582643 |
0.14000000000000001 |
0.14000000000000001 |
0.14000000000000001 |
0.13749608697971227 |
0.13585219914519298 |
0.13436630661352175 |
0.13311137601401804 |
0.13186816599275497 |
0.13063656708395466 |
0.12941647084420829 |
0.12820776984292739 |
0.12701035765288488 |
0.12582412884084371 |
0.1246489789582735 |
0.13597991601645662 |
|
|
|
|
IRR |
|
|
|
|
0.12610463500022887 |
2.4433327247938674E-2 |
2.5433327247938675E-2 |
2.6433327247938676E-2 |
2.7433327247938677E-2 |
2.8433327247938678E-2 |
8 |
0.11914742588996888 |
0.12352177500724792 |
0.12790891528129572 |
0.13230887055397034 |
0.13672167658805848 |
10 |
0.11795477271080015 |
0.12232921719551085 |
0.12671645283699035 |
0.13111651539802549 |
0.13552942872047424 |
12 |
0.11734769940376283 |
0.12171975970268248 |
0.12610463500022887 |
0.13050233721733095 |
0.13491291403770447 |
14 |
0.11669792532920836 |
0.12103695273399354 |
0.12538878321647645 |
0.129898864030838 |
0.13427643179893492 |
16 |
0.11632608771324157 |
0.12075121998786925 |
0.1250570476055145 |
0.12950783371925356 |
0.1338402330875397 |
12
600
600
55
85
80
6
6
4
4
0
3
1
0
2
0
0
False
False
15
143
R245C9:R249C13
R196C7:R196C7
R196C9:R196C9
Buildup |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Date |
|
|
2016 |
2017 |
2018 |
2019 |
2020 |
2021-03-31T00:00:00.000 |
2021-06-30T00:00:00.000 |
2021-09-30T00:00:00.000 |
2021-12-31T00:00:00.000 |
2022-03-31T00:00:00.000 |
2022-06-30T00:00:00.000 |
2022-09-30T00:00:00.000 |
2022-12-31T00:00:00.000 |
2023-03-31T00:00:00.000 |
2023-06-30T00:00:00.000 |
2023-09-30T00:00:00.000 |
2023-12-31T00:00:00.000 |
2024-03-31T00:00:00.000 |
2024-06-30T00:00:00.000 |
2024-09-30T00:00:00.000 |
2024-12-31T00:00:00.000 |
2025-03-31T00:00:00.000 |
2025-06-30T00:00:00.000 |
2025-09-30T00:00:00.000 |
2025-12-31T00:00:00.000 |
2026-03-31T00:00:00.000 |
2026-06-30T00:00:00.000 |
2026-09-30T00:00:00.000 |
2026-12-31T00:00:00.000 |
2027-03-31T00:00:00.000 |
2027-06-30T00:00:00.000 |
2027-09-30T00:00:00.000 |
2027-12-31T00:00:00.000 |
2028-03-31T00:00:00.000 |
2028-06-30T00:00:00.000 |
2028-09-30T00:00:00.000 |
2028-12-31T00:00:00.000 |
2029-03-31T00:00:00.000 |
2029-06-30T00:00:00.000 |
2029-09-30T00:00:00.000 |
2029-12-31T00:00:00.000 |
2030-03-31T00:00:00.000 |
2030-06-30T00:00:00.000 |
2030-09-30T00:00:00.000 |
2030-12-31T00:00:00.000 |
2031-03-31T00:00:00.000 |
2031-06-30T00:00:00.000 |
2031-09-30T00:00:00.000 |
2031-12-31T00:00:00.000 |
2032-03-31T00:00:00.000 |
2032-06-30T00:00:00.000 |
2032-09-30T00:00:00.000 |
2032-12-31T00:00:00.000 |
|
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
2030 |
2031 |
2032 |
|
Quarter |
|
|
|
|
|
|
|
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
Q1 |
Q2 |
Q3 |
Q4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Year |
|
|
|
|
|
|
|
2021 |
2021 |
2021 |
2021 |
2022 |
2022 |
2022 |
2022 |
2023 |
2023 |
2023 |
2023 |
2024 |
2024 |
2024 |
2024 |
2025 |
2025 |
2025 |
2025 |
2026 |
2026 |
2026 |
2026 |
2027 |
2027 |
2027 |
2027 |
2028 |
2028 |
2028 |
2028 |
2029 |
2029 |
2029 |
2029 |
2030 |
2030 |
2030 |
2030 |
2031 |
2031 |
2031 |
2031 |
2032 |
2032 |
2032 |
2032 |
|
|
|
|
|
|
|
|
|
|
|
|
|
(Values in GHS '000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
Revenue Buildup |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue - Mini Buses |
|
|
|
|
|
2363.79 |
2363.79 |
2363.79 |
2363.79 |
3151.72 |
3151.72 |
3151.72 |
3151.72 |
3939.65 |
3939.65 |
3939.65 |
3939.65 |
4727.58 |
4727.58 |
4727.58 |
4727.58 |
5515.51 |
5515.51 |
5515.51 |
5515.51 |
6716.7886439041231 |
6799.3805291293993 |
6882.9879918674878 |
6967.6235199999983 |
7934.9622243341819 |
8032.5331803436284 |
8131.303901542552 |
8231.2891406459948 |
8795.4207113162829 |
8903.5721533832202 |
9013.0534618437105 |
9123.8809891808196 |
9722.1803041612893 |
9841.7274929133837 |
9962.744673981133 |
10085.249922882922 |
10413.446768147764 |
10541.494001114508 |
10671.115745790534 |
10802.331362899737 |
11256.782817444666 |
11395.199993234173 |
11535.319193026831 |
11677.161345480454 |
11933.326185518628 |
12080.062365398966 |
12228.60286254602 |
12378.969863449867 |
9455.16 |
12606.88 |
15758.6 |
18910.32 |
22062.04 |
27366.780684901008 |
32330.088446866357 |
35835.927315724031 |
39611.902393938726 |
42428.38787795254 |
45864.463349186124 |
48620.961276913484 |
|
|
|
Revenue - Existing Vehicles |
|
|
|
|
|
415.45399999999995 |
415.45399999999995 |
415.45399999999995 |
415.45399999999995 |
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 |
1661.8159999999998 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Revenue - Corp. Transport Serv. |
|
|
|
|
|
455 |
455 |
455 |
455 |
690.90869649578156 |
699.42099178534806 |
708.03816225084483 |
715.97533250413414 |
1448.0029582721659 |
1464.2351991594883 |
1480.6494048989673 |
1498.8559664258473 |
2023.0485359169422 |
2047.9246190188358 |
2073.1065867792067 |
2098.5982004583757 |
3452.1553097953674 |
3494.6041689514777 |
3537.5749935123722 |
3581.0742017396769 |
3903.9627747250461 |
3951.9672099556337 |
4000.5619238171357 |
4049.754174573513 |
4392.3764032915396 |
4446.3865362582965 |
4501.0607959289709 |
4556.4073486281904 |
4919.9300918362069 |
4980.4272018398242 |
5041.6682045920115 |
5103.6622472474246 |
5295.5790541731276 |
5360.6952697682964 |
5426.6121761831209 |
5493.3396189803816 |
5764.3346708160007 |
5835.2148626416274 |
5906.9666210712312 |
5979.6006631800028 |
6195.5543751844407 |
6271.7369890778509 |
6348.8563699348242 |
6426.9240365560318 |
6730.2948097046683 |
6813.0527712730845 |
6896.8283524847129 |
6981.6340663318824 |
1820 |
2814.3431830361087 |
5891.7435287564685 |
8242.677942173359 |
14065.408673998894 |
15906.246083071328 |
17896.231084106999 |
20045.687745515468 |
21576.226119104926 |
23486.116817708862 |
25243.071770753148 |
27421.80999979435 |
|
|
|
Revenue - Vehicle Mgmt. |
|
|
|
|
|
429.78 |
429.78 |
429.78 |
429.78 |
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 |
1719.12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Total Revenue |
|
|
|
|
|
|
|
3664.0239999999994 |
3664.0239999999994 |
3664.0239999999994 |
3664.0239999999994 |
3842.6286964957812 |
3851.140991785348 |
3859.7581622508446 |
3867.6953325041341 |
5387.652958272166 |
5403.8851991594884 |
5420.2994048989676 |
5438.5059664258479 |
6750.6285359169424 |
6775.5046190188359 |
6800.6865867792067 |
6826.1782004583756 |
8967.6653097953676 |
9010.114168951477 |
9053.0849935123733 |
9096.5842017396772 |
10620.75141862917 |
10751.347739085033 |
10883.549915684624 |
11017.377694573512 |
12327.338627625722 |
12478.919716601926 |
12632.364697471523 |
12787.696489274185 |
13715.350803152491 |
13883.999355223044 |
14054.721666435722 |
14227.543236428244 |
15017.759358334417 |
15202.422762681679 |
15389.356850164255 |
15578.589541863304 |
16177.781438963764 |
16376.708863756136 |
16578.082366861767 |
16781.932026079739 |
17452.337192629107 |
17666.936982312025 |
17884.175562961656 |
18104.085382036486 |
18663.620995223297 |
18893.115136672051 |
19125.431215030734 |
19360.603929781748 |
|
14656.095999999998 |
15421.223183036107 |
21650.343528756472 |
27152.997942173362 |
36127.448673998893 |
43273.02676797234 |
50226.319530973356 |
55881.615061239499 |
61188.128513043659 |
65914.50469566141 |
71107.535119939275 |
76042.771276707834 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
Direct Costs (COGS) Buildup |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mini Buses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No. of Mini Buses |
|
|
|
|
|
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
50 |
50 |
50 |
50 |
60 |
60 |
60 |
60 |
70 |
70 |
70 |
70 |
80 |
80 |
80 |
80 |
90 |
90 |
90 |
90 |
95 |
95 |
95 |
95 |
100 |
100 |
100 |
100 |
102 |
102 |
102 |
102 |
105 |
105 |
105 |
105 |
106 |
106 |
106 |
106 |
|
120 |
160 |
200 |
240 |
280 |
320 |
360 |
380 |
400 |
408 |
420 |
424 |
New Additions |
|
|
|
|
|
0 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
5 |
0 |
0 |
0 |
5 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
3 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
|
0 |
10 |
10 |
10 |
10 |
10 |
10 |
5 |
5 |
2 |
3 |
1 |
Insurance Costs |
|
|
|
|
|
88.740000000000009 |
88.740000000000009 |
88.740000000000009 |
88.740000000000009 |
118.32000000000001 |
118.32000000000001 |
118.32000000000001 |
118.32000000000001 |
147.9 |
147.9 |
147.9 |
147.9 |
177.48000000000002 |
177.48000000000002 |
177.48000000000002 |
177.48000000000002 |
207.06 |
207.06 |
207.06 |
207.06 |
236.64000000000001 |
236.64000000000001 |
236.64000000000001 |
236.64000000000001 |
266.22000000000003 |
266.22000000000003 |
266.22000000000003 |
266.22000000000003 |
281.01 |
281.01 |
281.01 |
281.01 |
295.8 |
295.8 |
295.8 |
295.8 |
301.71600000000001 |
301.71600000000001 |
301.71600000000001 |
301.71600000000001 |
310.59000000000003 |
310.59000000000003 |
310.59000000000003 |
310.59000000000003 |
313.548 |
313.548 |
313.548 |
313.548 |
|
354.96000000000004 |
473.28000000000003 |
591.6 |
709.92000000000007 |
828.24 |
946.56000000000006 |
1064.8800000000001 |
1124.04 |
1183.2 |
1206.864 |
1242.3600000000001 |
1254.192 |
New Registration Costs |
|
|
|
|
|
0 |
0 |
0 |
0 |
20.550104818848887 |
0 |
0 |
0 |
21.534402969175801 |
0 |
0 |
0 |
22.564772131381279 |
0 |
0 |
0 |
23.695267215163472 |
0 |
0 |
0 |
24.882400102643153 |
0 |
0 |
0 |
26.129008347785568 |
0 |
0 |
0 |
13.719035833004806 |
0 |
0 |
0 |
14.406359528238344 |
0 |
0 |
0 |
6.0512472562412309 |
0 |
0 |
0 |
9.5316221156683714 |
0 |
0 |
0 |
3.3363854612211177 |
0 |
0 |
0 |
|
0 |
20.550104818848887 |
21.534402969175801 |
22.564772131381279 |
23.695267215163472 |
24.882400102643153 |
26.129008347785568 |
13.719035833004806 |
14.406359528238344 |
6.0512472562412309 |
9.5316221156683714 |
3.3363854612211177 |
Fuel Costs |
|
|
|
|
|
1140 |
1140 |
1140 |
1140 |
1538.7270603276013 |
1557.6848461739619 |
1576.8762001777061 |
1594.5531214744092 |
2015.5352532726124 |
2038.1295812476401 |
2060.9771936322627 |
2086.3196602264543 |
2534.3684955443014 |
2565.5319403093108 |
2597.0785812398854 |
2629.0131302445589 |
3104.8970833662484 |
3143.0759389386071 |
3181.7242545200038 |
3220.8478027481119 |
3922.3487846531084 |
3970.5793004263833 |
4019.4028747927273 |
4068.8268001994484 |
4633.7157661097563 |
4690.6934887999614 |
4748.3718286723224 |
4806.7594007506186 |
5136.1907552136227 |
5199.3470788437726 |
5263.2799938048483 |
5327.9990493242349 |
5677.3830653156028 |
5747.1940710461513 |
5817.8634963099666 |
5889.4018965214491 |
6081.0563560256705 |
6155.8310638856719 |
6231.5252266245952 |
6308.1501501679149 |
6573.5324935643939 |
6654.3628531329987 |
6736.1871299043223 |
6819.0175454175405 |
6968.6080569347487 |
7054.2963980947216 |
7141.0383918278858 |
7228.8469941995581 |
|
4560 |
6267.8412281536785 |
8200.9616883789695 |
10325.992147338056 |
12650.545079572972 |
15981.157760071666 |
18879.540484332661 |
20926.81687718648 |
23131.842529193171 |
24776.562796703853 |
26783.100022019255 |
28392.789841056914 |
Service Costs |
|
|
|
|
|
12.180000000000001 |
12.180000000000001 |
12.180000000000001 |
12.180000000000001 |
16.440083855079113 |
16.642632830174438 |
16.847677296635492 |
17.036541245226584 |
21.534402969175808 |
21.77580552596163 |
22.0199142267026 |
22.29067847505107 |
27.077726557657542 |
27.410683362252122 |
27.747734315352474 |
28.088929759981347 |
33.173374101228873 |
33.581285031817764 |
33.994211771976886 |
34.412215997782461 |
39.811840164229054 |
40.301379899327792 |
40.796939179146186 |
41.298592022024401 |
47.032215026014029 |
47.610538911319615 |
48.195974061024074 |
48.788607917618791 |
52.13233616541828 |
52.773372850264309 |
53.422291937119219 |
54.079190350640999 |
57.62543811295339 |
58.334019821118453 |
59.051314487546179 |
59.777429249692723 |
61.722722013660572 |
62.481685298439587 |
63.249981050239661 |
64.027724024204346 |
66.721354809678616 |
67.541782959299951 |
68.3722993685289 |
69.213028085988057 |
70.731371777887716 |
71.601108440661434 |
72.48153967705305 |
73.372796991125512 |
|
48.720000000000006 |
66.966935227115627 |
87.620801196891108 |
110.32507399524349 |
135.16108690280598 |
162.20875126472743 |
191.62733591597652 |
212.4071913034428 |
234.78820167131073 |
251.48211238654415 |
271.84846522349551 |
288.18681688672768 |
Mini Bus Direct Costs |
|
|
|
|
|
|
|
1240.92 |
1240.92 |
1240.92 |
1240.92 |
1694.0372490015293 |
1692.6474790041364 |
1712.0438774743416 |
1729.9096627196357 |
2206.504059210964 |
2207.8053867736016 |
2230.8971078589652 |
2256.5103387015056 |
2761.4909942333402 |
2770.4226236715631 |
2802.3063155552377 |
2834.5820600045404 |
3368.8257246826411 |
3383.717223970425 |
3422.7784662919807 |
3462.3200187458942 |
4223.6830249199802 |
4247.5206803257115 |
4296.8398139718729 |
4346.7653922214731 |
4973.0969894835562 |
5004.5240277112816 |
5062.7878027333463 |
5121.7680086682376 |
5483.0521272120459 |
5533.1304516940372 |
5597.7122857419681 |
5663.0882396748757 |
6045.2148629567946 |
6101.3280908672696 |
6172.7148107975127 |
6244.9793257711417 |
6450.5463252955715 |
6520.0287491841118 |
6596.4912076748351 |
6673.8938741921193 |
6960.375470489741 |
7032.4946360922986 |
7115.1494292728512 |
7198.820573503529 |
7356.223814173858 |
7439.4455065353832 |
7527.0679315049383 |
7615.7677911906831 |
|
4963.68 |
6828.6382681996429 |
8901.7168925450369 |
11168.801993464682 |
13637.64143369094 |
17114.808911439039 |
20162.176828596421 |
22276.983104322924 |
24564.237090392719 |
26240.960156346639 |
28306.840109358418 |
29938.505043404864 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Corporate Transport Services |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No. of Vehicles |
|
|
|
|
|
10 |
10 |
10 |
10 |
15 |
15 |
15 |
15 |
30 |
30 |
30 |
30 |
40 |
40 |
40 |
40 |
65 |
65 |
65 |
65 |
70 |
70 |
70 |
70 |
75 |
75 |
75 |
75 |
80 |
80 |
80 |
80 |
82 |
82 |
82 |
82 |
85 |
85 |
85 |
85 |
87 |
87 |
87 |
87 |
90 |
90 |
90 |
90 |
|
40 |
60 |
120 |
160 |
260 |
280 |
300 |
320 |
328 |
340 |
348 |
360 |
Fuel Costs |
|
|
|
|
|
273.702 |
273.702 |
273.702 |
273.702 |
415.61119131491967 |
420.73170174424916 |
425.91529908655116 |
430.68984715834421 |
871.03583667034832 |
880.80022523153946 |
890.6740734497962 |
901.62610048942281 |
1216.9503964341518 |
1231.9144265377879 |
1247.062459372841 |
1262.39675749859 |
2076.6193683551915 |
2102.1541763744121 |
2128.0029689545568 |
2154.1696069550617 |
2348.4009216874606 |
2377.2776468115972 |
2406.5094498298849 |
2436.1006968991633 |
2642.2026512828584 |
2674.6920609823469 |
2707.5809713568156 |
2740.8742948005111 |
2959.5488043862701 |
2995.940408786732 |
3032.7794965565768 |
3070.0715701013501 |
3185.5177544731719 |
3224.6879488486197 |
3264.3397930674114 |
3304.479209657512 |
3467.4943474102865 |
3510.1318205159073 |
3553.2935782866757 |
3596.9860675026207 |
3726.8914804323763 |
3772.7185876584294 |
3819.1092003602212 |
3866.0702475900184 |
4048.5607692434864 |
4098.3432298966709 |
4148.7378323775174 |
4199.752103787182 |
1094.808 |
1692.9480393040642 |
3544.1362358411066 |
4958.3240398433709 |
8460.9461206392225 |
9568.2887152281055 |
10765.349978422531 |
12058.340279830929 |
12979.024706046715 |
14127.90581371549 |
15184.789516041044 |
16495.393935304855 |
CTS Direct Costs |
|
|
|
|
|
|
|
273.702 |
273.702 |
273.702 |
273.702 |
415.61119131491967 |
420.73170174424916 |
425.91529908655116 |
430.68984715834421 |
871.03583667034832 |
880.80022523153946 |
890.6740734497962 |
901.62610048942281 |
1216.9503964341518 |
1231.9144265377879 |
1247.062459372841 |
1262.39675749859 |
2076.6193683551915 |
2102.1541763744121 |
2128.0029689545568 |
2154.1696069550617 |
2348.4009216874606 |
2377.2776468115972 |
2406.5094498298849 |
2436.1006968991633 |
2642.2026512828584 |
2674.6920609823469 |
2707.5809713568156 |
2740.8742948005111 |
2959.5488043862701 |
2995.940408786732 |
3032.7794965565768 |
3070.0715701013501 |
3185.5177544731719 |
3224.6879488486197 |
3264.3397930674114 |
3304.479209657512 |
3467.4943474102865 |
3510.1318205159073 |
3553.2935782866757 |
3596.9860675026207 |
3726.8914804323763 |
3772.7185876584294 |
3819.1092003602212 |
3866.0702475900184 |
4048.5607692434864 |
4098.3432298966709 |
4148.7378323775174 |
4199.752103787182 |
|
1094.808 |
1692.9480393040642 |
3544.1362358411066 |
4958.3240398433709 |
8460.9461206392225 |
9568.2887152281055 |
10765.349978422531 |
12058.340279830929 |
12979.024706046715 |
14127.90581371549 |
15184.789516041044 |
16495.393935304855 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Office Vehicles |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No. of Vehicles |
|
1 |
1 |
1 |
1 |
2 |
2 |
2 |
2 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
4 |
8 |
24 |
24 |
24 |
24 |
24 |
24 |
24 |
24 |
24 |
24 |
Insurance Costs |
|
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
0.84462499999999996 |
1.7100622938542112 |
1.7311310042101089 |
1.7524592902303879 |
1.772104513454372 |
5.3759098840906745 |
5.4361743080882778 |
5.4971143015946833 |
5.5647086621645334 |
5.6331341856555408 |
5.7024010923256627 |
5.7725197281045748 |
5.8435005661389745 |
5.9153542083568809 |
5.9880913870511758 |
6.0617229664826127 |
6.1362599445025348 |
6.211713454195559 |
6.2880947655424375 |
6.3654152871033887 |
6.4436865677221098 |
6.5229202982507539 |
6.6031283132961107 |
6.6843225929872663 |
6.7665152647649851 |
6.8497186051931145 |
6.9339450417922439 |
7.0192071548959261 |
7.1055176795297079 |
7.1928895073132875 |
7.2813356883860338 |
7.3708694333562095 |
7.4615041152741455 |
7.5532532716296803 |
7.6461306063741716 |
7.7401499919673533 |
7.8353254714493774 |
7.9316712605383248 |
8.0292017497535149 |
8.1279315065649129 |
8.2278752775689874 |
8.3290479906912918 |
8.4314647574161619 |
8.5351408750438136 |
8.6400918289751907 |
3.3784999999999998 |
6.9657571017490802 |
21.87390715593817 |
22.951555572224752 |
24.101428506393205 |
25.308910074563496 |
26.576886469299112 |
27.908388481410991 |
29.306598744329676 |
30.774859341420584 |
32.316679794425738 |
33.935745452126454 |
Fuel Costs |
18.910319999999999 |
18.910319999999999 |
18.910319999999999 |
18.910319999999999 |
38.286606715071379 |
38.758314342500526 |
39.235833612821679 |
39.675670768526238 |
120.36131561262989 |
121.71057657744905 |
123.07496287669909 |
124.58833388581111 |
126.1203138122666 |
127.67113147755254 |
129.24101851682167 |
130.83020941349019 |
132.43894153426112 |
134.06745516457786 |
135.71599354451439 |
137.38480290510603 |
146.39382368960796 |
148.19393122981387 |
150.01617349588895 |
151.86082266384398 |
153.72815425645723 |
155.61844718442751 |
157.53198378803293 |
159.4690498793025 |
161.42993478470569 |
163.41493138836725 |
165.42433617581332 |
167.4584492782555 |
169.51757451741938 |
171.60201945092439 |
173.71209541822151 |
175.84811758709603 |
178.01040500074203 |
180.19928062541561 |
182.41507139867431 |
184.65810827820945 |
186.9287262912791 |
189.22726458474887 |
191.55406647574782 |
193.90947950294765 |
196.2938554784721 |
198.70755054044466 |
201.15092520618268 |
203.62434442604524 |
75.641279999999995 |
155.95642543891984 |
489.73518895258911 |
513.862673220131 |
539.60719314845937 |
596.46475107915478 |
626.34763510822017 |
657.72765162714177 |
690.67980697366136 |
725.28286530304149 |
761.61953685472349 |
799.77667565114473 |
Service Costs |
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
1.8154000000000001 |
3.6755330333141161 |
3.7208171970318569 |
3.7666592813192206 |
3.8088838641113716 |
11.554745364603475 |
11.684275079358839 |
11.815256833642136 |
11.960541193184545 |
12.107612017924016 |
12.256491274835589 |
12.407201201007602 |
12.559764306963086 |
12.714203380022003 |
12.870541487704848 |
13.028801981178081 |
13.189008498741932 |
13.351184969361102 |
13.515355616238857 |
13.681544960435097 |
13.849777824528898 |
14.020079336326086 |
14.192474932612416 |
14.36699036295289 |
14.54365169353779 |
14.722485311076015 |
14.903517926736292 |
15.086776580136821 |
15.272288643384027 |
15.46008182516092 |
15.650184174865775 |
15.842624086801672 |
16.037430304417562 |
16.234631924601477 |
16.434258402026543 |
16.636339553550428 |
16.840905562668876 |
17.047986984024007 |
17.25761474796807 |
17.469820165183304 |
17.68463493135858 |
17.902091131923601 |
18.122221246841264 |
18.345058155458979 |
18.57063514141964 |
7.2616000000000005 |
14.971893375776567 |
47.014818470788995 |
49.331068800730293 |
51.802555347646866 |
54.397863370563954 |
57.123196325429184 |
59.985068461333157 |
62.99032039124593 |
66.146135442847324 |
69.460056828533965 |
72.940005675643476 |
Office Vehicles Direct Costs |
|
|
|
|
|
|
|
21.570345 |
21.570345 |
21.570345 |
21.570345 |
43.672202042239711 |
44.210262543742488 |
44.754952184371291 |
45.256659146091984 |
137.29197086132405 |
138.83102596489616 |
140.38733401193591 |
142.1135837411602 |
143.86106001584616 |
145.63002384471378 |
147.42073944593386 |
149.23347428659224 |
151.06849912264002 |
152.92608803933391 |
154.80651849217509 |
156.71007134835051 |
165.9567221131646 |
167.99738161159516 |
170.06313374342744 |
172.15428705609497 |
174.27115389103409 |
176.41405043033603 |
178.58329674397308 |
180.77921683760528 |
183.00213870097483 |
185.25239435689579 |
187.53031991084606 |
189.83625560116923 |
192.17054584989359 |
194.53353931417621 |
196.92558893837938 |
199.34705200678775 |
201.79829019697317 |
204.27966963381635 |
206.7915609441921 |
209.3343393123277 |
211.90838453584144 |
214.51408108247045 |
217.15181814749604 |
219.8219897118752 |
222.524994601087 |
225.26123654470209 |
228.03112423668549 |
230.83507139644007 |
86.281379999999999 |
177.89407591644547 |
558.62391457931631 |
586.14529759308607 |
615.51117700249949 |
676.17152452428218 |
710.04771790294853 |
745.62110856988591 |
782.97672610923689 |
822.20386008730929 |
863.39627347768305 |
906.65242677891467 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Direct Costs (COGS) |
|
|
|
|
|
|
|
1536.1923450000002 |
1536.1923450000002 |
1536.1923450000002 |
1536.1923450000002 |
2153.3206423586889 |
2157.5894432921277 |
2182.7141287452641 |
2205.8561690240717 |
3214.8318667426361 |
3227.4366379700373 |
3261.9585153206972 |
3300.2500229320885 |
4122.3024506833381 |
4147.9670740540651 |
4196.7895143740125 |
4246.2122917897223 |
5596.5135921604724 |
5638.7974883841707 |
5705.5879537387127 |
5773.1996970493065 |
6738.0406687206059 |
6792.795708748904 |
6873.4123975451857 |
6955.0203761767316 |
7789.5707946574485 |
7855.6301391239649 |
7948.9520708341352 |
8043.4215203063541 |
8625.6030702992903 |
8714.3232548376654 |
8818.0221022093901 |
8922.9960653773942 |
9422.9031632798597 |
9520.5495790300647 |
9633.980192803303 |
9748.8055874354413 |
10119.838962902832 |
10234.440239333835 |
10356.576346905702 |
10480.214281007067 |
10899.17533545796 |
11019.727304833199 |
11151.410447780569 |
11284.712810805424 |
11627.30957801843 |
11763.049972976756 |
11903.836888119142 |
12046.354966374303 |
6144.7693800000006 |
8699.4803834201521 |
13004.477042965458 |
16713.271330901138 |
22714.098731332662 |
27359.269151191431 |
31637.5745249219 |
35080.944492723742 |
38326.238522548665 |
41191.069830149434 |
44355.025898877153 |
47340.55140548863 |
600
600
55
85
6
6
5
59
0
3
1
0
2
0
0
False
False
Supporting Data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month |
|
2020-01-31T00:00:00.000 |
2020-02-29T00:00:00.000 |
2020-03-31T00:00:00.000 |
2020-04-30T00:00:00.000 |
2020-05-31T00:00:00.000 |
2020-06-30T00:00:00.000 |
2020-07-31T00:00:00.000 |
2020-08-31T00:00:00.000 |
2020-09-30T00:00:00.000 |
2020-10-31T00:00:00.000 |
2020-11-30T00:00:00.000 |
2020-12-31T00:00:00.000 |
2021-01-31T00:00:00.000 |
2021-02-28T00:00:00.000 |
2021-03-31T00:00:00.000 |
2021-04-30T00:00:00.000 |
2021-05-31T00:00:00.000 |
2021-06-30T00:00:00.000 |
2021-07-31T00:00:00.000 |
2021-08-31T00:00:00.000 |
2021-09-30T00:00:00.000 |
2021-10-31T00:00:00.000 |
2021-11-30T00:00:00.000 |
2021-12-31T00:00:00.000 |
2022-01-31T00:00:00.000 |
2022-02-28T00:00:00.000 |
2022-03-31T00:00:00.000 |
2022-04-30T00:00:00.000 |
2022-05-31T00:00:00.000 |
2022-06-30T00:00:00.000 |
2022-07-31T00:00:00.000 |
2022-08-31T00:00:00.000 |
2022-09-30T00:00:00.000 |
2022-10-31T00:00:00.000 |
2022-11-30T00:00:00.000 |
2022-12-31T00:00:00.000 |
2023-01-31T00:00:00.000 |
2023-02-28T00:00:00.000 |
2023-03-31T00:00:00.000 |
Year |
|
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2020 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2021 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2022 |
2023 |
2023 |
2023 |
Quarter |
|
Q1 |
Q1 |
Q1 |
Q2 |
Q2 |
Q2 |
Q3 |
Q3 |
Q3 |
Q4 |
Q4 |
Q4 |
Q1 |
Q1 |
Q1 |
Q2 |
Q2 |
Q2 |
Q3 |
Q3 |
Q3 |
Q4 |
Q4 |
Q4 |
Q1 |
Q1 |
Q1 |
Q2 |
Q2 |
Q2 |
Q3 |
Q3 |
Q3 |
Q4 |
Q4 |
Q4 |
Q1 |
Q1 |
Q1 |
EXIM Loan |
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
Mora. End |
2020-09-30T00:00:00.000 |
Opening Balance |
2046.7961 |
2046.7961 |
2046.7961 |
2046.7961 |
2057.0300805000002 |
2067.2640610000003 |
2077.4980415000005 |
2087.7320220000006 |
2097.9660025000007 |
2108.1999830000009 |
1988.9321589176138 |
1869.086055680403 |
1748.6587818925943 |
1627.6474317014349 |
1506.049084724908 |
1383.8608059790865 |
1261.0796458051243 |
1137.7026397958805 |
1013.7268087221785 |
889.14915845869621 |
763.96667990948481 |
638.17634893311549 |
511.77512626745266 |
384.75995745404981 |
257.12777276216815 |
128.87548711241527 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Int. (Monthly) |
5.0000000000000001E-3 |
Principal Paid |
0 |
0 |
0 |
0 |
0 |
0 |
-115.65583096474016 |
-116.23411011956387 |
-116.81528067016167 |
-117.39935707351249 |
-117.98635385888005 |
-118.57628562817445 |
-119.16916705631533 |
-119.76501289159691 |
-120.36383795605489 |
-120.96565714583517 |
-121.57048543156434 |
-122.17833785872216 |
-122.78922954801578 |
-123.40317569575583 |
-124.02019157423463 |
-124.64029253210582 |
-125.26349399476632 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Tenure (Months) |
17 |
Net Capitalised Interest |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470454 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Closing Balance |
|
|
|
|
2057.0300805000002 |
2067.2640610000003 |
2077.4980415000005 |
2087.7320220000006 |
2097.9660025000007 |
2108.1999830000009 |
1988.9321589176138 |
1869.086055680403 |
1748.6587818925943 |
1627.6474317014349 |
1506.049084724908 |
1383.8608059790865 |
1261.0796458051243 |
1137.7026397958805 |
1013.7268087221785 |
889.14915845869621 |
763.96667990948481 |
638.17634893311549 |
511.77512626745266 |
384.75995745404981 |
257.12777276216815 |
128.87548711241527 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
EMI |
0 |
0 |
0 |
0 |
0 |
0 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
125.88981146474016 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
Interest Paid |
0 |
0 |
0 |
0 |
0 |
0 |
-10.540999915000004 |
-9.944660794588069 |
-9.3454302784020147 |
-8.743293909462972 |
-8.1382371585071756 |
-7.5302454236245397 |
-6.9193040298954331 |
-6.3053982290256219 |
-5.6885131989794022 |
-5.0686340436108921 |
-4.4457457922934811 |
-3.8198333995474241 |
-3.1908817446655777 |
-2.5588756313372634 |
-1.923799787270249 |
-1.2856388638108407 |
-0.64437743556207638 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Capitalised Interest Opening Balance |
|
0 |
10.233980499999999 |
20.467960999999999 |
30.701941499999997 |
40.935921999999998 |
51.169902499999999 |
61.403883 |
57.79188988235294 |
54.17989676470588 |
50.56790364705882 |
46.95591052941176 |
43.3439174117647 |
39.73192429411764 |
36.11993117647058 |
32.50793805882352 |
28.89594494117646 |
25.283951823529399 |
21.671958705882339 |
18.059965588235279 |
14.447972470588221 |
10.835979352941163 |
7.2239862352941042 |
3.6119931176470454 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
(+) Accrued |
|
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
10.233980499999999 |
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 |
|
|
|
|
(-) Paid |
|
0 |
0 |
0 |
0 |
0 |
0 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470588 |
-3.6119931176470454 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
Closing Balance |
|
|
|
|
10.233980499999999 |
20.467960999999999 |
30.701941499999997 |
40.935921999999998 |
51.169902499999999 |
61.403883 |
57.79188988235294 |
54.17989676470588 |
50.56790364705882 |
46.95591052941176 |
43.3439174117647 |
39.73192429411764 |
36.11993117647058 |
32.50793805882352 |
28.89594494117646 |
25.283951823529399 |
21.671958705882339 |
18.059965588235279 |
14.447972470588221 |
10.835979352941163 |
7.2239862352941042 |
3.6119931176470454 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Stanbic - 1 (10-01-2018) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mora. End |
NA |
Opening Balance |
595.35029882862625 |
573.62227279003662 |
551.16234675144699 |
528.06262071285732 |
504.41909467426768 |
480.35402764524747 |
454.57259999999997 |
429.64176999999995 |
405.38917999999995 |
380.64882999999998 |
355.16395 |
329.41347999999999 |
302.93141000000003 |
276.13045000000005 |
248.79047000000006 |
220.41642000000007 |
191.95594000000008 |
162.79853000000008 |
133.17925000000008 |
102.87787000000009 |
72.053480000000093 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Int. (Monthly) |
NA |
Principal Paid |
-21.728026038589626 |
-22.459926038589622 |
-23.099726038589623 |
-23.64352603858962 |
-24.065067029020234 |
-24.494123683837074 |
-24.930829999999993 |
-24.252589999999994 |
-24.740349999999992 |
-25.484879999999993 |
-25.750469999999993 |
-26.482069999999993 |
-26.800959999999996 |
-27.339979999999994 |
-28.374049999999997 |
-28.460479999999993 |
-29.157409999999995 |
-29.619279999999993 |
-30.301379999999995 |
-30.824389999999994 |
-72.053479999999993 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Tenure (Months) |
NA |
Closing Balance |
|
573.62227279003662 |
551.16234675144699 |
528.06262071285732 |
504.41909467426768 |
480.35402764524747 |
454.57259999999997 |
429.64176999999995 |
405.38917999999995 |
380.64882999999998 |
355.16395 |
329.41347999999999 |
302.93141000000003 |
276.13045000000005 |
248.79047000000006 |
220.41642000000007 |
191.95594000000008 |
162.79853000000008 |
133.17925000000008 |
102.87787000000009 |
72.053480000000093 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
EMI |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
32.893449999999994 |
73.502600000000001 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
Interest Paid |
-11.165423961410371 |
-10.433523961410371 |
-9.7937239614103717 |
-9.2499239614103725 |
-8.8283829709797619 |
-8.3993263161629201 |
-7.9626200000000003 |
-8.64086 |
-8.1531000000000002 |
-7.4085700000000001 |
-7.1429799999999997 |
-6.4113800000000003 |
-6.0924899999999997 |
-5.5534699999999999 |
-4.5193999999999992 |
-4.4329700000000001 |
-3.73604 |
-3.2741700000000002 |
-2.5920700000000001 |
-2.0690599999999999 |
-1.4491200000000044 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
New Loan Added |
595.35029882862625 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Stanbic - 2 (09-28-2018) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mora. End |
NA |
Opening Balance |
453.6385509450958 |
437.26778241001563 |
420.24271387493548 |
402.7164153398553 |
384.73557680477518 |
366.43415739493378 |
346.82745 |
327.86761999999999 |
309.42651000000001 |
290.61452000000003 |
271.23564000000005 |
251.65556000000004 |
231.51843000000002 |
211.13957000000002 |
190.35085000000004 |
168.77355000000003 |
147.13278000000003 |
124.96132000000003 |
102.43940000000003 |
79.398070000000033 |
55.95980000000003 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Int. (Monthly) |
NA |
Principal Paid |
-16.370768535080153 |
-17.025068535080152 |
-17.526298535080151 |
-17.980838535080149 |
-18.301419409841422 |
-18.627715930013903 |
-18.95983 |
-18.441109999999998 |
-18.811990000000002 |
-19.378879999999999 |
-19.580079999999999 |
-20.137129999999999 |
-20.37886 |
-20.788719999999998 |
-21.577300000000001 |
-21.64077 |
-22.17146 |
-22.521919999999998 |
-23.041329999999999 |
-23.438269999999999 |
-55.959800000000001 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
Tenure (Months) |
NA |
Closing Balance |
|
437.26778241001563 |
420.24271387493548 |
402.7164153398553 |
384.73557680477518 |
366.43415739493378 |
346.82745 |
327.86761999999999 |
309.42651000000001 |
290.61452000000003 |
271.23564000000005 |
251.65556000000004 |
231.51843000000002 |
211.13957000000002 |
190.35085000000004 |
168.77355000000003 |
147.13278000000003 |
124.96132000000003 |
102.43940000000003 |
79.398070000000033 |
55.95980000000003 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
EMI |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
25.03511 |
57.085250000000002 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
Interest Paid |
-8.6643414649198487 |
-8.0100414649198495 |
-7.508811464919849 |
-7.0542714649198492 |
-6.7336905901585773 |
-6.407394069986097 |
-6.0752799999999993 |
-6.5940000000000003 |
-6.2231199999999998 |
-5.6562299999999999 |
-5.4550299999999998 |
-4.8979799999999996 |
-4.65625 |
-4.2463899999999999 |
-3.4578099999999998 |
-3.3943400000000001 |
-2.8636500000000003 |
-2.5131900000000003 |
-1.9937799999999999 |
-1.5968399999999998 |
-1.1254500000000001 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
New Loan Added |
453.6385509450958 |
|
|
|
|
|
|
|
|
|
|
|
SheetHidden
300
300
55
85
5
5
7
7
0
3
1
0
2
0
0
22
14
False
False