|
Federal Agricultural Mortgage Corporation (AGM) DCF Valuation
US | Financial Services | Financial - Credit Services | NYSE
|
- ✓ 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
Federal Agricultural Mortgage Corporation (AGM) Bundle
Evaluate the financial prospects of Federal Agricultural Mortgage Corporation (AGM) like an expert! This (AGM) DCF Calculator offers pre-filled financials and allows you to easily modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 194.1 | 206.9 | 238.8 | 309.1 | 349.2 | 405.5 | 470.8 | 546.6 | 634.7 | 736.9 |
| Revenue Growth, % | 0 | 6.6 | 15.44 | 29.42 | 12.97 | 16.11 | 16.11 | 16.11 | 16.11 | 16.11 |
| EBITDA | 138.7 | 137.4 | .0 | 645.1 | .0 | 192.9 | 224.0 | 260.0 | 301.9 | 350.6 |
| EBITDA, % | 71.44 | 66.43 | 0 | 208.71 | 0 | 47.57 | 47.57 | 47.57 | 47.57 | 47.57 |
| Depreciation | 466.0 | 82.3 | 73.0 | 64.1 | .0 | 155.0 | 179.9 | 208.9 | 242.6 | 281.7 |
| Depreciation, % | 240.12 | 39.8 | 30.56 | 20.75 | 0 | 38.22 | 38.22 | 38.22 | 38.22 | 38.22 |
| EBIT | -327.4 | 55.1 | -73.0 | 581.0 | .0 | -3.2 | -3.7 | -4.3 | -5.0 | -5.8 |
| EBIT, % | -168.68 | 26.63 | -30.56 | 187.96 | 0 | -0.78635 | -0.78635 | -0.78635 | -0.78635 | -0.78635 |
| Total Cash | 10,707.2 | 11,835.3 | 11,073.7 | 5,489.3 | 5,868.2 | 405.5 | 470.8 | 546.6 | 634.7 | 736.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 237.6 | 223.5 | 222.9 | 276.2 | 337.0 | 388.6 | 451.2 | 523.9 | 608.2 | 706.2 |
| Account Receivables, % | 122.44 | 108.05 | 93.32 | 89.36 | 96.49 | 95.83 | 95.83 | 95.83 | 95.83 | 95.83 |
| Inventories | 1.8 | 1,257.5 | 1,119.9 | 861.0 | .0 | 244.0 | 283.3 | 329.0 | 382.0 | 443.5 |
| Inventories, % | 0.91201 | 607.8 | 468.9 | 278.54 | 0 | 60.18 | 60.18 | 60.18 | 60.18 | 60.18 |
| Accounts Payable | 129.0 | 121.6 | 130.7 | 186.8 | 258.5 | 255.0 | 296.1 | 343.8 | 399.1 | 463.4 |
| Accounts Payable, % | 66.49 | 58.78 | 54.73 | 60.42 | 74.03 | 62.89 | 62.89 | 62.89 | 62.89 | 62.89 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 20.98 | 20.98 | 20.98 | 20.98 | 20.98 | 20.98 | 20.98 | 20.98 | 20.98 | 20.98 |
| EBITAT | -258.6 | 43.6 | -59.3 | 458.6 | .0 | -2.5 | -2.9 | -3.4 | -4.0 | -4.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 97.0 | -1,123.1 | 161.0 | 784.4 | 872.0 | -146.7 | 116.2 | 134.9 | 156.6 | 181.8 |
| WACC, % | 3.94 | 3.95 | 4.03 | 3.94 | 3.95 | 3.96 | 3.96 | 3.96 | 3.96 | 3.96 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 370.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 185 | |||||||||
| Terminal Value | 9,451 | |||||||||
| Present Terminal Value | 7,782 | |||||||||
| Enterprise Value | 8,152 | |||||||||
| Net Debt | 26,799 | |||||||||
| Equity Value | -18,647 | |||||||||
| Diluted Shares Outstanding, MM | 11 | |||||||||
| Equity Value Per Share | -1,704.96 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real AGM financials.
- Actual Data Insights: Historical performance data and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Federal Agricultural Mortgage Corporation (AGM).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and user-friendliness, complete with step-by-step guidance.
Key Features
- Accurate Financial Data: Gain access to reliable historical records and future forecasts for Federal Agricultural Mortgage Corporation (AGM).
- Customizable Assumptions: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments for DCF, Net Present Value (NPV), and cash flow metrics.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation insights.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the comprehensive Excel file featuring Federal Agricultural Mortgage Corporation’s (AGM) financial data.
- Customize: Tailor your projections, including loan growth, net income %, and cost of capital.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare results.
- Make Decisions: Utilize the valuation findings to inform your investment approach.
Why Choose Federal Agricultural Mortgage Corporation (AGM)?
- Support Agriculture: Invest in a company dedicated to enhancing the agricultural sector.
- Stable Returns: Benefit from a solid track record of consistent financial performance.
- Expertise in the Field: Leverage deep industry knowledge and experienced management.
- Commitment to Community: Engage in initiatives that support rural development and farmers.
- Trusted by Investors: Recognized for transparency and reliability in financial practices.
Who Should Use This Product?
- Investors: Evaluate Federal Agricultural Mortgage Corporation’s (AGM) performance before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Farm Operators and Agribusiness Owners: Understand how agricultural finance companies like Federal Agricultural Mortgage Corporation (AGM) are valued.
- Consultants: Provide detailed valuation analyses for agricultural clients.
- Students and Educators: Utilize industry-specific data to learn and teach valuation principles.
What the Template Contains
- Preloaded AGM Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.