Download data All in all, it is telling that last week, with all its volatility, felt calmer than prior weeks, perhaps because more of it was on the upside and it is all relative. That said, we are still on a roller coaster and there are more thrills to come in the coming weeks. Equity Market Breakdown In keeping with my practice in prior weeks, I will break down the equity movement last week by region and sector first, looking to see if there are divergences. Moving on to sectors, and looking at the same metrics, I get the following: The results here are consistent with the earlier findings that corporate bond default spreads declined last week, after the surge in the prior one, and the most highly levered sectors real estate and utilities benefited. Updating the list of the ten industries that have been hurt the most and least during this crisis dating back to February 14, , I get this list: Download full list of industries Some of the worst performing industries over the six-week period had the best weekly performance last week, but remain deeply damaged. In previous weeks, I have looked at classes of stocks, focusing on a different dimension each week.

Author:Kekasa Arazshura
Language:English (Spanish)
Published (Last):7 July 2018
PDF File Size:15.38 Mb
ePub File Size:14.53 Mb
Price:Free* [*Free Regsitration Required]

To help you in finding the spreadsheet that you might want, I have categorized the spreadsheets into the following groups: Corporate finance spreadsheets : These spreadsheets are most useful if you are interested in conventional corporate financial analysis. These programs are broadly categorized into those that Estimate risk in an investment and its hurdle rate, as well as assess investment returns net present value, internal rate of return, accounting return Evaluate the right mix of debt and equity in a business and the right type of debt for a firm Examine how much a firm should return to investors and in what form dividends versus buybacks Valuation Inputs Spreadsheets : In this section, you will find spreadsheets that allow you to Estimate the right discount rate to use for your firm, starting with the risk premium in your cost of equity and concluding with the cost of capital for your firm.

While they require a large number of inputs, they are flexible enough to allow you to value just about any company. If you have no idea which one will work for you, I would suggest that you try the "right model" spreadsheet first.

Focused valuation spreadsheets : If you have a clear choice in terms of models - stable growth dividend discount, 2-stage FCFE etc. Valuation of specific types of companies: Valuation is all about exceptions, and these spreadsheets are designed to help value specific types of companies including: Financial Service firms : While dividend discount models tend to be the weapon of choice for many, you will find an excess equity return model here.

Troubled firms : You will find an earnings normalizer spreadsheet, a generic valuation model for valuing a firm as a going concern and a spreadsheet that allows you to estimate the probability that a troubled firm will not survive.

Private companies : You will find spreadsheets for adjusting discount rates and estimating illiquidity discounts for private companies. Young and high-growth firms : You will find a revenue growth estimator as well as a generic valuation model for high growth firms in this section. Multiples : You can estimate equity as well as firm value multiples, based upon fundamentals. Valuation in Acquisitions : You can value synergy in an acquiisition and analyze a leveraged buyout.

Valuation of other assets : In this section, you will find a model for valuing income-generating real estate. Basic option pricing models : In this seciton, you will find Black-Scholes models for valuing short term options, long term options and options that result in dilution of stock such as warrants.

In addition, you will find spreadsheets that convert Black-Scholes inputs into Binomial model inputs and use the binomial model to value options. Real option models in corporate finance : In this section, you will find three basic real option models - the option to delay, the option to expand and the option to abandon.

In addition, the value of financial flexibility is considered as an option. Real option models in valuation : In this section, you will find models to value both a patent and a firm owning a patent as an option, natural resource firms and equity in deeply troubled firms.

These spreadsheet programs are in Excel and are not copy protected. Download them and feel free to modify them to your own specifications. I do have video guides available for some of the most accessed spreadsheets.

I hope they are useful. One more point. I am not an expert on Microsoft Excel and am frankly mystified by some of the quirky differences between the Mac version which I use and the PC version which you probably have. If you want to refine your spreadsheet skills, you can of course by a book on Excel. However, a reader of this website, Alex Palfi of Tykoh Training, has been kind enough to offer this guide to using and building spreadsheets. Please feel free to download it and use it and to then convey your appreciation to him.


Musings on Markets

Jutaxe Should Microsoft pay dividends? This spreadsheet allows you to measure the complexity in a company and valuatlon it a score. Warning signs of distress How costly is distress? Microsoft faces a call to pay dividends For more readings, go here. The supporting material valyation. Estimate the value of a patent. Competitive Advantage Period For more readings, go here.






Related Articles