Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hos can i get the depr total? 10 11 12 13 14 17 18 19 20 21 22 23 25 26 27 28 29 30
Hos can i get the depr total?
10 11 12 13 14 17 18 19 20 21 22 23 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Project DCF valuation Valuation summary Discount rate : 12.0% Tax rate : 20.0% Inflation : 3.0% Project NPV ($000s) = Cash flow estimation (SOOOs) Time-line O : end of 2050) > Calendar year Ship year (SY Est. daily hire rates, ooos Est. days of operation (14 days to subtract) $000s Est. daily oper. costs, , growing @(1+ 01 Revenues (z daily hire rate x days of oper) - Costs (2 daily cost x 365) Gross profits - Depr acquisition cost ($44 mln 125 years) 2050 50.00 14.001 2051 50.16 14.56 2 2052 SYO 50.24 15.15 500 3 2053 SYI 50.43 351 15.76 17,702 5,753 11 ,949 4 2054 SY2 50.51 351 16.40 17,729 5,985 11,744 5 2055 SY3 50.41 351 17.06 17,695 6,226 11 ,469 6 2056 SY4 47.82 351 17.75 16,783 6,477 10,306 7 2057 SY5 48.15 351 18.46 16,901 6,738 10,163 8 2058 SY6 47.50 351 19.20 16,673 7,010 9,663 9 2059 SY7 46.93 351 19.98 16,472 7,292 9,180 10 2060 SY8 45.51 351 20.78 15,973 7,586 8,387 11 2061 SY9 41 .95 351 21 .62 14,724 7,892 6,833 12 2062 SYIO 40.99 351 22.49 14,389 8,210 6,179 13 2063 SYII 41.13 351 23.40 14,436 8,540 5,895 14 2064 SY12 40.83 351 24.34 14,332 8,885 5,448 15 2065 SY13 41 .26 351 25.32 14,481 9,243 5,238 16 2066 SY14 42.67 351 26.34 14,976 9,615 5,361 17 2067 SY15 44.51 351 27.40 15,623 10,003 5,620 18 2068 SY16 45.86 351 28.51 16,096 10,406 5,690 19 2069 SY17 45.88 351 29.66 16,102 10,825 5,277 20 2070 SY18 46.28 351 30.85 16,244 11,261 4,982 21 2071 SY19 47.39 351 32.10 16,635 11,715 4,920 22 2072 SY20 48.57 351 33.39 17,047 12,187 4,859 23 2073 SY21 47.19 351 34.74 16,563 12,679 3,885 24 2074 SY22 44.98 351 36.14 15,789 13,189 2,599 25 2075 SY23 42.45 351 37.59 14,900 13,721 1,179 26 2076 SY24 42.42 351 39.11 14,890 14,274 617 27 2077 SY25 42.83 351 40.68 15,032 14,849 182 - Depr additional capex SY5, SYIO, SY15, SY20 (each capexJ5 years) - Depr total EBIT - Income taxes Unlevered net income ($000s) [+1 Depr add back *WC balance (to be recovered at the end) Changes in WC (incr. = outflow) *Ship acquisition cost (10%, 10% & 80% of $44 mln) Addl capex (0.3 mln; 0.35 mln; 0.65 mln; 1.2 mln) Investment costs total (sum of the above two) [+] CF from liquidation *Liquidation at the end of SY25 (cash flow, net of tax) Unlevered CF (SOOOS DCF Discounted (Unlevered) CF (i.e., PV) NPV (sum of all discounted cash flows) = Liquidation at the end of SY25 (cash flow, net of tax)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started