Realty Analytics Ver. 4.0
Installation
System Requirements
Installing the Software
Setting File Permissions
Uninstalling the Software
Before Getting Started
License Agreement
Disclaimer
Privacy Agreement
Excel Settings and Conventions
Addin and Com File
General Excel Settings
Macro Settings
File Name Extensions
Screen Resolutions
Realty Analytics Ribbon
Ribbon Components
Minimizing the Ribbon
Show / Hide Years
Protected Cells
Unprotecting Worksheets
Excel Headings and Formula Bar
Accessing the VBA Modules
Entering Data
Accessing Help
Software Updates
Managing the Workspace
Adding or Deleting Rows or Columns
Changing the Year of Resale
Executive Dashboard
Components
Launching a New Analysis
Deleting Projects
Comparative Analysis
Using RealQuest Pro Search
Property Listing Services
Property Summary
Property Set Up
Adding Photos
Property Details
Contacts
Summary Numbers
Instant Analyst
Observations and Assessments
Messages
Charts
Instant Analyst Charts
Global Investment Drivers
Entering Drivers
Taxes & Depreciation
Entering Tax and Depreciation Drivers
Price and Units
Purchase Price
Income and Expense
Setting up income and expenses
1st Mortgage
Setting up the First
2nd Mortgage
Setting up the Second
3rd Mortgage
Setting up the Third
Refinance Loan
Set up the refinance loan
Cash Requirements
Reviewing Cash Requirements
Renovations
Enter Renovation Costs
Stabilized Value
Entering Stabilized Value Drivers
Resale Drivers
Entering Resale Drivers
Operating Expense Set Up
Control Center
Components
Adding Expenses
Entering Expenses
Property Management Fees
Property Management Fee
Estimated Income
Estimator Window
Vacancy and Credit Loss
Enter the Vacancy Factor
Fixed Expenses
Entering Fixed Cost Amounts
Variable Expenses
Entering Variable Cost Amounts
Increasing Expenses
Increasing Expenses
Expense Recoveries
Income and Expense Statements
Expense Charts
Operating Expense Charts
Detailed Income Set Up
Control Center
Components
Lease Form Components
Entering Basic Lease Data
Changing Lease Rates
Other Lease Attributes
Adding a new lease
Add New Unit Window.
Deleting a lease
Deleting a Lease
Expense Recoveries
Recovering Expenses
Lease Turnover Tool
Entering Turnover Costs
Automatic Rent Increase Tool
Rent Increase Tool
Purchase And Resale Set Up
Observations and Assessments
Time of Acquisition
Time of Resale
Graph Tools
Using the Graph Tools
Step 1 - Purchase Price and Units
Entering Data
Step 2 - Global Investment Drivers
Driver Set Up
Step 3 - Federal Taxes
Tax Set Up
Step 4 - Depreciation
Depreciation Set Up
Step 5 - First Mortgage
First Mortgage Set Up
Step 6 - Second Mortgage
Second Mortgage Set Up
Step 7 - Third Mortgage
Third Mortgage Set Up
Step 8 - Refinancing
Refinance Set Up
Step 9 - Cash Requirements
Entering Data for Cash Requirements
step 10 - Purchase Side Closing Costs
Entering Closing Costs
Step 11 - Resale Closing Costs
Entering Resale Closing Costs
Step 12 - Resale Valuation Drivers
Entering Resale Valuation Drivers
Step 13 - Interest Rate Set Up
Changing Interest Rates
Step 14 - Funded Reserves
Funded Reserves Set Up
Reserves Calculator
Step 15 - Capital Improvements
Adding Capital Improvements
Step 16 - Historic Rehab
Setting Up Historic Rehab
Mortgage Graph Tools
Modifying Mortgage Charts
Cash Flow Analysis
Rent Roll
Lease Expiration
Chart Set Up
Charts and Graphs
Customizing Charts
Chart Controls
Chart Titles
Chart Listing
Break Even Analysis
Using the Breakeven Tools
Closing Costs
Components of Closing Cost Estimator
Entering Data
100. Gross Amount Due - Borrower
200. Credits to Buyer
300. Cash to or From Borrower
400. Summary of Seller's Transaction
500. Reductions to Seller
600. Cash to Seller.
700. Settlement Charges.
800. Items Payable in connection with the loan
900. Lender Required Advance Payments
1000. Reserves
1100. Title Charges
1200. Government Fees and Taxes
1300. Additional Costs
1400 Total Settlement Charges
Closing Dates
Amortization Tables
Chart Tools
Extra Principal Payments
Business Plan and Reports
Setting Up the Plan
Executive Summary
Adding Photos and Maps
Adding Financial Reports
Adding Charts and Graphs
Adding Supporting Documents
Printing the Plan
Business Plan Output
Table ofContents
Acquisition Details
Financing Summary
Income and Expense Summary
Cash Flow Summary
Measurement of Financial Viability
Key Assumptions Used in the Model
Proforma Income & Expense Statement
Taxable Income and Operating Cash Flows
Analysis of Resale
Summary Cash Flow and Resale Analysis
Risk Assessments
Rent Roll Report
Breakeven Analysis
Charts and Graphs
Working with Line/ColumnCharts
Working with Bar Charts
Working with Pie Charts
Working with Line Charts
Printing
Emailing Business Plan
System Lexicon
Real Estate Dictionary
FAQ
Troubleshooting
Excel Tools and Links
To properly display this page you need a browser with JavaScript support.
< Previous page
Print version
Next page >
Control Center
The Control Center tells you where you are at all times by keeping track of income and recoveries as you go.
What you'll find in: Control Center
Components
Product Features:
Executive Dashboard
Property Summary
Instant Analyst
Expense Setup
Income Setup
Purchase and Resale
Cash Flow Analysis
Rent Roll
Charts and Graphs
Lease expiration Report
Breakeven Analysis
HUD-1 Closing Costs
Amortization Tools
Business Plan
About us
|
Contact us
|
Download Free 7 Day Trial
|
Realty Analytics.net
| © Copyright 2007 Reality Analytics, LLC
Realty Analytics (http://www.realtyanalytics.net)
