Skip to content. | Skip to navigation

Personal tools
Sections
You are here: Home Admin MorningstarMappings

MorningstarMappings

Prop new prop aprox. use
Act_Pay AccountsPayable 10
Act_Rec AccountsReceivable 30
Act_Rec_Turn ReceivableTurnover 4
Ast_Turn AssetsTurnover 90
Beta #same 152
Beta_MR   8
Book_Val_to_Shares BookValuePerShare 11
Capex CapitalExpenditure 34
Cash CashAndCashEquivalents 1425
Cash_Flow ChangesInCash 668
Cash_Flow_MR_Gwth_12M   53
Cash_Flow_MR_Gwth   59
Cash_Flow_to_Shares Formula: Cash Flow To Shares 230
Cash_Flow_to_Shares_Gwth_12M   4
Cash_Flow_to_Shares_Gwth   7
Cash_from_Fin FinancingCashFlow 9
Cash_from_Inv InvestingCashFlow 14
Cash_from_Ops OperatingCashFlow 460
Cash_to_Shares Formula: Cash To Shares 14
Common_Eqty CommonStockEquity 47
COGS CostOfRevenue 59
Cur_Assets CurrentAssets 34
Cur_Liab CurrentLiabilities 63
Cur_Ratio CurrentRatio 108
Cur_Ratio_MR   4
Debt_to_Ast_Ratio Formula: Debt to Assets 93
Depreciation Depreciation 1
Deprec_and_Amort DepreciationAndAmortization 32
Div DividendPerShare 525
Div_Gwth   11
Div_MR_Gwth   4
Div_Indicated   91
DCF   119
DCF_BS   3
EPS BasicEPS 3301
EPS_Gwth_12M   20
EPS_Gwth   353
EPS_Gwth_5Q_to_1Q   10
EPS_Gwth_6Q_to_2Q   8
EPS_Cont BasicContinuousOperations 197
EPS_Cont_Gwth_12M   4
EPS_Cont_Gwth   67
EPS_Cont_Gwth_5Q_to_1Q   22
EPS_Cont_Gwth_6Q_to_2Q   15
EPS_Cont_Gwth_7Q_to_3Q   8
EPS_Cont_Gwth_8Q_to_4Q   8
EPS_Cont_MR_Gwth   4
EPS_Dil DilutedEPS 28
EPS_Dil_Gwth   3
EPS_Dil_Cont DilutedContinuousOperations 24
EPS_Dil_Cont_Gwth_12M DilutedContEPSGrowth 0
EPS_Dil_Cont_Gwth   12
EPS_Dil_Cont_Gwth_5Q_to_1Q   4
Est_EPS   850
Chng_Est_EPS_1M   19
Est_EPS_F1Y   155
Chng_Est_EPS_F1Y_1M   4
Est_EPS_Gwth   224
Est_EPS_Gwth_MR   132
Est_EPS_High   18
Est_EPS_High_F1Y   6
Est_EPS_Low   14
Est_EPS_Low_F1Y   6
Est_EPS_Gwth_F1Y   25
Est_EPS_Gwth_MR_12M   98
Earnings_Retained_to_Book Formula: Earnings Retained To Book Value 37
Earnings_Yld EarningYield 6
Exg_Rate_Effects EffectOfExchangeRateChanges 1
Float   16
Free_Cash_Flow_Growth_MR_12M   85
Free_Cash_Flow_Growth_MR   178
Free_Cash_Flow_to_Shares FCFPerShare 212
Free_Cash_Flow_to_Shares_Gwth_12M   4
Free_Cash_Flow_to_Shares_Gwth   5
Intangibles GoodwillAndOtherIntangibleAssets 7
Gr_Inc GrossProfit 21
Gr_Mgn GrossMargin 357
Gr_Op_Inc OperatingIncome 23
Inc_After_Taxes NetIncome 220
Inc_Tax IncomeTaxPayable_1Q 54
Insider_Ownership   28
Insiders_Buy_Trades   110
Insiders_Net_Shares_Purchased   123
Insiders_Sell_Trades   105
Insiders_Shares_Purchased   7
Insiders_Shares_Sold   8
Institutional_Ownership   79
Institutional_Ownership_MR   19
Institutional_Shareholders   28
Institutions_Shares_Purchased   123
Institutions_Shares_Sold   117
Int_Expense InterestExpense 68
Int_Expense_Non_Op InterestExpenseNonOperating 0
Investware_Buy_P   125
Investware_Forecast_High_P   4
Investware_Forecast_Low_P   4
Investware_Tot_Return   3
Invt Inventory 169
Invt_Turn InventoryTurnover 120
Liab_and_Eqty TotalAssets 7
Lt_Debt LongTermDebt 275
Lt_Debt_to_Eqty LongTermDebtEquityRatio 13
Lt_Debt_to_Free_Cash_Flow Formula: Long Term Debt to Free Cash Flow 39
Lt_Debt_to_Tot_Cap LongTermDebtTotalCapitalRatio 4
Lt_Debt_to_Working_Cap Formula: Long Term Debt to Working Capital 3
Lt_Inv LongTermInvestments 4
Lt_Sustainable_Gwth SustainableGrowthRate 0
Market_Cap MarketCap 1650
Market_Cap_MR   9
Net_Fixed_Assets NetPPE 45
Net_Inc NetIncome 931
Net_Inc_Gwth_12M NetIncomeGrowth 19
Net_Inc_Gwth   23
Net_Inc_MR_Gwth   3
Net_Mgn NetMargin 32
Number_EPS_Est   446
Number_EPS_Est_Up   112
Number_EPS_Est_Up_F1Y   4
Number_EPS_Est_Down   105
Number_EPS_Est_Down_F1Y   4
Employees   117
One_Time_Items NonRecurringOperationExpense 35
Op_Inc_Gwth_12M OperationIncomeGrowth 0
Op_Inc_Gwth   16
Op_Inc_Gwth_5Q_to_1Q   7
Op_Mgn OperationMargin 281
Op_Mgn_Avg   6
Other_Cur_Assets OtherCurrentAssets 0
Other_Cur_Liab OtherCurrentLiabilities 3
Other_Inc OtherIncomeExpense 0
Other_Lt_Assets OtherNonCurrentAssets 4
Other_Lt_Liab OtherNonCurrentLiabilities 7
PE PERatio 638
PE_MR   12
PE_Est   5
PE_Avg   35
PE_Rel_Val   157
PE_to_EPS_Est_Gwth   9
PE_to_EPS_Gwth Formula: PE to EPS Growth 9
PE_to_EPS_Gwth_MR   6
Payout_Ratio PayoutRatio 19
Pre_Tax_Inc PretaxIncome 40
Preferred_Stock PreferredStock 32
Pre_Tax_Mgn PretaxMargin 3
P_to_Book PBRatio 210
P_to_Book_MR   13
P_to_CFPS PCFRatio 50
P_to_CFPS_MR   11
P_to_FCFPS Formula: Price to Free Cash Flow 196
P_to_FCFPS_MR   10
P_to_Sales PSRatio 310
P_to_Sales_MR   4
Is_Drp_Plan IsDividendReinvest 2
Q_Surprise_Last_Q #retired 3
Q_Surprise #retired 121
Quick_Ratio QuickRatio 208
Quick_Ratio_MR   81
Rel_Earnings_Gwth   9
Rel_Earnings_Gwth_MR   5
Rel_P_Strength_MR_T6M   5
Rel_Strength_MR   86
Rel_Strength_MR_T1M   25
Rel_Strength_MR_T3M   14
Rel_Strength_MR_T6M   11
Rel_Strength   106
Rel_Strength_T1M   3
Rel_Strength_T3M   4
Rel_Strength_T6M   4
Research_and_Development ResearchAndDevelopment 29
ROA ROA 110
ROA_MR   3
ROE ROE 71
ROE_MR   4
ROE_Avg   8
ROIC

ROIC

3
Thumb Formula: Thumb 6
Sic_Code Sic_Code 29
Sales TotalRevenue 1809
Sales_MR   10
Sales_Gwth_12M RevenueGrowth 50
Sales_Gwth   263
Sales_Gwth_5Q_to_1Q   151
Sales_Gwth_6Q_to_2Q   15
Sales_Gwth_7Q_to_3Q   5
Sales_Gwth_8Q_to_4Q   5
Sales_MR_Gwth   3
Shares BasicAverageShares 1106
St_Debt #Will Create When Data is in 42
Standard_Deviation_EPS_Est   5
Standard_Deviation_EPS_Est_Gwth_Rate   5
Industry MorningstarIndustryCode 979
TIE InterestCoverage 36
TIE_MR   7
Tot_Assets TotalAssets 320
Tot_Liab TotalLiabilities 97
Tot_Liab_Assets_MR   68
Tot_Op_Expenses TotalExpenses 15
Sector   57
Unus_Inc   26
Val_Avg_PE   8
Val_Avg_P_to_FCF   136
Val_Avg_P_to_Sales   111
Val_Via_EPS_and_EPS_Est   162
Val_PE   4
Val_P_to_CF   83
Val_P_to_FCF   43
Val_P_to_Sales   4
Val_Div_Yld   3
Yld DividendYield 116
Yld_MR   7
Yld_Avg   32
Zip #same 50