Real Estate Financial Model Excel Template for Complete Valuation with 2 Lien Positions

Complete Excel Template for financial evaluation of single and multifamily Real Estate investments in rental property

Original Best Practice:  Real Estate Excel Financial Model for Valuation of Hot Weather Property  by Prof. Gustavo Quintini

Description
Complete Excel Template for financial evaluation of single and multifamily Real Estate investments. This template contains the following sheets:

-Financial Summary: This tab shows the outputs of the model based on the information on the Input Tab. You do not need to enter any data here. You will find Un-Levered, Levered, and After-Tax IRR Calculations as well as these same returns based on varying key inputs. This should provide a range of returns in order to get a sense of the risks involved in the investment. Note: The data table factors must be adjusted on the financial inputs tab (grouped and hidden) at the bottom of the worksheet.

-Revenue Breakdown: This graph is used to show where the revenue is either used for operating expenses or retained as Net Income.

-Financial Inputs: Use this tab to enter all of the relevant investment related information. In general the inputs that should be manually change are in Blue font. The inputs in Black font are calculated off of other data and do not need to be changed by the user. A more detailed explanation of the sections is below:

-Underwriting CF Analysis: This tab calculates all of the relevant investing cash flows, based on all the data on the Financial Inputs tab, necessary to determine the rate or return on the modeled investment.

-Exhibit I - Income Statement, Exhibit II - Stmt. of Cash Flows, Exhibit III - Loan Amortization: These tabs are informational that can be used for analysis or other purposes.

-Actuals: This tab will be used in order to track actual results of the investment versus what was originally modeled. Over time this is will allow a user to better estimate and define the inputs that go into each of the investments being modeled.

This tab can only be used after the user has modeled the investment. Values from the Underwriting CF tab must be pasted into the Actuals tab. Then as results come in they can be input into the correct month.

-Actuals vs. Model: This tab compares the results from the Actuals tab versus what was originally modeled. The model can then be adjusted accordingly.

This Best Practice includes
1 Excel File

Acquire business license for $30.00

Add to cart

Add to bookmarks

Discuss

Further information

Multifamily Real Estate Rental Property Financial Evaluation


0.0 / 5 (0 votes)

please wait...