elliotn
Member of DD Central
Posts: 3,063
Likes: 2,681
|
Post by elliotn on Mar 31, 2017 8:37:33 GMT
Availability may improve further with 3 'imminent' loans, the airplane looks particularly close to take off from Geneva 😎
|
|
stevio
Member of DD Central
Posts: 2,065
Likes: 894
|
Post by stevio on Jun 21, 2017 7:38:01 GMT
I was looking for a simple excel formula for calculating AER Does EFFECT(nominal_rate,npery) do this? ablrateandy I seem to remember you offered an AER calculator, is that still available? Is there also a formula for AER when there is a discount/premium, as on the SM?
|
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Jun 21, 2017 9:12:41 GMT
I was looking for a simple excel formula for calculating AER Does EFFECT(nominal_rate,npery) do this? ablrateandy I seem to remember you offered an AER calculator, is that still available? Is there also a formula for AER when there is a discount/premium, as on the SM? There's a pinned thread just above that may help
|
|
|
Post by ablrateandy on Jun 21, 2017 20:31:49 GMT
Thanks SteveT. I could go into a long discourse about what is "right" and what AER is.... but suffice to say that there are three ways to calculate it : 1. XIRR (which looks at each cashflow and evaluates it based on the fraction of a period elapsed) 2. IRR (which ignores the date and assumes a set of regular payment dates) 3. The Discounted Cashflow Method (which looks at each cashflow and evaluates it longhand based upon the number of days elapsed) Number 3 is the most exact way (in my opinion) and is what is used on the Ablrate secondary market (as well as in bond markets)
|
|