Please read more about these assumptions here: You can modify this for each FY and for each stock.ġ5% x total capital = enterprising interest.ĭefensive Income = Free Cash Flow – change in working capital since last FY. This is based on: Earnings Power Valuation ModelĮnterprising EPS = (Enterprising Income)/(Shares Outstanding)ĭefensive EPS = (Defensive Income)/(Shares Outstanding)Įnterprising Income = Net Income – (15% x total capital)ġ5% here is the weighted average cost of capital (WACC) and is an expected return. The idea is to spot where a company falls in. This is a plot of two the Defensive EPS (earnings per share) vs Enterprising EPS The financial data can be analysed (rolling growth in EPS, operating margin etc.) and visualised via graphs in the Analysis and Graphs sheets. Update: See belowīefore we consider each valuation method, the Read me first sheet gives an overview of all features available. This will copy the financials from the morningstar file and the rest of analysis is automated (with the exception of a few subjective inputs).ĥ: Stock price history can be obtained from Google Finance via a macro. This is how the data sheet looks for Apple Inc.Ĥ: Now open the freefincal stock analyzer (download link below) and follow the steps listed in the inputs page. New Tool! => Track your mutual funds and stocks investments with this Google Sheet!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |