Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

NOTE: READ THIS EXPLANATION, DON'T WRITE THE COMMENT WITHOUT READING THIS EXPLANATION SUCH AS NOT LEGIBLE,THIS IS BLUR ETC., I MADE AN ALL EXPLANATION BELOW,

NOTE:

READ THIS EXPLANATION, DON'T WRITE THE COMMENT WITHOUT READING THIS EXPLANATION SUCH AS NOT LEGIBLE,THIS IS BLUR ETC., I MADE AN ALL EXPLANATION BELOW, OK?

==>>The main question is the question in the photo I first posted. If you save the image your PC you can see the photo, Don't wrte the comment "image not clear", If you do that as my sad yu can see and it can be read more clearly. However, I discarded the information in that photo separately in case you couldn't save it. If you can not read the texts and numbers in the first picture, I also photographed each part of that question separately, you can look at them. THANKS. (UPVOTE)

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

7 2009 9 2010 2001 2002 Year Daily Charter Rate Days in maintenance 2003 20.000 $ 2004 20.200 $ 2005 20.400$ 6 2007 17.283 $ 8 2006 18.7145 8 10 2011 18.092 $ 12 11 2012 17.428 $ 12 2009 17.682 $ 12 12 2013 17.628 $ 16 13 2014 17.831 $ 16 14 2015 18.036 $ 16 15 2016 18.243$ 16 $ 16 2017 14.762 16 17.481 $ 12 17.886 $ 12 8 12.941.775 - cremental Earnings Forecast Revenues $ $ $ 7.140.000 $ 7.211.400 $ 7.282.300 $ 6.680.898 $ 6.170.031 $ 6.170.793 $ 6.241.746 $ 6.313.758 5 6.386.476 $ 6.152.084 5 6.152.172 $ 6.223.019 5 6.294.564 56.366.807 $ COGS $ 3.900,000 $ 3.900.000 $ 31.200.000 $ $ $ $ $ - 5 $ $ $ $ $ . $ $ 5 S Gross Profit $ (3.900.000) $ (3.900.000) $ (24.060,000) $ 7.211.400 $ 7.282.800 $ 6.680.898 $ 6.170.031 $ 6.170.793 $ 6.241.746 $ 6.313.758 $ 6.386.476 $ 6.152.084 $ 6.152.172 $ 6.223.019 $ 6.294.564 $ 6.366 307 $ Operating costs S - S - $ $ 4.000 $ 4.1605 4.326 $ 4.499 $ 4.679 $ 4.8675 5.061 $ 5.264 $ 5.474 $ 5.693 $ 5.921 $ 6.1585 6.404 5 6.660 $ Depreciation $ $ $ $ . $ $ $ $ $ 60,000 $ $ 60.000 $ 60,000 $ 50.000 $ 60,000 $ 70.000 5 70.000 $ 70.000 $ 70.000 $ EBIT $ 3.900.000) $ (3.500.000) $ (24.064.000) $ 7.207.240 $ 7.278.474 $ 6.676.399 $ 6.165.352 $ 6.105.925 $ 6.176.685 $ 6.248.494 $ 6.321.002 $ 6,086 391 $ 4.07 251 $ 6.146.861 $ 6.218.160 $ 6.290.147 $ Income Tox at 35% $ (1.365.000) $ (1.365.000) $18.422.400||$2.522.534 $ 2.547.466 $ 2.336.739 $ 2.157.373 $ 2.137.074 $ 2.161.840 $ 2.186.973 $ 2.212,351 $ 2.130.2372.126.688 $ 2.151.401 $ 2.176,356 $ 2201.551 Net Income $ 12.535.000) 5 (2.535.000) $ (15.641.600) $ 4.684.705 5 4.731.008 5 4.339.659 $ 4.007.479 $ 3.968.852 5 4.014.845 5 4.061.521 5 4.105.651 $ 3.956,154 $ 3.949.563 5 3.995.460 5 4,041.804 5 4.088.595$ Plus: Depreciation $ $ . $ . $ - $ $ $ . $ $ GO.DDO $ 50.000 $ 60,000 $ 50,000 $ 50.000 $ 70.000 $ 70.000 $ 70.000 $ 70.000 $ Less: Capital Expenditures S - $ . 15 $ $ $ . $ 300.000 $ $ $ $ $ 950.000 $ $ $ $ $ Less: Increases in NWC $ 500.000 $ 1.500 $ 3.045$ 4.636 5 6.275$ 7.964 $ 9.7035 11.494 $13.339 5 15.239 17.196 $ 19.212S 21.2885 23.4275 25.6295 27.098 $ Free Cash Flow $ (3,035.000) $ (2.536.500) $ (15.544.5451 $ 4.680.070 $ 4.724.732 $ 4.331.695 $ 3.697.775 $ 4.017.358 $ 4.061.507 $ 4.106.283 $ 4.151.455 $ 3.546.942 $ 3.999.275$ 4,042,033 $ 4085 174 $ 4.130.597 $ Projected Cost of Capital 0,12 $ 2.974,269 PV of Free Cash Flow $ 40,860 769 NPV $ 5.130.963 12.941.775 6.927 70,000 12.864 840 4.502.697 8.362.151 70.000 30.235 8,401.916 12.864.84 70,000 30.235 12.904.613 No Tax Case Net Income = EBIT $ 3.900.000) $ (3.900.000) $ (24.064.000 $ 7.207.240 5 7.278.474 $ 6.675.399 $ 5.165.352 $ 6.105,925 $ 6.175.685 5 6.243.494 $ 6.321.002 $ 6.056.391 $ 6.075.251 $ 6.146.861 5 6.218.160 5 6.290.147 $ Plus: Depreciation $ $ $ $ $ - $ $ $ 50.000 $ 50.000 $ 50.000 $ 50.000 $ 50.000$ 70.000 $ 70.000 $ 70.000 $ 70.000 $ Less: Capital Expenditures $ $ $ $ S $ 300.000 S $ $ $ $ 350.000$ Is $ $ $ $ Less: Increases in NWC $ 500.000 $ 1.500 $ 3.045 $ 4.636 5 6.275$ 7.964 $ 9.703 $ 11.4945 13.339 $ 15,2395 17.196 $ 19.212 $ 21.2885 23.4275 25.629 $ 27.698$ Free Cash Flow $ (4.400.000) $ (3.901.500) $ (24.067.0451 $ 7.202.604 $ 7.272.198 $ 6.668,435 $ 5.855.549 $ 6.154.433 $ 6.223.346 $ 6.293.256 $ 6,363.805 $ 5.777.179 $ 6.124 963 $ 6.193.434 $ 6.262.530 $ 6.332.248 $ Projected Cost of Capitals 0,12 PV of Free Cash Flow $ 63.260.149 NPV $ 8.240.688 You are going to make a projection for 20 years Scrap value of the vessel is 5000000 USD You can use the same assumptions given in the 15 years projection Please also find the IRR Revenues and costs increase with the inflation rate of 4% Otomatik Kaydet 201733503 - Uyumluluk Modu - Kaydedila osya Giri Ekle Sayfa Dzeni Formller Veri Gozden Geir Grnm Yardn Arial 10 A A == 25 Metni kaydir X kes [ Kopyala - pastir Biim Boyacs Pano K TA a. Ar - - Birlesir ve Otale Yaz Tipi Hizalama 10 f fx 0 2001 1 2002 Year Daily Charter Rate Days in maintenance D 2 2003 20.000 $ 8 E 3 2004 20.200 $ 8 F 4 2005 20.400 8 $ Incremental Earnings Forecast Revenues* COGS Gross Profit Operating Costs** Depreciation EBIT Income Tax at 35% Net Income Plus: Depreciation Less: Capital Expenditures Less: Increases in NWC Free Cash Flow Projected Cost of Capital PV of Free Cash Flow NPV $ $ $ 7.140.000 $7.211.400 $7.282.800 $ 3.900.000 $ 3.900.000 $ 31.200.000 $ $ $ (3.900.000) $ (3.900.000) $ (24.060.000) $7.211.400 $7.282.800 $ $ $ 4.000 $ 4.160 $ 4.326 $ $ $ $ S $ (3.900.000) S (3.900.000) S (24.064.000) $7.207.240 $7.278.474 $ (1.365.000) $ (1.365.000) $ (8.422.400) $2.522.534 $2.547.466 $ (2.535.000) $ (2.535.000) $ (15.641.600) $4.684.706 $4.731.008 $ $ $ $ $ $ $ $ $ $ 500.000 $ 1.500 $ 3.045 $ 4.636 $ 6.275 $ (3.035.000) $ (2.536.500) $ (15.644.645) $4.680.070 $4.724.732 0,12 $2.974.269 $40.860.769 $ 5.130.968 No Tax Case Net Income = EBIT Plus: Depreciation 5 Less: Capital Expenditures Less: Increases in NWC 3 Free Cash Flow Projected Cost of Capital PV of Free Cash Flow 1 NPV $ (3.900.000) $ (3.900.000) $ (24.064.000) $7.207.240 $7.278.474 $ $ $ $ $ $ $ $ $ 500.000 $ 1.500 $ 3.045 $ 4.636 $ 6.275 $ (4.400.000) $ (3.901.500) $ (24.067.045) $7.202.604 $7.272.198 $0.12 $63.260.149 $ 8.240.688 4 5 6 7 p Ara Power Pivot Genel Normal 2 Normal 3 Norr %, do not Koullu Tablo Olarak Kt Biimlendirme Biimlendir Ntr Ak Sayi Stiller N G 5 2006 18.714 $ 8 H 6 2007 17.283 $ 8 1 7 2008 17.481 $ 12 8 2009 17.682 $ 12 K 9 2010 17.886 $ 12 L 10 2011 18.092 $ 12 M 11 2012 17.428 $ 12 20 17.6 $6.680.898 $6.170.031 $6.170.793 $6.241.746 $6.313.758 $6.386.476 $6.152.084 $6.152.17 $ $ $ $ $ $ $ $ $6.680.898 $6.170.031 $6.170.793 $6.241.746 $6.313.758 $6.386.476 $6.152.084 $6.152.17 $ 4.499 $ 4.679 $ 4.867 $ 5.061 $ 5.264 $ 5.474 $ 5.693 $ 5.92 $ $ $ 60.000 $ 60.000 $ 60.000 $ 60.000 $ 60.000 $ 70.00 $6.676.399 $6.165.352 $6.105.926 $6.176.685 $ 6.248.494 $6.321.002 $6.086.391 $6.076.25 $2.336.739 $2.157.873 $2.137.074 $ 2.161.840 $2.186.973 $2.212.351 $2.130.237 $2.126.68 $4.339.659 $4.007.479 $3.968.852 $4.014.845 $4.061.521 $4.108.651 $3.956.154 $3.949.56 $ $ $ 60.000 $ 60.000 $ 60.000 $ 60.000 $ 60.000 $ 70.000 $ $ 300.000 $ $ $ $ $ 350.000 $ $ 7.964 $ 9.703 $ 11.494 $ 13.339 $ 15.239 $ 17.196 $ 19.212 $ 21.288 $4.331.695 $3.697.776 $4.017.358 $4.061.507 $4.106.283 $4.151.455 $3.646.942 $3.998.27 $6.676.399 $6.165.352 $6.105.926 $6.176.685 $6.248.494 $6.321.002 $6.086.391 $6.076.251 $ $ 60.000 $ 60.000 $ 60.000 $ 60.000 $ 60.000 $ 70.000 $ $ 300.000 $ $ 350.000 $ $ 7.964 $ 9.703 $ 11.494 $ 13.339 $ 15.239 $ 17.196 $ 19.212 $ 21.288 $6.668.435 $5.855.649 $6.154.433 $6.223.346 $6.293.256 $6.363.806 $5.777.179 $6.124.963 Normal 3 Normal iyi Ntr Aklama Me... Bagli Hcre Ekle Sil P. Biim Stiller Hcreler S M 11 2012 17.428 $ 12 N 12 2013 17.628 $ 16 o 13 2014 17.831 $ 16 14 2015 18.036 $ 16 $ 15 2016 18.243 $ 16 R 16 2017 14.762 16 $6.152.084 $6.152.172 $6.223.019 $6.294.564 $6.366.807 $12.941.775 $ $ $ $ $ $ $6.152.084 $6.152.172 $6.223.019 $6.294.564 $6.366.807 $12.941.775 $ 5.693 $ 5.921 $ 6.158 $ 6.404 $ 6.660 $ 6.927 $ 60.000 $ 70.000 $ 70.000 $ 70.000 $ 70,000 $ 70.000 $6.086.391 $6.076.251 $6.146.861 $6.218.160 $6.290.147 $12.864.848 $2.130.237 $ 2.126.688 $ 2.151.401 $2.176.356 $2.201.551 $ 4.502.697 $3.956.154 $3.949.563 $3.995.460 $4.041.804 $4.088.595 $ 8.362.151 $ 60.000 $ 70.000 $ 70.000 $ 70.000 $ 70.000 $ 70.000 $ 350.000 $ $ $ $ $ $ 19.212 $ 21.288 $ 23.427 $ 25.629 $ 27 898 $ 30.235 $ 3.646.942 $3.998.275 $4.042.033 $4.086.174 $4.130.697 $ 8.401.916 $6.086.391 $6.076.251 $6.146.861 $6.218.160 $6.290.147 $ 12.864.848 $ 60.000 $ 70,000 $ 70.000 $ 70 000 $ 70.000 $ 70.000 $ 350.000 $ $ $ $ $ $ 19.212 5 21.288 $ 23.427 $ 25.629 $ 27.898 $ 30.235 $5.777.179 $6.124.963 $6.193.434 $6.262.530 $6.332 248 $12.904.613 You are going to make a projection for 20 years You can use the same assumptions given in the 15 years projection Revenues and costs increase with the inflation rate of 4% Scrap value of the vessel is 5000000 USD Please also find the IRR +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

New York Institute Of Finance How Mutual Funds Work

Authors: Albert J. Fredman, Russ Wiles

1st Edition

0130125016, 9780130125019

More Books

Students also viewed these Finance questions

Question

U11 Informing Industry: Publicizing Contract Actions 317

Answered: 1 week ago