DCF Tool

IMKTA

Ingles Markets, Inc. – Supermarkets and Other Grocery (except Convenience) Stores
since 1963, ingles markets, inc. has been western north carolina's leading local supermarket. ingles is a publicly held, locally owned company with over 200 retail locations operating in 6 southeastern states including alabama, georgia, tennessee, virginia, and the carolinas. mr. ingle’s commitment to our associates, customers, and communities has been our guiding force. our dedicated workforce has risen to the challenge of meeting our goals, today, and as we proceed into the future. our company standard couples old-fashioned values with progressive vision.
Analysis Results
Intrinsic Value $973.25
Latest Price $76.71
Relative Value 92% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Millions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 16.8%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 4.5%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 16.8%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (million) Present value (million)
2024 289 277
2025 338 309
2026 395 346
2027 462 387
2028 539 432
Terminal Value

Assuming the company was sold after the projection period at an exit multiple of 30, the terminal value of the company would be 16200 million. This corresponds to a present value of 12400 million.

Intrinsic Value Per Share

The total present value of the projected cash flows is 1750 million. Adding in the terminal value gives a total present value of 14100 million.

There are presently 14.5 million outstanding shares, so the intrinsic value per share is 973.25.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 952,556,345
Current Cash 328,539,922
Current Liabilities 330,533,149
Current Debt 18,161,848
Non-Cash Working Capital (NCWC) 311,645,122
Change in NCWC 56,868,199
EBIT 289,534,381
Tax Provision 67,693,000
Depreciation and Amortization 115,979,172
Capital Expenditure -173,591,468
Unlevered Free Cash Flow 218,416,489
Current Assets 838,131,702
Current Cash 267,198,517
Current Liabilities 333,777,051
Current Debt 17,620,789
Non-Cash Working Capital (NCWC) 254,776,923
Change in NCWC 43,146,450
EBIT 375,574,475
Tax Provision 88,511,000
Depreciation and Amortization 117,801,654
Capital Expenditure -119,608,974
Unlevered Free Cash Flow 324,897,996
Current Assets 575,440,415
Current Cash 75,313,350
Current Liabilities 306,097,331
Current Debt 17,600,739
Non-Cash Working Capital (NCWC) 211,630,473
Change in NCWC 52,854,499
EBIT 340,101,715
Tax Provision 77,883,000
Depreciation and Amortization 117,103,658
Capital Expenditure -140,597,162
Unlevered Free Cash Flow 288,611,144
Current Assets 470,186,860
Current Cash 6,903,955
Current Liabilities 323,812,907
Current Debt 19,305,976
Non-Cash Working Capital (NCWC) 158,775,974
Change in NCWC -61,223,034
EBIT 276,502,727
Tax Provision 56,443,000
Depreciation and Amortization 116,282,239
Capital Expenditure -122,767,178
Unlevered Free Cash Flow 142,396,059
Current Assets 497,103,371
Current Cash 42,125,105
Current Liabilities 247,579,389
Current Debt 12,600,131
Non-Cash Working Capital (NCWC) 219,999,008
Change in NCWC -18,916,727
EBIT 148,140,748
Tax Provision 25,018,000
Depreciation and Amortization 112,520,100
Capital Expenditure -161,751,023
Unlevered Free Cash Flow 45,225,230
Current Assets 496,743,116
Current Cash 10,537,303
Current Liabilities 260,138,091
Current Debt 12,848,013
Non-Cash Working Capital (NCWC) 238,915,735
Change in NCWC 50,340,729
EBIT 124,095,255
Tax Provision -17,046,000
Depreciation and Amortization 113,082,675
Capital Expenditure -150,486,508
Unlevered Free Cash Flow 137,032,151
Current Assets 445,840,014
Current Cash 23,912,100
Current Liabilities 245,563,479
Current Debt 12,210,571
Non-Cash Working Capital (NCWC) 188,575,006
Change in NCWC 7,371,084
EBIT 126,448,144
Tax Provision 30,388,000
Depreciation and Amortization 110,929,378
Capital Expenditure -127,695,650
Unlevered Free Cash Flow 71,450,841
Current Assets 418,487,439
Current Cash 5,679,509
Current Liabilities 241,604,637
Current Debt 10,000,629
Non-Cash Working Capital (NCWC) 181,203,922
Change in NCWC -2,994,946
EBIT 129,810,547
Tax Provision 30,445,000
Depreciation and Amortization 106,587,686
Capital Expenditure -137,642,132
Unlevered Free Cash Flow 49,065,260
Current Assets 432,296,094
Current Cash 7,505,040
Current Liabilities 253,243,507
Current Debt 12,651,321
Non-Cash Working Capital (NCWC) 184,198,868
Change in NCWC 17,154,817
EBIT 136,990,787
Tax Provision 35,105,000
Depreciation and Amortization 102,876,964
Capital Expenditure -104,055,949
Unlevered Free Cash Flow 102,054,517
Current Assets 413,917,298
Current Cash 8,613,628
Current Liabilities 250,748,019
Current Debt 12,488,400
Non-Cash Working Capital (NCWC) 167,044,051
Change in NCWC -18,334,764
EBIT 122,519,301
Tax Provision 28,350,000
Depreciation and Amortization 97,663,587
Capital Expenditure -108,338,402
Unlevered Free Cash Flow 49,970,281
Current Assets 434,540,068
Current Cash 16,844,007
Current Liabilities 251,274,007
Current Debt 18,956,761
Non-Cash Working Capital (NCWC) 185,378,815
Change in NCWC 20,081,825
EBIT 121,312,471
Tax Provision 5,447,000
Depreciation and Amortization 94,889,139
Capital Expenditure -101,453,001
Unlevered Free Cash Flow 109,650,698
Current Assets 426,203,869
Current Cash 4,683,410
Current Liabilities 306,151,733
Current Debt 49,928,264
Non-Cash Working Capital (NCWC) 165,296,990
Change in NCWC 44,473,758
EBIT 123,176,817
Tax Provision 23,903,000
Depreciation and Amortization 90,530,952
Capital Expenditure -180,628,852
Unlevered Free Cash Flow 33,834,610

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.