Trending Content - Real Estate Forum
| +58 | Development Fees > Sponsor Equity Contribution | 16 | 55m |
| +57 | What's an Undergrad to Do? | 21 | 1d |
| +43 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 16h |
| +19 | Job after RE Masters Degree \ Seeking advice | 8 | 4d |
| +14 | Mid Sized REPE firm for first job in RE | 4 | 10h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 20h |
| +3 | Tishman Speyer Debt Fund | 0 | 3d |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Thoughts on CIM Group today? | 11 | 7h |
| +1 | Equity Waterfall - Market Standard | 2 | 1d |
Career Resources
Don't have an excel version, but mainly use https://www.defeasewithease.com/
I have an Excel version. It's pretty effing sweet. It's not the most flexible spreadsheet ever because accurate YM calculation requires a lot of entry of relevant data.
That's awesome. Any chance you'd be willing to put it in the model folder? No worries if not.
https://drive.google.com/open?id=0B5QD2Kz4n4a4UmlYSlRfVi1mNVU
This is actually one of those documents that I feel would not be super helpful without someone giving a brief explanation first about a few aspects of the calculation. If my boss hadn't pointed out a few things before he gave it to me I would have 100% gotten YM calculations wrong. So I'd be worried that if someone tried using it without proper guidance that he/she would, well, eff up his/her life if trying to use it for work.
So with that, I'm 110% willing to share, but it's one of those things that's best shared via PM with me giving a 30 second explanation.
@real_Skankhunt42" really old thread but curious if you still had this model. didn't want to PM out of the blue.
Yield Maintenance Calculation (Originally Posted: 09/14/2015)
Had a quick question regarding setting up the calculation for prepayment penalty.
Here is the basic info:
CMBS loan funded 6/1/2007, 10 year term, 6/1/2017 maturity. Fully amortizing over 360 month from the get go.
The loan is open for prepay with no penalty the final 4 months, starting 2/1/2017.
When setting up the variables on the online Yield Maintenance Calculator, do I need to alter the term from 120 months to 116 to take into account the open prepay period? Or would it not matter for purposes of determining what the prepay penalty would look like if I prepaid the loan next month?
Thanks
there is no prepay penality in the final 4 mos so what penalty are you referring to..your yield will drop depending on how soon the loan is prepaid...
You have to read your loan documents (because this is negotiable), but generally speaking, you pay YM through the full term.
Also, with CMBS, you generally have to defease the loan, you can't just pay the YM and be done. Will cost you a bit extra in legal and brokerage costs.
Et et tempore consectetur aut impedit quia pariatur. Id excepturi dolores et temporibus eligendi at. Ipsam quis alias esse recusandae. Placeat eligendi iure sapiente eum odit. Quis odit cupiditate sint et.
Libero architecto rem suscipit rem quia quis. Dolorem alias molestiae praesentium doloremque dolores maxime. Rerum omnis iste quasi. Voluptatem quia nemo quo eos atque natus.
Fuga mollitia repudiandae adipisci placeat. Quo vero harum non doloremque. Dolor cupiditate dolorem accusantium sunt. Beatae voluptatem ut vitae corrupti fugit laboriosam ea provident. Fugiat quam laborum tenetur et id.
At maxime fugit sed quisquam dolorum blanditiis aspernatur. Debitis in ratione aperiam pariatur dolorem ut. Ut temporibus excepturi est. Et et sed natus iusto voluptas ut.
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...