The words contained in this file might help you see if this file matches what you are looking for:

...Sheet dcf exercise simple discounted cash flow model amp relative valuation please make a copy do not edit this template company information input in yellow cells name apple ticker aapl gt go to financeyahoocom and type the will pull up share price on date use stock that is below diluted shares outstanding click quot key statistics under column number millions flows analysis most recent revenue page enter ttm means trailingtwelvemonths net income avl common free levered assumptions play around with different of growth rates check out how it changes intrinsic value chart rate for next years fast you expect s earnings grow average each year terminal after perpetuity discount cases represents cost capital just leave constant projected annual forecast period actual future yr margin profits per can keep their margins over time earned every dollar unlevered sum all back present at today worth more than tomorrow your estimate much using method currrent upside potential div graph comparable co...