Project DCF valuation Valuation summary Discount al Taxa Inflation Project NPV (5000)- Cash low estimation (5000)...

Transcribed Image Text:

Project DCF valuation Valuation summary Discount al Taxa Inflation Project NPV (5000)- Cash low estimation (5000) Time-line 0:and of 2050) Calendar your Shipy (SY) Daily hire rate growth assumption Estdaily hire rates, 5000 12.0% 20.0% 3.0% Est. days of operation (14 days to subtract) Est. daily oper. costs, 1000s, growing @1 in1.01 -Income taxes .Unleverednet income (5000) [+] Depradd back *WC balance (to be recovered at the end) - Changes in WC (ine-outlow) D DCF Discounted (Unleverd) CF (PV) NPV (sum of all discounted cash flows) 0 2050 Revenues (-daily hire rate days of oper -Costa (-daily cost365) Gross profits -De-acquisition cost (544 min/25 years) -Depr-additional capex SYS, SY10, SY15, SY20 (each capex/5 years) Depr total EBIT 50.00 14.00 1 2051 0.326 *Shipacquisition cost (10%, 10%6 & 80% af $44 mi) "Add capex (0.3 mic 0.35 min; 0.85 min 12 min) - Investment costs total (sum of the above two) [+] CF from liquidation "Liquidation at the end of SY25 (cash flow, net of tax) .Unlevered CE (5000) D 2 2052 SYO 0.00% 500 4 5 3 2053 2054 2055 SY1 SY2 SY3 0.00% D D 0 0.00% 0 D 0 0.00% D D 0 6 7 2056 2057 SY4 SYS SY6 0.00% D D 0 D 0 0.00% D D 0 D B D 0.00% D D 0 D 2059 SY7 0.00% D D 0 10 2060 SYB D 0 D 0 11 2061 SY9 0.00% 0.00% D D 0 13 12 2062 2063 SY10 SY11 D D D 0 D 0.00% D D 0 D 0 Project DCF valuation Valuation summary Discount al Taxa Inflation Project NPV (5000)- Cash low estimation (5000) Time-line 0:and of 2050) Calendar your Shipy (SY) Daily hire rate growth assumption Estdaily hire rates, 5000 12.0% 20.0% 3.0% Est. days of operation (14 days to subtract) Est. daily oper. costs, 1000s, growing @1 in1.01 -Income taxes .Unleverednet income (5000) [+] Depradd back *WC balance (to be recovered at the end) - Changes in WC (ine-outlow) D DCF Discounted (Unleverd) CF (PV) NPV (sum of all discounted cash flows) 0 2050 Revenues (-daily hire rate days of oper -Costa (-daily cost365) Gross profits -De-acquisition cost (544 min/25 years) -Depr-additional capex SYS, SY10, SY15, SY20 (each capex/5 years) Depr total EBIT 50.00 14.00 1 2051 0.326 *Shipacquisition cost (10%, 10%6 & 80% af $44 mi) "Add capex (0.3 mic 0.35 min; 0.85 min 12 min) - Investment costs total (sum of the above two) [+] CF from liquidation "Liquidation at the end of SY25 (cash flow, net of tax) .Unlevered CE (5000) D 2 2052 SYO 0.00% 500 4 5 3 2053 2054 2055 SY1 SY2 SY3 0.00% D D 0 0.00% 0 D 0 0.00% D D 0 6 7 2056 2057 SY4 SYS SY6 0.00% D D 0 D 0 0.00% D D 0 D B D 0.00% D D 0 D 2059 SY7 0.00% D D 0 10 2060 SYB D 0 D 0 11 2061 SY9 0.00% 0.00% D D 0 13 12 2062 2063 SY10 SY11 D D D 0 D 0.00% D D 0 D 0