• Link to Facebook
  • Link to Youtube
  • Link to LinkedIn
  • Link to X
  • Link to Tiktok
  • Link to Instagram
  • EN ESPAÑOL
    • Inicio
    • Glosario de Términos
    • Modelos Financieros
    • Tutoriales Cortos
  • A.CRE HELP
    • Support Section
    • Contact Us
  • LOGIN/REGISTER
  • Shopping Cart Shopping Cart
    0Shopping Cart
Adventures in CRE
  • A.CRE
    • A.CRE Home
    • A.CRE Help
    • Accelerator
      • Learn More
      • Login
    • AI.Edge
      • Learn More
      • Login
    • Artificial Intelligence
    • Careers
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • Meet the A.CRE Team
  • RE Modeling
    • 1031 Exchange
    • Audio Series
    • All-in-One (Ai1) Model
      • Download
      • Guides and Tutorials
      • Support
    • Ask Me Anything (Live)
    • Beginner’s Guide to Excel
    • Excel Models
      • Excel Add-ins
      • Library of Excel Models
      • All-in-One (Ai1) Model
      • Apartment
      • Condo
      • Debt
      • Development
      • Equity Waterfall
      • Hotel
      • Industrial
      • Office
      • Portfolio
      • Retail
      • Single Family
      • Tutorial
    • Excel Tips
    • Practice Library of Case Studies
    • Stochastic Modeling
    • Argus
    • My Downloads / My Account
  • Careers
    • About Careers in Real Estate
    • Ask Me Anything (Live)
    • Audio Series
    • Compensation in Real Estate
    • CRE Job Board
      • Find a Job
        • Browse Jobs
        • Post a Resume
        • Register
        • Login
      • Post a Job
    • CRE Event Calendar
    • CRE Interviews
    • Day in the Life Series
    • Real Estate Legal Content
    • What CRE Pros Do
  • Education
    • Accelerator
    • AI.Edge
    • A.CRE 101
    • Ask Me Anything (Live)
    • A.CRE Audio Series
    • Audio Series
    • Book Reviews
    • CRE Event Calendar
    • Deep Dive Series
    • Glossary of CRE Terms
    • Real Estate Legal Content
    • Real Estate Clubs
    • University Profiles
    • Watch Me Build
  • AI
    • AI Skills
    • AI Use Cases in CRE
    • AI for CRE Training
    • AI Tools for CRE
    • AI.Edge Membership
      • Learn More
      • Login
  • Accelerator
    • Accelerator Reviews
    • Accelerator Story
    • Enroll Now
    • Learn More
    • See What’s New
    • Enterprise Members Only
      • General Enterprise Login
      • ICSC Login
      • M&M Login
    • Members Only
      • Extend/Renew Membership
      • Login
      • Manage Membership
  • My Downloads
    • View My Downloads
    • Find an Excel Model
    • Register
    • Login
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
You are here: Home1 / Real Estate Financial Modeling2 / Case Study #16: Sunset Vista – The Hold/Sell Decision
Emilio Tovar
Real Estate Financial Modeling, Real Estate Case Studies

Case Study #16: Sunset Vista – The Hold/Sell Decision

THE BACKGROUND

You are Alexa Rivera, a real estate financial advisor who supports small investors, including teachers, business owners, and retirees, who own real estate as part of a long-term wealth-building strategy. Your clients typically hold single-family rentals, small multifamily properties, or vacation homes as a “side business,” intending to generate passive income and long-term appreciation.

Over the years, you’ve built a reputation for delivering clear, actionable financial insights tailored to non-institutional investors. One of your long-time clients, Arthur Vandelay, a small business owner based in San Diego, purchased a three-bedroom single-family rental in Oceanside eight years ago. The home has appreciated nicely, and Arthur approaches you with a key question centered on a classic hold/sell decision:

“Should I keep the property for another five years or sell now and reinvest the proceeds into a different opportunity?”

Arthur’s concern is whether he is letting potential gains slip away by holding onto a maturing asset. At the same time, he’s cautious about transaction costs, capital gains taxes, and the uncertainty of future returns.

hold/sell decision

SUNSET VISTA – PROPERTY DETAILS

Arthur’s property, nicknamed “Sunset Vista”, is a 1,650-square-foot single-family rental located four blocks from the beach. It’s currently leased to a long-term tenant at $3,200/month. The tenant’s lease ends in nine months, at which point Arthur can either increase the rent to market (~$3,600/month), sell the home, or continue leasing at a modest increase.

Below are the key financial assumptions for Sunset Vista, which will inform the hold/sell decision analysis:

  • Current Rent: $3,200/month (below market)
  • Market Rent: $3,600/month with 3% annual increases
  • Operating Expenses: $7,200/year (excluding debt service)
  • Annual Property Tax: 1.25% of the market value
  • Current Market Value: $810,000
  • Outstanding Loan Balance: $430,000
  • Interest Rate: 4.25%, 30-year fixed, P&I
  • Selling Costs (Brokerage, Legal, Fees): 7% of sale price
  • Reinvestment Option: Buy a fixer-upper for $628,000 and invest $75,000 in rehab with the intention to flip or hold

THE TASK

Arthur needs your help to evaluate two potential paths in a hold/sell decision scenario.

Option 1: Hold Sunset Vista

  • Hold for another five years
  • Re-lease the home at market rent when the current lease ends
  • Assume 3% annual rent growth and similar appreciation
  • Reassess sale in year 5

Option 2: Sell and Reinvest

  • Sell Sunset Vista immediately
  • Net the after-tax, after-fee proceeds
  • Reinvest in a fixer-upper project (either to flip or hold long-term)

You advise Arthur that the most effective way to evaluate this hold/sell decision is by quantifying projected returns in both scenarios. You decide to use A.CRE’s trusted modeling tools to support your recommendation.


TOOLS TO USE

1. For analyzing the potential reinvestment (flip):

Use the A.CRE House Flipping Pro Forma Model.

Alternatively, you and Arthur can test the numbers himself using the A.CRE House Flip Web App, which allows him to input assumptions and download the Excel model.

2. To decide between holding or selling Sunset Vista:

Follow the framework outlined in this article: A.CRE Hold/Sell Analysis.

Apply Net Present Value (NPV), IRR, and equity multiple concepts over a 5-year horizon for the hold scenario.

3. To review the full details of the reinvestment opportunity:

You should download the Offering Memorandum (OM) for the fixer-upper deal. The OM includes all key assumptions, project timelines, market comps, and exit strategies.


SUNSET VISTA – THE QUESTIONS

  1. Using A.CRE’s tools and your assumptions, what is the projected:
    • What is the projected levered IRR and equity multiple if Arthur holds Sunset Vista for five more years?
    • Levered IRR and equity multiple if he sells now and reinvests in the flip opportunity?
  2. Debt Structuring: For both the hold and reinvestment scenarios, define a reasonable set of debt assumptions (LTV, interest rate, amortization, loan fees) using publicly available market data or a lender term sheet from similar deals.

    • How do these assumptions impact the investment’s cash flow and overall return?
    • Would a more aggressive or conservative leverage profile be more appropriate in this context?
  3. What are the peak equity needs in the reinvestment scenario?
  4. Which option offers the highest risk-adjusted return, and what factors support that conclusion?
  5. Beyond returns, what qualitative factors might influence Arthur’s decision (e.g., time involvement, liquidity, tax exposure)?
  6. Investor Profile Sensitivity Analysis: Assuming Arthur has varying levels of risk tolerance, he might consider alternatives to real estate, such as:
    • A bond fund with stable 4% annual returns
    • A diversified stock portfolio targeting 8% returns with higher volatility

How might his hold/sell decision change based on his risk profile (e.g., conservative, balanced, or aggressive)? What would be the most appropriate option in each case, and why?

(Use justification grounded in expected returns, liquidity, time involvement, and risk tolerance.)


Frequently Asked Questions about the Sunset Vista Hold/Sell Case Study

What is the core question being evaluated in this case study?

The central question is whether Arthur should hold onto his current rental property (Sunset Vista) for another five years, or sell it now and reinvest in a new real estate opportunity—specifically, a fixer-upper project. The decision is based on comparing projected returns, equity needs, and qualitative factors.

What financial metrics are used to evaluate the hold vs. sell options?

Key financial metrics include:
– Levered Internal Rate of Return (IRR)
– Equity Multiple
– Net Present Value (NPV)
These metrics are calculated over a 5-year hold period using A.CRE’s Hold/Sell Analysis framework and House Flipping Pro Forma tools.

How does the reinvestment scenario work if Arthur sells Sunset Vista?

If Arthur sells Sunset Vista, he nets the after-tax and after-fee proceeds and reinvests them into a $628,000 fixer-upper, with $75,000 in rehab costs. The new project can be either flipped for profit or held as a rental. Returns are modeled using the A.CRE House Flip Pro Forma or Web App.

What tools are recommended for modeling these scenarios?

Use the following tools:
– Hold/Sell Analysis article for structure and methodology
– A.CRE House Flip Web App or downloadable model for the reinvestment project
– Offering Memorandum (OM) for deal assumptions and comps
Each tool helps quantify risk, returns, and capital needs more precisely.

What debt assumptions should be considered in both scenarios?

Typical debt assumptions include:
– Loan-to-Value (LTV): 70%–75%
– Interest Rate: 6.25%–7.00%
– Amortization: 25–30 years
– Loan Fees: 1%–2%
These assumptions impact cash flow, return volatility, and the peak equity required. Leverage should be matched to Arthur’s risk profile—conservative if he values stability, more aggressive if seeking higher upside.

How does Arthur’s risk tolerance affect the decision?

Arthur’s decision could shift depending on his investor profile:

– Conservative: May prefer holding Sunset Vista or reallocating to bonds (4% return, low risk).
– Balanced: Could benefit from the hold or flip, depending on effort and return expectations.
– Aggressive: May favor the fixer-upper flip with higher upside potential, despite added complexity and risk.

Each path should be evaluated for liquidity, time involvement, return variability, and risk-adjusted returns.

What qualitative factors could influence Arthur’s decision beyond returns?

Non-financial considerations include:
– Time involvement (flips may be more hands-on)
– Liquidity needs (Sunset Vista is less liquid during the hold)
– Tax exposure (capital gains on sale)
– Lifestyle goals (passive vs. active investment)
– Market risk (timing future appreciation or price dips)
These can often tip the scale even when the financials are close.

What is the peak equity requirement for the reinvestment option?

Arthur’s peak equity will depend on:
– Net sale proceeds from Sunset Vista
– Rehab costs ($75,000)
– Down payment based on LTV
– Reserves and closing costs
This total should be clearly modeled in the flip pro forma to confirm feasibility before proceeding.

What’s the biggest mistake to avoid in a hold/sell analysis?

Avoid basing the decision purely on intuition or market comps. Use structured financial modeling, realistic assumptions, and risk-adjusted return analysis. Emotional attachment or outdated performance expectations can lead to suboptimal choices.


About the Author: Emilio is a Financial Analyst on the A.CRE team. He has a diverse background, with experience in import/export economics, blockchain, marketing, programming and trading. He has built his career by getting involved in projects he is passionate about, which led to his interest in commercial real estate and A.CRE. In his spare time, he loves to cook and learn more about technology. To contact Emilio by mail click here.

Contact Emilio

by Emilio Tovar
Share this entry
  • Share on X
  • Share on LinkedIn
  • Share by Mail
  • Link to Instagram
  • Link to Youtube
https://www.adventuresincre.com/wp-content/uploads/2026/01/Imagen1.jpg 1024 1536 Emilio Tovar https://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.png Emilio Tovar2026-01-21 08:01:432026-01-23 08:04:53Case Study #16: Sunset Vista – The Hold/Sell Decision
You might also like
Single Tenant Net Lease Valuation Model – Custom GPT by A.CRE
Case Study #1 – Presidio (Case + Solution, Updated May 2024)
Maplewood Plaza Value-Add Retail Case Study Case Study #12 – Maplewood Plaza: Value-Add Retail (Case Only)
Case Study #7 -The Cellon Group – Asset Management Analyst Test (Case + Solution, Updated June 2024)
Real Estate Case Studies Creator Assistant – Custom GPT by A.CRE (Updated Oct 2024)
Advanced Mortgage Amortization Schedule – Custom GPT by A.CRE

Featured Content

  • RE Financial Modeling Accelerator
  • A.CRE Job Search
  • Library of Real Estate Excel Models
  • Real Estate Financial Modeling
  • Real Estate Education
  • Real Estate Careers
  • AI in Real Estate

Recent Posts

  • The 2008 Financial Crisis, From the Ground Up: Why We Believed Houses Were Safe
  • Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated June 2026)
  • A.CRE Self Storage Development Model (Updated June 2026)
  • Episode 12 of Multipliers: Ask Why Until the Answer Changes
  • A.CRE Jobs of the Week (Updated 6.22.2026)
Accelerator - Learn More

Search Adventures in CRE

Search Search

Have a Question or Need Help?

Visit our Help Section

Contact Adventures in CRE

  • Visit A.CRE Help
  • Via Email
  • Via LinkedIn

You Might Also Like

  • Real Estate Modeling Courses
  • Real Estate Financial Modeling
  • A.CRE Job Board
  • Careers in Commercial Real Estate
  • Real Estate Education

A.CRE Library of Excel Models

  • Browse Excel Models
  • Login/Register
  • View My Downloads
  • Edit Account Details

Terms, Policies, and Disclaimer

  • Privacy Policy
  • Cookie Policy
  • AI Usage Policy
  • Terms of Use
  • Disclaimer
© 2014 - Present - Copyright - www.AdventuresinCRE.com, LLC | Adventures in CRE | A.CRE
  • Link to Facebook
  • Link to Youtube
  • Link to LinkedIn
  • Link to X
  • Link to Tiktok
  • Link to Instagram
Link to: Self Storage Acquisition Model (Updated Jan 2026) Link to: Self Storage Acquisition Model (Updated Jan 2026) Self Storage Acquisition Model (Updated Jan 2026) Link to: Herramienta de retratos profesionales con IA para bienes raíces: por qué lo hicimos y cómo usarla Link to: Herramienta de retratos profesionales con IA para bienes raíces: por qué lo hicimos y cómo usarla Herramienta de retratos profesionales con IA para bienes raíces: por qué lo...
Scroll to top Scroll to top Scroll to top