保利地产股票价值评估.xlsVIP

Value Working capital Net investDep. RE NOPAT NOPM Equity REV Gen.Input Summary Year Latest Year Growth CAGR Revenue(mil) Reve. Growth rate% 10 years growth forecast CGS SGA RD NOP NOPM 3years NOPM record Avg. NOPM NOP est. Tax rate tax tax rate Avg. NOPAT Tax Tax rate record in the past 3year investdepreciation record Rev. Invest Invest% Depre. Depre.% Net invest Working capital record in the past Acc. Rece. Acc.Pay. Inventory Working Cap. Wor.Cap.% Rev. growth Wor.Cap. Wor.Cap. FCFF Cost of Common Equity Excess Return Period(years) Rev.(mil.) Growth Rate(%) Net Operating Profit Margin(%) Tax Rate(%) Stock Price Shares Outstanding(mil.) 10-year Treasury Yield(%) Bond Spread to Treasury(%) Perferred Stock Yield(%) Depreciation Rate(% of Rev.) Investment Rate(% of Rev.) Working Capital(% of Rev.) Short-Term Liabilities(mil.) Short-Term Assets(mil.) Equity Risk Permium(%) Value of Debt out(mil.) Value of Pref. Stock Out(mil.) Company WACC(%) Company Ticker Company Specific Beta Market Capitalization and After Tax Weighted Average Cost of Capital Long-Term Debt Perferred Stock Common Stock Current Yield After Tax Yield Market Value % Capitalization WACC Yield Disc. Eccess Return Period FCFF Discount Factor Discounted FCFF Est. growth rate Rev. before tax Disc. Residual Value Short-Term Assets Total Corporate Value Less Debt Less Perferred Stocks Less Short-Term Liabilities Total Value to Common Equity Equity Risk Premium(%) 10-year Treasury Bond Yield(%) Growth rate 10-year treasurary yield RE growth 3years ROA record Asset Rev./Asset AVG. 3years Equity/Asset record E/A Equity 10 years RE forecast RE RE/Share Equity/share Intrinsic Stock Value assessed by DCF Intrinsic Stock Value assessed by DRE RE/share Discounted RE DCF DRE RE growth% EPS E EPS/E Intrinsic Stock Value by DCF Intrinsic Stock Value by DRE 保利地产 BLDC Retained Earnings Shares outstanding RES Average Stock Value Standard Deviation Quantitative grade Safety index(α) Company Beta(β) 30~19% Growth % EPS gro