“World's Most Complete Neighborpedia”
Explore:   What's happening in your neck of the woods?

Frank Gallinelli

6-Part Video Series on Mixed-Use Investment Analysis

As you may know, I spend much of my time teaching and writing about real estate investment analysis. Much of it is the basic theory and math, but in my grad-school classes I try also to include what I believe is more of a practical approach -- call it "applied finance" if you will.

In that spirit, I've just released a 6-part video series demonstrating a step by step financial analysis of a mixed-use real estate investment.

It starts the way a typical investor might, with a very basic back-of-the-envelope approach, and then moves on to more detailed looks at revenue, expenses, cash flows, metrics and potential partnership structure.

You can get more info about these videos and a link to the first session (free) at http://www.realdata.com/mixeduse You can also download a pdf copy of the case study used in the videos at http://www.realdata.com/files/urbancenter.pdf

The first session is free, and if you decide you would like access to the rest, use this promo code for a $10 discount: 2012video6

New for 2012: Real Estate Investment Analysis, Version 16

Thirty years of development time, and of listening carefully to what to our customers want. All this comes together now in the latest version of our most popular and powerful software app for real estate investors: Real Estate Investment Analysis, Version 16

What’s New in Version 16?

    • The Decision Maker

      The centerpiece of v16 is a new module called “The Decision Maker.” Here is how it works: Enter data about the property — revenue, expenses, financing, etc. — as you normally would. Then go to the new module. The top half of the page will display 12-18 of your key assumptions, like those shown here:

      snippet - input, Decision Maker
      snippet 1 from Decision Maker

      You can now toggle any or all of your assumptions up or down with the arrows, while watching the effect of each change as it displays instantly on the bottom half of the page.

      There you’ll see more than a dozen key metrics, such as cash flow and IRR. These will update in response to your clicking the arrows to raise or lower any of the basic assumptions; the data will display going out 20 years.

      snippet 2, Decision Maker
      snippet 2 from Decision Maker

      For example, toggle the purchase price or the cap rate up and down, and watch the effect on your IRR. Toggle the mortgage interest rate, watch the impact on your cash flow. What better way to decide how — or if — you can make this deal work. Hence the name: Decision Maker

    • Detailed Capital Improvements

      Many users have asked to be able to provide a detailed break-out of anticipated expenditures for capital improvements. Here it is. You can now choose to fill out a complete year-by-year schedule of improvements, or simply enter an annual total.

    • Detailed Closing Costs

      Likewise, the ability to itemize acquisition closing costs has been another common request. You now have two options: itemize or enter a single amount.

    • Improved Reports
      We really do pay attention when users call and say things like, “Why doesn’t the partnership presentation show cash-on-cash return?” We keep track of those requests, and you’ll find several now implemented in v16.

    • Import Data from Your Version 15 Analyses

      Here’s a big one: If you’re upgrading from v15 to v16 you can run a special function that will read all of the user entries from an analysis you did in v15 and transfer that information into the new version. That’s no small trick, but our super-smart programmers did it.

Upgrade from Version 15

      If you’re currently a registered user of v15, keep your eye out for an email from us with an offer to upgrade at a nominal cost.

Frank Gallinelli to Speak at BiggerPockets Real Estate Investing Summit and Expo, March 23-24, 2012

BiggerPockets -- an 85,000-member community of real estate investors -- is having its first Real Estate Investing Summit in Denver, March 2012, and has invited Frank Gallinelli as a featured speaker. Frank is the founder of RealData Software and the author of What Every Real Estate Investor Needs to Know About Cash Flow... and Mastering Real Estate Investment. He will speak on, "Real Estate Investment Analysis, Methods and Mindset -- What to Know, What to Do."

According to BP founder Josh Dorkin, "BiggerPockets is planning on having dozens of expert investors, commentators and educators speak to an audience that is expected to include hundreds of attendees from around the country. Through lectures, roundtables, and other session formats, the event will cover topics including rehabbing, landlording, investing in notes & mortgages, real estate financing & capital raising, commercial investing, and much more."

You can sign up to attend by following this link. Hope to see you there.

The RealData Dispatch, Oct 2011 issue available

Our Oct 2011 newsletter, The RealData Dispatch, is available now, with new educational content for real estate investors and special offers: bit.ly/t0SZZI subscribe @ bit.ly/d3UXOK

New Article... "For Real Estate Investors: A Lesson in Clarity"

Recently, I was conducting the last class in my course on real estate investment analysis that I teach in Columbia’s MSRED program. I had assigned my 55 students a series of case studies (much like those in my book, Mastering Real Estate Investment) and told them to build financial pro forms and discuss the reasoning behind their analyses. After reading and commenting on all those analyses, I felt there was one overarching theme on which I wanted to focus my final remarks to the troops: The theme was “clarity.”

Trying to reduce a course to a single word might seem unrealistic (because it is), but I really had more than one angle on the notion of clarity in mind. Even combined, those notions would not replace the real content of a course in investment analysis, but they might express some essential principles that are sine qua non — “without which, nothing” — for investors. ...

Read the rest of the artiicle here.

Frank Gallinelli

www.realdata.com