Skip to content
Real Estate Spreadsheets
  • SpreadsheetsExpand
    • Rental Property Analysis
    • House Flipping & Rehab
    • Airbnb Calculator
    • Comparative Market Analysis
    • Excel Mortgage Calculator
  • Online CalculatorsExpand
    • Rental Property Calculator
    • House Flipping Calculator
    • Airbnb Estimator
  • My AccountExpand
    • Orders
    • Downloads
    • Account Details
    • Affiliate Dashboard
  • HelpExpand
    • Contact Us
    • FAQs
    • Documentation
    • Changelog
  • ResourcesExpand
    • Blog
    • Best Real Estate Resources
    • Home Inspection Checklist
Shopping Cart 0
Pricing
Real Estate Spreadsheets

Support

5
  • How to Open a Corrupted Workbook
  • How to Fix “The File Extension Is Not Valid”
  • I get a #NAME? error when opening the spreadsheet
  • How to download my spreadsheet?
  • How to unblock macros?

Learning

1
  • Key Financial Ratios

Rental Property

10
  • Mortgage Tab
  • Estimate Maximum Purchase Price
  • Run Alternative Scenarios
  • Available Reports
  • Multi-Unit Forecasts
  • Dashboard Overview
  • Forecasts Sheet
  • Debt Sheet
  • Multi-Units Assumptions
  • Customize Your Spreadsheet

House Flipping

12
  • Getting Started
  • Dashboard Overview
  • Build Your Repair Database
  • Review Your Project By Area
  • Keep Track of Deadlines (Schedule)
  • Compare Actuals Vs. Budget (Tracker Tab)
  • Keep Track of Your Expenses
  • Keep Track of Your Vendors
  • Run Alternative Scenarios
  • Estimate Maximum Purchase Price
  • Customize Your Spreadsheet
  • Available Reports

FAQ

4
  • How to Add My Own Logo & Property Photo
  • How to change the Print Area on a worksheet
  • How to change column size of a sheet?
  • How to whitelist an Email Address

Sourcing Data

3
  • How to Estimate Rent
  • How to Estimate Vacancy Rate
  • How to Estimate Operating Expenses

Comparative Market Analysis

4
  • Listing Tab
  • Comps Analysis
  • Selection Report
  • Summary Report

Licenses

8
  • Where can I find my license key?
  • How do I register my spreadsheet?
  • How many license keys can I get?
  • How do I generate a license key?
  • How can I delete my license key?
  • How can I associate my license with another computer?
  • What is the Workbook Key?
  • What is the Check Status button?

Affiliate Program

6
  • What is your Affiliate Program?
  • How do I join your program?
  • What happen after a customer clicks my link?
  • Where do I get my affiliate link?
  • How do I get paid?
  • How does the dashboard work?
  • Home
  • Docs
  • House Flipping
  • Run Alternative Scenarios
View Categories

Run Alternative Scenarios

1 min read

0:00 / 2:25
  • View as Markdown Open this page as plain Markdown (opens in a new tab)
  • Export PDF Download this page as a PDF
  • Open in ChatGPT Ask questions about this page (opens in a new tab)
  • Open in Claude Ask questions about this page (opens in a new tab)
  • Open in Google AI Studio Ask questions about this page (Google account required) (opens in a new tab)

Description #

The Scenario Analysis tool is a great way to quickly assess the impact of variations in key Assumptions on your project profitability (often called sensitivity analysis or scenario analysis).

Our spreadsheet offers scenarios built around 4 Assumptions: Purchase Price, After-Repair Value, Repair Estimate and Holding Period. Profitability impact is estimated based on 4 Financial Ratios: Project Profit ($ amount), Return on Investment (ROI), Annualized ROI and Internal Rate of Return (IRR).

With this tool, it becomes very easy to assess how your project profit, ROI or IRR is impacted by a change in your purchase price or a delay in your rehab project for instance. When such analysis is performed, all other parameters in your model are assumed constant.

To run the analysis, you need to input 2 parameters for each of the 2 assumptions displayed in the table (x- and y-axes):

Scenario Parameters

  • Mid-Value: represents the central value of that parameter in the table (i.e. central row for Purchase Price and Holding Period / central  column for ARV and Repair Estimate)
  • Interval: defines the increment / reduction in value from one row (or column) to another for that particular parameter

Once your parameters have been set, you can run the analysis by pressing F9 on your keyboard. This will populate or refresh all tables.

Important: Your parameters’ values must be plugged and cannot be linked directly to another sheet of this workbook (like the Dashboard) or it will create circularities which will prevent Excel from running the analysis properly.

Please also note that your Repair Estimate Method in the Dashboard must be set as “Lump Sum” in order for the Holding Period / Repair Estimate Scenario analysis to run properly.

Exemple #

The exemple below shows how decreasing or increasing you ARV by $10,000 impacts your project profit, ROI, annualized ROI and IRR. We set the mid-range at $610,000, which is our expected After-Repair Value but you can set that parameter to any desired value. Each of the below tables also shows the impact on profitability of a $5,000 variation in Purchase Price (with a mid-value of $400,000)

How to read results:

  • Assuming a Purchase Price of $400,000 and an ARV of $610,000 (both being our mid-range values), we can expect a project profit of $41,402 and a ROI of 22.9% (as shown in the center of each table). Should the ARV decrease by $10,000, our projected profit would decrease to $31,402 and our ROI to 17.4%.
  • Conversely, an increase to our ARV to $630,000 associated with an increase to our Purchase Price to $410,000 would lead to a project profit of $51,034, a ROI of 27.9%, an annualized ROI of 83.8% (assuming an holding period of 4 months) and an IRR of 111.6%

scenarios-outputs

 

Still stuck? How can we help?

How can we help?

Updated on September 11, 2021
Keep Track of Your VendorsEstimate Maximum Purchase Price

Powered by BetterDocs

Table of Contents
  • Description
  • Exemple
The Ultimate Source of Real Estate Spreadsheets
Facebook Twitter Instagram Facebook Group Pinterest Linkedin

Spreadsheets

  • Rental Property Analysis
  • House Flipping & Rehab
  • Airbnb Calculator
  • Comparative Market Analysis
  • Excel Mortgage Calculator

Resources

  • Blog
  • FAQs
  • Documentation
  • Changelog
  • Best Resources
  • Home Inspection Checklist

About Us

  • About Us
  • Terms And Conditions
  • Privacy Policy
  • Contact Us
  • Become an Affiliate

Other Websites

  • Disciplined Finance

    Graz-Apotheke.com

© 2026 Real Estate Spreadsheets – All rights reserved.

  • Spreadsheets
    • Rental Property Analysis
    • House Flipping & Rehab
    • Airbnb Calculator
    • Comparative Market Analysis
    • Excel Mortgage Calculator
  • Online Calculators
    • Rental Property Calculator
    • House Flipping Calculator
    • Airbnb Estimator
  • My Account
    • Orders
    • Downloads
    • Account Details
    • Affiliate Dashboard
  • Help
    • Contact Us
    • FAQs
    • Documentation
    • Changelog
  • Resources
    • Blog
    • Best Real Estate Resources
    • Home Inspection Checklist
Purchase
Search