Sir,
Please dont steal someone else's hard work.
Its been developed by A.Damodaran and its his hard work.
You guys are good at theft of IP only.
Dont offer it now.
regards,
Ravi
P.S: people can check the original things at damodaran.com
zwright@[EMAIL PROTECTED]
wrote:
> Tools For Financial Analysis
>
>
--------------------------------------------------------------------------------
> We offer over a hundred xcel spreadsheets for fianancial analysis. They
are yours to use as you please.
>
> These spreadsheet programs are written in Excel and are not copy
protected. Download them and feel free to modify them to your own
specifications.
>
> http://houstonfirstcapital.com/analysis.html
>
> The spreadsheets may be gouped into the following categories...
>
> Cor****ate finance spreadsheets: These spreadsheets are most useful if
you are interested in conventional cor****ate financial analysis. It
includes spreadsheets to analyze a project's cashflows and viability, a
company's risk profile, its optimal capital structure and debt type, and
whether it is paying out what it can afford to in dividends.
>
> Valuation Inputs Spreadsheets: In this section, you will find
spreadsheets that allow you to
> a. 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.
> b. Convert R&D and operating leases into capitalized assets
> c. estimate the right capital expenditures and diagnose the terminal
value assumptions to see if they are reasonable.
>
> Big-picture valuation spreadsheets If you are looking for one
spreadsheet to help you in valuing a company, I would recommend one of
these 'ginzu' spreadsheets. While they require a large number of inputs,
they are flexible enough to allow you to value just about any company. You
do have to decide whether you want to use a dividend, FCFE or FCFF model
spreadsheet. 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. - you can
download a spreadsheet for the specific model in this section.
>
> 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.
>
> Value Enhancement Spreadsheets In this section, you will find a
spreadsheet that reconciles EVA and DCF valuation, a model for estimating
CFROI and a DCF version of a value enhancement spreadsheet.
>
> 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 cor****ate 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.
>
> Compliments of Houston First Capital
> http://www.houstonfirstcapital.com
|
