For tev calculation purposes on this page capital iq

This preview shows page 69 - 75 out of 112 pages.

For TEV calculation purposes on this page Capital IQ only uses balance sheet components from the original filing that is publicly available as of a given pricing date and does not use restated balance sheet data from a later filing. In the cases where a company did not disclose balance sheet values for a particular period, TEV is calculated using balance sheet components from the last reported balance sheet as of this date. The table above is organized along period end dates. ** For companies that have multiple share classes that publicly trade, we are incorporating the different prices to calculate our company level market capitalization. Please click on the value to see the detailed calculation. Prices shown on this page are the close price of the company’s primary stock class. Shares shown on this page are total company as-reported share values.
the firm's CNWC? CAPEX of $7.5 million, and a tax rate of 21%? Standardized IS Relative to Sales 2017 2018 2019 100.00% 100.00% 100.00% 65.00% 65.00% 65.00% 35.00% 35.00% 35.00% 15.45% 15.01% 14.58% 2.73% 2.65% 2.57% 3.64% 3.53% 3.43% 13.18% 13.81% 14.41% 0.00% 0.00% 0.00% 2.44% 2.49% 2.55% 15.62% 16.30% 16.96% 3.28% 3.42% 3.56% 12.34% 12.87% 13.40% BS relative to Assets 2017 2018 2019 3% 3% 3% 5% 5% 5% 8% 8% 8% 3% 3% 3% 3% 3% 3% 5% 5% 6% 16% 16% 17% 68% 69% 70% 8% 10% 11% 60% 59% 59% 14% 14% 15% 6% 6% 6% 4% 4% 4% 100% 100% 100% 2017 2018 2019 8% 8% 8% 10% Err:522 Err:522 2% Err:522 Err:522 20% Err:522 Err:522 22% Err:522 Err:522 42% Err:522 Err:522 44% Err:522 Err:522 15% Err:522 Err:522 58% Err:522 Err:522 100% Err:522 Err:522
FCF=EBIT+ Dep - Tax - CAPEX - CN Type Ratio Formula 2017 Liquidity Current CA/CL 82.04% Quick (CA-Inv)/CL 54.70% Cash Cash/CL 13.67% Solvency Total Debt Ratio (TA-TE)/TL 41.51% Times Interest Earned EBIT/Int #DIV/0! Cash Coverage (EBIT+Dep)/Int #DIV/0! Asset Management Inventory Turn COGS/Inv 6.5 Days' Sales in Inv 365/Inv Turn 56.1538461538462 Receivables Turnover Sales/AR 20 Days' Sales in Rec 365/Rec Turn 18.25 Total Asset Turn Sales/TA 54.05% Profitability Profit Margin NI/Sales 12.34% ROA NI/TA 6.67% ROE NI/TE 11.40% Market Value EPS NI/# Shares 0.23 PE Price per share/ EPS 75.1536228467013 Price-Sales Price per share/ Sales 0.0309% Market-to-Book Market Value per share 5.012 Payout Dividend Payout Ratio Div/NI 0 Retention (b) Addition to RE/ NI 1 Internal Growth Rate ROA*b/(1-ROA*b) 7.15% Sustainable Growth ROE*b/(1-ROE*b) 12.87% Dupont ROE=NI/TE 11.40% ROE=NI/Sales * Sales/Assets * (1+D/E) 11.40% Operating 12.34% Sales 54.05% Leverage 1.70960152182619 ROE 11.40%
Simple Growth Growth 5% 2020 2021 2022 $ 63,669.38 $ 66,852.84 $ 70,195.49 $ 41,385.09 $ 43,454.35 $ 45,627.07 $ 22,284.28 $ 23,398.50 $ 24,568.42 $ 9,285.57 $ 9,749.85 $ 10,237.34 $ 1,638.63 $ 1,720.56 $ 1,806.59 $ 2,184.84 $ 2,294.08 $ 2,408.79 $ 9,175.24 $ 9,634.00 $ 10,115.70 $ - $ - $ - $ 1,621.54 $ 1,702.61 $ 1,787.74 $ 10,796.78 $ 11,336.62 $ 11,903.45 $ 2,267.32 $ 2,380.69 $ 2,499.72 $ 8,529.45 $ 8,955.93 $ 9,403.72 2020 2021 2022 $ 3,183.47 $ 3,342.64 $ 3,509.77 $ 6,246.24 $ 6,558.55 $ 6,886.48 $ 9,429.71 $ 9,901.19 $ 10,396.25 $ 3,183.47 $ 3,342.64 $ 3,509.77 $ 3,183.47 $ 3,342.64 $ 3,509.77 $ 6,366.94 $ 6,685.28 $ 7,019.55 $ 18,980.12 $ 19,929.12 $ 20,925.58 $ 79,586.72 $ 83,566.05 $ 87,744.36 $ 12,726.84 $ 13,363.18 $ 14,031.34 $ 66,859.88 $ 70,202.87 $ 73,713.02 $ 17,146.08 $ 18,003.38 $ 18,903.55 $ 6,300.00 $ 6,615.00 $ 6,945.75 $ 4,725.00 $ 4,961.25 $ 5,209.31 $ 114,011.07 $ 119,711.63 $ 125,697.21 $ 9,429.71 $ 9,901.19 $ 10,396.25 $ 11,787.14 $ 12,376.49 $ 12,995.32 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 $ 30,681.75 $ 32,215.83 $ 33,826.63 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 PoS 2017 2018 2019 1 1 1 0.65 0.65 0.65 0.35 0.35 0.35 0.154545454545455 0.15012987012987 0.145840445269017 0.027272727272727 0.026493506493507 0.025736549165121 0.036363636363636 0.035324675324675 0.034315398886828 0.131818181818182 0.138051948051948 0.144107606679035 NA NA NA 0.024363636363636 0.024907359307359 0.025468068439497 0.156181818181818 0.162959307359307 0.169575675118532 0.032798181818182 0.034221454545455 0.035610891774892 0.123383636363636 0.128737852813853 0.13396478334364
2017 2018 2019 0.05 0.05 0.05 0.1 0.099047619047619 0.098104308390023 0.15 0.149047619047619 0.148104308390023 0.05 0.05 0.05 0.05 0.05 0.05 0.1 0.1 0.1 0.3 0.299047619047619 0.298104308390023 1.25 1.25 1.25 0.145454545454545 0.173852813852814 0.199889507318079 1.10454545454545 1.07614718614719 1.05011049268192 NA NA NA NA NA NA NA NA NA 1.85 1.81883116883117 1.79067367553082 2017 2018 2019 0.15 0.149047619047619 0.148104308390023 0.1875 0.186309523809524 0.185130385487528 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA tatement Restatement: Latest Filings Order: Latest on Right Conversion: Historical Decimals: Capital IQ (Default) Ratio Analysis USD USD Type Ratio Liquidity Current 110,360.0 125,843.0 Quick - - Cash 110,360.0 125,843.0 Solvency Total Debt Ratio Times Interest Earned 38,353.0 42,910.0 Cash Coverage 72,007.0 82,933.0 Inventory Turn 12 months Jun-30-2018 12 months Jun-30-2019
Asset Management Days' Sales in Inv 22,223.0 23,098.0 Receivables Turnover 14,726.0

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture