https://www.biggerpockets.com/renewsblog/bp-podcast-197starting-10k-buying-52-units-3-years-chris-heeren/Essentially, it's based on a zero-appreciation, cashflow-intensive model.

The challenge with re-using other people's spreadsheet is that you have to adopt their mental model of how to layout information, and also how to show what's important.For instance, I like to optimize for data-entry, and I want to know what numbers they gave me vs what I think they should be, so I have sections for "Marketing data" and a separate section for "adjustments" to that data.

Right now, my model shows this information automatically once the necessary information is entered: LTV, Cost/PSF, Cap Rate, GRM, CoCR, ROI, DSCR, projected revenues, expenses, and the resulting Gross Rental Income, Op Ex, NOI, Annual CF, Equity Capture, Appreciate and Total Return in dollar amounts over an 10 year model and adjusting for inflation. 

I’m willing to make whatever adjustment(s) necessary to pull this off.  

Would love some insight and some ideas to adjust my approach/ insight on if what I’m looking for is even possible in this market.

A common mistake is discovering one of your assumptions was wrong or that you missed something, and not adjusting your valuation accordingly.

HaleyThere are different ways this can go. 1) if you acquired the property in the current year, you would put the assets in your depreciation schedule just as any other asset and take the benefit of accelerated depreciation. 2) If you did a retroactive cost seg, you have to file for 3115 and take the adjustment as section 481 adjustment3) If you did the cost seg on the properties that were acquired last year(only one tax return has been filed), you could amend your return from the prior year. 

Anyway, I was interested in the real estate angle so I signed up for the "Intensive" course, which turned out to be another 3 day sales pitch for the really expensive mentorship program.

So you don't even have the normal balloons or calls or adjustable rates of a standard commercial loan with this 5-unit?  

I have been a property claims adjuster for over 25 years.