![Financial Calculations-Reefer Facility [PDF]](https://pdfs.asia/img/200x200/financial-calculations-reefer-facility.jpg)
28 0 266 KB
NET PRESENT VALUE Investment Cost Working Capital (three months) Total Investment
40,250,000.00 2,846,299.00 43,096,299.00 Year 0 (43,096,299.00)
Year 01 8,009,203.08
Year 02 7,934,616.08
Year 03 7,849,479.79
Year 04 7,753,164.53
Year 05 7,645,693.05
Year 06 8,464,296.16
Year 07 8,343,904.21
Year 08 8,209,616.68
(43,096,299.00)
39,192,156.53 42,668,411.02 7,281,093.71
3,904,142.47 427,887.98 6,557,533.95
0.46 0.13 5,897,430.34
6.00 months 2.00 months 5,295,515.69 4,747,373.85
4,777,874.52
4,281,742.19
3,829,846.77
Year 01 19,556 17,600,400
Year 02 19,810 17,829,000
Year 03 20,067 18,060,300
Year 04 20,327 18,294,300
Year 05 20,591 18,531,900
Year 06 20,858.00 19,710,810
Year 07 21,129.00 19,966,905
Year 08 21,403.00 20,225,835
Year 09 21,681.00 20,488,545
Year 10 21,962.00 20,754,090
4,846,153 248
4,932,370 249
5,020,803 250
5,111,530 251
5,204,849 253
5,300,631.00 254.13
5,399,182.00 255.53
5,500,382.00 256.99
5,604,547.00 258.50
5,711,566.00 260.07
12,754,247 652 72.47%
12,896,630 651 72.34%
13,039,497 650 72.20%
13,182,770 649 72.06%
13,327,051 647 71.91%
14,410,179.00 690.87 73.11%
14,567,723.00 689.47 72.96%
14,725,453.00 688.01 72.81%
14,883,998.00 686.50 72.65%
15,042,524.00 684.93 72.48%
Fixed Costs Fixed Costs per Unit
6,539,044 334
6,756,014 341
6,984,017 348
7,223,605 355
7,475,358 363
7,739,882.84 371.08
8,017,818.79 379.47
8,309,836.32 388.26
8,616,639.54 397.43
8,938,967.72 407.02
BEVunits BEVpesos
10,027 9,023,644
10,378 9,339,880
10,748 9,673,183
11,139 10,024,510
11,550 10,394,842
11,204.00 10,586,916.38
11,630.00 10,989,433.70
12,079.00 11,413,800.20
12,552.00 11,861,222.17
13,051.00 12,333,046.01
51.27%
52.39%
53.56%
54.80%
56.09%
53.72%
55.04%
56.44%
57.89%
59.43%
Cash Flows Net Present Value IRR Payback Period Discounted Payback Period PVs
Year 09 8,061,358.46
Year 10 7,897,556.28 6,035,764.77 13.15% 5 years 6 months 8 years 2 months 3,418,802.92 3,044,849.83
BREAK-EVEN POINTS No. of Units Revenues Variable Cost Variable Cost per Unit Contribution Margin Contribution Margin per Unit Contribution Margin Ratio
Target Market Ratio
REEFER FACILITY PROJECT PROJECTED INCOME STATEMENT
REVENUE OPERATING COSTS VARIABLE COSTS Cash Equipment Running Costs Power/ Electricity Non-Cash None TOTAL VARIABLE COSTS FIXED COSTS Cash Direct Labor Overhead Expenses (MSD) Power/ Electricity Security Services Real Property Tax-Land Real Property Tax-Equipment Miscellaneous
Year 01
Year 02
Year 03
Year 04
Year 05
Year 06
Year 07
Year 08
Year 09
Year 10
17,600,400
17,829,000
18,060,300
18,294,300
18,531,900
19,710,810
19,966,905
20,225,835
20,488,545
20,754,090
627,057 4,219,096 4,846,153
658,410 4,273,960 4,932,370
691,331 4,329,472 5,020,803
725,898 4,385,632 5,111,530
762,193 4,442,656 5,204,849
800,303 4,500,328 5,300,631
840,318 4,558,864 5,399,182
882,334 4,618,048 5,500,382
926,451 4,678,096 5,604,547
972,774 4,738,792 5,711,566
-
-
-
-
-
-
-
-
-
-
4,846,153
4,932,370
5,020,803
5,111,530
5,204,849
5,300,631
5,399,182
5,500,382
5,604,547
5,711,566
3,765,338 571,950 5,000 76,032 188,020 88,704 50,000 4,745,044
3,953,605 600,548 5,000 79,834 188,020 85,008 50,000 4,962,014
4,151,285 630,575 5,000 83,825 188,020 81,312 50,000 5,190,017
4,358,849 662,104 5,000 88,017 188,020 77,616 50,000 5,429,605
4,576,792 695,209 5,000 92,417 188,020 73,920 50,000 5,681,358
4,805,631 729,969 5,000 97,038 188,020 70,224 50,000 5,945,883
5,045,913 766,468 5,000 101,890 188,020 66,528 50,000 6,223,819
5,298,209 804,791 5,000 106,985 188,020 62,832 50,000 6,515,836
5,563,119 845,031 5,000 112,334 188,020 59,136 50,000 6,822,640
5,841,275 887,282 5,000 117,951 188,020 55,440 50,000 7,144,968
1,794,000 1,794,000 6,539,044
1,794,000 1,794,000 6,756,014
1,794,000 1,794,000 6,984,017
1,794,000 1,794,000 7,223,605
1,794,000 1,794,000 7,475,358
1,794,000 1,794,000 7,739,883
1,794,000 1,794,000 8,017,819
1,794,000 1,794,000 8,309,836
1,794,000 1,794,000 8,616,640
1,794,000 1,794,000 8,938,968
11,385,197
11,688,384
12,004,820
12,335,135
12,680,207
13,040,514
13,417,001
13,810,218
14,221,187
14,650,534
NET INCOME
6,215,203
6,140,616
6,055,480
5,959,165
5,851,693
6,670,296
6,549,904
6,415,617
6,267,358
6,103,556
ADD BACK: NON-CASH EXPENSES
1,794,000
1,794,000
1,794,000
1,794,000
1,794,000
1,794,000
1,794,000
1,794,000
1,794,000
1,794,000
NET CASH INCOME
8,009,203
7,934,616
7,849,480
7,753,165
7,645,693
8,464,296
8,343,904
8,209,617
8,061,358
7,897,556
Non-Cash Depreciation Expenses TOTAL FIXED COSTS TOTAL OPERATING COST
MARKET Year 2012 2013 2014 2015 2016 Average Market Share % Annual Growth Rate Year Annual Unit Projection REEFER RACK SYSTEM CAPACITY Daily Capacity Annual Capacity (Units) Annual Capacity (Hours)
Outgoing 1,757.00 1,548.00 1,435.00 1,707.00 2,403.00 1,770.00
BREAKBULK Total 8,963.00 8,027.00 10,861.00 14,115.00 16,112.00 11,615.60
Incoming 352.00 236.00 518.00 974.00 1,863.00 788.60
CONTAINERIZED Outgoing 64.00 40.00 117.00 281.00 1,331.00 366.60
Total 416.00 276.00 635.00 1,255.00 3,194.00 1,155.20
Incoming 7,558.00 6,715.00 9,944.00 13,382.00 15,572.00 10,634.20
Outgoing 1,821.00 1,588.00 1,552.00 1,988.00 3,734.00 2,136.60
TOTAL Total 9,379.00 8,303.00 11,496.00 15,370.00 19,306.00 12,770.80
Year 02 19,810
Year 03 20,067
Year 04 20,327
Year 05 20,591
Year 06 20,858
Year 07 21,129
Year 08 21,403
Year 09 21,681
Year 10 21,962
(24 outlets; 6 hours charging; 24 hours operation) Year 01 Year 02 Year 03 96 96 96 35,040 35,040 35,040 210,240 210,240 210,240
Year 04 96 35,040 210,240
Year 05 96 35,040 210,240
Year 06 96 35,040 210,240
Year 07 96 35,040 210,240
Year 08 96 35,040 210,240
Year 09 96 35,040 210,240
Year 10 96 35,040 210,240
Incoming 7,206.00 6,479.00 9,426.00 12,408.00 13,709.00 9,845.60
Unit Increase Base Year (1,076.00) -11.5% 3,193.00 38.5% 3,874.00 33.7% 3,936.00 25.6% 2,481.75 21.6%
100% 1.30% Year 01 19,556
PROJECTED USAGE Daily Usage (Units) Annual Usage (Units) Annual Usage (Hours)
54 19,556 117,336
55 19,810 118,860
55 20,067 120,402
56 20,327 121,962
57 20,591 123,546
58 20,858 125,148
58 21,129 126,774
59 21,403 128,418
60 21,681 130,086
61 21,962 131,772
ELECTRICITY USAGE COST Maintenance (3kwH/ hour)-95% Pull-Down (15kwH/ hour)-5%
111,469 5,867
112,917 5,943
114,382 6,020
115,864 6,098
117,369 6,177
118,891 6,257
120,435 6,339
121,997 6,421
123,582 6,504
125,183 6,589
334,408 88,002 422,410
338,751 89,145 427,896
343,146 90,302 433,447
347,592 91,472 439,063
352,106 92,660 444,766
356,672 93,861 450,533
361,306 95,081 456,386
365,991 96,314 462,305
370,745 97,565 468,310
375,550 98,829 474,379
10
10
10
10
10
10
10
10
10
10
4,224,096
4,278,960
4,334,472
4,390,632
4,447,656
4,505,328
4,563,864
4,623,048
4,683,096
4,743,792
Cost Per Unit 3,850,000.00 30,000,000.00 3,100,000.00 2,800,000.00 500,000.00 -
Count
Total Cost 3,850,000.00 30,000,000.00 3,100,000.00 2,800,000.00 500,000.00 -
Economic Life 25 30 10 10 10 1
Maintenance Consumption (kwH) Pull-Down Consumption (kwH) Total Electricity Consumption Rate per kwH Annual Electricity Cost INVESTMENT COST
Rubber Tired Gantry (RTG) Crane Reefer Rack System Tractor Head Chassis Transformers (NGCP/ Noreco 2) Land TOTAL
1 1 1 1 1 1
40,250,000.00
Annual Depreciation 154,000.00 1,000,000.00 310,000.00 280,000.00 50,000.00 1,794,000.00
DEPRECIATION COST Begginning Balance Less: Depreciation Net Book Value (NBV)
Year 01 40,250,000 1,794,000 38,456,000
Year 02 38,456,000 1,794,000 36,662,000
Year 03 36,662,000 1,794,000 34,868,000
Year 04 34,868,000 1,794,000 33,074,000
Year 05 33,074,000 1,794,000 31,280,000
Year 06 31,280,000 1,794,000 29,486,000
Year 07 29,486,000 1,794,000 27,692,000
Year 08 27,692,000 1,794,000 25,898,000
Year 09 25,898,000 1,794,000 24,104,000
Year 10 24,104,000 1,794,000 22,310,000
3,850,000 154,000 3,696,000
3,696,000 154,000 3,542,000
3,542,000 154,000 3,388,000
3,388,000 154,000 3,234,000
3,234,000 154,000 3,080,000
3,080,000 154,000 2,926,000
2,926,000 154,000 2,772,000
2,772,000 154,000 2,618,000
2,618,000 154,000 2,464,000
2,464,000 154,000 2,310,000
88,704
85,008
81,312
77,616
73,920
70,224
66,528
62,832
59,136
55,440
REAL PROPERTY TAX- RTG EQUIPMENT (2.4% of NBV) Begginning Balance Less: Depreciation Net Book Value (NBV) Real Property Tax
.
OPERATING COSTS VARIABLE Cash Equipment Running Costs Power/ Electricity Non-Cash None TOTAL VARIABLE COSTS FIXED Cash Direct Labor Overhead Expenses (MSD) Power/ Electricity Security Services Real Property Tax-Land Real Property Tax-Equipment Miscellaneous
Year 01
Year 02
Year 03
Year 04
Year 05
Year 06
Year 07
Year 08
Year 09
Year 10
627,057 4,219,096 4,846,153
658,410 4,273,960 4,932,370
691,331 4,329,472 5,020,803
725,898 4,385,632 5,111,530
762,193 4,442,656 5,204,849
800,303 4,500,328 5,300,631
840,318 4,558,864 5,399,182
882,334 4,618,048 5,500,382
926,451 4,678,096 5,604,547
972,774 4,738,792 5,711,566
-
-
-
-
-
-
-
-
-
-
4,846,153
4,932,370
5,020,803
5,111,530
5,204,849
5,300,631
5,399,182
5,500,382
5,604,547
5,711,566
3,765,338 571,950 5,000 76,032 188,020 88,704 50,000 4,745,044
3,953,605 600,548 5,000 79,834 188,020 85,008 50,000 4,962,014
4,151,285 630,575 5,000 83,825 188,020 81,312 50,000 5,190,017
4,358,849 662,104 5,000 88,017 188,020 77,616 50,000 5,429,605
4,576,792 695,209 5,000 92,417 188,020 73,920 50,000 5,681,358
4,805,631 729,969 5,000 97,038 188,020 70,224 50,000 5,945,883
5,045,913 766,468 5,000 101,890 188,020 66,528 50,000 6,223,819
5,298,209 804,791 5,000 106,985 188,020 62,832 50,000 6,515,836
5,563,119 845,031 5,000 112,334 188,020 59,136 50,000 6,822,640
5,841,275 887,282 5,000 117,951 188,020 55,440 50,000 7,144,968
1,794,000 1,794,000 6,539,044
1,794,000 1,794,000 6,756,014
1,794,000 1,794,000 6,984,017
1,794,000 1,794,000 7,223,605
1,794,000 1,794,000 7,475,358
1,794,000 1,794,000 7,739,883
1,794,000 1,794,000 8,017,819
1,794,000 1,794,000 8,309,836
1,794,000 1,794,000 8,616,640
1,794,000 1,794,000 8,938,968
11,385,197
11,688,384
12,004,820
12,335,135
12,680,207
13,040,514
13,417,001
13,810,218
14,221,187
14,650,534
Cost per Unit Cost per Hour
582 97
590 98
598 100
607 101
616 103
625 104
635 106
645 108
656 109
667 111
10-Year Average/ Unit 10-Year Average/ Hour
622 104
Mark-Up 40% (Per 6-hour charging) Mark-Up 40% (Per hour charging)
871 145
Rounded Tariff (5% increase in 5 years) Rounded Tariff (5% increase in 5 years)
900 150
900 150
900 150
900 150
900 150
945 158
945 158
945 158
945 158
945 158
Non-Cash Depreciation Expenses TOTAL FIXED COSTS TOTAL OPERATING COST
six hours charging 1 hour charging
MANPOWER/ PERSONNEL COSTS Position
Annual Cost Head Count
Operator Reefer Technician RTG Operator
857,925.12 1,715,850.24 1,191,562.56 3,765,337.92
MSD Security Guard
2 4 2
Basic Pay 18,000.00 18,000.00 25,000.00
Overtime Pay 10,546.88 10,546.88 14,648.44
571,950.00
2
12,000.00
7,031.25
76,032.00
2
3,168.00
-
Benefits 6,300.00 6,300.00 8,750.00
Night-Shift Pay 900.00 900.00 1,250.00
Monthly Total 35,746.88 35,746.88 49,648.44 121,142.20
4,200.00
600.00
23,831.25
-
-
3,168.00
Year
BREAKBULK Incoming
Outgoing
CONTAINERIZED Total
Incoming
TOTAL
Outgoing
Total
Incoming
Outgoing
Total
2012
7,206.00
1,757.00
8,963.00
352.00
64.00
416.00
7,558.00
1,821.00
9,379.00
2013
6,479.00
1,548.00
8,027.00
236.00
40.00
276.00
6,715.00
1,588.00
8,303.00
2014
9,426.00
1,435.00
10,861.00
518.00
117.00
635.00
9,944.00
1,552.00
11,496.00
2015
12,408.00
1,707.00
14,115.00
974.00
281.00
1,255.00
13,382.00
1,988.00
15,370.00
2016
13,709.00
2,403.00
16,112.00
1,863.00
1,331.00
3,194.00
15,572.00
3,734.00
19,306.00
Year 2012 2013 2014 2015 2016
Quantity 9,379.00 8,303.00 11,496.00 15,370.00 19,306.00
Year 2012 2013 2014 2015 2016
% Growth 0.000% -11.500% 38.456% 33.699% 25.608%
Perishable Goods (in Metric Tons) 25,000.00
1
20,000.00 15,370.00
15,000.00 10,000.00
11,496.00 9,379.00
8,303.00
5,000.00 -
Quantity 2012
2013
2014
2015
2016
Unit
%
Increase
Growth
Base
Year
(1,076.00)
-11.5%
3,193.00
38.5%
3,874.00
33.7%
3,936.00
25.6%
Goods Tons)
Perishable Goods (% of Growth) 50.000% 19,306.00
15,370.00
38.456%
40.000%
33.699% 25.608%
30.000% 20.000%
496.00
10.000% 0.000%
% Growth
-10.000%
uantity 2015
-11.500%
-20.000% 2016
2012
2013
2014
2015
2016
.608%
TEU PPA RTG ITV
Twenty-foot Equivalent Units Philippine Ports Authority Rubber Tired Gantry Cranes Intra Terminal Vehicle
