Monday, June 10, 2013
Personal Investment Log
This template is prepared to keep track of personal investments. Investment type list is flexible. Also a report on the investment position is displayed on the second sheet including the gain/loss analysis for different investment types. PSW version of the template provides save feature. Hence, a collection of logs can be created and saved by the name of the individual. Saved logs are editable online.
Quick Budget
This template is prepared for evaluating personal budget. The data may be entered with any frequency. 2 charts displaying the final balance and spending distribution to main categories are provided.
Portfolio Performance Monitoring
The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of investments. The template allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations. Roll over of the model and archiving of transactions make this template ideal for monitoring your portfolio of financial investments on an ongoing basis.
Option Pricing - Barrier Options
This template use the formulas provided by John Hull to value barrier option when the barrier is less than the striking price.
Option Pricing - Binomial Model
The Binomial Options Pricing Model (BOPM) provides a generalizable numerical method for the valuation of options. The binomial model was first proposed by Cox, Ross and Rubinstein (1979). Essentially, the model uses a “discrete-time” (lattice based) model of the varying price over time of the underlying financial instrument. In general, binomial options pricing models do not have closed-form solutions.
Investment Model
This template is a simple investment model that may be used for analyzing a single investment. Straight line, declining balance and sum of the years' digits methods may be used for depreciation. Initial inputs and projected growth rates are entered by the users to simulate the value and projected operating cash flows of the investment.
Flexible Balance Sheet
This is a sample balance sheet which is flexible in current asset types, fixed asset types, other asset types, current liability types and long-term debt type. Also 4 types of analysis are provided. You can select any of them that you want to display on the sheet.
Subscribe to:
Posts (Atom)