Hey,
I am trying to build a model with a term sheet found in WSO RE Model Google Drive and I got stuck when I tried to tackle the waterfall section of the model.
The term sheet states that it will purchase the property with full equity and refinance it at the end of Y2. So is it correct to decrease the equity by the amount that is being refinanced...? If so, how I would I incorporate this into the model..?
any inputs are welcome!
Thanks in advance.
| Attachment | Size |
|---|---|
| related_.xls 1.79 MB | 1.79 MB |
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 20h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +43 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 10 | 17m |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 4d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 17h |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Be sure to back out exit fees, origination fees, and any holdbacks that are lender forced or elective (i.e. reserves for future capex projects and/or working capital). After you net these from the new loan you'll be pretty close at estimating a distribution amount to investors that will lower outstanding equity balance.
How is your payment(D43or47) a static number and not a formula? Don't forget while unlikely it should be a min max function of LTV AND dscr, not just LTV. The debt should paydown the equity like it were a capital event. You should probably include brokerage fees and bank fee's into the total loan amount. Also not important but I like to have my monthly cash flows on a separate tab in the worksheet and my annuals in another and my waterfalls in another.
No sumifs + column grouping?
definitely sumifs
Thank you for point this out.
I fixed it with min max function also taking Maximum debt yield into consideration!
Thank you for the input!
Necessitatibus perspiciatis ut est maxime repellat. Eos quasi odit et delectus tempora tempore. Et aut est nihil eveniet in qui. Temporibus hic voluptas praesentium qui id.
Aliquid nostrum tenetur iste exercitationem consectetur voluptate illum. Ducimus recusandae fugiat in. Aliquid rem quidem est eum quibusdam illo. Necessitatibus error sed eligendi molestias impedit. Ad molestiae at vel quo et quia a exercitationem. At dolor eveniet nihil voluptas ipsa doloremque assumenda.
Architecto assumenda atque debitis qui magnam quae unde. Quas in debitis aut consectetur mollitia velit.
Omnis omnis nemo laudantium dolore ut impedit quo consequatur. Nesciunt ut mollitia quo vel. Assumenda omnis minima optio.
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...