All
Members
Companies
Blog
Forums
Podcast
Webinars
    User Log in  /  Sign up
  • Forums
    Newest Posts Trending Discussions Followed Forums Real Estate News & Current Events General Landlording & Rental Properties Buying & Selling Real Estate Deal Analysis See All
  • Education

    Read

    BiggerPockets Blog BPInsights: Expert Analysis Guides Glossary Reviews Member Blogs

    Watch

    Webinars Video Library Financial Independence Blueprint Intro to Real Estate: Rentals

    Listen

    BiggerPockets Real Estate Podcast BiggerPockets Money Podcast BiggerPockets Business Podcast Real Estate Rookie Podcast Daily Podcast (Audio Blog)

    Topics

    Business Operations Finance Finding Deals Property Management Property Types Strategy
  • Network

    Recommended Vendors

    Real Estate Agents Mortgage Lenders Hard Money Lenders Insurance Contractors Investment Companies Build Your Team

    Search

    Members Events Jobs
  • Tools

    Calculators

    Rental Property Fix and Flip BRRRR Rehab Estimator
    Wholesaling Mortgage Payment 70% Rule Airbnb

    Services

    BPInsights: Property Insights Tenant Screening Property Management Lease Agreement Packages

    New Feature

    BPInsights (beta)

    Quickly analyze a property address or ZIP Code to compare your rent in your neighborhood.

    Analyze a property
  • Find Deals
    Real Estate Listings Find Foreclosures External Link Ads, Jobs, and Other
  • Bookstore

    Real Estate Books

    Profit Like The Pros Bidding to Buy See all books

    Featured Book

    BiggerPockets Wealth Magazine book cover
    BiggerPockets Wealth Magazine

    Written by financial journalists and data scientists, get 60+ pages of newsworthy content, expert-driven advice, and data-backed research written in a clear way to help you navigate your tough investment decisions in an ever-changing financial climate! Subscribe today and get the Oct/Nov issue delivered to your door!

    Get the Magazine
  • Pricing
Log In Sign up
User
Quick search links
Podcast Hard Money Lenders Books Washington
ForumsArrowReal Estate Deal Analysis and AdviceArrowIRA Non-recourse calculator
  • Newest Posts
    • Newest Posts
    • Unanswered Discussions
  • Trending
    • Top Discussions
    • Trending Discussions
  • Browse Forums
Search Nova
Create post

IRA Non-recourse calculator

4 Replies

  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
Rotate Log in or sign up to reply
user profile avatar
  • Posts 155
  • Votes 63

Bernie Huckestein
Rental Property Investor from Apopka, FL

posted over 3 years ago

I am looking for (or looking to create) a spreadsheet to make financial projections on use of SDIRA funds -- does anyone know where I might start...here is my general thoughts / situation but I'd like to find/create a spreadsheet to model different alternatives:

I have $200k which can be moved to a SDIRA, although I need to do additional research I think I can get non-recourse finding for 50% ltv.  I have about 14 years before I am forced to make withdraws.

For my illustration here I would assume to purchase 4 single family homes ~$100k each. Back of the napkin calculation let's just say these would produce $5,000 a month gross and $3,800 NOI, loan payments ~$1,300 leaving $2,500 cash flow to the IRA monthly. That is a 15% return, I know using the rule of 72 in 4.8 years my 200 and now 400, then if re-invested @15% my $400k becomes $800k in about 9.5 years and the $800 becomes nearly $1.6 M by the time I need to withdraw funds.

This is what I want to model to determine the best current alternative + to keep the money working I'd need to add another investment every two years or so.

In addition to the $1.6 million you would have the loan pay down and any appreciation which after 14 years could easily add another 15-20% (blended).

I've tried to keep the example above simple but also realize the spreadsheet model would need to accurately account for:

Cost to purchase, cost to sell, UBIT, management, etc., etc.  --  for me I am not terribly concerned about UBIT as I think worrying about that is like stepping over dollars to pick up pennies, although maybe it changes my return from 15% to something a little less.

On a similar note, this might be a great BiggerPockets calculator with a couple of tweaks it could be used for IRA investor or a standard business modeling tool if all monies are remain in the business / not withdrawn to pay personal living expenses.

I can create this spreadsheet but I am not particularly good at making things like this user friendly....appreciate any direction others might have for something currently available or something that could be used as a starting point.

Thanks, bernie

Rotate Log in or sign up to reply
user profile avatar
  • Posts 2.6K
  • Votes 2.2K

Brian Eastman
Self Directed IRA & 401k Advisor from Boulder, Colorado

replied over 3 years ago

@Bernie Huckestein

We have a property calculator that includes UDFI cost for debt-financed properties in an IRA.

We are not allowed to promote or link outside corporate owned websites from BP.  PM me and I'll send you a link.

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Rentals, Flipping, and Team
  • Posts 3.8K
  • Votes 3.0K

Chris Seveney
Investor from Northern Virginia

replied over 3 years ago

@Bernie Huckestein
One note In your calculation - you note NOi of 3,800 and 1,300 in loan payments for $2500 to your IRA. I believe That is incorrect. Whatever percentage of ownership your SDIRA has is the amount that flows back to it. If you borrowed 50% then 50% flows into SDIRA. I would check with someone on that

Rotate Log in or sign up to reply
user profile avatar
  • Posts 2.6K
  • Votes 2.2K

Brian Eastman
Self Directed IRA & 401k Advisor from Boulder, Colorado

replied over 3 years ago

@Chris Seveney

@Bernie Huckestein is making the correct basic assumption. When an IRA borrows, 100% of the income generated by the IRA's investment must flow to the IRA.

The IRA is the borrower, not the IRA account holder.

If the NOI is $3,800 and there is $1,300 in loan payments, then $2,500 does flow to the IRA as pre-tax income.

While not a direct correlation, that $2500 will be partially taxable to the IRA per UDFI taxation. The way it actually is calculated is not on the net income, however. 50% of the gross income is taxable, and this taxable income is offset by 50% of the allowable deductions such as depreciation, interest on the note, etc. (assuming 50% debt-financing ratio as in Bernie's illustration). That net income is then run through the trust tax table and tax due is paid by the IRA using form 990-T.

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Rentals, Flipping, and Team
  • Posts 3.8K
  • Votes 3.0K

Chris Seveney
Investor from Northern Virginia

replied over 3 years ago

@Brian Eastman - thank you for the clarification

Rotate Log in or sign up to reply
  • 1
Related Resources Real Estate Deal Analysis and Advice
The 2% Rule: Fact, Fiction, or Feasible? (Updated 2021)
Is That Neighborhood Up-and-Coming? Here’s How to Tell
Do Your Due Diligence Before Digging Up Dirt: Investing in Vacant Land 101
Best Deal Ever: How a Postcard Gets the Phone Ringing
Meet the Investors: I Sold My Wife on House Hacking With a PowerPoint (& Soon We’ll Live for Free!) Featuring Joaquín Camarasa
Resources Read, see, and learn more!
Link Real Estate Investment Calculators
Link BiggerPockets Blog
Link Path to Purchase
Link Mortgage Loans
Link Find a Contractor
Link Real Estate Agents
Link Hard Money Lenders
Link Real Estate Listings

Top Contributors

Joe Villeneuve
Joe Villeneuve
Plymouth, MI
9.29
Score
Justin Phillips
Justin Phillips
Phoenix, AZ
5.72
Score
Joe Splitrock
Joe Splitrock
Sioux Falls, SD
5.16
Score
Deryck C.
Deryck C.
San Francisco Bay Area
4.63
Score
Collin Lee Johnson
Collin Lee Johnson
Mankato Minnesota
3.36
Score

Real Estate Deal Analysis and Advice Trending Discussions

  • Northern Virginia Market - Is Anyone Actually Making Money?
    21 Replies
  • First Timer. Can anyone help me analyze this deal?
    10 Replies
  • Beach area north of Tulum! Worth investing?
    15 Replies
  • Credit cards for rehab projects
    5 Replies
  • Am I overcomplicating my analysis?
    3 Replies
Log in Sign up

Log in

Forgot password?

If you signed up for BiggerPockets via Facebook, you can log in with just one click!

Log in with Facebook

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Let's get started

We just need a few details to get you set up and ready to go!

Use your real name

Use at least 8 characters. Using a phrase of random words (like: paper Dog team blue) is secure and easy to remember.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Why create an account?

Receive a free digital download of The Ultimate Beginner's Guide to Real Estate Investing.

Connect with 1,000,000+ real estate investors!

Find local real estate meetups and events in your area.

Start analyzing real estate properties, we do the math for you.

It's free!

Explore

  • Membership
  • Community
  • Education
  • Marketplace
  • Tools
  • FilePlace
  • REI Resources
  • Perks
  • Glossary
  • Reviews
  • iOS App
  • Android App

Company

  • About Us
  • Press
  • Advertising
  • Careers
  • Stats
  • Contact Us

Important

  • Editorial Guidelines
  • Terms of Use
  • Rules
  • Privacy
  • FAQ

Social

  • Facebook
  • Twitter
  • YouTube
  • Instagram
© 2004-2021 BiggerPockets, LLC. All Rights Reserved.