Efficient Frontier and CAL Template This efficient frontier and CAL template demonstrates how to construct a portfolio frontier and CAL line chart to find the optimal portfolio. Below is a screenshot of the efficient frontier and CAL template: Download the Free Template The Efficient Frontier A portfolio frontier is a graph that maps out all…
Charts and Graphs Template This charts and graphs template provides you with 10 different types of charts and graphs used in financial planning and analysis. Here is a preview of the charts and graphs template: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge and perform better financial analysis….
Common Size Analysis Template This common size analysis template allows you to compare the financial performance of companies in different sizes on the same scale. Here is a screenshot of the common size analysis template: Download the Free Template Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. Common size…
Cost of Equity Calculator This cost of equity calculator helps you calculate the cost of equity given the risk-free rate, beta, and equity risk premium. This is what the cost of equity calculator looks like: Download the Free Template Cost of Equity is the rate of return a shareholder requires for investing equity into a business. The rate…
Beta Calculator This beta calculator allows you to measure the volatility of returns of an individual stock relative to the entire market. Below is a screenshot of the beta calculator: Download the Free Beta Calculator The beta (β) of an investment security (i.e. a stock) is a measurement of its volatility of returns relative to the…
Debt to Asset Ratio Template This debt to asset ratio template will show you how to calculate the Debt/Asset ratio given the number of assets, short-term debt, and long-term debt. Here is a preview of the debt to asset ratio template: Download the Free Template The Debt to Asset Ratio, also known as the debt…
Marginal Cost of Production Template This marginal cost of production template will show you how to calculate different types of marginal costs. This is what the marginal cost of production template looks like: Download the Free Template The Marginal Cost of production is the cost to provide one additional unit of a product or service….
Net Present Value Template This net present value template helps you calculate net present value given the discount rate and undiscounted cash flows. Here is a screenshot of the net present value template: Download the Free Template Net Present Value (NPV) is the value of all future cash flows (positive and negative) over the entire life of an…
Depreciation Methods Template This depreciation methods template will show you the calculation of depreciation expenses using four types of commonly used depreciation methods. Below is a preview of the depreciation methods template: Download the Free Excel Template There are several types of depreciation expenses and different formulas for determining the book value of an asset. The most…
Dilution Template This dilution template helps you identify the impact of dilutive securities on the share price. Here is a preview of the dilution template: Download the Free Template Dilution can be caused due to a number of dilutive securities such as stock options, restricted and performance stock units, preferred stock, warrants, and convertible debt. Dilution may cause…
