Originally published: 02/08/2016 09:01
Publication number: ELQ-86769-1
View all versions & Certificate
Publication number: ELQ-86769-1
View all versions & Certificate
Valuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components
Dheeraj Vaidya CFA FRM offers you this Best Practice for free!
download for free
Add to bookmarks
Reviews
Write a review
People using this Best Practice also downloaded
Waterfall Chart Excel Template
An effective tool for quickly working out financial changes over a period.346Discussadd_shopping_cartfree
by Brian Weisberg
Private Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.916Discussadd_shopping_cartEconomic Value Added Tree Model
Visualize how your EVA can be broken-up into its subparts.1,179Discussadd_shopping_cartfree
by Manfred Grotheer
Cash Flow Waterfall Model
A cash flow model for Real Estate based on a waterfall structure12,3625add_shopping_cartfree
by Amit Tandon
Terminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,992Discussadd_shopping_cartActivision Blizzard DCF (Discounted Cash Flow) Model
A simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)769Discussadd_shopping_cartfree
by Erin Chan Parker
Private Equity Fund Cashflows Model
PE Financial Model to analyze fund cashflows and returns available to LP and GP along with portfolio level cashflows.7276add_shopping_cart$105.00
by Anuj Verma
COVID-19 vs Index Return Excel Model
Analysis on index return in relation to Covid-19 cases.57Discussadd_shopping_cart$25.00
by Sara AlSaidan
Estimating the Discount for a Minority Stake in a Private Business
This model can be used to estimate the discounts for a minority stake in a private business316Discussadd_shopping_cartfree
by Aswath Damodaran
Client Corporate Excel Dashboard
A neat corporate summary report which can be easily adapted to incorporate financial and non financial data.4,166Discussadd_shopping_cart$99.00
by Marcus Small
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization502Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation754Discussadd_shopping_cartComparable Company Analysis
Arrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,874Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share1,158Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.916Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,4312add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index933Discussadd_shopping_cartFootball Field Graph
Representing the spread of key PE ratios in floating columns/bars.432Discussadd_shopping_cartAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,567Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,720Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)716Discussadd_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,992Discussadd_shopping_cart
Any questions on Valuation Waterfall Graph?
The user community and author are here to help. Go ahead!
