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

Financial Statement Analysis DCF Homework Step 1: Use company Freshpet, Inc. Ticker symbol (FRPT) Review their financial statements on yahoo finance. Step 2: Using the "Growing Perpetuity Formula"...

1 answer below »
Financial Statement Analysis DCF Homework
Step 1: Use company Freshpet, Inc. Ticker symbol (FRPT)
Review their financial statements on yahoo finance.
Step 2: Using the "Growing Perpetuity Formula" method of analysis:
P = C1/(R-g)
Determine what is the fair market value of the company based on "Free Cash Flow to the Firm" or "Operating Cash Flow" from the Statement of Cash Flows.
***NOTE: This method using a Growing Perpetuity Formula only works when the Discount Rate  > Growth Rate.***
(When the Discount Rate < or = Growth Rate, the Formula
eaks down). Therefore, for the purpose of this assignment, it is important to make sure that your Discount Rate > Growth Rate. 
 
Step 3: Determine the Growth Rate by using "regression analysis" (using historical data to forecast the growth rate) 
(To determine the growth rate, either use "Free Cash Flow" or "Operating Cash Flow" depending on which historical values are more consistent)
Step 4: Forecast the next year's Free Cash Flow or Operating Cash Flow (use the more conservative estimate)
Step 5: Using CAPM model determine the appropriate discount rate for your growing perpetuity equation. You can use 3% as your Risk-Free Rate and 10% as the Expected Market rate.
CAPM = Rf + B(Er - Rf)
Step 6: Determine the "Enterprise Value" of your company
Enterprise Value = Market Value of Equity + Market Value of Debt
(For the purpose of this assignment, you can disregard Minority Interest and Cash, and you can also assume that the Book Value of Liabilities = Market Value of Debt)
Step 7: (Final Step) Compare the value of your Growing Perpetuity Formula to the "Enterprise Value" for your company. Based on your calculation, is your company overvalued, undervalued, or fairly valued?
Answered Same Day Dec 15, 2021

Solution

Shakeel answered on Dec 16 2021
130 Votes
Sheet1
                                        Year    Operating Cash flow
        Cu
ent Operating cash flow    18,575.00    ( as on 2018)                        1    6,739        Regression Model:
        Next year's Operating cash flow    20,340.50    Using Regression Analysis                        2    12,800        Operating Cash flow = 3851.50 + 3297.80*No. of years
        Growth rate    9.50%                            3    10,270
                                        4    18,575        For 5th year,
        CAPM                                            Forecasted Operating Cash flow            20,340.50    (3851.50 + 3297.80*5)
        Risk free rate    3%                            SUMMARY OUTPUT
        Market return    10%
        Beta    1.05                            Regression Statistics
        Discount...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here