- Next Level Financial Modeling
- Posts
- 📈3 Things Every Model Should Have
📈3 Things Every Model Should Have
Next Level Financial Modeling: Helping you become an expert commercial real estate underwriter every Saturday!
This newsletter is sponsored by SyndicationPro! SyndicationPro is a real estate syndication software that helps you manage your capital, leads and investors at ease. Book a free demo today!
Underwriting models are like snowflakes. Meaning no two are exactly the same.
Here are 3 things every multifamily underwriting model should have:
Monthly Proforma
Every underwriting model should have a monthly proforma. Especially multifamily models! The annual proforma will then be a summary of the monthly.
Benefits of a monthly proforma:
See operations on a monthly basis
Make granular adjustments
Forecast unit renovations on a monthly basis
Year-by-Year Growth & Vacancy Assumptions
As shown in the picture, this allows you to control economic loss assumptions for individual line items.
Similarly, having individual growth rates for rent, payroll, taxes, etc. is much needed today. For example, taxes and insurance are heavily increasing each in year in large metros. Many underwriters will need to grow taxes higher than other operating expenses.
Dedicated Output Page
Having a dedicated output page is helpful when you are sharing the model with other partners and investors. Instead of mindlessly searching throughout the model, users can come to one worksheet to view assumptions, timelines, and returns.
These outputs are prepopulated and are a result of assumptions the underwriter made on different tabs. All in one place.
📈 CRE & Market News
📈 Stay Up-To-Date on Rates
US Ten Year Treasury Yield: 4.12%
30 Day Term SOFR: 5.33%
30 Day Average SOFR: 5.34%
Fannie Mae (1.35x DSC / 65% LTV / 10Y): 5.30% - 6.05%
Freddie Mac (1.35x DSC / 65% LTV / 10Y): 5.65% - 5.80%
5 Year FHLB: 4.26%
WSJ Prime Rate: 8.50%
📈 Chart of The Week
Dallas Overtakes New York in Job Gains
According to the latest data release from the Bureau of Labor Statistics (BLS), the Dallas-Plano-Irving metro division produced more jobs in the year-ending November than the New York-White Plains metro division (103,500 jobs versus 90,300 jobs).
📈 Modeling Your Success,
The Next Level Value Add Model
Finally, a multifamily underwriting model, built by a real multifamily underwriter!
Apartment / Mixed-Use underwriting model
Free 1-Hour Consultation included
Free Next Level B.O.T.E. Model included
Lifetime support and updates included