Financial management, financial risk & cash flow

Reg No. Assumed Exchange rates for DJF (Part I of assignment)  
62 £Sterling $US € Euro Rand  
157 112 148 11.1
Cost break down of “Temporary works and site overheads”: Skilled Labour Unskilled Labour Local Material Plant (USA) Component Equipment
Skilled Labour DJF 306,000,000 306,000,000 0 0 0                                  –                              –            785,214,000
Unskilled Labour DJF 1,989,000,000 1,989,000,000 982,500,000 7,860,000,000 6,877,500,000          3,917,424,000          525,340,800            440,199,360
Local Material DJF 306,000,000 306,000,000 642,600,000 2,754,000,000 3,488,400,000          1,830,124,800          321,900,000            209,790,000
Plant (USA) $ 1,815,600             203,347,200 150,000,000 1,425,000,000 1,312,500,000              498,400,000          160,950,000              44,955,000
Component (France)                 2,958,000             437,784,000 112,500,000 281,250,000 506,250,000                74,760,000          257,520,000 0
Subtotal 3,242,131,200 112,500,000 675,000,000 1,012,500,000              358,848,000          164,169,000 0
Cost breakdown for supervisory and managerial staff 114,750,000 1,262,250,000 459,000,000              457,531,200 0 0
Supervisory  Staff £ 30,600,000          4,804,200,000 2,114,850,000 14,257,500,000 13,656,150,000          7,137,088,000      1,429,879,800        1,480,158,360
Subtotal          4,804,200,000
Cost breakdown for Construction of Quay and Jetties
Skilled Labour DJF 982,500,000 982,500,000 Cost breakdown for Construction of Rail Links
Unskilled Labour DJF 7,860,000,000 7,860,000,000 Skilled Labour DJF 642,600,000 642,600,000 Supervisory Skilled Unskilled Local Plant from Components from France Equipment from
Local Material DJF 6,877,500,000 6,877,500,000 Unskilled Labour DJF 2,754,000,000 2,754,000,000 Staff Labour Labour Materials USA South Africa
Plant (USA) $ 34,977,000          3,917,424,000 Local Material DJF 3,488,400,000 3,488,400,000 £ Sterling D Dalasi D Dalasi D Dalasi $ Dollars € Euros R South Africa
Equipment (Sout Africa) R 70,740,000             785,214,000 Plant (USA) $ 16,340,400.00          1,830,124,800 1 Temporary works and site overheads. DJF 306,000,000 DJF 1,989,000,000 DJF 306,000,000 $1,815,600 € 2,958,000
Subtotal 20,422,638,000 Component (France)                3,549,600              525,340,800 2 Costs of supervisory and managerial staff £30,600,000
Equipment (SA) R 39,657,600              440,199,360 3 Construction of Quay and Jetties DJF 982,500,000 DJF 7,860,000,000 DJF 6,877,500,000 $34,977,000 R 70,740,000
Subtotal 9,680,664,960 4 Construction of Rail Links DJF 642,600,000 DJF 2,754,000,000 DJF 3,488,400,000 $16,340,400.00 € 3,549,600 R 39,657,600
Cost breakdown for Construction of Roads 5 Construction of Roads DJF 150,000,000 DJF 1,425,000,000 DJF 1,312,500,000 $4,450,000.00 € 2,175,000 R 18,900,000
Skilled Labour DJF 150,000,000 150,000,000 Cost breakdown for Landscaping 6 Warehouses DJF 112,500,000 DJF 281,250,000 DJF 506,250,000 $667,500.00 € 1,087,500 R 4,050,000
Unskilled Labour DJF 1,425,000,000 1,425,000,000 Skilled Labour DJF 114,750,000 114,750,000 7 Storm Culverts and River Diversions DJF 112,500,000 DJF 675,000,000 DJF 1,012,500,000 $3,204,000.00 € 1,740,000
Local Material DJF 1,312,500,000 1,312,500,000 Unskilled Labour DJF 1,262,250,000 1,262,250,000 8 Landscaping DJF 114,750,000 DJF 1,262,250,000 DJF 459,000,000 $4,085,100.00 € 1,109,250
Plant (USA) $ 4,450,000.00             498,400,000 Local Material DJF 459,000,000 459,000,000
Component (France)                 2,175,000             321,900,000 Plant (USA) $ 4,085,100.00              457,531,200
Equipment (SA) R 18,900,000             209,790,000 Component (France)                1,109,250              164,169,000
Subtotal 3,917,590,000 Subtotal 2,457,700,200
Cost breakdown for Warehouses A summary of the project tender sum
Skilled Labour DJF 112,500,000 112,500,000 Temporary works and site overheads 3,242,131,200
Unskilled Labour DJF 281,250,000 281,250,000 Costs of supervisory and managerial staff          4,804,200,000
Local Material DJF 506,250,000 506,250,000 Costs of skilled labour 2,114,850,000
Plant (USA) $ 667,500.00                74,760,000 Costs of unskilled labour 14,257,500,000
Component (France)                 1,087,500             160,950,000 Costs of construction plant          7,137,088,000
Equipment (SA) R 4,050,000                44,955,000 Costs of local material 13,656,150,000
Subtotal 1,180,665,000 Costs of imported component          1,429,879,800
Costs of imported equipment          1,480,158,360
Cost breakdown for Storm Culverts and River Diversions Contingencies          5,774,634,883
Skilled Labour DJF 112,500,000 112,500,000 Head office overheads          2,406,097,868
Unskilled Labour DJF 675,000,000 675,000,000 Profit margin        12,030,489,340
Local Material DJF 1,012,500,000 1,012,500,000 Total of Tender Sum 68,333,179,451
Plant (USA) $ 3,204,000.00             358,848,000
Component (France)                 1,740,000             257,520,000 Cost breakdown for other expenditures
Subtotal 2,416,368,000 Contingency (12%)        5,774,634,883
Head office overheads (5%)        2,406,097,868
Profit margin (25%)      12,030,489,340
Subtotal      20,211,222,091
Item Currency Amount Assumed Exchange rates for DJF
Total Tender Sum DJF 69,237,347,078 (Part I of assignment)
Total 69,237,347,078 £Sterling $US € Euro Rand
157 112 148 11.1
Project Period 2 years (24 Months)
Stages of Settlement
Expected monthly Settlement (DJF)                       2,884,889,462 Stage Item % Contract Amount (DJF)
Stage1  (31/12/2015) Mobilization Settlement 20%                                                  13,847,469,416
Work Completion Settlement per Month                       1,730,933,677 Stage2 (31/01/2016 – 31/08/2017) Interim Settlement 50%                                                  34,618,673,539
Stage3 (31/09/2017 – 31/11/2017) Final Settlement 30%                                                  20,771,204,123
Half contract sum amount                    34,618,673,539 Total Settlement 100%                                                  69,237,347,078
Rrequired Period to achieve 50% of Contract Sum = 20 months                              34,618,673,539
Project Cash Flow:
Mobilization activities Stage 1
2015
Month 01Dec2015
Settlement                              13,847,469,416
 Interim Settlement Stage 2
Jan-16
Month Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16
Settlement          1,730,933,677                       1,730,933,677                                1,730,933,677                    1,730,933,677                            1,730,933,677                                    1,730,933,677
Month Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16
Settlement          1,730,933,677                       1,730,933,677                                1,730,933,677                    1,730,933,677                            1,730,933,677                                    1,730,933,677
Interim Settlement Stage 2 & 3
Jan-17
Month Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17
Settlement          1,730,933,677                       1,730,933,677                                1,730,933,677                    1,730,933,677                            1,730,933,677                                    1,730,933,677
Month Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17
Settlement          1,730,933,677                       1,730,933,677                                5,192,801,031                    5,192,801,031                            5,192,801,031                                    5,192,801,031
Preparation Expenses for Cash flow
Item Advanced Settlement% (Dec-2015)
Temporary works and site overheads 50%                    1,621,065,600
Costs of supervisory and managerial staff 20%                        960,840,000
Costs of skilled labour 10%                        211,485,000
Subtotal                    2,793,390,600
Head office overheads 5%                        139,669,530
Total Expenditure                    2,933,060,130
CASH FLOW
2016
TOTALS
Temporary works and site overheads                    1,621,065,600
Costs of supervisory and managerial staff                    3,843,360,000 1621065600
Costs of skilled labour                    1,903,365,000
Costs of unskilled labour                  14,257,500,000
Costs of construction plant                    7,137,088,000
Costs of local material                  13,656,150,000
Costs of imported component                    1,429,879,800
Costs of imported equipment                    1,480,158,360
Item   1-Jan 1-Feb 1-Mar 1-Apr
Temporary works and site overheads                             67,544,400                                      67,544,400                          67,544,400                                  67,544,400
Costs of supervisory and managerial staff                          160,140,000                                    160,140,000                        160,140,000                               160,140,000
Costs of skilled labour                             79,306,875                                      79,306,875                          79,306,875                                  79,306,875
Costs of unskilled labour                          594,062,500                                    594,062,500                        594,062,500                               594,062,500
Costs of construction plant                          297,378,667                                    297,378,667                        297,378,667                               297,378,667
Costs of local material                          569,006,250                                    569,006,250                        569,006,250                               569,006,250
Costs of imported component                             59,578,325                                      59,578,325                          59,578,325                                  59,578,325
Costs of imported equipment                             61,673,265                                      61,673,265                          61,673,265                                  61,673,265
Subtotal                       1,888,690,282                                1,888,690,282                    1,888,690,282                            1,888,690,282
Head office overheads (5%)                             94,434,514                                      94,434,514                          94,434,514                                  94,434,514
Total Expenditure                       1,983,124,796                                1,983,124,796                    1,983,124,796                            1,983,124,796
Item   1-May 1-Jun 1-Jul 1-Aug
Temporary works and site overheads                             67,544,400                                      67,544,400                          67,544,400                                  67,544,400
Costs of supervisory and managerial staff                          160,140,000                                    160,140,000                        160,140,000                               160,140,000
Costs of skilled labour                             79,306,875                                      79,306,875                          79,306,875                                  79,306,875
Costs of unskilled labour                          594,062,500                                    594,062,500                        594,062,500                               594,062,500
Costs of construction plant                          297,378,667                                    297,378,667                        297,378,667                               297,378,667
Costs of local material                          569,006,250                                    569,006,250                        569,006,250                               569,006,250
Costs of imported component                             59,578,325                                      59,578,325                          59,578,325                                  59,578,325
Costs of imported equipment                             61,673,265                                      61,673,265                          61,673,265                                  61,673,265
Subtotal                       1,888,690,282                                1,888,690,282                    1,888,690,282                            1,888,690,282
Head office overheads (5%)                             94,434,514                                      94,434,514                          94,434,514                                  94,434,514
Total Expenditure                       1,983,124,796                                1,983,124,796                    1,983,124,796                            1,983,124,796
Item   1-Sep 1-Oct 1-Nov 1-Dec
Temporary works and site overheads                             67,544,400                                      67,544,400                          67,544,400                                  67,544,400
Costs of supervisory and managerial staff                          160,140,000                                    160,140,000                        160,140,000                               160,140,000
Costs of skilled labour                             79,306,875                                      79,306,875                          79,306,875                                  79,306,875
Costs of unskilled labour                          594,062,500                                    594,062,500                        594,062,500                               594,062,500
Costs of construction plant                          297,378,667                                    297,378,667                        297,378,667                               297,378,667
Costs of local material                          569,006,250                                    569,006,250                        569,006,250                               569,006,250
Costs of imported component                             59,578,325                                      59,578,325                          59,578,325                                  59,578,325
Costs of imported equipment                             61,673,265                                      61,673,265                          61,673,265                                  61,673,265
Subtotal                       1,888,690,282                                1,888,690,282                    1,888,690,282                            1,888,690,282
Head office overheads (5%)                             94,434,514                                      94,434,514                          94,434,514                                  94,434,514
Total Expenditure                       1,983,124,796                                1,983,124,796                    1,983,124,796                            1,983,124,796
CASH FLOW
2017
Item   1-Jan 1-Feb 1-Mar 1-Apr
Temporary works and site overheads                             67,544,400                                      67,544,400                          67,544,400                                  67,544,400
Costs of supervisory and managerial staff                          160,140,000                                    160,140,000                        160,140,000                               160,140,000
Costs of skilled labour                             79,306,875                                      79,306,875                          79,306,875                                  79,306,875
Costs of unskilled labour                          594,062,500                                    594,062,500                        594,062,500                               594,062,500
Costs of construction plant                          297,378,667                                    297,378,667                        297,378,667                               297,378,667
Costs of local material                          569,006,250                                    569,006,250                        569,006,250                               569,006,250
Costs of imported component                             59,578,325                                      59,578,325                          59,578,325                                  59,578,325
Costs of imported equipment                             61,673,265                                      61,673,265                          61,673,265                                  61,673,265
Subtotal                       1,888,690,282                                1,888,690,282                    1,888,690,282                            1,888,690,282
Head office overheads (5%)                             94,434,514                                      94,434,514                          94,434,514                                  94,434,514
Total Expenditure                       1,983,124,796                                1,983,124,796                    1,983,124,796                            1,983,124,796
Item   1-May 1-Jun 1-Jul 1-Aug
Temporary works and site overheads                             67,544,400                                      67,544,400                          67,544,400                                  67,544,400
Costs of supervisory and managerial staff                          160,140,000                                    160,140,000                        160,140,000                               160,140,000
Costs of skilled labour                             79,306,875                                      79,306,875                          79,306,875                                  79,306,875
Costs of unskilled labour                          594,062,500                                    594,062,500                        594,062,500                               594,062,500
Costs of construction plant                          297,378,667                                    297,378,667                        297,378,667                               297,378,667
Costs of local material                          569,006,250                                    569,006,250                        569,006,250                               569,006,250
Costs of imported component                             59,578,325                                      59,578,325                          59,578,325                                  59,578,325
Costs of imported equipment                             61,673,265                                      61,673,265                          61,673,265                                  61,673,265
Subtotal                       1,888,690,282                                1,888,690,282                    1,888,690,282                            1,888,690,282
Head office overheads (5%)                             94,434,514                                      94,434,514                          94,434,514                                  94,434,514
Total Expenditure                       1,983,124,796                                1,983,124,796                    1,983,124,796                            1,983,124,796
Item   1-Sep 1-Oct 1-Nov 1-Dec Jan-18
Temporary works and site overheads                             67,544,400                                      67,544,400                          67,544,400                                  67,544,400                                          67,544,400
Costs of supervisory and managerial staff                          160,140,000                                    160,140,000                        160,140,000                               160,140,000                                        160,140,000
Costs of skilled labour                             79,306,875                                      79,306,875                          79,306,875                                  79,306,875                                          79,306,875
Costs of unskilled labour                          594,062,500                                    594,062,500                        594,062,500                               594,062,500                                        594,062,500
Costs of construction plant                          297,378,667                                    297,378,667                        297,378,667                               297,378,667                                        297,378,667
Costs of local material                          569,006,250                                    569,006,250                        569,006,250                               569,006,250                                        569,006,250
Costs of imported component                             59,578,325                                      59,578,325                          59,578,325                                  59,578,325                                          59,578,325
Costs of imported equipment                             61,673,265                                      61,673,265                          61,673,265                                  61,673,265                                          61,673,265
Subtotal                       1,888,690,282                                1,888,690,282                    1,888,690,282                            1,888,690,282                                    1,888,690,282
Head office overheads (5%)                             94,434,514                                      94,434,514                          94,434,514                                  94,434,514                                          94,434,514
Total Expenditure                       1,983,124,796                                1,983,124,796                    1,983,124,796                            1,983,124,796                                    1,983,124,796
Cash flow schedule:
Cash Flow Dec-15 Year-2016
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash in hand      10,914,409,286      10,662,218,167      10,410,027,048       10,157,835,929        9,905,644,810        9,653,453,692        9,401,262,573         9,149,071,454         8,896,880,335        8,644,689,216        8,392,498,098          8,140,306,979
Income
Mobilization       13,847,469,416
Interim Payment         1,730,933,677         1,730,933,677         1,730,933,677         1,730,933,677        1,730,933,677        1,730,933,677        1,730,933,677         1,730,933,677         1,730,933,677        1,730,933,677        1,730,933,677          1,730,933,677
Final Payment
Total income       13,847,469,416      12,645,342,963      12,393,151,844      12,140,960,725       11,888,769,606      11,636,578,487      11,384,387,369      11,132,196,250       10,880,005,131      10,627,814,012      10,375,622,893      10,123,431,775          9,871,240,656
Expenditure  
Temporary works and site overheads          1,621,065,600              67,544,400              67,544,400              67,544,400               67,544,400              67,544,400              67,544,400              67,544,400               67,544,400              67,544,400              67,544,400              67,544,400                67,544,400
Costs of supervisory and managerial staff             960,840,000            160,140,000            160,140,000            160,140,000            160,140,000           160,140,000            160,140,000           160,140,000            160,140,000            160,140,000            160,140,000            160,140,000             160,140,000
Costs of skilled labour             211,485,000              79,306,875              79,306,875              79,306,875               79,306,875              79,306,875              79,306,875              79,306,875               79,306,875              79,306,875              79,306,875              79,306,875                79,306,875
Costs of unskilled labour            594,062,500            594,062,500            594,062,500            594,062,500           594,062,500            594,062,500           594,062,500            594,062,500            594,062,500            594,062,500            594,062,500             594,062,500
Costs of construction plant            297,378,667            297,378,667            297,378,667            297,378,667           297,378,667            297,378,667           297,378,667            297,378,667            297,378,667            297,378,667            297,378,667             297,378,667
Costs of local material            569,006,250            569,006,250            569,006,250            569,006,250           569,006,250            569,006,250           569,006,250            569,006,250            569,006,250            569,006,250            569,006,250             569,006,250
Costs of imported component              59,578,325              59,578,325              59,578,325               59,578,325              59,578,325              59,578,325              59,578,325               59,578,325              59,578,325              59,578,325              59,578,325                59,578,325
Costs of imported equipment              61,673,265              61,673,265              61,673,265               61,673,265              61,673,265              61,673,265              61,673,265               61,673,265              61,673,265              61,673,265              61,673,265                61,673,265
Subtotal          2,793,390,600         1,888,690,282         1,888,690,282         1,888,690,282         1,888,690,282        1,888,690,282        1,888,690,282        1,888,690,282         1,888,690,282         1,888,690,282        1,888,690,282        1,888,690,282          1,888,690,282
Head office overheads (5%)             139,669,530              94,434,514              94,434,514              94,434,514               94,434,514              94,434,514              94,434,514              94,434,514               94,434,514              94,434,514              94,434,514              94,434,514                94,434,514
Total Expenditure          2,933,060,130         1,983,124,796         1,983,124,796         1,983,124,796         1,983,124,796        1,983,124,796        1,983,124,796        1,983,124,796         1,983,124,796         1,983,124,796        1,983,124,796        1,983,124,796          1,983,124,796
Cumulative Cash Flow       10,914,409,286      10,662,218,167      10,410,027,048      10,157,835,929         9,905,644,810        9,653,453,692        9,401,262,573        9,149,071,454         8,896,880,335         8,644,689,216        8,392,498,098        8,140,306,979          7,888,115,860
Cash Flow Year-2017 TOTAL
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 18-Jan
Cash in hand          7,888,115,860         7,635,924,741         7,383,733,622         7,131,542,504         6,879,351,385        6,627,160,266        6,374,969,147        6,122,778,028         5,870,586,910         9,080,263,145      12,289,939,380      15,499,615,615        18,709,291,850
Income
Mobilization       13,847,469,416
Interim Payment          1,730,933,677         1,730,933,677         1,730,933,677         1,730,933,677         1,730,933,677        1,730,933,677        1,730,933,677        1,730,933,677       34,618,673,539
Final Payment         5,192,801,031         5,192,801,031        5,192,801,031 5192801031 5192801031       20,771,204,123
Total income          9,619,049,537         9,366,858,418         9,114,667,299         8,862,476,181         8,610,285,062        8,358,093,943        8,105,902,824        7,853,711,705       11,063,387,940      14,273,064,176      17,482,740,411      20,692,416,646        23,902,092,881       69,237,347,078
Expenditure
Temporary works and site overheads               67,544,400              67,544,400              67,544,400              67,544,400               67,544,400              67,544,400              67,544,400              67,544,400               67,544,400              67,544,400              67,544,400              67,544,400                67,544,400         3,242,131,200
Costs of supervisory and managerial staff             160,140,000            160,140,000            160,140,000            160,140,000            160,140,000           160,140,000            160,140,000           160,140,000            160,140,000            160,140,000            160,140,000            160,140,000             160,140,000         4,804,200,000
Costs of skilled labour               79,306,875              79,306,875              79,306,875              79,306,875               79,306,875              79,306,875              79,306,875              79,306,875               79,306,875              79,306,875              79,306,875              79,306,875                79,306,875         2,114,850,000
Costs of unskilled labour             594,062,500            594,062,500            594,062,500            594,062,500            594,062,500           594,062,500            594,062,500           594,062,500            594,062,500            594,062,500            594,062,500            594,062,500             594,062,500       14,257,500,000
Costs of construction plant             297,378,667            297,378,667            297,378,667            297,378,667            297,378,667           297,378,667            297,378,667           297,378,667            297,378,667            297,378,667            297,378,667            297,378,667             297,378,667         7,137,088,000
Costs of local material             569,006,250            569,006,250            569,006,250            569,006,250            569,006,250           569,006,250            569,006,250           569,006,250            569,006,250            569,006,250            569,006,250            569,006,250             569,006,250       13,656,150,000
Costs of imported component               59,578,325              59,578,325              59,578,325              59,578,325               59,578,325              59,578,325              59,578,325              59,578,325               59,578,325              59,578,325              59,578,325              59,578,325                59,578,325         1,429,879,800
Costs of imported equipment               61,673,265              61,673,265              61,673,265              61,673,265               61,673,265              61,673,265              61,673,265              61,673,265               61,673,265              61,673,265              61,673,265              61,673,265                61,673,265         1,480,158,360
Subtotal          1,888,690,282         1,888,690,282         1,888,690,282         1,888,690,282         1,888,690,282        1,888,690,282        1,888,690,282        1,888,690,282         1,888,690,282         1,888,690,282        1,888,690,282        1,888,690,282          1,888,690,282       48,121,957,360
Head office overheads (5%)               94,434,514              94,434,514 94434514.08              94,434,514               94,434,514              94,434,514              94,434,514              94,434,514               94,434,514              94,434,514              94,434,514              94,434,514                94,434,514         2,406,097,868
Total Expenditure          1,983,124,796         1,983,124,796         1,983,124,796         1,983,124,796         1,983,124,796        1,983,124,796        1,983,124,796        1,983,124,796         1,983,124,796         1,983,124,796        1,983,124,796        1,983,124,796          1,983,124,796       50,528,055,228
Cumulative Cash Flow          7,635,924,741         7,383,733,622         7,131,542,504         6,879,351,385         6,627,160,266        6,374,969,147        6,122,778,028        5,870,586,910         9,080,263,145      12,289,939,380      15,499,615,615      18,709,291,850        21,918,968,085       18,709,291,850
The profit received by the contractor at the end of the project (DJF)      21,918,968,085
Pretax Profit Margin                      32
Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18
2015-2018 10,914,409,286 10,662,218,167 10,410,027,048 10,157,835,929 9,905,644,810 9,653,453,692 9,401,262,573 9,149,071,454 8,896,880,335 8,644,689,216 8,392,498,098 8,140,306,979 7,888,115,860 7,635,924,741 7,383,733,622 7,131,542,504 6,879,351,385 6,627,160,266 6,374,969,147 6,122,778,028 5,870,586,910 9,080,263,145 12,289,939,380 15,499,615,615 18,709,291,850 18,709,291,850
Reg No. Exchange rates for DJF (Part II of assignment)  
62 £Sterling $US € Euro ZARand
170 121 160 12.1
Cost break down of “Temporary works and site overheads”:
Skilled Labour DJF 306,000,000 306,000,000 Skilled Labour Unskilled Labour Local Material Plant (USA) Component Equipment
Unskilled Labour DJF 1,989,000,000 1,989,000,000 0 0 0                                             –                              –          855,954,000
Local Material DJF 306,000,000 306,000,000 982,500,000 7,860,000,000 6,877,500,000                      4,232,217,000          567,936,000          479,856,960
Plant (USA) $ 1,815,600                219,687,600 642,600,000 2,754,000,000 3,488,400,000                      1,977,188,400          348,000,000          228,690,000
Component (France)                    2,958,000                473,280,000 150,000,000 1,425,000,000 1,312,500,000                         538,450,000          174,000,000            49,005,000
Subtotal 3,293,967,600 112,500,000 281,250,000 506,250,000                            80,767,500          278,400,000 0
Cost breakdown for supervisory and managerial staff 112,500,000 675,000,000 1,012,500,000                         387,684,000          177,480,000 0
Supervisory  Staff £ 30,600,000            5,202,000,000 114,750,000 1,262,250,000 459,000,000                         494,297,100 0 0
Subtotal            5,202,000,000 2,114,850,000 14,257,500,000 13,656,150,000                      7,710,604,000      1,545,816,000      1,613,505,960
Cost breakdown for Construction of Roads Cost breakdown for Construction of Quay and Jetties
Skilled Labour DJF 150,000,000 150,000,000 Skilled Labour DJF 982,500,000 982,500,000
Unskilled Labour DJF 1,425,000,000 1,425,000,000 Unskilled Labour DJF 7,860,000,000 7,860,000,000
Local Material DJF 1,312,500,000 1,312,500,000 Local Material DJF 6,877,500,000 6,877,500,000
Plant (USA) $ 4,450,000.00                538,450,000 Plant (USA) $ 34,977,000                      4,232,217,000
Component (France)                    2,175,000                348,000,000 Equipment (Sout Africa) R 70,740,000                         855,954,000
Equipment (SA) R 18,900,000                228,690,000 Subtotal 20,808,171,000
Subtotal 4,002,640,000
Cost breakdown for Construction of Rail Links
Cost breakdown for Warehouses Skilled Labour DJF 642,600,000 642,600,000
Skilled Labour DJF 112,500,000 112,500,000 Unskilled Labour DJF 2,754,000,000 2,754,000,000
Unskilled Labour DJF 281,250,000 281,250,000 Local Material DJF 3,488,400,000 3,488,400,000
Local Material DJF 506,250,000 506,250,000 Plant (USA) $ 16,340,400.00                      1,977,188,400
Plant (USA) $ 667,500.00                  80,767,500 Component (France)                3,549,600                         567,936,000
Component (France)                    1,087,500                174,000,000 Equipment (SA) R 39,657,600                         479,856,960
Equipment (SA) R 4,050,000                  49,005,000 Subtotal 9,909,981,360
Subtotal 1,203,772,500
Cost breakdown for Storm Culverts and River Diversions
Skilled Labour DJF 112,500,000 112,500,000 Cost breakdown for Landscaping
Unskilled Labour DJF 675,000,000 675,000,000 Skilled Labour DJF 114,750,000 114,750,000
Local Material DJF 1,012,500,000 1,012,500,000 Unskilled Labour DJF 1,262,250,000 1,262,250,000
Plant (USA) $ 3,204,000.00                387,684,000 Local Material DJF 459,000,000 459,000,000
Component (France)                    1,740,000                278,400,000 Plant (USA) $ 4,085,100.00                         494,297,100
Subtotal 2,466,084,000 Component (France)                1,109,250                         177,480,000
Subtotal 2,507,777,100
A summary of the project tender sum
Temporary works and site overheads 3,293,967,600
Costs of supervisory and managerial staff        5,202,000,000
Costs of skilled labour 2,114,850,000
Costs of unskilled labour 14,257,500,000
Costs of construction plant        7,710,604,000
Costs of local material 13,656,150,000
Costs of imported component        1,545,816,000
Costs of imported equipment        1,613,505,960
Subtotal of Tender Sum     49,394,393,560
Cost escalation (4.5%)        2,222,747,710
Subtotal costs after inflation (from revised cash flow)      59,706,245,601
Head office overheads (5%)        2,985,312,280
Total Tender Sum      62,691,557,881
Revision of Cash Flow Schedule
List of Hypothesis Uncertainties
Inflation per annum Interest Rates Cost escalation (contract sum) Time overrun
% % % Weeks
10.7 5.5 6.8 -5
Payment Stage(inclusive interest rate)
Stage Item % Contract Amount (DJF) FOR FEBRUARY 2018, THE COST IS FOR ONE WEEK
Stage1  (01/01/2014) Mobilization 20%                13,847,469,416
Stage2 (31/01/2014 – 31/09/2015) Interim Payment 50%                34,618,673,539
Stage3 (31/10/2015 – 31/01/2016) Final Payment 30%                20,771,204,123
Total Payment 100%                69,237,347,078
Project Cash Flow:
Year 2016  Mobilization Activities -Stage 1
Month Jan-16
Payment       13,847,469,416
Year 2016 Interim Payment – Stage 2
Month Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16
Payment         1,730,933,677                 1,730,933,677           1,730,933,677       1,730,933,677      1,730,933,677        1,730,933,677
Month Aug-16 Sep-16 Oct-16 Nov-16 Dec-16
Payment         1,730,933,677                 1,730,933,677           1,730,933,677       1,730,933,677      1,730,933,677
Year 2017  Interim Payment + Final Payment – Stage 2 + Stage 3
Month Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17
Payment         1,730,933,677                 1,730,933,677           1,730,933,677       1,730,933,677      1,730,933,677        1,730,933,677
Month Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17
Payment         1,730,933,677                 1,730,933,677           1,730,933,677       5,192,801,031      5,192,801,031        5,192,801,031
Year 2018  Final Payment – Stage 3
Month Jan-18 Feb-18 FOR FEBRUARY 2018, THE COST IS FOR ONE WEEK
Payment         5,192,801,031           1,298,200,257.71
Expenditure on prepartion stage Cash Flow
Item Advanced Payment% Amount (DJF)
Temporary works and site overheads 50%           1,646,983,800
Costs of supervisory and managerial staff 20%           1,040,400,000
Costs of skilled labour 10%               211,485,000
Subtotal           2,898,868,800
Project cash flow – Expenditure over Construction stage
Cash flow – 2016
Item 1-Jan 1-Feb 1-Mar 1-Apr 1-May 1-Jun
Temporary works and site overheads                 1,646,983,800                 68,624,325             68,624,325            68,624,325              68,624,325              68,624,325
Costs of supervisory and managerial staff                 1,040,400,000               173,400,000           173,400,000          173,400,000            173,400,000           173,400,000
Costs of skilled labour                     211,485,000                 79,306,875             79,306,875            79,306,875              79,306,875              79,306,875
Costs of unskilled labour               594,062,500           594,062,500          594,062,500            594,062,500           594,062,500
Costs of construction plant               321,275,167           321,275,167          321,275,167            321,275,167           321,275,167
Costs of local material               569,006,250           569,006,250          569,006,250            569,006,250           569,006,250
Costs of imported component                 64,409,000             64,409,000            64,409,000              64,409,000              64,409,000
Costs of imported equipment                 67,229,415             67,229,415            67,229,415              67,229,415              67,229,415
Subtotal                 2,898,868,800           1,937,313,532       1,937,313,532      1,937,313,532        1,937,313,532        1,937,313,532
Item 1-Jul 1-Aug 1-Sep 1-Oct 1-Nov 1-Dec
Temporary works and site overheads                       68,624,325                 68,624,325             68,624,325            68,624,325              68,624,325              68,624,325
Costs of supervisory and managerial staff                     173,400,000               173,400,000           173,400,000          173,400,000            173,400,000           173,400,000
Costs of skilled labour                       79,306,875                 79,306,875             79,306,875            79,306,875              79,306,875              79,306,875
Costs of unskilled labour                     594,062,500               594,062,500           594,062,500          594,062,500            594,062,500           594,062,500
Costs of construction plant                     321,275,167               321,275,167           321,275,167          321,275,167            321,275,167           321,275,167
Costs of local material                     569,006,250               569,006,250           569,006,250          569,006,250            569,006,250           569,006,250
Costs of imported component                       64,409,000                 64,409,000             64,409,000            64,409,000              64,409,000              64,409,000
Costs of imported equipment                       67,229,415                 67,229,415             67,229,415            67,229,415              67,229,415              67,229,415
Subtotal                 1,937,313,532           1,937,313,532       1,937,313,532      1,937,313,532        1,937,313,532        1,937,313,532
Cash flow – 2017
Item 1-Jan 1-Feb 1-Mar 1-Apr 1-May 1-Jun
Temporary works and site overheads                       68,624,325                 68,624,325             68,624,325            68,624,325              68,624,325              68,624,325
Costs of supervisory and managerial staff                     173,400,000               173,400,000           173,400,000          173,400,000            173,400,000           173,400,000
Costs of skilled labour                       79,306,875                 79,306,875             79,306,875            79,306,875              79,306,875              79,306,875
Costs of unskilled labour                     594,062,500               594,062,500           594,062,500          594,062,500            594,062,500           594,062,500
Costs of construction plant                     321,275,167               321,275,167           321,275,167          321,275,167            321,275,167           321,275,167
Costs of local material                     569,006,250               569,006,250           569,006,250          569,006,250            569,006,250           569,006,250
Costs of imported component                       64,409,000                 64,409,000             64,409,000            64,409,000              64,409,000              64,409,000
Costs of imported equipment                       67,229,415                 67,229,415             67,229,415            67,229,415              67,229,415              67,229,415
Subtotal                 1,937,313,532           1,937,313,532       1,937,313,532      1,937,313,532        1,937,313,532        1,937,313,532
Item 1-Jul 1-Aug 1-Sep 1-Oct 1-Nov 1-Dec
Temporary works and site overheads                       68,624,325                 68,624,325             68,624,325            68,624,325              68,624,325              68,624,325
Costs of supervisory and managerial staff                     173,400,000               173,400,000           173,400,000          173,400,000            173,400,000           173,400,000
Costs of skilled labour                       79,306,875                 79,306,875             79,306,875            79,306,875              79,306,875              79,306,875
Costs of unskilled labour                     594,062,500               594,062,500           594,062,500          594,062,500            594,062,500           594,062,500
Costs of construction plant                     321,275,167               321,275,167           321,275,167          321,275,167            321,275,167           321,275,167
Costs of local material                     569,006,250               569,006,250           569,006,250          569,006,250            569,006,250           569,006,250
Costs of imported component                       64,409,000                 64,409,000             64,409,000            64,409,000              64,409,000              64,409,000
Costs of imported equipment                       67,229,415                 67,229,415             67,229,415            67,229,415              67,229,415              67,229,415
Subtotal                 1,937,313,532           1,937,313,532       1,937,313,532      1,937,313,532        1,937,313,532        1,937,313,532
Cash flow – 2018
Item 1-Jan 1-Feb Total
Temporary works and site overheads                       68,624,325                 17,156,081       3,242,499,356
Costs of supervisory and managerial staff                     173,400,000                 43,350,000       5,071,950,000
Costs of skilled labour                       79,306,875                 19,826,719       2,055,369,844
Costs of unskilled labour                     594,062,500               118,319,075     13,781,756,575
Costs of construction plant                     321,275,167                 80,318,792       7,469,647,625
Costs of local material                     569,006,250               142,251,563     13,229,395,313
Costs of imported component                       64,409,000                 16,102,250       1,497,509,250
Costs of imported equipment                       67,229,415                 16,807,354       1,563,083,899
Subtotal                 1,937,313,532               454,131,833     47,911,211,861
Cash flow schedule:
Cash Flow Year-2016
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash in hand                            8,363,848,601                       6,430,079,409         4,496,310,217               2,562,541,025                         628,771,833 –                1,304,997,358 –        3,238,766,550 –      5,172,535,742 –                 7,106,304,934 –       9,040,074,126 –     10,973,843,317
Income
Mobilization                        13,847,469,416
Interim Payment                            1,730,933,677                       1,730,933,677         1,730,933,677               1,730,933,677                     1,730,933,677                  1,730,933,677          1,730,933,677         1,730,933,677                    1,730,933,677         1,730,933,677          1,730,933,677
Final Payment
Total income                        13,847,469,416                          10,094,782,278                       8,161,013,086         6,227,243,894               4,293,474,702                     2,359,705,510                      425,936,319 –        1,507,832,873 –      3,441,602,065 –                 5,375,371,257 –       7,309,140,449 –       9,242,909,640
Expenditure  
Temporary works and site overheads                           1,646,983,800                                  68,624,325                             68,624,325               68,624,325                    68,624,325                           68,624,325                        68,624,325                68,624,325              68,624,325                         68,624,325               68,624,325               68,624,325
Costs of supervisory and managerial staff                           1,040,400,000                                173,400,000                          173,400,000             173,400,000                  173,400,000                         173,400,000                      173,400,000             173,400,000            173,400,000                       173,400,000             173,400,000             173,400,000
Costs of skilled labour                              211,485,000                                  79,306,875                             79,306,875               79,306,875                    79,306,875                           79,306,875                        79,306,875                79,306,875              79,306,875                         79,306,875               79,306,875               79,306,875
Costs of unskilled labour                                594,062,500                          594,062,500             594,062,500                  594,062,500                         594,062,500                      594,062,500             594,062,500            594,062,500                       594,062,500             594,062,500             594,062,500
Costs of construction plant                                321,275,167                          321,275,167             321,275,167                  321,275,167                         321,275,167                      321,275,167             321,275,167            321,275,167                       321,275,167             321,275,167             321,275,167
Costs of local material                                569,006,250                          569,006,250             569,006,250                  569,006,250                         569,006,250                      569,006,250             569,006,250            569,006,250                       569,006,250             569,006,250             569,006,250
Costs of imported component                                  64,409,000                             64,409,000               64,409,000                    64,409,000                           64,409,000                        64,409,000                64,409,000              64,409,000                         64,409,000               64,409,000               64,409,000
Costs of imported equipment                                  67,229,415                             67,229,415               67,229,415                    67,229,415                           67,229,415                        67,229,415                67,229,415              67,229,415                         67,229,415               67,229,415               67,229,415
Subtotal                           2,898,868,800                            1,937,313,532                       1,937,313,532         1,937,313,532               1,937,313,532                     1,937,313,532                  1,937,313,532          1,937,313,532         1,937,313,532                    1,937,313,532         1,937,313,532          1,937,313,532
Cost escalation (6.8%)                              197,123,078                                131,737,320                          131,737,320             131,737,320                  131,737,320                         131,737,320                      131,737,320             131,737,320            131,737,320                       131,737,320             131,737,320             131,737,320
Subtotal                           3,095,991,878                            2,069,050,852                       2,069,050,852         2,069,050,852               2,069,050,852                     2,069,050,852                  2,069,050,852          2,069,050,852         2,069,050,852                    2,069,050,852         2,069,050,852          2,069,050,852
Subtotal cost after inflation(10.7%)                           3,427,263,009                            2,290,439,293                       2,290,439,293         2,290,439,293               2,290,439,293                     2,290,439,293                  2,290,439,293          2,290,439,293         2,290,439,293                    2,290,439,293         2,290,439,293          2,290,439,293
Head office overheads (5%)                              171,363,150                                114,521,965                          114,521,965             114,521,965                  114,521,965                         114,521,965                      114,521,965             114,521,965            114,521,965                       114,521,965             114,521,965             114,521,965
Interest rates(5.5%)                           1,884,994,655                            1,259,741,611                       1,259,741,611         1,259,741,611               1,259,741,611                     1,259,741,611                  1,259,741,611          1,259,741,611         1,259,741,611                    1,259,741,611         1,259,741,611          1,259,741,611
Total Expenditure                           5,483,620,815                            3,664,702,869                       3,664,702,869         3,664,702,869               3,664,702,869                     3,664,702,869                  3,664,702,869          3,664,702,869         3,664,702,869                    3,664,702,869         3,664,702,869          3,664,702,869
Cumulative Cash Flow                           8,363,848,601                            6,430,079,409                       4,496,310,217         2,562,541,025                  628,771,833 –                   1,304,997,358 –                3,238,766,550 –        5,172,535,742 –      7,106,304,934 –                 9,040,074,126 –     10,973,843,317 –     12,907,612,509
Cash flow schedule:
Cash Flow Year-2017
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash in hand –                      12,907,612,509 –                        15,233,504,908 –                  17,559,397,307 –     19,885,289,705 –          22,211,182,104 –                 24,537,074,503 –              26,862,966,902 –     29,188,859,300 –    31,514,751,699 –               33,840,644,098 –     32,704,669,143 –     31,568,694,188
Income
Mobilization
Interim Payment                           1,730,933,677                            1,730,933,677                       1,730,933,677         1,730,933,677               1,730,933,677                     1,730,933,677                  1,730,933,677          1,730,933,677         1,730,933,677
Final Payment                    5,192,801,031         5,192,801,031          5,192,801,031
Total income –                      11,176,678,832 –                        13,502,571,231 –                  15,828,463,630 –     18,154,356,028 –          20,480,248,427 –                 22,806,140,826 –              25,132,033,225 –     27,457,925,623 –    29,783,818,022 –               28,647,843,067 –     27,511,868,112 –     26,375,893,157
Expenditure
Temporary works and site overheads                                68,624,325                                  68,624,325                             68,624,325               68,624,325                    68,624,325                           68,624,325                        68,624,325                68,624,325              68,624,325                         68,624,325               68,624,325               68,624,325
Costs of supervisory and managerial staff                              173,400,000                                173,400,000                          173,400,000             173,400,000                  173,400,000                         173,400,000                      173,400,000             173,400,000            173,400,000                       173,400,000             173,400,000             173,400,000
Costs of skilled labour                                79,306,875                                  79,306,875                             79,306,875               79,306,875                    79,306,875                           79,306,875                        79,306,875                79,306,875              79,306,875                         79,306,875               79,306,875               79,306,875
Costs of unskilled labour                              594,062,500                                594,062,500                          594,062,500             594,062,500                  594,062,500                         594,062,500                      594,062,500             594,062,500            594,062,500                       594,062,500             594,062,500             594,062,500
Costs of construction plant                              321,275,167                                321,275,167                          321,275,167             321,275,167                  321,275,167                         321,275,167                      321,275,167             321,275,167            321,275,167                       321,275,167             321,275,167             321,275,167
Costs of local material                              569,006,250                                569,006,250                          569,006,250             569,006,250                  569,006,250                         569,006,250                      569,006,250             569,006,250            569,006,250                       569,006,250             569,006,250             569,006,250
Costs of imported component                                64,409,000                                  64,409,000                             64,409,000               64,409,000                    64,409,000                           64,409,000                        64,409,000                64,409,000              64,409,000                         64,409,000               64,409,000               64,409,000
Costs of imported equipment                                67,229,415                                  67,229,415                             67,229,415               67,229,415                    67,229,415                           67,229,415                        67,229,415                67,229,415              67,229,415                         67,229,415               67,229,415               67,229,415
Subtotal                           1,937,313,532                            1,937,313,532                       1,937,313,532         1,937,313,532               1,937,313,532                     1,937,313,532                  1,937,313,532          1,937,313,532         1,937,313,532                    1,937,313,532         1,937,313,532          1,937,313,532
Cost escalation (6.8%)                              131,737,320                                131,737,320                          131,737,320             131,737,320                  131,737,320                         131,737,320                      131,737,320             131,737,320            131,737,320                       131,737,320             131,737,320             131,737,320
Subtotal                           2,069,050,852                            2,069,050,852                       2,069,050,852         2,069,050,852               2,069,050,852                     2,069,050,852                  2,069,050,852          2,069,050,852         2,069,050,852                    2,069,050,852         2,069,050,852          2,069,050,852
Subtotal cost after inflation(10.7%)                           2,535,516,297                            2,535,516,297                       2,535,516,297         2,535,516,297               2,535,516,297                     2,535,516,297                  2,535,516,297          2,535,516,297         2,535,516,297                    2,535,516,297         2,535,516,297          2,535,516,297
Head office overheads (5%)                              126,775,815                                126,775,815                          126,775,815             126,775,815                  126,775,815                         126,775,815                      126,775,815             126,775,815            126,775,815                       126,775,815             126,775,815             126,775,815
Interest rates(5.5%)                           1,394,533,964                            1,394,533,964                       1,394,533,964         1,394,533,964               1,394,533,964                     1,394,533,964                  1,394,533,964          1,394,533,964         1,394,533,964                    1,394,533,964         1,394,533,964          1,394,533,964
Total Expenditure                           4,056,826,076                            4,056,826,076                       4,056,826,076         4,056,826,076               4,056,826,076                     4,056,826,076                  4,056,826,076          4,056,826,076         4,056,826,076                    4,056,826,076         4,056,826,076          4,056,826,076
Cumulative Cash Flow –                      15,233,504,908 –                        17,559,397,307 –                  19,885,289,705 –     22,211,182,104 –          24,537,074,503 –                 26,862,966,902 –              29,188,859,300 –     31,514,751,699 –    33,840,644,098 –               32,704,669,143 –     31,568,694,188 –     30,432,719,232
Cash flow schedule:
Cash Flow Year-2018 Year-2018 Total
Jan Feb
Cash in hand –                      30,432,719,232                     (7,608,179,808.11)
Income
Mobilization                     13,847,469,416
Interim Payment                     34,618,673,539
Final Payment 5192801031                            1,298,200,258                     16,876,603,350
Total income –                        6,309,979,550 –                          6,309,979,550                     65,342,746,305
Expenditure
Temporary works and site overheads 68624325                                  17,156,081                       3,242,499,356
Costs of supervisory and managerial staff 173400000                                  43,350,000                       5,071,950,000
Costs of skilled labour 79306875                                  19,826,719                       2,055,369,844
Costs of unskilled labour 594062500                                118,319,075                     13,781,756,575
Costs of construction plant 321275166.7                                  80,318,792                       7,469,647,625
Costs of local material 569006250                                142,251,563                     13,229,395,313
Costs of imported component 64409000                                  16,102,250                       1,497,509,250
Costs of imported equipment 67229415                                  16,807,354                       1,563,083,899
Subtotal                          1,937,313,532                               454,131,833                    47,911,211,861
Cost escalation (6.8%)                              131,737,320                                  30,880,965                       3,257,962,407
Subtotal                           2,069,050,852                                485,012,798                     50,684,161,470
Subtotal cost after inflation(10.7%)                           2,806,816,541                                657,954,802                     59,706,245,601
Interest rates(5.5%)                           1,137,977,969                                266,757,039                       2,985,312,280
Head office overheads (5%)                              140,340,827                                  32,897,740                     95,434,874,860
Total Expenditure                           4,085,135,337                                957,609,580 –                  30,092,128,555
Cumulative Cash Flow –                      10,395,114,887 –                          7,267,589,131
Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18
2014-2015-2016 8,363,848,601 6,430,079,409 4,496,310,217 2,562,541,025 628,771,833 -1,304,997,358 -3,238,766,550 -5,172,535,742 -7,106,304,934 -9,040,074,126 -10,973,843,317 -12,907,612,509 -15,233,504,908 -17,559,397,307 -19,885,289,705 -22,211,182,104 -24,537,074,503 -26,862,966,902 -29,188,859,300 -31,514,751,699 -33,840,644,098 -32,704,669,143 -31,568,694,188 -30,432,719,232 -7267589131 -10395114887

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: