Download - OceanCarriers
-
8/12/2019 OceanCarriers
1/16
Year 1 Year 2 Year 3 Year 4
A) Sales 10000000 13000000 13000000 8666667COGS 6000000 7800000 7800000 5200000
Selling&Admn expenses 2350000 3055000 3055000 2036667
Depreciation-SLM 100000 100000 100000 100000EBIT 1550000 2045000 2045000 1330000Corp Tax @40% 620000 818000 818000 532000PAT 930000 1227000 1227000 798000+Depreciation 100000 100000 100000 100000-Working capital -2700000 -810000 0 1170000FCFF -1700000 -1670000 517000 1327000 2068000InvestmentsCapital goods -500000Working Capital -2700000 -3510000 -3510000 -2340000 -1170000MarketdevelopmentInvestments -$1,200,000.00Rate 20%
B) NPV 161474IRR 21.79%
C) As the company is getting a positive NPV of $ 161474 and also IRR is 21.79% which is higher t
-
8/12/2019 OceanCarriers
2/16
Year 5
43333332600000
1018333
100000615000246000369000100000
23400002809000
han discount rate, it is profitable for the company to introduce the new product.
-
8/12/2019 OceanCarriers
3/16
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
-
8/12/2019 OceanCarriers
4/16
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
-
8/12/2019 OceanCarriers
5/16
2005 2006 2007 2008 2009 2010 2011 2012 201320400 18714 17283 17481 17682 17886 18092 17428 17628
365 365 365 366 365 365 365 366 3658 8 8 12 12 12 12 12 16
357 357 357 354 353 353 353 354 3497282800 6680898 6170031 6188274 6241746 6313758 6386476 6169512 6152172
4326.4 4499.456 4679.434 4866.612 5061.276 5263.727 5474.276 5693.247 5920.9771579136 1642301 1707993 1781180 1847366 1921260 1998111 2083728 2161157
300000 35000060000 60000 60000 60000 60000 70000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
4143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 23610151450282 1217509 1015713 975483 971033.1 970374.2 968927.8 863024.2 826355.42693382 2261088 1886324 1811611 1803347 1802123 1799437 1602759 15346604143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 2361015
15913.5 16390.91 16882.63 17389.11 17910.78 18448.11 19001.55 19571.6 20158.75
4237468 3804697 3129442 3414222 3405436 3403675 3400436 2853188 3144501
2005 2006 2007 2008 2009 2010 2011 2012 201320400 18714 17283 17481 17682 17886 18092 17428 17628
365 365 365 366 365 365 365 366 3658 8 8 12 12 12 12 12 16
357 357 357 354 353 353 353 354 3497282800 6680898 6170031 6188274 6241746 6313758 6386476 6169512 6152172
-
8/12/2019 OceanCarriers
6/16
4326.4 4499.456 4679.434 4866.612 5061.276 5263.727 5474.276 5693.247 5920.9771579136 1642301 1707993 1781180 1847366 1921260 1998111 2083728 2161157
300000 35000060000 60000 60000 60000 60000 70000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
4143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 23610154143664 3478597 2902038 2787094 2774380 2772498 2768365 2465784 2361015
15913.5 16390.91 16882.63 17389.11 17910.78 18448.11 19001.55 19571.6 20158.75
5687751 5022206 4145155 4389705 4376469 4374049 4369364 3716212 3970857
-
8/12/2019 OceanCarriers
7/16
2014 2015 2016 2017 2018 2019 2020 2021 202217831 18036 18243 14762 14932 15104 15278 15454 14654
365 365 366 365 365 365 366 365 36516 16 16 16 16 16 16 16 16
349 349 350 349 349 349 350 349 3496223019 6294564 6385050 5151938 5211268 5271296 5347300 5393446 5114246
6157.816 6404.129 6660.294 6926.706 7203.774 7491.925 7791.602 8103.266 8427.3972247603 2337507 2437668 2528248 2629378 2734553 2851726 2957692 3076000
750000 85000070000 70000 70000 70000 150000 150000 150000 150000 150000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
2345416 2327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2820895.6 814469.9 811083.8 347791.6 305161.7 289360.2 274950.8 254013.9 114886.21524520 1512587 1506299 645898.8 566728.8 537383.2 510622.9 471740 2133602345416 2327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2
20763.51 21386.41 22028.01 22688.85 23369.51 24070.6 24792.71 25536.5 26302.59
3133757 3121201 3114271 1503210 2253359 2223313 2195830 2156204 1047057
2014 2015 2016 2017 2018 2019 2020 2021 202217831 18036 18243 14762 14932 15104 15278 15454 14654
365 365 366 365 365 365 366 365 36516 16 16 16 16 16 16 16 16
349 349 350 349 349 349 350 349 3496223019 6294564 6385050 5151938 5211268 5271296 5347300 5393446 5114246
-
8/12/2019 OceanCarriers
8/16
6157.816 6404.129 6660.294 6926.706 7203.774 7491.925 7791.602 8103.266 8427.3972247603 2337507 2437668 2528248 2629378 2734553 2851726 2957692 3076000
750000 85000070000 70000 70000 70000 150000 150000 150000 150000 150000
1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000 1560000
2345416 2327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.22345416 2327057 2317382 993690.4 871890.5 826743.4 785573.7 725753.9 328246.2
20763.51 21386.41 22028.01 22688.85 23369.51 24070.6 24792.71 25536.5 26302.59
3954653 3935671 3925354 1851002 2558521 2512673 2470781 2410217 1161944
-
8/12/2019 OceanCarriers
9/16
2023 2024 2025 2026 202714823 14993 15166 15341 13448
365 366 365 365 36516 16 16 16 16
349 350 349 349 3495173227 5247550 5292934 5354009 4693352
8764.493 9115.072 9479.675 9858.862 10253.223199040 3336116 3460081 3598485 3742424
170000 170000 170000 170000 170000
1560000 1560000 1560000 1560000 1560000
244187.2 181433.5 102852.6 25524.31 -77907285465.52 63501.74 35998.4 8933.507 -272675158721.7 117931.8 66854.17 16590.8 -506397244187.2 181433.5 102852.6 25524.31 -779072
27091.67 27904.42 28741.55 29603.8 30491.91
1861630 1820027 1768113 1716987 1193111
2023 2024 2025 2026 202714823 14993 15166 15341 13448
365 366 365 365 36516 16 16 16 16
349 350 349 349 3495173227 5247550 5292934 5354009 4693352
-
8/12/2019 OceanCarriers
10/16
8764.493 9115.072 9479.675 9858.862 10253.223199040 3336116 3460081 3598485 3742424
170000 170000 170000 170000 170000
1560000 1560000 1560000 1560000 1560000
244187.2 181433.5 102852.6 25524.31 -779072244187.2 181433.5 102852.6 25524.31 -779072
27091.67 27904.42 28741.55 29603.8 30491.91
1947096 1883529 1804111 1725921 920436
-
8/12/2019 OceanCarriers
11/16
SCENARIO: 15 YEARS USE WITH T
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 Rate
Purchase Price 39000000 SCENARIO: 15 YEARS USE WITHO
2001revenues
operating cost
PURCHASE -3900000CAPITAL EXP
EBITDADEPNDEPN OF CAPITAL EXPEBIT
PATNET SALVAGE VALUEINV IN WORKING CAPITAL
-
8/12/2019 OceanCarriers
12/16
FCF -3900000
Rs. -200,319.06
-
8/12/2019 OceanCarriers
13/16
AX
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 60000
0 3413333 3426333 3436997 2771930 2195371 2067813 2067713
0 1194666.6 1199216.6 1202949 970175.3 768379.7 723734.5 723699.60 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%
UT 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 60000
3413333 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
-
8/12/2019 OceanCarriers
14/16
-4400000 -25535000 5677550 5687751 5022206 4145155 4317091 4316469
-
8/12/2019 OceanCarriers
15/16
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 2623690
2266667 2266667 2266667 2266667 2266667 2266667 2266667 2266667
60000 60000 60000 70000 70000 70000 70000 70000
2065831 2061698 1747382 1654348 1638749 1620390 1599133 287023.4
723040.7 721594.4 611583.6 579021.9 573562.2 567136.5 559696.4 100458.2 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 -750000
4392498 4388365 4074049 3991015 3975416 3957057 3935800 26236902266667 2266667 2266667 2266667 2266667 2266667 2266667 2266667
60000 60000 60000 70000 70000 70000 70000 70000
2065831 2061698 1747382 1654348 1638749 1620390 1599133 287023.4
2065831 2061698 1747382 1654348 1638749 1620390 1599133 287023.43250000
-18448.11 -19001.55 -19571.6 -20158.75 -20763.51 -21386.41 -22028.01 -22688.85
-
8/12/2019 OceanCarriers
16/16
4314049 4309364 3644477 3900857 3884653 3865671 3843772 1781002