Reliance Financial Model (Done)
Reliance Financial Model (Done)
Charts
Amount
₹ 4,000,000.00 ₹ 3,000,000.00
₹ 3,000,000.00 ₹ 2,000,000.00
₹ 2,000,000.00
₹ 1,000,000.00
₹ 1,000,000.00
₹-
₹-
2018 2019 2020 2021
2018 2019 2020 2021
₹ 400,000.00
Amount
₹ 800,000.00
₹ 600,000.00 ₹ 300,000.00
₹ 400,000.00 ₹ 200,000.00
₹ 200,000.00 ₹ 100,000.00
₹- ₹-
2018 2019 2020 2021 2018 2019 2020 2021
Net Income
₹ 600,000
₹ 500,000
₹ 400,000
Amount
₹ 300,000
₹ 200,000
₹ 100,000
₹-
2018 2019 2020 2021
EBITAD
₹ 1,200,000.0
₹ 1,000,000.0
₹ 800,000.0
Amount
₹ 600,000.0
₹ 400,000.0
₹ 200,000.0
₹-
2018 2019 2020 2021
EBITAD/Net Income
₹ 1,800,000.0
₹ 1,600,000.0
₹ 1,400,000.0
₹ 1,200,000.0
₹ 1,000,000.0
₹ 800,000.0
₹ 600,000.0
₹ 400,000.0
₹ 200,000.0
₹-
2018 2019 2020 2021
Assumptions
Revenue
Revenue Growth 9.5% 10.0% 12.0% 13.0%
OPEX
Research & Development 0.2% 0.2% 0.2% 0.2%
Other SG&A (OPEX) 45.4% 45.4% 45.4% 45.4%
Depreciation & Amortization Other Model Other Model Other Model Other Model
Interest Payment Other Model Other Model Other Model Other Model
Charts
Amount
₹ 4,000,000.00 ₹ 3,000,000.00
₹ 3,000,000.00 ₹ 2,000,000.00
₹ 2,000,000.00
₹ 1,000,000.00
₹ 1,000,000.00
₹- ₹-
2022 2023 2024 2025 2022 2023 2024 2025
₹ 2,000,000.00 ₹ 1,000,000.0
₹ 1,500,000.00 ₹ 800,000.0
Amount
Amount
₹ 600,000.0
₹ 1,000,000.00
₹ 400,000.0
₹ 500,000.00
₹ 200,000.0
₹-
2022 2023 2024 2025 ₹-
2022 2023 2024 2025
Net Income
₹ 1,000,000.00
₹ 900,000.00
₹ 800,000.00
₹ 700,000.00
₹ 600,000.00
Amount
₹ 500,000.00
₹ 400,000.00
₹ 300,000.00
₹ 200,000.00
₹ 100,000.00
₹-
2022 2023 2024 2025
EBITAD
₹ 1,400,000.0
₹ 1,200,000.0
₹ 1,000,000.0
Amount
₹ 800,000.0
₹ 600,000.0
₹ 400,000.0
₹ 200,000.0
₹-
2022 2023 2024 2025
EBITAD/Net Income
₹ 2,500,000.0
₹ 2,000,000.0
₹ 1,500,000.0
₹ 1,000,000.0
₹ 500,000.0
₹-
2022 2023 2024 2025
CAPEX
Broadband Connectivity Equip. 30 ₹ 1,000.00 ₹ 1,200.00 ₹ 1,440.00 ₹ 1,728.00
Equipments For Subsidiaries 20 ₹ 9,000.00 ₹ 9,900.00 ₹ 10,890.00 ₹ 11,979.00
Machinery 15 ₹ 18,508.48 ₹ 20,789.16 ₹ 20,971.61 ₹ 20,986.21
Gross CAPEX ₹ 28,508.48 ₹ 31,889.16 ₹ 33,301.61 ₹ 34,693.21
Depreciation
Broadband Connectivity Equip. ₹ 33.33 ₹ 73.33 ₹ 121.33 ₹ 178.93
Equipments For Subsidiaries ₹ 450.00 ₹ 945.00 ₹ 1,489.50 ₹ 2,088.45
Machinery ₹ 1,233.90 ₹ 2,619.84 ₹ 4,017.95 ₹ 5,417.03
Gross D&A ₹ 1,717.23 ₹ 3,638.18 ₹ 5,628.78 ₹ 7,684.41
Assumptions
Charts
₹ 40,000.00
₹ 35,000.00
₹ 30,000.00
₹ 25,000.00
₹ 20,000.00
Machinery
₹ 15,000.00 Equipments For Subsidiaries
Broadband Connectivity Equip.
₹ 10,000.00
₹ 5,000.00
₹-
2022 2023 2024 2025
Gross CAPEX
₹ 9,000.00
₹ 8,000.00
₹ 7,000.00
₹ 6,000.00
₹ 5,000.00
₹ 4,000.00 Machinery
Equipments For Subsidiaries
₹ 3,000.00
Broadband Connectivity Equip.
₹ 2,000.00
₹ 1,000.00
₹-
2022 2023 2024 2025
Gross D&A
Balance Sheet (In INR Millions) 2021 2022 2023 2024 2025
(Historical)
Asset
Cash & Short Term Investments ₹ 1,698,430.00 ₹ 1,250,183.02 ₹ 1,111,537.99 ₹ 1,597,565.82 ₹ 2,152,217.38
Cash Only ₹ 173,970.00 ₹ 128,056.11 ₹ 113,854.72 ₹ 163,638.49 ₹ 220,451.39
Short-Term Investments ₹ 1,524,460.00 ₹ 1,122,126.90 ₹ 997,683.28 ₹ 1,433,927.33 ₹ 1,931,765.99
Liabilities
ST Debt & Current Portion LT Debt ₹ 894,940.00 ₹ 980,131.69 ₹ 1,078,144.85 ₹ 1,207,522.24 ₹ 1,364,500.13
Short Term Debt ₹ 600,810.00 ₹ 658,002.68 ₹ 723,802.95 ₹ 810,659.30 ₹ 916,045.01
Current Portion of Long Term Debt ₹ 294,130.00 ₹ 322,129.01 ₹ 354,341.91 ₹ 396,862.94 ₹ 448,455.12
Provision for Risks & Charges ₹ 26,250.00 ₹ 28,748.81 ₹ 31,623.69 ₹ 35,418.53 ₹ 40,022.94
Equity
Assumptions
Assets
Cash 10.2% 10.2% 10.2% 10.2%
Short Term Investments 89.8% 89.8% 89.8% 89.8%
AR 12.6% 12.6% 12.6% 12.6%
Other Current Assets 13.4% 6.0% 13.4% 13.4%
Inventories 22.0% 22.2% 22.2% 22.2%
Other Current Assets 13.4% 13.4% 13.4% 13.4%
LT Investment - Affiliate Companies 17.2% 17.2% 17.2% 17.2%
Other Long-Term Investments 28.4% 21.0% 21.0% 21.0%
Long-Term Note Receivable 1.00% 1.20% 1.40% 1.60%
Net Goodwill 2.2% 2.2% 2.2% 2.2%
Net Other Intangibles 28.9% 28.9% 28.9% 28.9%
Other Assets 9.5% 9.5% 9.5% 9.5%
Other Adjustments ₹ 845,055.51 ₹ 1,665,878.20 ₹ 965,851.89 ₹ 335,182.69
Liabilities
Short Term Debt 12.88% 12.88% 12.88% 12.88%
Current Portion of Long Term Debt 6.3% 6.3% 6.3% 6.3%
Accounts Payable 23.4% 23.4% 23.4% 23.4%
Other Current Liabilities 17.0% 17.0% 17.0% 17.0%
Provision for Risks & Charges 0.6% 0.6% 0.6% 0.6%
Deferred Taxes - Credit 7.9% 7.9% 7.9% 7.9%
Deferred Taxes - Debit 0.2% 0.2% 0.2% 0.2%
Tax Rate (Income Tax) 0.3% 0.3% 0.3% 0.3%
Other Liabilities 7.3% 7.3% 7.3% 7.3%
Debt
Net Borrowings ₹ 9,000.00 ₹ 9,000.00 ₹ - ₹ -
Debt Repayments ₹ 200.00 ₹ 300.00 ₹ 300.00 ₹ 400.00
Interest Rate 8.0% 8.0% 8.0% 8.0%
Interest Payment ₹ 137,208.80 ₹ 137,904.80 ₹ 137,880.80 ₹ 137,848.80
Debt
Minority Interest (Accumulated) Increase 10.1% 10.1% 10.1% 10.1%
Charts
₹ 18,000,000.00
₹ 16,000,000.00
₹ 14,000,000.00
₹ 4,000,000.00 Inventories
Accounts Receivable
₹ 2,000,000.00 Cash & Short Term Investments
₹-
2021 2022 2023 2024
Net Assets
₹ 8,000,000.00
₹ 7,000,000.00
₹ 6,000,000.00
Other Liabilities
₹ 5,000,000.00
Taxes (Income Tax Payable)
₹ 4,000,000.00 Deferred Taxes
Provision for Risks & Charges
₹ 3,000,000.00 Long-Term Debt
Other Current Liabilities
₹ 2,000,000.00
Accounts Payable
₹-
2021 2022 2023 2024
Net Liabilities
₹ 25,000,000.00
₹ 20,000,000.00
₹ 15,000,000.00
Total Equity
₹ 10,000,000.00 Minority Interest (Accumulated)
Total Shareholders' Equity
₹ 5,000,000.00
₹-
2021 2022 2023 2024
Net Equity
Cash Flow Statement (In INR Millions) 2022 2023 2024 2025
Net Income ₹ 602,669.53 ₹ 694,047.50 ₹ 789,207.48 ₹ 904,954.87
Operating Activities
Depreciation ₹ 1,717.23 ₹ 3,638.18 ₹ 5,628.78 ₹ 7,684.41
Changes in AR (Accounts Receivable) ₹ -56,089.40 ₹ -64,530.94 ₹ -85,180.84 ₹ -103,352.75
Changes in AP (Accounts Payable) ₹ 103,661.91 ₹ 119,263.19 ₹ 157,427.41 ₹ 191,011.93
Funds from Operation ₹ 604,386.76 ₹ 697,685.68 ₹ 794,836.26 ₹ 912,639.29
Net Operating Cash Flow ₹ 653,676.51 ₹ 756,056.11 ₹ 872,711.62 ₹ 1,007,982.88
Investing Activities
CAPEX ₹ -1,665,740.00 ₹ -1,667,457.23 ₹ -1,671,095.41 ₹ -1,676,724.19
Net Assets from Acquisitions ₹ -4,000.00 ₹ - ₹ - ₹ -
Sale of Fixed Assets & Businesses ₹ 20,000.00 ₹ 22,000.00 ₹ 24,000.00 ₹ 25,000.00
Purchase/Sale of Investments ₹ -875,470.00 ₹ -174,810.00 ₹ -172,810.00 ₹ -170,000.00
Purchase of Investments ₹ 898,660.00 ₹ 200,000.00 ₹ 200,000.00 ₹ 200,000.00
Sale of Investments ₹ 23,190.00 ₹ 25,190.00 ₹ 27,190.00 ₹ 30,000.00
Net Investing Cash Flow ₹ -2,525,210.00 ₹ -1,820,267.23 ₹ -1,819,905.41 ₹ -1,821,724.19
Financing Activities
New Debt ₹ 9,000.00 ₹ 9,000.00 ₹ - ₹ -
Cash Dividends Paid ₹ -39,210.00 ₹ -39,210.00 ₹ -39,210.00 ₹ -39,210.00
Change in Capital Stock ₹ 800,000.00 ₹ 200,000.00 ₹ 600,000.00 ₹ 400,000.00
Issuance/Reduction of Debt, Net ₹ -200.00 ₹ -300.00 ₹ -300.00 ₹ -400.00
Other Funds ₹ 20.00 ₹ 20.00 ₹ 20.00 ₹ 20.00
Net Financing Cash Flow ₹ 769,610.00 ₹ 169,510.00 ₹ 560,510.00 ₹ 360,410.00
Charts
₹ 1,000,000.00 ₹-
2022 2023 2024 2025
₹ 800,000.00 ₹ -500,000.00
₹ 600,000.00 ₹ -1,000,000.00
₹ 400,000.00 ₹ -1,500,000.00
₹ 200,000.00 ₹ -2,000,000.00
₹- ₹ -2,500,000.00
2022 2023 2024 2025
₹ -200,000.00 ₹ -3,000,000.00
Depreciation Changes in AR (Accounts Receivable) CAPEX Net Assets from Acquisitions
Changes in AP (Accounts Payable) Funds from Operation Sale of Fixed Assets & Businesses Purchase/Sale of Investments
₹ 800,000.00
₹ 600,000.00
₹ 400,000.00
₹ 200,000.00
₹-
2022 2023 2024 2025
₹ -200,000.00
New Debt Cash Dividends Paid
Change in Capital Stock Issuance/Reduction of Debt, Net
Other Funds
₹ 200,000.00
₹ -1,000,000.00 Free Cash Flow Net Cash Flow
₹-
2022 2023 2024 2025
₹ -200,000.00
₹ -1,500,000.00
₹ -400,000.00
₹ -2,000,000.00 ₹ -600,000.00
₹ 500,000.00
₹-
2022 2023 2024 2025
₹ -500,000.00
₹ -1,000,000.00
₹ -1,500,000.00
₹ -2,000,000.00
Free Cash Flow Net Cash Flow