Answered step by step
Verified Expert Solution
Link Copied!

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?
image text in transcribed

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

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

Payroll Accounting

Authors: Bernard J. Bieg, Judith A. Toland

2013 edition

113396253X, 978-1133962533

More Books

Students also viewed these Accounting questions

Question

3. Experiment with cooperative learning activities.

Answered: 1 week ago

Question

13.6 Explain how to set up aflexible benefits program.

Answered: 1 week ago

Question

13.2 Describe five government-mandated benefits.

Answered: 1 week ago