Present Value of Growth Opportunities (PVGO)
What is Present Value of Growth Opportunities? Present Value of Growth Opportunities (PVGO) is a concept that gives analysts a different approach to equity valuation. Considering that valuation in stock markets is a combination of fundamentals and expectations, we can break down the value of a stock to the sum of (1) its value assuming…
Comparable Company Analysis
What is Comparable Company Analysis? Comparable company analysis (or “comps” for short) is a valuation methodology that looks at ratios of similar public companies and uses them to derive the value of another business. Comps is a relative form of valuation, unlike a discounted cash flow (DCF) analysis, which is an intrinsic form of valuation….
Exchange Ratio
What is an Exchange Ratio? In mergers and acquisitions (M&A), the exchange ratio measures the number of shares the acquiring company has to issue for each individual share of the target firm. For M&A deals that include shares as part of the consideration (compensation) for the deal, the share exchange ratio is an important metric….
Excel for Finance Functions
Excel for Finance Functions This Excel for finance functions template demonstrates sample calculations using the top 10 most important functions and formulas for finance professionals. Below is a preview of the XNPV function example: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge and perform better financial analysis. #1…
Bloomberg Functions Spreadsheet
Bloomberg Functions Spreadsheet This Bloomberg functions spreadsheet contains a list of some of the most common and important functions, keystrokes and shortcuts to know on the Bloomberg Terminal. Below is a screenshot of the Bloomberg functions spreadsheet: Download the Free Template Enter your name and email in the form below and download the free template…
Bullet Chart Template
Bullet Chart Template This bullet chart template teaches you how to create a bullet chart from scratch to compare actual versus forecasted performance. This is what the bullet chart template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! Bullet Chart is one…
Gantt Chart Template
Gantt Chart Template This Gantt chart template will help you use Excel to build a project schedule using a bar chart. Below is a screenshot of the Gantt chart template: Download the Free Template Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. The Gantt Chart is a type of…
Football Field Chart
Why is it Called a Football Field? The bars look like yard lines on a football field, and hence the name. Also, the graph is commonly used in investment banking, and bankers like sports analogies. Why Use a Football Field Chart? It is used to visually show what the range of values is for a business…
How to Create a Waterfall Chart in Excel
What is a Waterfall Chart? A waterfall chart is a dynamic, intuitive visualization that shows how a series of positive or negative changes impact an initial value, ultimately resulting in a final total. Commonly used in financial analysis, business reporting, and performance tracking, this chart breaks down how specific data points, such as revenue shifts,…
