New/Additional Items: ·Extended DuPont Analysis oDiscuss results of extended DuPont analysis for past 3 years.Include discussion of profit margin, asset turnover ratio and equity multiplier. oDiscuss...

1 answer below »

New/Additional Items:


·Extended DuPont Analysis


oDiscuss results of extended DuPont analysis for past 3 years.Include discussion of profit margin, asset turnover ratio and equity multiplier.


oDiscuss how the various factors/inputs into the Model impacted the performance of your organization.


·Historical Free Cash Flow Analysis


oDiscuss results of FCF analysis for past 3 years.


oUse the historical FCF to factor into and compare with estimates for FCF Valuation


·Valuation based on Free Cash Flow Analysis


oDiscuss the basis for your estimation of weighted average cost of capital (WACC)


oUse Excel templates to assess if your firm’s capital structure is ideal as it currently is


oScenario analysis to see if another capital structure results in a lower cost of capital


oUse the calculated WACC as the basis for your discount FCF valuation.


oIf not enough data to calculate WACC use the industry averages (Damodaran)


oExplain assumptions, risks and uncertainties relating to free cash flow forecast.


oCheck the soundness and logic of your forecast by comparing parameters (such as NOPAT, profit margin, net investments, NWC etc.). Are your growth estimates producing performance metrics that look realistic when comparing year 5 with year 0?If not, make some adjustments.


oRemember the rule of 72 when quickly assessing doubling times in years.


oBased on the above, discuss results of forecast and present value of free cash flow.Explain why you agree / disagree with resulting valuation.


oNote: If your organization is privately held, you might only able to address total value of common equity and not the value of a single share of common stock.



·Valuation Based on Market Multiples


oIf your organization is a publicly traded company:


oExplain what companies you are using for comparison and why you selected them.


oDiscuss market multiples for your organization vs comparison organizations.


oExplain why your organization appears to be receiving higher or lower market multiples than comparison organizations.


oHow might your firm be able to increase its market multiple based valuation?


oUse WACC template to assess if your firm’s capital structure is ideal as it currently is


oIf your organization is a privately held company:


oExplain what companies you are using for comparison and why you selected them.


oDiscuss market multiples for your organization vs comparison organizations.


oExplain why you agree or disagree with the resulting valuation.



·About the organization


oInclude any additional information about the firm that may impact its future growth


oAny strategic issues of the firm that you may not have covered



·Accounting Policies


oProvide additional information on how the organization recognizes revenue


oDiscuss any areas of concern about accounting policies (review notes to financials)


oDiscuss if anything has or is going to change in terms of accounting policies



·Control Environment and Business Ethics


oWhat major ethical issues confront your business and/or industry?


oDoes your organization have a published corporate code of conduct?


§If yes, how is this code of conduct implemented within the organization?


§If no, should the organization consider implementing a code of conduct?


§What resources and commitments would be needed to implement it?


oDiscuss any other Aspects of your organization’s internal control structure and control procedures, including but not limited to:


§How does management ensure that assets are protected?


§How do you ascertain that financial information is reliable?


§Are financial statements audited by a public accounting firm?If so, which one?What was the audit opinion?


§Discuss any issues / concerns relating to audit process.


§Discuss any major actual or contingent liabilities (e.g. potential litigation).


§Discuss any internal control problems experienced by the organization in recent years.



·Check list for ASRP3


oCompany background & Mission


oOverview of the industry and its main competitors


oBalance Sheet & Income Statement (horizontal & vertical analysis)


oReview the financial performance metrics, ratios & multiples


oGenerate the Statement of Cash Flows for your firm


oProduce Common-size Balance Sheet and Income Statement


oDetailed Industry/Competitor Analysis based on Common-size Financials


oDupont Ext.


oCalculate historical free cash flow


oValuation based on discounted free cash flow


oValuation based on market multiples (P/E is preferred)

Answered 1 days AfterAug 04, 2021

Answer To: New/Additional Items: ·Extended DuPont Analysis oDiscuss results of extended DuPont analysis for...

Himanshu answered on Aug 05 2021
145 Votes
Key Stats
    
    Ethan Allen Interiors Inc. (NYSE:ETH) > Financials > Key Stats
    In Millions of the trading currency, except per share items.    Currency:    Trading Currency         Conversion:    Historical
        Order:    Latest on Right         Units:    S&P Capital IQ (Default)
        Decimals:    Capital IQ (Default)         Dilution:    Basic
    Key Financials¹
    For the Fiscal Period Ending    12 months
Jun-30-2016A    12 months
Jun-30-2017A    12 months
Jun-30-2018A    12 months
Jun-30-2019A    12 months
Jun-30-2020A    LTM²
12 months
Mar-31-2021A    12 months†
Jun-30-2021E    12 months
Jun-30-2022E
    Currency    USD    USD    USD    USD    USD    USD    USD    USD
    Total Revenue    794.2    763.4    766.8    746.7    589.8    598.4    685.1    747.75
    Growth Over Prior Year    5.2%    (3.9%)    0.4%    (2.6%)    (21.0%)    (12.3%)    16.15%    9.14%
    Gross Profit    442.2    419.7    416.0    411.5    328.6    337.7    -    -
    Margin %    55.7%    55.0%    54.2%    55.1%    55.7%    56.4%    57.45%    56.60%
    EBITDA    108.5    78.1    68.7    74.1    33.9    67.2    97.45    101.25
    Margin %    13.7%    10.2%    9.0%    9.9%    5.7%    11.2%    14.22%    13.54%
    EBIT    89.2    58.0    48.9    54.6    17.1    50.9    79.95    82.8
    Margin %    11.2%    7.6%    6.4%    7.3%    2.9%    8.5%    11.67%    11.07%
    Earnings from Cont. Ops.    56.6    36.2    36.4    25.7    8.9    29.8    -    -
    Margin %    7.1%    4.7%    4.7%    3.4%    1.5%    5.0%    -    -
    Net Income    56.6    36.2    36.4    25.7    8.9    29.8    59.55    61.8
    Margin %    7.1%    4.7%    4.7%    3.4%    1.5%    5.0%    8.69%    8.26%
    D
iluted EPS Excl. Extra Items³    2.0    1.29    1.32    0.96    0.34    1.17    2.36    2.44
    Growth Over Prior Year    57.5%    (35.5%)    2.3%    (27.3%)    (64.6%)    74.8%    352.88%    3.75%
    Same Store Sales Growth %    8.3%    (4.6%)    NA    NA    NA    NA    -    -
    Currency    USD    USD    USD    USD    USD    USD    USD    USD
    Exchange Rate    1.0    1.0    1.0    1.0    1.0    1.0    1.0    1.0
    Conversion Method    H    H    H    H    H    H    S    S
    ¹All results are taken from the most recently filed statement for each period. When there has been more than one, earlier filings can be viewed on the individual statement pages.
    ²Growth rates for the LTM period are calculated against the LTM period ending 12 months before.
    ³All forward period figures are consensus mean estimates provided by the brokers and may not be on a comparable basis as financials.
    †Growth rates for forward periods are calculated against prior period estimates or actual pro forma results as disclosed on the Estimates Consensus page.
    Growth Rates are calculated in originally reported currency only and will not reflect any currency conversion selected above.
    Latest Capitalization (Millions of USD)
    Currency    USD
    Share Price    $23.61
    Shares Out.    25.2
    Market Capitalization    594.9
    Class A Common Stock Shares Out    25.2
    * Class A Common Stock Share Price    23.6
    = Class A Common Stock Market Capitalization    594.9
    + Class B Common Stock Shares Out    0
    * Class B Common Stock Share Price    23.6
    = Class B Common Stock Market Capitalization    0
    - Cash & Short Term Investments    109.0
    + Total Debt    133.4
    + Pref. Equity    -
    + Total Minority Interest    0
    - Long Term Marketable Securities    -
    = Total Enterprise Value (TEV)    619.4
    Book Value of Common Equity    356.6
    + Pref. Equity    -
    + Total Minority Interest    0
    + Total Debt    133.4
    = Total Capital    490.0
    **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.
    Total Liability includes Total Debt, Minority Interest and Pref. Equity.
    Net Liability includes Total Liability, net of Cash and Short Term Investments.
    TEV includes Market Cap and Net Liability.
    Total Capital includes Common Equity and Total Liability.
    Valuation Multiples based on Current Capitalization
    For the Fiscal Period Ending    12 months
Jun-30-2019A    12 months
Jun-30-2020A    LTM
12 months
Mar-31-2021A    12 months
Jun-30-2021E    12 months
Jun-30-2022E
    TEV/Total Revenue    0.8x    1.2x    1.0x    0.89x    0.82x
    TEV/EBITDA    8.4x    9.4x    5.9x    6.28x    6.04x
    TEV/EBIT    11.3x    41.2x    12.2x    7.65x    7.39x
    P/Diluted EPS Before Extra    24.6x    69.4x    20.2x    9.89x    9.54x
    P/BV    1.7x    1.8x    1.7x    -    -
    Price/Tang BV    2.0x    2.1x    1.9x    -    -
Income Statement
    
    Ethan Allen Interiors Inc. (NYSE:ETH) > Financials > Income Statement
    In Millions of the reported currency, except per share items.    Template:    Standard         Restatement:    Latest Filings
        Period Type:    Annual         Order:    Latest on Right
        Currency:    Reported Currency         Conversion:    Historical
        Units:    S&P Capital IQ (Default)         Decimals:    Capital IQ (Default)
        Source:    Capital IQ & Proprietary Data     
    Income Statement
    For the Fiscal Period Ending    12 months
Jun-30-2016    12 months
Jun-30-2017    12 months
Jun-30-2018    Reclassified
12 months
Jun-30-2019    12 months
Jun-30-2020    LTM
12 months
Mar-31-2021
    Currency    USD    USD    USD    USD    USD    USD
    Revenue    794.2    763.4    766.8    746.7    589.8    598.4
    Other Revenue    -    -    -    -    -    -
    Total Revenue    794.2    763.4    766.8    746.7    589.8    598.4
    Cost Of Goods Sold    352.0    343.7    350.8    335.2    261.3    260.7
    Gross Profit    442.2    419.7    416.0    411.5    328.6    337.7
    Selling General & Admin Exp.    353.1    361.8    367.1    356.9    310.9    286.1
    R & D Exp.    -    -    -    -    -    -
    Depreciation & Amort.    -    -    -    -    0.6    0.7
    Other Operating Expense/(Income)    -    -    -    -    -    -
    Other Operating Exp., Total    353.1    361.8    367.1    356.9    311.5    286.8
    Operating Income    89.2    58.0    48.9    54.6    17.1    50.9
    Interest Expense    (1.6)    (1.0)    -    (0.1)    (0.5)    (0.7)
    Interest and Invest. Income    0.4    -    0.2    -    0.0    0.0
    Net Interest Exp.    (1.2)    (1.0)    0.2    (0.1)    (0.5)    (0.7)
    Other Non-Operating Inc. (Exp.)    -    -    -    -    -    (0.9)
    EBT Excl. Unusual Items    88.0    57.0    49.1    54.5    16.6    49.3
    Restructuring Charges    -    -    -    (20.7)    (2.4)    (10.0)
    Impairment of Goodwill    -    -    -    -    -    -
    Asset Writedown    -    -    -    -    -    (0.1)
    Other Unusual Items    -    -    -    -    -    -
    EBT Incl. Unusual Items    88.0    57.0    49.1    33.9    14.2    39.2
    Income Tax Expense    31.3    20.8    12.7    8.2    5.3    9.4
    Earnings from Cont. Ops.    56.6    36.2    36.4    25.7    8.9    29.8
    Earnings of Discontinued Ops.    -    -    -    -    -    -
    Extraord. Item & Account. Change    -    -    -    -    -    -
    Net Income to Company    56.6    36.2    36.4    25.7    8.9    29.8
    Minority Int. in Earnings    -    -    -    -    -    -
    Net Income    56.6    36.2    36.4    25.7    8.9    29.8
    Pref. Dividends and Other Adj.    -    -    -    -    -    -
    NI to Common Incl Extra Items    56.6    36.2    36.4    25.7    8.9    29.8
    NI to Common Excl. Extra Items    56.6    36.2    36.4    25.7    8.9    29.8
    Per Share Items
    Basic EPS    $2.02    $1.31    $1.33    $0.96    $0.34    $1.18
    Basic EPS Excl. Extra Items    2.02    1.31    1.33    0.96    0.34    1.18
    Weighted Avg. Basic Shares Out.    28.1    27.7    27.3    26.7    26.0    25.2
    Diluted EPS    $2.0    $1.29    $1.32    $0.96    $0.34    $1.17
    Diluted EPS Excl. Extra Items    2.0    1.29    1.32    0.96    0.34    1.17
    Weighted Avg. Diluted Shares Out.    28.3    28.0    27.6    26.8    26.1    25.3
    Normalized Basic EPS    $1.96    $1.29    $1.12    $1.28    $0.4    $1.22
    Normalized Diluted EPS    1.94    1.27    1.11    1.27    0.4    1.22
    Dividends per Share    $0.62    $0.74    $0.76    $0.76    $0.84    $0.92
    Payout Ratio %    29.4%    55.3%    81.1%    79.0%    241.2%    56.8%
    Supplemental Items
    EBITDA    108.5    78.1    68.7    74.1    33.9    67.2
    EBITA    89.2    58.0    48.9    54.6    17.1    50.9
    EBIT    89.2    58.0    48.9    54.6    17.1    50.9
    EBITDAR    138.4    109.4    NA    106.5    74.4    NA
    Effective Tax Rate %    35.6%    36.5%    25.9%    24.1%    37.3%    24.1%
    Current Domestic Taxes    30.6    16.9    12.0    11.4    2.4    2.4
    Current Foreign Taxes    0.1    0.4    0.8    0.3    0.3    0.3
    Total Current Taxes    30.6    17.3    12.8    11.7    2.8    2.8
    Deferred Domestic Taxes    0    3.5    0.1    (3.5)    2.5    2.5
    Deferred Foreign Taxes    0.7    0.0    (0.2)    0    0    0
    Total Deferred Taxes    0.7    3.5    (0.1)    (3.5)    2.5    2.5
    Normalized Net Income    55.0    35.6    30.7    34.1    10.4    30.8
    Interest on Long Term Debt    NA    0.8    NA    0.5    0.5    NA
    Filing Date    Aug-02-2018    Aug-09-2019    Aug-27-2020    Aug-27-2020    Aug-27-2020    Apr-30-2021
    Restatement Type    NC    NC    NC    RC    O    O
    Calculation Type    REP    REP    REP    REP    REP    LTM
    Supplemental Operating Expense Items
    Advertising Exp.    34.1    39.7    43.3    30.5    29.1    NA
    Selling and Marketing Exp.    105.8    111.0    116.9    106.1    93.5    93.5
    Net Rental Exp.    29.9    31.4    NA    32.4    40.5    NA
    Imputed Oper. Lease Interest Exp.    6.6    8.5    -    16.4    1.8    -
    Imputed Oper. Lease Depreciation    23.4    22.8    -    16.0    38.7    -
    Stock-Based Comp., SG&A Exp.    2.4    1.3    1.0    0.1    0.3    1.1
    Stock-Based Comp., Total    2.4    1.3    1.0    0.1    0.3    1.1
    Note: For multiple class companies, per share items are primary class equivalent, and for foreign companies listed as primary ADRs, per share items are ADR-equivalent.
Balance Sheet
    
    Ethan Allen Interiors Inc. (NYSE:ETH) > Financials > Balance Sheet
    In Millions of the reported currency, except per share items.    Template:    Standard         Restatement:    Latest Filings
        Period Type:    Annual         Order:    Latest on Right
        Currency:    Reported Currency         Conversion:    Historical
        Units:    S&P Capital IQ (Default)         Decimals:    Capital IQ (Default)
        Source:    Capital IQ & Proprietary Data     
    Balance Sheet
    Balance Sheet as of:    Jun-30-2016    Jun-30-2017    Jun-30-2018    Jun-30-2019    Jun-30-2020    Mar-31-2021
    Currency    USD    USD    USD    USD    USD    USD
    ASSETS
    Cash And Equivalents    52.7    57.7    22.4    20.8    72.3    109.0
    Total Cash & ST Investments    52.7    57.7    22.4    20.8    72.3    109.0
    Accounts Receivable    9.5    12.3    12.4    14.2    8.1    11.6
    Total Receivables    9.5    12.3    12.4    14.2    8.1    11.6
    Inventory    162.3    149.5    163.0    162.4    126.1    135.7
    Prepaid Exp.    23.8    23.6    16.7    10.8    14.5    15.2
    Other Current Assets    -    -    -    8.0    9.0    19.7
    Total Current Assets    248.2    243.1    214.4    216.3    230.0    291.1
    Gross Property, Plant & Equipment    598.3    605.2    611.0    591.4    675.9    -
    Accumulated Depreciation    (324.6)    (335.0)    (343.1)    (346.1)    (329.9)    -
    Net Property, Plant & Equipment    273.6    270.2    267.9    245.2    346.0    347.9
    Goodwill    25.4    25.4    25.4    25.4    25.4    25.4
    Other Intangibles    19.7    19.7    19.7    19.7    19.7    19.7
    Deferred Tax Assets, LT    -    -    1.7    2.1    0.1    1.7
    Other Long-Term Assets    10.5    9.8    1.3    1.6    1.6    1.6
    Total Assets    577.4    568.2    530.4    510.4    622.8    687.5
    LIABILITIES
    Accounts Payable    15.4    17.0    33.3    34.2    25.5    36.8
    Accrued Exp.    44.0    43.8    18.9    22.6    18.3    27.8
    Curr. Port. of LT Debt    3.0    2.7    -    -    -    -
    Curr. Port. of Leases    -    -    0.6    0.6    27.8    34.7
    Unearned Revenue, Current    -    -    61.2    56.7    64.0    115.3
    Other Current Liabilities    61.0    63.0    7.2    8.8    3.3    11.5
    Total Current Liabilities    123.3    126.4    121.3    122.8    139.0    225.9
    Long-Term Debt    38.8    11.6    -    -    50.0    -
    Long-Term Leases    -    -    1.1    0.5    102.2    98.8
    Def. Tax Liability, Non-Curr.    -    -    4.2    1.1    1.1    2.1
    Other Non-Current Liabilities    23.0    29.3    20.0    22.0    2.4    4.2
    Total Liabilities    185.2    167.3    146.6    146.4    294.7    331.0
    Common Stock    0.5    0.5    0.5    0.5    0.5    0.5
    Additional Paid In Capital    375.0    377.6    377.0    377.9    378.3    381.0
    Retained Earnings    646.3    662.0    669.0    647.7    638.6    662.5
    Treasury Stock    (624.9)    (635.2)    (656.6)    (656.6)    (680.9)    (681.0)
    Comprehensive Inc. and Other    (4.8)    (4.1)    (6.2)    (5.7)    (8.4)    (6.5)
    Total Common Equity    392.0    400.7    383.7    363.9    328.1    356.6
    Minority Interest    0.2    0.2    0.1    0.1    0    0
    Total Equity    392.2    400.9    383.9    363.9    328.1    356.6
    Total Liabilities And Equity    577.4    568.2    530.4    510.4    622.8    687.5
    Supplemental Items
    Total Shares Out. on Filing Date    27.7    27.4    26.5    26.6    25.1    25.2
    Total Shares Out. on Balance Sheet Date    27.7    27.4    26.5    26.6    25.1    25.2
    Book Value/Share    $14.13    $14.6    $14.46    $13.69    $13.09    $14.16
    Tangible Book Value    346.9    355.6    338.6    318.7    282.9    311.5
    Tangible Book Value/Share    $12.5    $12.95    $12.76    $11.99    $11.29    $12.37
    Total Debt    41.8    14.3    1.7    1.1    180.1    133.4
    Net Debt    (10.8)    (43.4)    (20.7)    (19.8)    107.8    24.5
    Debt Equivalent Oper. Leases    239.3    250.8    NA    259.2    323.9    NA
    Total Minority Interest    0.2    0.2    0.1    0.1    0    0
    Inventory Method    FIFO    FIFO    FIFO    FIFO    FIFO    NA
    Raw Materials Inventory    27.6    26.3    27.9    26.7    21.3    25.6
    Work in Progress Inventory    9.5    10.6    12.1    9.2    9.6    10.7
    Finished Goods Inventory    129.6    117.4    124.6    128.0    97.7    102.2
    Land    80.0    79.2    82.9    83.3    83.1    NA
    Buildings    392.2    400.2    404.5    384.6    361.3    NA
    Machinery    126.1    125.8    123.6    123.4    122.2    NA
    Full Time Employees    5,200    5,200    5,200    4,700    3,369    NA
    Accum. Allowance for Doubtful Accts    1.6    NA    NA    NA    NA    NA
    Order Backlog    NA    NA    NA    46.4    63.8    NA
    Filing Date    Aug-02-2018    Aug-09-2019    Aug-27-2020    Aug-27-2020    Aug-27-2020    Apr-30-2021
    Restatement Type    NC    NC    NC    NC    O    O
    Calculation Type    RUP    RUP    RUP    REP    REP    REP
    Note: For multiple class companies, total share counts are primary class equivalent, and for foreign companies listed as primary ADRs, total share counts are ADR-equivalent.
Cash Flow
    
    Ethan Allen Interiors Inc. (NYSE:ETH) > Financials > Cash Flow
    In Millions of the reported currency, except per share items.    Template:    Standard         Restatement:    Latest Filings
        Period Type:    Annual         Order:    Latest on Right
        Currency:    Reported Currency         Conversion:    Historical
        Units:    S&P Capital IQ (Default)         Decimals:    Capital IQ (Default)
        Source:    Capital IQ & Proprietary Data     
    Cash Flow
    For the Fiscal Period Ending    12 months
Jun-30-2016    Restated
12 months
Jun-30-2017    Restated
12 months
Jun-30-2018    12 months
Jun-30-2019    12 months
Jun-30-2020    LTM
12 months
Mar-31-2021
    Currency    USD    USD    USD    USD    USD    USD
    Net...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here