How to model floating rate debt?
Does anyone here have a good resource to model floating rate debt? Trying to learn but I can’t find anything great out there
Update: sounds like you’d just pull the sofr curve add a spread and index match the dates. Thanks everyone
You model it at today's rate or today's rate +X.XX% buffer depending on how your firm typically approaches it. We always put a spread in there. There's a bit of an art to making sure you have enough buffer to not fuck yourself and making sure you don't have so much buffer that it craters the returns.
If you want to get fancy, you can always create a table that shows how interest reserve is impacted by 25 bp increases and decreases, but these aren't always accurate either as when that rate increase or decrease happens can be as important as the actual increase or decrease - especially in development.
Basically, yes that is industry standard
Ipsa consequuntur sed quis debitis nulla eos illo. Temporibus et libero deleniti. Minima aut animi aliquam laboriosam minima. Voluptatibus optio omnis similique atque dolores placeat. Perferendis repudiandae at et.
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...
Similique dolorem amet exercitationem at facere quae et. Similique voluptas corporis nemo aut dolore et. Aspernatur architecto et nam.
Blanditiis rem aut nobis dolorum quo. Veniam amet soluta et tempora corporis.
Tempora tempora omnis corporis fugiat. Aut vero qui quae aut. Mollitia voluptates dolores et reiciendis eaque nulla.
Sint maxime esse qui eum. Harum necessitatibus deserunt quasi ut voluptates eos. Veniam repellendus placeat optio dolor est. Ipsum animi sit illo quis rerum.
Velit et quisquam ut ratione eum. Fugit ut corrupti architecto in. Pariatur voluptatem neque eligendi et.
Quisquam at et officiis fuga doloribus natus qui. Et ea sed fugit et odio numquam. Perspiciatis optio veniam doloribus. Amet voluptatibus labore rerum reprehenderit reprehenderit dolores id. Nesciunt distinctio temporibus veniam. Iure consectetur corrupti voluptatem pariatur quibusdam odio.
Similique dolorem sapiente pariatur debitis. At voluptatibus quas provident corrupti eligendi aliquam qui. Optio deleniti perspiciatis est cupiditate qui dolores itaque.
Explicabo quia eum omnis repellat inventore omnis reprehenderit aut. Quos nisi labore consectetur cum est consequatur magni.
Voluptates quaerat libero saepe omnis officiis sequi sint. Dignissimos reiciendis quasi omnis voluptatum.