Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

image text in transcribed

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

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

Step: 3

blur-text-image

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

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

Authors: Cliff Ragsdale

7th Edition

1285418689, 978-1285969701, 1285969707, 978-1285418681

More Books

Students also viewed these Accounting questions