RExl - Real Estate Excel Tools

A comprehensive suite of Python scripts and VBA macros for generating professional real estate analysis Excel workbooks.

Get Started GitHub
RExl Dashboard

Python Scripts

Development Budget Generator

development-budget-generator.py

Creates a detailed real estate development budget with summary, detailed budget, and forecast sheets.

Features:
  • Comprehensive budget structure (hard costs, soft costs, other costs)
  • Line-item detail with cost per square foot analysis
  • Visual budget breakdown with pie charts
  • Configurable project details (name, address, size, type)
Usage:
python py/development-budget-generator.py

Mortgage Calculator Generator

mortgage-calculator-generator.py

Generates a mortgage calculator workbook with payment schedules, loan comparison, and affordability analysis.

Features:
  • Principal & interest calculation
  • Amortization schedule
  • Loan comparison tool
  • Affordability calculator based on income
Usage:
python py/mortgage-calculator-generator.py

Running All Scripts

To run all Python scripts and generate all Excel files at once:

python run_all_scripts.py
Output files will be saved to the xl folder by default.

VBA Code

Available Modules

RealEstateAnalysis.bas

Core functions for real estate analysis

PropertyValuation.bas

Methods for valuing properties using various approaches

CashflowProjections.bas

Routines for calculating and visualizing cash flows

Installation Instructions

  1. Open your Excel workbook
  2. Press Alt + F11 to open the VBA editor
  3. Right-click on your project in the Project Explorer
  4. Select "Import File" and navigate to the desired VBA module
  5. Save the workbook as .xlsm (macro-enabled)
Remember to enable macros when opening your workbook.

Generated Excel Files

Real_Estate_Development_Budget.xlsx

Development Budget Preview
Key Components:
  • Summary overview of total development costs
  • Detailed budget with line-item costs
  • Time-based forecast for project spending
  • Cost per square foot analysis

A comprehensive development budget workbook for real estate projects that helps developers and project managers track and forecast all project costs.

Mortgage_Calculator.xlsx

Mortgage Calculator Preview
Key Components:
  • Loan amount, rate, and term inputs
  • Monthly payment calculator
  • Complete amortization schedule
  • Loan comparison tool
  • Affordability analysis based on income

An interactive mortgage calculator that helps borrowers understand payment scenarios, compare different loan options, and determine affordability based on income.

Browse All Excel Files

Getting Started

Prerequisites

  • Python 3.6 or higher
  • Microsoft Excel (2016 or newer recommended)
  • Required Python package: openpyxl

Installation

  1. Clone the repository:
    git clone https://github.com/yourusername/RExl.git
  2. Navigate to the project directory:
    cd RExl
  3. Install required dependencies:
    pip install -r requirements.txt
  4. Run the scripts:
    python run_all_scripts.py

    This will generate all Excel files in the xl folder.

Customization

You can customize the generated Excel files by modifying the Python scripts:

  • Adjust budget categories in development-budget-generator.py
  • Modify default mortgage parameters in mortgage-calculator-generator.py
  • Add new line items or calculation methods as needed
Pro Tip: Make a backup of your scripts before modifying them.