ocean carriers excel
DESCRIPTION
Ocean carriersTRANSCRIPT
SCENARIO: 25 YEARS USE WITH TAX
Purchase Price 39000000Exptected Rate of Inflation 3.00%Tax Rate 35.00%Discount Rate 9.00%Rate of Increase of Operating Costs 4.00%
2001 2002 2003 2004Average Daily Hire Rate 20000 20200No. of days in year 365 366Maintenance days 8 8Days on which revenue is earned 357 358Annual Revenue 7140000 7231600
Operating Costs per day 4000 4160Annual Operating Costs 1460000 1522560
Survey Capital ExpenditureDepreciation on Survey Capital Expenditure
Purchase Cost -3900000 -3900000 -31200000Depreciation on Purchase Cost 1560000 1560000
Operating Profit 4120000 4149040Tax @ 35% 1442000 1452164PAT 2678000 2696876PAT (No Tax) 4120000 4149040
Change in Net Working Capital 500000 15000 15450
Cash flow -3900000 -4400000 -26977000 4241426NPV Rs. -4,566,937.03
SCENARIO: 25 YEARS WITHOUT TAX
2001 2002 2003 2004Average Daily Hire Rate 20000 20200No. of days in year 365 366Maintenance days 8 8Days on which revenue is earned 357 358Annual Revenue 7140000 7231600
Operating Costs per day 4000 4160Annual Operating Costs 1460000 1522560
Survey Capital ExpenditureDepreciation on Survey Capital Expenditure
Purchase Cost -3900000 -3900000 -31200000Depreciation on Purchase Cost 1560000 1560000
Operating Profit 4120000 4149040PAT (No Tax) 4120000 4149040
Change in Net Working Capital 500000 15000 15450
Cash flow -3900000 -4400000 -25535000 5693590NPV Rs. 3,078,974.12
2005 2006 2007 2008 2009 2010 2011 2012 2013 201420400 18714 17283 17481 17682 17886 18092 17428 17628 17831
365 365 365 366 365 365 365 366 365 3658 8 8 12 12 12 12 12 16 16
357 357 357 354 353 353 353 354 349 3497282800 6680898 6170031 6188274 6241746 6313758 6386476 6169512 6152172 6223019
4326.4 4499.456 4679.434 4866.612 5061.276 5263.727 5474.276 5693.247 5920.977 6157.8161579136 1642301 1707993 1781180 1847366 1921260 1998111 2083728 2161157 2247603
300000 35000060000 60000 60000 60000 60000 70000 70000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
4143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 2361015 23454161450282 1217509 1015713 975483 971033.1 970374.2 968927.8 863024.2 826355.4 820895.62693382 2261088 1886324 1811611 1803347 1802123 1799437 1602759 1534660 15245204143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 2361015 2345416
15913.5 16390.91 16882.63 17389.11 17910.78 18448.11 19001.55 19571.6 20158.75 20763.51
4237468 3804697 3129442 3414222 3405436 3403675 3400436 2853188 3144501 3133757
2005 2006 2007 2008 2009 2010 2011 2012 2013 201420400 18714 17283 17481 17682 17886 18092 17428 17628 17831
365 365 365 366 365 365 365 366 365 3658 8 8 12 12 12 12 12 16 16
357 357 357 354 353 353 353 354 349 3497282800 6680898 6170031 6188274 6241746 6313758 6386476 6169512 6152172 6223019
4326.4 4499.456 4679.434 4866.612 5061.276 5263.727 5474.276 5693.247 5920.977 6157.8161579136 1642301 1707993 1781180 1847366 1921260 1998111 2083728 2161157 2247603
300000 35000060000 60000 60000 60000 60000 70000 70000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
4143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 2361015 23454164143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 2361015 2345416
15913.5 16390.91 16882.63 17389.11 17910.78 18448.11 19001.55 19571.6 20158.75 20763.51
5687751 5022206 4145155 4389705 4376469 4374049 4369364 3716212 3970857 3954653
2015 2016 2017 2018 2019 2020 2021 2022 2023 202418036 18243 14762 14932 15104 15278 15454 14654 14823 14993
365 366 365 365 365 366 365 365 365 36616 16 16 16 16 16 16 16 16 16
349 350 349 349 349 350 349 349 349 3506294564 6385050 5151938 5211268 5271296 5347300 5393446 5114246 5173227 5247550
6404.129 6660.294 6926.706 7203.774 7491.925 7791.602 8103.266 8427.397 8764.493 9115.0722337507 2437668 2528248 2629378 2734553 2851726 2957692 3076000 3199040 3336116
750000 85000070000 70000 70000 150000 150000 150000 150000 150000 170000 170000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
2327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2 244187.2 181433.5814469.9 811083.8 347791.6 305161.7 289360.2 274950.8 254013.9 114886.2 85465.52 63501.741512587 1506299 645898.8 566728.8 537383.2 510622.9 471740 213360 158721.7 117931.82327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2 244187.2 181433.5
21386.41 22028.01 22688.85 23369.51 24070.6 24792.71 25536.5 26302.59 27091.67 27904.42
3121201 3114271 1503210 2253359 2223313 2195830 2156204 1047057 1861630 1820027
2015 2016 2017 2018 2019 2020 2021 2022 2023 202418036 18243 14762 14932 15104 15278 15454 14654 14823 14993
365 366 365 365 365 366 365 365 365 36616 16 16 16 16 16 16 16 16 16
349 350 349 349 349 350 349 349 349 3506294564 6385050 5151938 5211268 5271296 5347300 5393446 5114246 5173227 5247550
6404.129 6660.294 6926.706 7203.774 7491.925 7791.602 8103.266 8427.397 8764.493 9115.0722337507 2437668 2528248 2629378 2734553 2851726 2957692 3076000 3199040 3336116
750000 85000070000 70000 70000 150000 150000 150000 150000 150000 170000 170000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
2327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2 244187.2 181433.52327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2 244187.2 181433.5
21386.41 22028.01 22688.85 23369.51 24070.6 24792.71 25536.5 26302.59 27091.67 27904.42
3935671 3925354 1851002 2558521 2512673 2470781 2410217 1161944 1947096 1883529
2025 2026 202715166 15341 13448
365 365 36516 16 16
349 349 3495292934 5354009 4693352
9479.675 9858.862 10253.223460081 3598485 3742424
170000 170000 170000
1560000 1560000 1560000
102852.6 25524.31 -77907235998.4 8933.507 -272675
66854.17 16590.8 -506397102852.6 25524.31 -779072
28741.55 29603.8 30491.91
1768113 1716987 1193111
2025 2026 202715166 15341 13448
365 365 36516 16 16
349 349 3495292934 5354009 4693352
9479.675 9858.862 10253.223460081 3598485 3742424
170000 170000 170000
1560000 1560000 1560000
102852.6 25524.31 -779072102852.6 25524.31 -779072
28741.55 29603.8 30491.91
1804111 1725921 920436
SCENARIO: 15 YEARS USE WITH TAX
2001revenues
operating cost
PURCHASE -3900000CAPITAL EXPEBITDA 0DEPN OF PURCHASEDEPN OF CAPITAL EXPEBIT 0
TAX 0PAT 0NET SALVAGE VALUEINV IN WORKING CAPITAL
FCF -3900000
npv
Exptected Rate of Inflation 3.00% Tax RateRate of Increase of Operating Costs 4.00% Discount RatePurchase Price 39000000
SCENARIO: 15 YEARS USE WITHOUT TAX
2001revenues
operating cost
PURCHASE -3900000CAPITAL EXPEBITDADEPNDEPN OF CAPITAL EXPEBIT
PATNET SALVAGE VALUEINV IN WORKING CAPITAL
FCF -3900000
Rs. -200,319.06
SCENARIO: 15 YEARS USE WITH TAX
2002 2003 2004 2005 2006 2007 2008 20097140000 7211400 7282800 6680898 6170031 6170793 6241746
-1460000 -1518400 -1579136 -1642301 -1707993 -1776313 -1847366
-3900000 -31200000-300000
0 5680000 5693000 5703664 5038597 4462038 4394480 43943802266667 2266667 2266667 2266667 2266667 2266667 2266667
60000 600000 3413333 3426333 3436997 2771930 2195371 2067813 2067713
0 1194666.5 1199216.5 1202949 970175.35 768379.68 723734.47 723699.630 2218666.5 2227116.5 2234048 1801754 1426991 1344078 1344014
-500000 -15000 -15450 -15913.5 -16390.91 -16882.63 -17389.11 -17910.78
-4400000 -26729667 4478333.5 4484802 4052030 3376775 3593356 3592770
Rs. -5,932,339.87
35.00%9.00%
SCENARIO: 15 YEARS USE WITHOUT TAX
2002 2003 2004 2005 2006 2007 2008 20097140000 7211400 7282800 6680898 6170031 6170793 6241746
-1460000 -1518400 -1579136 -1642301 -1707993 -1776313 -1847366
-3900000 -31200000-300000
5680000 5693000 5703664 5038597 4462038 4394480 43943802266667 2266667 2266667 2266667 2266667 2266667 2266667
60000 600003413333 3426333 3436997 2771930 2195371 2067813 2067713
3413333 3426333 3436997 2771930 2195371 2067813 2067713
-500000 -15000 -15450 -15913.5 -16390.91 -16882.63 -17389.11 -17910.78
-4400000 -25535000 5677550 5687750.5 5022206 4145155 4317091 4316469
2010 2011 2012 2013 2014 2015 2016 20176313758 6386476 6152084 6152172 6223019 6294564 6366807 5151938
-1921260 -1998111 -2078035 -2161157 -2247603 -2337507 -2431007 -2528248
-350000 -7500004392498 4388365 4074049 3991015 3975416 3957057 3935800 26236902266667 2266667 2266667 2266667 2266667 2266667 2266667 2266667
60000 60000 60000 70000 70000 70000 70000 700002065831 2061698 1747382 1654348 1638749 1620390 1599133 287023.39
723040.71 721594.37 611583.61 579021.92 573562.18 567136.49 559696.44 100458.19 01342790 1340104 1135798 1075326 1065187 1053253 1039436 186565.2
5000000-18448.11 -19001.55 -19571.6 -20158.75 -20763.51 -21386.41 -22028.01 -22688.85
3591009 3587769 3032894 3321835 3311090 3298534 3284075 1680543
2010 2011 2012 2013 2014 2015 2016 20176313758 6386476 6152084 6152172 6223019 6294564 6366807 5151938
-1921260 -1998111 -2078035 -2161157 -2247603 -2337507 -2431007 -2528248
-350000 -7500004392498 4388365 4074049 3991015 3975416 3957057 3935800 26236902266667 2266667 2266667 2266667 2266667 2266667 2266667 2266667
60000 60000 60000 70000 70000 70000 70000 700002065831 2061698 1747382 1654348 1638749 1620390 1599133 287023.39
2065831 2061698 1747382 1654348 1638749 1620390 1599133 287023.393250000
-18448.11 -19001.55 -19571.6 -20158.75 -20763.51 -21386.41 -22028.01 -22688.85
4314049 4309364 3644477 3900857 3884653 3865671 3843772 1781002