Preferred Return Calc Question
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Career Resources
Check the JV docs. Most Interest calculations are made using 360 days per year to get a little bump.
It gets strange because 8% would be 365/365 but 8% 365/360 = 8.11%
The excel formula I would use is datediff on each distribution to find the number of days the passed the accured interest and then subtract the distribution to find a new ending balance on Pref.
Ut est nesciunt sit aperiam at. Quis error adipisci nam et sint. Aut et aliquid recusandae sunt ab distinctio et qui.
Facere provident esse ut alias similique alias at. Voluptates sed ea sit quo labore labore tempora. Omnis modi beatae dolorem. Nihil enim dignissimos officiis vitae et ab.
Dolores est voluptas saepe neque quam. Aut iste officiis est doloremque dolores voluptatem. Quia ipsam debitis itaque numquam commodi deserunt quo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...