IF Bancorp, Inc. (IROQ) 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
IF Bancorp, Inc. (IROQ) Bundle
Explore the financial prospects of IF Bancorp, Inc. (IROQ) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to determine the intrinsic value of IF Bancorp, Inc. (IROQ) and enhance your investment strategy.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 23.1 | 26.4 | 27.8 | 26.1 | 22.1 | 22.0 | 21.9 | 21.8 | 21.7 | 21.6 |
Revenue Growth, % | 0 | 14.46 | 5.03 | -6.13 | -15.28 | -0.47995 | -0.47995 | -0.47995 | -0.47995 | -0.47995 |
EBITDA | 6.6 | 8.1 | 8.5 | 6.9 | 3.0 | 5.7 | 5.7 | 5.6 | 5.6 | 5.6 |
EBITDA, % | 28.38 | 30.49 | 30.62 | 26.56 | 13.7 | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 |
Depreciation | .7 | .7 | .7 | .7 | .7 | .6 | .6 | .6 | .6 | .6 |
Depreciation, % | 2.91 | 2.57 | 2.43 | 2.54 | 3.04 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
EBIT | 5.9 | 7.4 | 7.8 | 6.3 | 2.4 | 5.1 | 5.1 | 5.1 | 5.0 | 5.0 |
EBIT, % | 25.47 | 27.92 | 28.19 | 24.02 | 10.66 | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 |
Total Cash | 195.9 | 252.6 | 298.2 | 11.0 | 6.2 | 16.3 | 16.2 | 16.1 | 16.0 | 16.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 2.0 | .0 | .0 | .3 | .3 | .3 | .3 | .3 |
Account Receivables, % | 0 | 0 | 7.29 | 0 | 0 | 1.46 | 1.46 | 1.46 | 1.46 | 1.46 |
Inventories | -38.8 | -67.1 | .0 | -17.8 | .0 | -11.8 | -11.7 | -11.7 | -11.6 | -11.6 |
Inventories, % | -167.81 | -253.97 | 0 | -68.41 | 0 | -53.68 | -53.68 | -53.68 | -53.68 | -53.68 |
Accounts Payable | .5 | .2 | .2 | 1.7 | 3.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Accounts Payable, % | 2.32 | 0.75273 | 0.63385 | 6.39 | 13.63 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
Capital Expenditure | -.2 | -.3 | -.4 | -2.3 | -.2 | -.6 | -.6 | -.6 | -.6 | -.6 |
Capital Expenditure, % | -0.68404 | -1.06 | -1.39 | -8.63 | -1.12 | -2.58 | -2.58 | -2.58 | -2.58 | -2.58 |
Tax Rate, % | 23.99 | 23.99 | 23.99 | 23.99 | 23.99 | 23.99 | 23.99 | 23.99 | 23.99 | 23.99 |
EBITAT | 4.2 | 5.3 | 5.8 | 4.7 | 1.8 | 3.8 | 3.8 | 3.7 | 3.7 | 3.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 44.1 | 33.8 | -63.1 | 24.4 | -14.3 | 13.3 | 3.7 | 3.7 | 3.7 | 3.7 |
WACC, % | 16.68 | 16.73 | 16.99 | 17.08 | 17.36 | 16.97 | 16.97 | 16.97 | 16.97 | 16.97 |
PV UFCF | ||||||||||
SUM PV UFCF | 20.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 4 | |||||||||
Terminal Value | 25 | |||||||||
Present Terminal Value | 11 | |||||||||
Enterprise Value | 31 | |||||||||
Net Debt | 48 | |||||||||
Equity Value | -17 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | -5.42 |
What You Will Get
- Real IF Bancorp Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on IF Bancorp’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- 🔍 Real-Life IROQ Financials: Pre-filled historical and projected data for IF Bancorp, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate IF Bancorp’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize IF Bancorp’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-built Excel file featuring IF Bancorp, Inc. (IROQ) financial data.
- Customize: Modify forecasts such as loan growth, net interest margin, and capital ratios.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for IF Bancorp, Inc. (IROQ)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, investment managers, and advisors.
- Accurate Data: IF Bancorp’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for investment analysis in IF Bancorp, Inc. (IROQ).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in IF Bancorp, Inc. (IROQ).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into the valuation processes of banking institutions like IF Bancorp, Inc. (IROQ).
What the Template Contains
- Pre-Filled Data: Includes IF Bancorp, Inc.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze IF Bancorp, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.