Just purchased your REIF Model? Here are a list of key places to begin inputting your data. REIF has all the inputs and customizations you need, but the items detailed below (in sequential order) are the starting points and perhaps all you need to build your model as our calculations will do the rest...
1) "How To" tab: Walkthrough of how to use the model, how the it flows, color coded tabs and what each input tab does, color coded cells, data restrictions/locked cells, reports details, and more.
2) "Model Profile" tab: Enter general information about your project. Most data here flows to the other Input tabs listed below, though some of it flows directly to the Financial Reports. Below are some key data entry points on the tab.
Property Name: name for your model
Currently Own Property: do you own the property you're modeling now or will you purchase in the future
Property Purchase Price
Property Value and Growth: rate your property will grow at, the metric to value the property (flat growth rate or Cap Rate), Free Cash Flow Growth Rate
Sale Date: if you will sell your property and when
Loan Financing: how much of your project you will finance and when you take those loans
3) "Cash Flow Inputs" tab: Enter your Cash Inflows (e.g. Rental Income) and Cash Outflows (e.g. Expenses; do NOT include Renovations) and the various parameters (date, amount, etc.) needed to build the formula.
4) "Renovation Inputs" tab: Enter your Renovations and Capital Improvements, if you plan on doing any, and the various parameters (date, amount, line of credit, etc.) needed to build the formula.
5) "Loan Inputs" tab: You already entered when and how much each loan will be on the "Model Profile" tab, now enter the various loan parameters (type, duration, interest rate, etc.) needed to build the formula.
6) Green Customization tabs: You entered the various parameters for each data input (Cash Inflows, Cash Outflows, Renovations, Loans), which builds the formula to generate the output values. That formula data can be customized if needed on those green tabs. If you don't need to customize the data and are good with linearish formulas, then no need to do anything here.
7) "Settings" tab to set Target Metrics: Input target metric hurdles that creates color changing cells based on the output values to identify if those metrics are great, good, average, poor, or awful.
Example: Great rate of return > 30% = highlighted green; Awful rate of return < 10% = highlighted red; Average rate of return = 15% to 25% = no formatting changes (black font color)
8) Review Model Reports - Blue Report tabs : Review all the inputs you entered and customized above and make your investment decision!
The "Key Data Summary" on the Premium model creates a consolidated, data visualization approach for fast, comprehensive analysis to make a sound investment decision in 15-minutes