For all of the expensive subscriptions and analytics programs, a huge amount of the work that Wall Street analysts and managers do is done on the Excel software that you have on your own computer. With just𓆏 a little bit of effort, you too can create a variety of financial and analytical models, and investing the additional time and energy to learn about macros can give you even more options.

Company Financial Models

The core of what every sell-side analyst (and many buy-side analysts) does is the creation of a company’s financial models. These are simply spreadsheets that hold (and help form) the anal💖yst's views on the likely financial results for the company in question.🙈

They ca✨n be incredibly detailed and complex, or relatively simplistic, but the model will never be any better than the quality of the work thatಞ goes into forming the estimates. In other words, elaborate guesswork is still just guesswork.

Financial models are usually built with the x-axis serving as the time (quarters and full years) and the y-axis🎉 breaking down the results by line item (i.e., revenue, cost of goods sold, etc.)

It is not at all uncommon to have a separate sheet generating the revenue estimate; whether that is a per-segment basis for a large conglomerate like United Technologies or General Electric or a more simple units-sold-and-estimated selling price for a smaller, simpler co🔯mpany.

For these models, the model-builder needs to input estimates for certain items (i.e., revenue, COGS/gross margin, SG&A/sales) and then make sure that the mathematical formulas are correct.♛

From this base, it is also possible to build sophisticated and interconnected models for the income statement, balance sheet, and cash flow statement, as well as macros that allow investors to create "bull/bear/base" scenarios that can be changed with a click or two.

Although most would deny it, surprisingly few buy-side analysts actually build their own company models from scratch. Instead, they will essentially copy the models built by sell-side analysts and "澳洲幸运5开奖号码历史查询:stress test" them to see how the numb﷽ers respond to a variety of circu𝓀mstances.

Valuation Models

Even if you don't build your own company models, you should seriously consider building your own 澳洲幸运5开奖号码历史查询:valuation models. Some investors are content with using simple metrics like price-earnings, price-earnings-growth, or EV/EBITDA, and if that works for you then there's 𓆉no reason to change. Investors who want a more rigorous approach, though, ought to consider a discounted cash flow model.

Discounted Cash Flow (DCF)

澳洲幸运5开奖号码历史查询:DCF modeling is pretty much the gold standard for valuation and plenty of books have been written on how free cash flow (operating cash flow minus capital expenditures at its simplest level) is the best proxy for corporate financial performance. One row will serve to hold the year-by-year cash flow estimates, while rows/columns beneath can hold the growth estimates, 澳洲幸运5开奖号码历史查询:discount rate, shares outstanding, and cash/debt balance.

There needs to be a starting estimate for "Year 1" and that can come from your own company financial model or sell-side analyst models. You can next estimate the growth rates by creating individual year-by-year estimates or using "bulk estimates" that apply the same growth rate for years two to five, six to 10, 10 to 15, and so on.

You then need to input a discount rate (a number that you can calculate with the CAPM model or another method) in a separate cell, as well as the shares outsꦜtanding and net cash/debt balance (all in separate cells).

Once this is done, use your spreadsheet's 澳洲幸运5开奖号码历史查询:NPV (net present value) function to process your cash flow estimates and discount rate into an estimated NPV, to which you can add/subtract the net cash/debt, and then divide by the shares outstanding. As part of this process, do not forget to calculate and include a 澳洲幸运5开奖号码历史查询:terminal value (most analysts calculate e🦩xplicit cash flows for 10 or 15 years and ꦆthen apply a terminal value).

The Bottom Line

Investors must remember that 澳洲幸运5开奖号码历史查询:detailed or sophisticated modeling is no substitute for judgment and discretion. All too often, analysts lean too heav🌃ily on their models and forget to do the occasional "reality check" regarding their core assumpti🔥ons.

Nevertheless, building your own models can teach you a lot about what a particular company must do to grow, what that growth is worth, and what the Street already expects from a particul♕ar company. Accordingly, the relatively modest amount of time it takes to build these models can often pay for itself many times over by leading you to better investment decisions.