New, improved FX walkforward sheet | CLNY Message Board Posts

Colony Capital, Inc.

  CLNY website

CLNY   /  Message Board  /  Read Message

 

 






Keyword
Subject
Between
and
Rec'd By
Authored By
Minimum Recs
  
Previous Message  Next Message   Post Message   Post a Reply return to message boardtop of board
Msg  7584 of 8274  at  1/11/2019 6:54:48 PM  by

dar200


New, improved FX walkforward sheet

 This one adds 21 cents per share to nav per share for recently announced premium to 9/30 nav. Yeah, yeah, I previously posted 20 cents but dividing by 9/30 calculated shares rounded to 21 cents.
 
I also added 22 million of UK equity to 12/31 cash.
 
 
NRE--FMV EQUITY FX EFFECT
FMV EQUITY 9/30/18 1,044,139
NAV PER SHARE 20.8500
CALCULATED SHARES 50,078,609
EURO POUND
EURO/LB 70-30 730,897 1,044,139 313,242
QTR END FX RATES 1.1605 1.3029
TODAY FX RATES 1.1467 1.2849
PCT CHANGE -1.19% -1.38%
TODAY EQUITY 722,206 1,031,120 308,914
TODAY NAV PER SH 20.5900
INCR (DECR) (0.2600)
PCT INCR (DECR) -1.25%
Today less 1.3978 term fee 19.1922
Add 21 cent UK/GER premium 19.4022
CLOSING PRICE 16.32
DISCOUNT EX CASH
NAV - CASH PER SH 11.8272
PRICE - CASH PER SH 8.7450
DISCOUNT ON NON CASH EQUITY -26.1%
Tower cash at 12/12 euro rate 360,000
Dec 12 euro rate 1.1373
Today exchange rate 1.1467
Today tower cash 362,975
Today per share 7.2481
Unrestricted 9/30 cash 65,000
Blended nav pct change -1.25%
Today unrestricted cash 64,190
Today per share 1.2818
UK cash at 12/31 lb rate 22,000
Dec 31 pound rate 1.2745
Today pound rate 1.2849
Today UK cash 22,180
Today per share 0.4429
Total cash today minus exit fee 7.5750


     e-mail to a friend      printer-friendly     add to library      
| More
Recs: 1     Views: 174
Previous Message  Next Message   Post Message   Post a Reply return to message boardtop of board


About Us    Contact Us    Follow Us on Twitter    Members Directory    Help Center    Advertise
Not a member yet? What are you waiting for? Create Account
Want to contribute? Support InvestorVillage by donating
2003-2018 Investorvillage.com. All rights reserved. User Agreement
   
Financial Market Data provided by
.


Loading...