> (Ive never been one to value stocks by inputting cashflow, if anyone has a calculater that would help me it would be appreciated)
Hi smaycs4,
I've used the data from the projections in "Exihibit B" in the Disclosure Statement (5/24/2012) to compute STRZQ present value and the result is $4.43 for share using a WACC (Weighted Average Cost of Capital) of 5.5%:
| Discounted Cash Flows Valuation for Star Buffet, Inc. (PINK: STRZQ) |
|
|
|
|
|
|
|
|
|
|
|
| Period | FY | CFFO | CAPEX | FCF | Disc. Factor | Disc. FCF |
| 1 | 2013 | 2609.3 | $ 650 | $ 1,959 | 94.79% | $ 1,857 |
| 2 | 2014 | 2558.1 | $ 550 | $ 2,008 | 89.85% | $ 1,804 |
| 3 | 2015 | 2751 | $ 550 | $ 2,201 | 85.16% | $ 1,874 |
| 4 | 2016 | 3214.4 | $ 550 | $ 2,664 | 80.72% | $ 2,151 |
| 5 | 2017 | 2805.3 | $ 550 | $ 2,255 | 76.51% | $ 1,726 |
| 6 | 2018 | 1881.8 | $ 550 | $ 1,332 | 72.52% | $ 966 |
| 7 | 2019 | 2296.6 | $ 550 | $ 1,747 | 68.74% | $ 1,201 |
| 8 | 2020 | 2339.7 | $ 550 | $ 1,790 | 65.16% | $ 1,166 |
| Residual | ... |
|
| $ 32,540 | 68.74% | $ 22,369 |
|
|
|
|
|
|
|
| | WACC | 5.50% |
|
|
|
|
|
| | Residual growth | 0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Disc. Excess Ret. Period FCF: | $ 12,745 |
|
|
|
|
|
| | Disc. Residual Value: | $ 22,369 |
|
|
|
|
|
| | + Short-Term Assets: | $ 1,234 |
|
|
|
|
|
| | Total Corporate Value: | $ 36,348 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| | - Debt: | $ 17,370 |
|
|
|
|
|
| | - Preferred Stock: | $ - |
|
|
|
|
|
| | - Short-Term Liabilities: | $ 4,734 |
|
|
|
|
|
| | Total Value to Common Equity: | $ 14,244 |
|
|
|
|
|
| | Shares Outstanding: | 3213 |
|
|
|
|
|
| | Intrinsic Stock Value: | $ 4.43 |
|
|
If you want, I can send you also my spreadsheet. |
