Help While You Model Build: Notes, Data Restrictions, Dynamic Inputs, Model Links, Hiding Cells

REIF has set up various items in the model to assist you as you build it out...

Notes: When you scroll over the cell with a red triangle in the top right corner a "note" pops to help explain what the cell does, what data to enter, and how it will filter through the model.

Data Restrictions = Error Proof Data: No need to worry about improper data entry (e.g., a positive value instead of a negative) as REIF contains built in data validation to keep you on the right track. If you try and enter the wrong type of value into the cell, it will be rejected and the model stays intact.

Dynamic Inputs = Adjusting Data Entry = Avoiding Confusion: Cell titles adjust and unused cells are blacked out based on the options you select to remove any confusion on where or what data you’re supposed to enter. Example: Fixed Rate Mortgage doesn't need the Adjustable Rate Fixed Years, but an ARM does and as such Adjustable Rate Fixed Years will be present for the ARM and absent for the Fixed Rate Mortgage.

Model Links: At the top of most worksheets you will see two links - "TOC" and "Scorecard: ". When clicked, they will take you within the to the "Table of Contents" and "Project Score and Project Grade" worksheets.

• "Table of Contents": Links to every worksheet within the model. This way you can quickly navigate to any other worksheet in the model.

  • For example, let's say you're entering expenses and want to see how it changes the cash flow. You can enter the data on "Expense INputs" then click "TOC", from there you can click on the Monthly or Annual "Financials" link, which will take you right to that worksheet.

• "Scorecard: ": Links directly to the "Inv Sum Scorecard" sheet/tab. Next to "Scorecard: " you will also see the current grade for the project, that way you can see how changes in assumptions will impact your Project Score and Project Grade.

Hiding Cells: On the top left of some worksheets you will see a cell that says "Cells: View or Hide" with a little arrow in the bottom right. Click that arrow and uncheck "Hide" and then click "OK". Only the cells that are visible will be shown now. If you add data (e.g. new Cash Flow), simply run the above again and the cell will now appear as it was hidden initially.

• On the "Financial Statements" the cells are NOT locked and you can thus override the formula values to "View" or "Hide" as needed.

Support Guarantee: If you have questions or issues using the REIF model, we’ll provide assistance, including a web meeting if needed.