Overview

The Multi-Family Housing Rental Renovation model projects
monthly future cash flows from the renovation and rental of a multi-family
housing property. This covers rent roll, project costs, financing, levered free
cash flow, and a cash waterfall for investors. The tabs included are:

• Project Inputs with purchase and valuation figures
• Monthly Cash Flows through the renovation and rental of the multi-family
property

The Project Inputs tab contains the assumptions of the
renovation project. Details of the project such as the renovation schedule, operational
costs, and finance options are entered in this tab and flow into the Monthly
Cash Flows tab. The financing options account for a transitional loan through
the renovation period and a permanent loan after stabilization. This tab
includes a capitalization and funding breakdown along with purchase and
valuation assumptions for a potential exit strategy.

The Monthly Cash Flows is a proforma with projected revenue from
the rent of the units after renovation and operating expenses from the property.
The Project Costs Section is tied to the inputs tab and calculates the net
sales realization and unlevered cash flows. The Financing Section breaks down
the two loan structures based on the assumptions. The Levered Free Cash Flow
Section sums up the above sections to calculate the equity balance and IRR.
Lastly, The Cash Flow Waterfall displays the contribution and distribution of
the project for investors. This includes metrics such as IRR, NPV, Cash on Cash
Multiple and Equity Multiple for the project.

All cells in blue font are input cells where custom
information can be entered. All cells in black font are formulas set to
streamline the model.
 

Reviews Add a review
No reviews yet

More From D'Errico Financial Services LLC

Browse our top rated business templates. See All
Multi-Family Housing Rental Renovation Model
832
0
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovation and rental of a multi-family housing…
Real Estate Development Model
1,002
0
 The Real Estate Development model projects monthly future cash flows from a development property from the purchase of the land…
Consumer Loan Model
878
0
The Consumer Loan model breaks down the financing structure of a bundle of consumer loans absorbed by a lender. This…
Venture Capital Financial Model
893
2
The Venture Capital Returns Model is used to provide an analysis into an investment return for a VC fund. This…
DCF Valuation Financial Model
1,018
0
The DCF Valuation Model builds on the 3 Statement model by adding a business valuation component for investment through the…
Private Equity Financial Model
837
0
The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model…
See All