Posted: November 4th, 2022
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
a.Find the WACC at gurufocus.com
b.Consider your growth analysis and industry analysis for the LONG-TERM FCF growth. Remember the FCF growth rate must be LOWER than the WACC.
c.From Morningstar.com, find the short-term investments (if any) listed on the balance sheet.
d.Find the total short-term debt on the balance sheet under the accounting line item Total Current Debt and Capital Lease Obligations
e.Find the total long-term debt on the balance sheet under the accounting line item Long Term Debt and Capital Lease Obligations
f.Add the total short-term debt and long-term debt and enter as the market value of debt on the template.
g.Find the weighted average diluted number of shares from the details on the income statement.
h.Find the revenues from the income statement.
i.Find the cash flow from operations from the statement of cash flows.
j.Find the capital expenditures from the statement of cash flows.
k.Determine the computed stock value (based on the growth rate from your analysis).
l.Table 1. Printout of spreadsheet. Intrinsic valuation.
n.Vary the growth rate until the computed stock value equals the market stock price.
o.Compare the growth rate from your analysis to the growth rate implied by the market price.
p.Table 2. Printout of spreadsheet. Implied market growth rate.
Place an order in 3 easy steps. Takes less than 5 mins.