DCF Tool

SONY

Sony Group Corporation – Consumer Lending
Analysis Results
Intrinsic Value $247.52
Latest Price $89.94
Relative Value 64% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
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 4.7%.

Weighted Average Cost of Capital (WACC)

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

Value of Future Flows

Assuming a growth rate of 4.7%, 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 (billion) Present value (billion)
2022 17.8 16.5
2023 18.7 16.0
2024 19.6 15.6
2025 20.5 15.1
2026 21.5 14.7
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 370 billion. This corresponds to a present value of 234 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 77.9 billion. Adding in the terminal value gives a total present value of 312 billion.

There are presently 1.26 billion outstanding shares, so the intrinsic value per share is 247.52.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 187,683,370,795
Current Cash 11,633,602,535
Current Liabilities 73,463,686,513
Current Debt 6,905,959,831
Non-Cash Working Capital (NCWC) 109,492,041,577
Change in NCWC 5,927,569,775
EBIT 8,833,531,461
Tax Provision 8,974,846
Depreciation and Amortization 5,986,872,362
Capital Expenditure -4,620,368,477
Unlevered Free Cash Flow 16,120,233,782
Current Assets 168,044,508,220
Current Cash 8,888,647,867
Current Liabilities 59,859,263,701
Current Debt 4,267,875,150
Non-Cash Working Capital (NCWC) 103,564,471,802
Change in NCWC 12,559,932,074
EBIT 7,775,901,967
Tax Provision 1,636,651,829
Depreciation and Amortization 6,894,747,982
Capital Expenditure -4,061,942,803
Unlevered Free Cash Flow 21,445,189,262
Current Assets 150,147,582,960
Current Cash 8,662,743,177
Current Liabilities 56,961,443,059
Current Debt 6,481,143,004
Non-Cash Working Capital (NCWC) 91,004,539,728
Change in NCWC 593,069,427
EBIT 7,419,798,206
Tax Provision 406,747,881
Depreciation and Amortization 6,516,543,364
Capital Expenditure -2,819,798,764
Unlevered Free Cash Flow 11,378,846,928
Current Assets 149,334,678,995
Current Cash 11,227,438,257
Current Liabilities 54,819,233,156
Current Debt 7,123,462,719
Non-Cash Working Capital (NCWC) 90,411,470,300
Change in NCWC 9,979,769,460
EBIT 6,953,018,117
Tax Provision 1,428,087,509
Depreciation and Amortization 6,781,632,561
Capital Expenditure -2,474,608,329
Unlevered Free Cash Flow 19,730,247,301
Current Assets 128,619,464,401
Current Cash 6,239,266,577
Current Liabilities 47,778,065,914
Current Debt 5,829,568,929
Non-Cash Working Capital (NCWC) 80,431,700,839
Change in NCWC 6,005,514,476
EBIT 3,947,822,508
Tax Provision 1,118,929,878
Depreciation and Amortization 5,633,099,136
Capital Expenditure -3,008,054,176
Unlevered Free Cash Flow 10,631,951,171
Current Assets 117,280,748,694
Current Cash 6,690,471,906
Current Liabilities 43,222,287,631
Current Debt 7,058,197,206
Non-Cash Working Capital (NCWC) 74,426,186,363
Change in NCWC 9,465,689,680
EBIT 3,032,629,915
Tax Provision 842,082,319
Depreciation and Amortization 6,189,117,153
Capital Expenditure -3,335,059,611
Unlevered Free Cash Flow 14,408,350,270

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.