Eastman Kodak Company (KODK) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Eastman Kodak Company (KODK) Bundle
Evaluate Eastman Kodak Company's financial prospects like an expert! This (KODK) DCF Calculator provides pre-filled financial data and offers comprehensive flexibility to modify revenue growth, WACC, profit margins, and other crucial assumptions to align with your forecasts.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 1,242.0 | 1,029.0 | 1,150.0 | 1,205.0 | 1,117.0 | 1,094.9 | 1,073.3 | 1,052.0 | 1,031.2 | 1,010.8 |
Revenue Growth, % | 0 | -17.15 | 11.76 | 4.78 | -7.3 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 |
EBITDA | 11.0 | -327.0 | 92.0 | 100.0 | 169.0 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 |
EBITDA, % | 0.88567 | -31.78 | 8 | 8.3 | 15.13 | 0.10716 | 0.10716 | 0.10716 | 0.10716 | 0.10716 |
Depreciation | 55.0 | 37.0 | 31.0 | 29.0 | 30.0 | 34.6 | 33.9 | 33.3 | 32.6 | 32.0 |
Depreciation, % | 4.43 | 3.6 | 2.7 | 2.41 | 2.69 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 |
EBIT | -44.0 | -364.0 | 61.0 | 71.0 | 139.0 | -33.5 | -32.8 | -32.1 | -31.5 | -30.9 |
EBIT, % | -3.54 | -35.37 | 5.3 | 5.89 | 12.44 | -3.06 | -3.06 | -3.06 | -3.06 | -3.06 |
Total Cash | 233.0 | 196.0 | 362.0 | 217.0 | 255.0 | 241.1 | 236.4 | 231.7 | 227.1 | 222.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 208.0 | 177.0 | 175.0 | 177.0 | 196.0 | 178.3 | 174.7 | 171.3 | 167.9 | 164.6 |
Account Receivables, % | 16.75 | 17.2 | 15.22 | 14.69 | 17.55 | 16.28 | 16.28 | 16.28 | 16.28 | 16.28 |
Inventories | 215.0 | 206.0 | 219.0 | 237.0 | 217.0 | 209.1 | 204.9 | 200.9 | 196.9 | 193.0 |
Inventories, % | 17.31 | 20.02 | 19.04 | 19.67 | 19.43 | 19.09 | 19.09 | 19.09 | 19.09 | 19.09 |
Accounts Payable | 153.0 | 118.0 | 153.0 | 134.0 | 125.0 | 130.1 | 127.5 | 125.0 | 122.5 | 120.1 |
Accounts Payable, % | 12.32 | 11.47 | 13.3 | 11.12 | 11.19 | 11.88 | 11.88 | 11.88 | 11.88 | 11.88 |
Capital Expenditure | -15.0 | -17.0 | -21.0 | -31.0 | -32.0 | -22.2 | -21.7 | -21.3 | -20.9 | -20.5 |
Capital Expenditure, % | -1.21 | -1.65 | -1.83 | -2.57 | -2.86 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 |
Tax Rate, % | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 |
EBITAT | -66.7 | -526.6 | 52.3 | 59.5 | 119.8 | -30.5 | -29.9 | -29.3 | -28.7 | -28.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -296.7 | -501.6 | 86.3 | 18.5 | 109.8 | 12.7 | -12.6 | -12.3 | -12.1 | -11.9 |
WACC, % | 16.78 | 16.78 | 16.12 | 16.04 | 16.15 | 16.37 | 16.37 | 16.37 | 16.37 | 16.37 |
PV UFCF | ||||||||||
SUM PV UFCF | -18.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -12 | |||||||||
Terminal Value | -75 | |||||||||
Present Terminal Value | -35 | |||||||||
Enterprise Value | -54 | |||||||||
Net Debt | 240 | |||||||||
Equity Value | -294 | |||||||||
Diluted Shares Outstanding, MM | 91 | |||||||||
Equity Value Per Share | -3.24 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Eastman Kodak Company’s (KODK) financial data pre-loaded to enhance your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue growth, operating margin, and capital investments.
- Instant DCF Valuation: Provides immediate calculations for intrinsic value, NPV, and additional financial metrics.
- High-Precision Outcomes: Leverages Eastman Kodak Company’s (KODK) actual financial data to ensure accurate valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and analyze different outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the necessity for intricate model creation from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Eastman Kodak Company (KODK) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Eastman Kodak Company (KODK)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Eastman Kodak Company (KODK)?
- Rich Heritage: Benefit from over a century of innovation in imaging technology.
- Quality Products: Renowned for high-quality photographic and imaging solutions.
- Commitment to Sustainability: Focused on eco-friendly practices and sustainable products.
- Expert Support: Access to knowledgeable professionals ready to assist you.
- Proven Track Record: A trusted name in the industry with a legacy of reliability.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment related to Eastman Kodak Company (KODK).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Eastman Kodak Company (KODK).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Photography and Technology Enthusiasts: Gain insights into how companies like Eastman Kodak Company (KODK) are valued in the industry.
What the Template Contains
- Historical Data: Includes Eastman Kodak Company’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Eastman Kodak Company’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Eastman Kodak Company’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.