Foot Locker / Hist.Data / Zero Real Growth
Present Value of Stock using P/S Ratios (Model PV‑STK‑PS)
@SimSim June 10, 2024
This model simulates the Present Value (PV) of a company to long-term shareholders, where the excess cash and all future earnings are assumed to be paid out as dividends. The model also simulates the Net Present Value (NPV) and NPV Ratio.
This model simulates the future share-prices using P/S (Price-To-Sales) ratios so the earnings can be zero or negative.
Earnings - Year 1
Earnings - Year 2
Earnings - Year 3
Earnings - Year 4
Earnings - Year 5
Earnings - Year 6
Earnings - Year 7
Earnings - Year 8
Earnings - Year 9
Earnings - Year 10
Sales - Year 1
Sales - Year 2
Sales - Year 3
Sales - Year 4
Sales - Year 5
Sales - Year 6
Sales - Year 7
Sales - Year 8
Sales - Year 9
Sales - Year 10
P/S Ratio - Year 1
P/S Ratio - Year 2
P/S Ratio - Year 3
P/S Ratio - Year 4
P/S Ratio - Year 5
P/S Ratio - Year 6
P/S Ratio - Year 7
P/S Ratio - Year 8
P/S Ratio - Year 9
P/S Ratio - Year 10
Discount Rate
Tax-Rate Dividends
Tax-Rate Cap-Gains
You can allow others to view, run and copy a simulation.
Only the author can save. Data in this tab is not visible to others.
This model is a BETA-version!
It may not be fully tested and its features may change in the future.
If you have great ideas for improving this model then please contact us.
If you have great ideas for improving this model then please contact us.