Publication number: ELQ-58839-1
View all versions & Certificate
NPV Calculator (Excel Template)
Calculate Net Present Value with ease by using this Excel spreadsheet.
Dheeraj Vaidya CFA FRM offers you this Best Practice for free!
download for free
Add to bookmarks
People using this Best Practice also downloaded
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables2,671add_shopping_cart
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,248add_shopping_cart
Comparable Company AnalysisArrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,214add_shopping_cart
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company920add_shopping_cart
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template1,110add_shopping_cart
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components883add_shopping_cart
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share654add_shopping_cart
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.578add_shopping_cart
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)463add_shopping_cart
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation371add_shopping_cart
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index592add_shopping_cart
Loan Amortization Schedule in ExcelA loan amortization schedule template along with step-by-step instructions.306add_shopping_cart
Any questions on NPV Calculator (Excel Template)?
The user community and author are here to help. Go ahead!