IRA Non-recourse calculator

[Bernie Huckestein]

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

[Brian Eastman]

@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.