Secfi interview questions

A) Calculating the vesting timeline For managing private equity, it is important to know the amount of stock options that have already vested. In this problem, we will be working with option grants (ignoring their type) that have different vesting schedules, with three variables that can change: ● Granting date: The date in which the grant has been awarded and the vesting starts. Cliff months: The duration of the cliff. In this context it will be either 0 (no cliff) or 12 months. ● Total duration: The total duration of the vesting schedule. In this context it will be from 36 to 60 months. Given a set of option grants with their quantity and vesting information (see the sample request below), we expect the service to return a timeline with monthly points indicating the total quantity of vested grants, from the date of the first grant until the totality of the options are fully vested B) b. Calculating the value of the vested equity over time Now consider that the stock for which if you have options has of course a value and this value can change over time; for example because of a new round of investment, among other things. In this part, we ask you to take this into consideration and return not the quantity of vested options but the total value of said vested options by using the provided valuations (see the sample request below). You may consider that there will be a valuation before a grant is awarded

They ask you to write an application.