I updated the spreadsheet that tracks FFP’s NAV discount to include the results of the latest annual report and to reflect the partial sale of the Zodiac stake in the beginning of this year. The spreadsheet updates automatically all share prices and the current discount, and is publicly accessible on Google Drive using this link. As is visible FFP’s NAV discount is basically unchanged at 47% since I initiated my position a half year ago:
Disclosure
Author is long FFP.PA
Thank you. This spreadsheet is nice.
Do you know if there is a possibility to set an alert if discount widens to say 50%? Something like “if(F35>0.50, send email)”
Something like that is possible, but you need a bit of a programming background: see http://www.withoutthesarcasm.com/automating-google-spreadsheets-email-reminders/
Where did you get the number of shares from or did you reverse calculate it from the % they hold times the market cap?
The number of shares that they own in the various companies is detailed in the latest financial report.