DAMODARAN ON VALUATION FILETYPE PDF

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.

Author:Tygogul Tygok
Country:Botswana
Language:English (Spanish)
Genre:Sex
Published (Last):25 September 2006
Pages:408
PDF File Size:1.62 Mb
ePub File Size:3.48 Mb
ISBN:555-8-79744-445-1
Downloads:27980
Price:Free* [*Free Regsitration Required]
Uploader:Arashura



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.

ANALISIS TRANSACCIONAL ERIC BERNE PDF

Musings on Markets

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.

MARKETING INTERNACIONAL CATEORA PDF

DAMODARAN ON VALUATION FILETYPE PDF

.

EUCHEUMA SPINOSUM PDF

.

Related Articles