Steel Plant Financial Model 20 Year 3 Statement

Description
Revenue ProjectionsA. Production & Sales

• Annual Production Capacity: Estimated in metric tons.
  
• Utilization Rate: Expected plant efficiency.
  
• Sales Price per Ton: Based on market trends.
  
• Total Revenue Calculation:
  
• Additional Revenue Streams:
  
  • By-products (slag, gases, etc.)
    
  • Scrap metal sales
    
  • Export incentives & subsidies (if applicable)
    

2. Cost Structure. Direct Costs (COGS - Cost of Goods Sold)

1. Raw Material Costs
   
   • Iron Ore
     
   • Coal
     
   • Scrap Metal
     
   • Gas
     
2. Energy Costs
   

• Electricity
  
• Gas & Fuel
  

Inputs: the manufacturing and sale of Plates, Beams, and Sheets, Coils, Bars, Pipes etc.
CAPEX: Blast Furnace Upgrade or Construction, Basic Oxygen Furnace replacement, Casting Machine Expansion, Roll Mill Modernization, detailed monthly financial tracking. 


Income Statement

• Revenue
  
• (-) Cost of Goods Sold
  
• Gross Profit
  
• (-) Operating Expenses
  
• EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)
  
• (-) Depreciation & Amortization
  
• EBIT (Operating Profit)
  
• (-) Interest Expense
  
• EBT (Earnings Before Tax)
  
• (-) Tax Expense
  
• Net Profit
  

Key Ratios:

• Gross Margin (%) = (Gross Profit / Revenue) * 100
  
• EBITDA Margin (%) = (EBITDA / Revenue) * 100
  
• Net Profit Margin (%) = (Net Profit / Revenue) * 100
  

Cash Flow Statement
Operating Activities

• Net Profit
  
• Add: Non-Cash Items (Depreciation, Amortization)
  
• Add: Changes in Working Capital
  
  • Inventory Changes
    
  • Accounts Receivable/Payable Fluctuations
    

Investing Activities

• Capital Expenditures (CapEx)
  
• Investments in R&D, Joint Ventures
  

Financing Activities

• Debt Financing (Loans, Bond Issuance)
  
• Equity Financing (Investor Funding, Share Issuance)
  
• Repayment of Debt & Interest
  
• Dividend Payments
  

Key Ratios:

• Free Cash Flow (FCF) = Operating Cash Flow - CapEx
  
• Debt Service Coverage Ratio (DSCR) = EBITDA / (Interest + Debt Repayment)
  

Balance Sheet
Assets

• Fixed Assets (PPE - Property, Plant, Equipment)
  
• (-) Accumulated Depreciation
  
• Net Fixed Assets
  
• Current Assets
  
  • Inventory
    
  • Accounts Receivable
    
  • Cash & Equivalents
    

Liabilities & Equity

• Equity
  
  • Share Capital
    
  • Retained Earnings
    
• Debt (Long-Term & Short-Term)
  
• Current Liabilities
  
  • Accounts Payable
    
  • Short-Term Loans
    

Key Ratios:

• Current Ratio = Current Assets / Current Liabilities
  
• Debt-to-Equity Ratio = Total Debt / Total Equity
  
• Return on Assets (ROA) = Net Profit / Total Assets
  

Sensitivity & Scenario Analysis

• Impact of Raw Material Price Fluctuations
  
• Steel Price Variability & Market Demand
  
• Interest Rate Changes on Debt Servicing
  
• Impact of ESG Regulations & Carbon Credits