Valuation Assumptions File
 Previous Top Next
The Valuation Assumptions File (files with extension va.csv) allows clients to upload values used as a part of an external valuations process of grants in the database. 

Data uploaded in this file goes towards producing the Assumptions Disclosure Summary report, which provides the type of information that can be used to prepare financial statement disclosures related to valuation assumptions as described in section A240: (a) Expected Term, (b) Expected Volatility, (c) Dividend, and (d) Risk Free Rate.


The Valuation Assumptions File (file with extension va.csv) contains information related to Fair Value, Expected Term, Risk Free Rate, and Dividend Yield.




Insertions and Modifications
The upload file can contain both new records, and updates to existing records. A row is uniquely identified (unique key) by a combination of the Grant ID and Vest Date. MPA Awards are not supported in this upload file.

When the Vesting Date is omitted, the record is updated to the Grant Level. 

When a Valuation record already exists for the GrantID, Vesting Date, and a record is provided in this file for that GrantID, Vesting Date, the existing record is updated.


Deletions

To delete the valuation information for a Grant, the user will add a record in an acceptable .CSV file format that contains only the GrantID.  Deletion records can be in the same file as insert and update records.   

 Only a single assumption delete row is needed to delete all the assumption rows for the Grant(Tranche and Grant Level).  This deletion will not affect any updated Fair Values at the Grant or Vesting levels.




Deletion records can be in the same file as insertion and modification records.




File Format
#
Field Name
P =Required
M= MPA Grant Only
Field Type

Sample Field
Description
1
Grant ID
P
Alpha-Numeric (40)
Grant01
Unique identifier for each Grant
2
Vesting Date
 
 
Date


01/21/2009
This date constitutes the end of the period over which the employee renders service (service end date), for the Tranche.

This date is typically used as the expense amortization end date unless another event causes an earlier end date (e.g. Vesting Acceleration, Cancellation or a Retirement Eligibility Date, or Condition Achieved Date).
3
Fair Value
 
Numeric (14.4)
10.50
Per-share Fair Value assigned to the Grant as the result of a valuation process as loaded or updated.
 
Optional Fields
 
 
 
If this file is only being used to load Fair Values only, the following fields can be omitted
 
4
Expected Term
 
Numeric (14.4)
2.8
Expected Term in years of Shares and instruments taking into account various related behaviors
 
5
Volatility
 
Numeric (14.4)
0.454
Expected Volatility of the shares entered as a percent where 1.0 is 100 percent.
 
6
Risk Free Rate
 
Numeric (14.4)
0.028
The Risk Free Rate used in valuation entered as a percent where 1.0 is 100 percent.
 
7
Dividend Yield
 
Numeric (14.4)
0.054
Expected Dividend Yield used in valuation entered as a percent where 1.0 is 100 percent.
 


Examples
To properly load, fields in each row of the file must be in the following sequence:
GrantID,Vesting Date, Fair Value, Expected Term, Volatility, Risk Free rate, Dividend Yield


An example of valid lines in an Mobility Reporting File are as follows:
Grant01,2/1/2010,12,2.35,0.3,0.4,0.5