Archive for the 'Stocks' Category
[enlarge]
Based on the definition found in the web, intrinsic value refers to actual value of any companies or any assets based on an underlying perception of their true value in terms of both tangible and intangible factors. The value should be different with the current market value. This intrinsic value calculator spreadsheet will give you […]
Tags: company value, discounted cash flow, intrinsic value sample
December 17th, 2009 | Posted in Financial, Stocks | No Comments
[enlarge]
Earnings per share (EPS) is a company profit’s allocation for outstanding share of common stock. This EPS value is usually being used as an indicator of the health of a company. Basic earnings per share are calculated by dividing the profit for the period attributable to equity shareholders of the Parent Company by the average […]
Tags: company profit, diluted earnings per share, earnings, EPS
December 15th, 2009 | Posted in Financial, Stocks | No Comments
[enlarge]
A dividend discount model is a financial model for valuing the price of a stock by using predicted dividends and discounting them back to present value. The idea is that if the value obtained from the DDM is higher than what the shares are currently trading at, then the stock is undervalued.
This model would typically […]
Tags: dividend, dividend excel model, dividend model
December 12th, 2009 | Posted in Financial, Stocks | No Comments
[enlarge]
This is a quasi-random and traditional Monte Carlo simulation of Black-Scholes (European Call Option) where you can use to calculation your option pricing.
Author : Marco A.G Dias
Download
Tags: Black Scholes Simulation, European Call Option, Monte Carlo Simulation, Option Pricing Calculator, Option Pricing Spreadsheet
March 24th, 2008 | Posted in Financial, Simulation, Stocks | No Comments
[enlarge]
In this model, the maker of this template constructed a Monte Carlo simulation to price an option contract where it can be used to value a stock or a currency option.
Author : Metin Kilic
Download
Tags: Excel Simulation Template, Monte Carlo Simulation, Option Pricing, Stock Valuation Spreadsheet
March 24th, 2008 | Posted in Financial, Simulation, Stocks | No Comments