Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 After Aug 04, 2021

Solution

Himanshu answered on Aug 05 2021
147 Votes
Key Stats
    
    Ethan Allen Interiors Inc. (NYSE:ETH) > Financials > Key Stats
    In Millions of the trading cu
ency, except per share items.    Cu
ency:    Trading Cu
ency         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
    Cu
ency    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%
    Diluted 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    -    -
    Cu
ency    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
okers 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 cu
ency only and will not reflect any cu
ency conversion selected above.
    Latest Capitalization (Millions of USD)
    Cu
ency    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 Cu
ent 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 cu
ency, except per share items.    Template:    Standard         Restatement:    Latest Filings
        Period Type:    Annual         Order:    Latest on Right
        Cu
ency:    Reported Cu
ency         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
    Cu
ency    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%
    Cu
ent Domestic Taxes    30.6    16.9    12.0    11.4    2.4    2.4
    Cu
ent Foreign Taxes    0.1    0.4    0.8    0.3    0.3    0.3
    Total Cu
ent Taxes    30.6    17.3    12.8    11.7    2.8    2.8
    Defe
ed Domestic Taxes    0    3.5    0.1    (3.5)    2.5    2.5
    Defe
ed Foreign Taxes    0.7    0.0    (0.2)    0    0    0
    Total Defe
ed 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 cu
ency, except per share items.    Template:    Standard         Restatement:    Latest Filings
        Period Type:    Annual         Order:    Latest on Right
        Cu
ency:    Reported Cu
ency         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
    Cu
ency    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 Cu
ent Assets    -    -    -    8.0    9.0    19.7
    Total Cu
ent 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
    Defe
ed 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
    Cu
. Port. of LT Debt    3.0    2.7    -    -    -    -
    Cu
. Port. of Leases    -    -    0.6    0.6    27.8    34.7
    Unearned Revenue, Cu
ent    -    -    61.2    56.7    64.0    115.3
    Other Cu
ent Liabilities    61.0    63.0    7.2    8.8    3.3    11.5
    Total Cu
ent 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-Cu
.    -    -    4.2    1.1    1.1    2.1
    Other Non-Cu
ent 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 cu
ency, except per share items.    Template:    Standard         Restatement:    Latest Filings
        Period Type:    Annual         Order:    Latest on Right
        Cu
ency:    Reported Cu
ency         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
    Cu
ency    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