Reputation
621
Top tag
Next privilege 750 Rep.
See votes, expandable usercard
Badges
3 13
Newest
 Yearling
Impact
~35k people reached

1d
awarded  Yearling
Apr
29
awarded  Nice Answer
Apr
11
comment bond price formula in excel
@user25064 any workbook function is called pretty easily via vba by WorksheetFunction.Sum(x,y), WorksheetFunction.xnpv(...), yadda yadda. The reason for this vba code is to catch the accrued interest at the sale date (you split this prorata between the bond seller and buyer based on how much time has elapsed from the last coupon payment)
Apr
11
comment bond price formula in excel
It's simple cash flow discounting, you'll see that formula on any google search for present value.
Sep
8
awarded  Benefactor
Sep
8
comment Different interim balances when calculating annual compound interest different ways
Exactly what I was looking for, thanks. Also, my use of "variance" is the jargon for my industry, although I understand where you're coming from.
Sep
4
awarded  Promoter
Sep
1
asked Different interim balances when calculating annual compound interest different ways
Jul
26
awarded  Yearling
Dec
29
revised Compare fund managers with insignificant alphas?
added 8 characters in body
Dec
29
answered Compare fund managers with insignificant alphas?
Dec
9
comment Securitization of a loan portfolio
Not offhand, in my opinion you're better off looking for industry primers based on the specific securitizations that have been brought to market. Just googling around for <insert i-bank in that market> clo/cmbs/etc. primer should yield some results.
Dec
9
answered Securitization of a loan portfolio
Dec
6
comment Single Most Important Fact about a Fund - Interview Question
Is this a ponzi scheme?
Dec
5
comment When did volatilities start to smile in capital markets?
I imagine it was always there, that was just when it became apparent current models didn't account for it.
Dec
5
comment Securitization of a loan portfolio
Yes. Tranching isn't as simple "slicing up" assets, unless you're just asking if higher tranches in the bond are safer because they have higher ratings, better collateral, and typically larger balances. Then the answer is yes. Otherwise, are any tranches pari-passau, what kind of waterfall is there(pro-rata, straight, etc.), are they grouped, subordination levels, etc.
Dec
4
revised Securitization of a loan portfolio
edited title
Dec
4
comment Securitization of a loan portfolio
You never described the tranches, nobody will be able to give you a decent answer until you do.
Nov
27
answered moody's credit ratings for senior unsecured bonds
Oct
22
comment Valuation of Mortgage Backed floating notes
Are you valuing commercial or residential backed securities?