All Forum Posts by: Ryan Hogan
Ryan Hogan has started 0 posts and replied 18 times.
Post: Modeling Prepayment Penalties in Excel?

- Investor
- Asheville, NC
- Posts 19
- Votes 41
I see where you're going with YM vs SD... one way is Data Validation list with YM or SD, then into a nested if/then function, but within the nested function, you may need a max of say two criteria from your lender for YM. How granular you want to get, for example if your original plan is to hold for 60 months, but you may decide in month 34 you want to ReFi, pending your lender, they may have two criteria, either a Minimum Prepayment Penalty (e.g. 1% of the loan) or an Equivalent Yield of Remaining Term, the Maximum of the two. Example formula:
=MAX(Minimum_Prepayment_Penalty*Outstanding_Loan_Balance_Upon_Payoff,((1-((1+Equivalent_Yield_of_Remaining_Term_Treasury)^(-Remaining_Term_Upon_Payoff/12)))/Equivalent_Yield_of_Remaining_Term_Treasury)*((Outstanding_Loan_Balance_Upon_Payoff*(Interest_Rate-Equivalent_Yield_of_Remaining_Term_Treasury))))
I don't have anything for SD, yet. A work in progress...
Post: Apartment Analysis Software

- Investor
- Asheville, NC
- Posts 19
- Votes 41
To add to all of the great info already noted above, if you're interested in starting from scratch, building your own model, I recommend Udemy courses from Justin Kivel... great instructor, teaches all kinds of shortcuts, tips, tricks how to be more efficient. As a beginner with no prior experience, seeing how it was actually built, I learned a great deal about the ins and outs of underwriting. As with any excel UW model, repetition, repetition, repetition has also been a big help.
https://www.udemy.com/user/justinkivel/
He also has an advanced course that includes various stress tests, next buyer analysis, hold-sell analysis, CF distributions, Uneven waterfall CF, EM (Equity Multiple) waterfall hurdles, clawbacks, etc...
Post: Just another question on Coaching- 20k for 2 years

- Investor
- Asheville, NC
- Posts 19
- Votes 41
Manmath,
I spent 13 years in a 9a-5p with zero real estate experience. I joined J&G last May… one of the best decisions I’ve ever made… if you (or anyone) would like further details, feel free to DM me.
*** FULL DISCLOSURE*** I don’t get paid or compensated or anything from anyone in or related to the J&G community. These are my own personal opinions / viewpoints.
“Relationship with the group” is an excellent way to describe this community. From my point of view it’s an all-encompassing program, specifically geared toward value add approach. There are other approaches to multifamily real estate investment such as new construction or institutional / A-class wealth preservation. In my personal opinion, I don’t want to deal with the permitting or local politics of new construction and I don’t have millions of my own in wealth to preserve. The value add approach is most suitable for what I envision and where I would like to go in the future. I had zero past experience, so diving in head first made my learning curve very steep.
The Academy program includes both mentoring and coaching; they’re different and it’s very apparent in their program. Some people learn and respond differently to each, and J&G provide both.
Mindset: Perhaps an alternative way to view / describe this program: It’s not a cost… it’s an investment in yourself and the potential for future freedom and generational wealth for you and your family. My mindset change has been a huge part of this program.
In terms of “what you get” or how they help you invest in yourself – a Library of hundreds of hours of video from start to finish of their own ground-up business step-by-step, documents, check lists, tools, programs, resources, networks, credibility book examples, private Facebook group with tons of historical data you can search and current news being posted.
They didn’t start in syndication, they partnered up, Jake went door to door collecting cash by hand, Gino entered data manually into QuickBooks. They’ve been through the inefficiencies of what may not be the best use of time and were able to look back and say “man, I should have outsourced that faster or changed that system so I could free up more of my time to focus on more important tasks.” Those lessons they have learned are shared with you so you can know it, address it, and then focus on your best use of time, in which steps, in which order, in what process. This allows you to get where you want to go, faster. They have expanded and broadened to Syndication… another tool in the toolbox of multifamily investing. They continually add new modules to the Library of which you have access to.
Yes their time is valuable… they spent years in the trenches building this. Still, they’re on a weekly group call on Mondays where you can ask them anything you want. Gino gets on a one-on-one call with you right away and is always personally available. You have periodic calls with your coach. There are Boot Camps throughout the year, Buy Right, Manage Right, Finance Right; 2.5 days each. There are various Money Mixers over weekends, I had an opportunity to meet face to face and shake hands with billionaire Jim Clayton, never expected that. Both Jake and Gino and the coaches all attend these events. Multifamily investing is a team sport – they have experts attend these events and present, and after you are able to personally meet and interact with them. They themselves are all active and participating in the market today.
Everyone’s situation is different, some may be young, single, with tons of free time, and can do a deal in 90 days. Other’s may have a full time job, 3 kids, aging parents, so “quantifying” students’ results isn’t fair to the Academy Program. You get out what you put in. There is way more knowledge to absorb than you can take in in a 2.5 day “coaching” program… it’s like drinking from a fire hose. The two years is a worthwhile investment.
That being said, what I have found most valuable is the networking and relationships built from within the community. Specifically the bi-monthly Accountability Pod (or Mastermind Group, whatever you want to call it) or when attending other industry conferences or meetups not put together by this group, I see individuals from previous Boot Camps or Mixers, they know others, and your network expands exponentially.
Their Academy Program aligns well with my goal of full-time real estate, specifically value add multifamily and I can’t say enough positive things about the J&G community.
It’s not necessarily the deals that you get under contract… sometimes it’s about a coach, mentor, another student seeing something you may miss, and helping you avoid a potential disaster that may drag you under, rather than push your momentum forward. You’ll learn things you didn’t know that you didn’t know J
Education x Action = Results
“If it makes you money, it costs you nothing” ~Cole Hatter
Post: Looking for advice on EXPERIENCE

- Investor
- Asheville, NC
- Posts 19
- Votes 41
@Account Closed if you're interested, check out "The Complete Guide to Buying and Selling Apartment Buildings" by Steve Bergers (c. 2005)... while it is an older book, the fundamentals of the book haven't changed. After that, also highly recommend Roni's recommendation for Joe Fairless' book(s)... he has REI Advice, Vol. 1 and 2, I haven't read those yet. I have read Syndication Book and it lays out the entire syndication process, start to finish, in an easy to comprehend way. A specific niche to apartment investing is "value add" where you could be in the mix of apartment investing well before 10 years - Jake and Gino's Wheelbarrow Profits is a great book to learn about the concepts of this process. If you're fully committed to real estate investing and are looking for ways to accelerate this process, I can't say enough positive things about getting involved with a mentorship / coaching program of like-minded individuals. They will teach you things you didn't know that you didn't know.
Post: In need of advice to finally start investing.

- Investor
- Asheville, NC
- Posts 19
- Votes 41
@Omar Herrera join your local REIA (Real Estate investors association) and network network network. Similar mindset people will be attending and can guide you to where you want to go.
Post: Asheville Multifamily Investor Club

- Investor
- Asheville, NC
- Posts 19
- Votes 41
@Timothy M Kolb there is a meetup group with upcoming event info (next June 20, 630p).
https://www.meetup.com/Asheville-Multifamily-Investment-Club/events/261711817/
https://www.meetup.com/Asheville-Multifamily-Investment-Club/
Post: List of All Books Mentioned on BiggerPockets.com Podcast

- Investor
- Asheville, NC
- Posts 19
- Votes 41
@Jorge Garifuna thank you for efforts in generating this list!!
Post: Question on Rental Property Calculator

- Investor
- Asheville, NC
- Posts 19
- Votes 41
not sure about your quote "there is a figure underneath monthly cash flow" ... perhaps you meant to reference "below monthly income"... the three-letter acronym does not end in an exclamation point [!] but the capital letter [I] (eye) and stands for "Net Operating Income"... if you move your cursor directly over and stop, a pop-up will appear... Why it looks like an exclamation point is there is a dotted underscore that is visually deceiving. This same dotted underscore also appears two columns over, underneath "ROI".