Author: Frank Gallinelli

RealData’s Commercial Income Worksheet

The Commercial Income worksheet in RealData’s REIA Pro software is one of its leading power features that makes it a stand-out tool for investment analysis.

It’s designed to allow you to enter income from any number of tenants with great flexibility, and to model a lease scenario of any size or shape.

In this video we’ll have a quick overview of how this feature works, and how it can help you when you’re evaluating a commercial income property.

Click here to watch

####

Copyright 2020,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

“The Top 10 Real Estate Finance Books Every Investor Should Read.”

investment book

I was honored to find that one of my books was featured at the top of a recent article on Motley Fool: “The Top 10 Real Estate Finance Books Every Investor Should Read.” The book, “What Every Real Estate Investor Needs to Know About Cash Flow,” was originally published in 2004, is now in its third edition, and is alive and still doing well —  a surprise certainly to me, and probably to the publisher as well.

I often get asked what accounts for the book’s long-term appeal, and I think there may be two reasons: First, I avoided “topical” or trendy content, preferring to stick with core concepts and math-based metrics don’t change with time. And second because I really dislike the get-rich quick hype that seems to characterize so many real estate books, and so I shunned that, too.

I don’t think they’ll ever make a movie out of it, but I’m satisfied if it has helped some readers make informed and unemotional investment decisions.

You can find the article here.

The RealData Software Menu — A Tool to Streamline Your Work

Have you ever had to scramble around a large DIY Excel model to find some key piece of information? Or churned out a ream of paper trying to format a report that a human could actually read?

We’ve all been there. And that’s why we built a unique menu that automatically adds itself to Excel when you run a RealData program.

In this video, we’ll show you how you can use that menu to streamline and simplify your real estate analysis work when you’re using RealData software.

Click here to watch.

In this video, we’ll show you how to use the custom menu that we add to your Excel toolbar whenever you’re using RealData software. It can really make your job a lot easier, especially when you’re working with a powerful program like our Real Estate Investment Analysis, Pro. Edition.

This is the third in our series demonstrating key features of RealData’s software for real estate investors and developers. More to come.

####

Copyright 2020,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

Leverage the Power of Excel to Extend your RealData Software

In our last post, we introduced our new series of short video that are designed to highlight some of the key features of our applications and help you get the most out of your RealData software. In that video we showed you the how REIA Pro could be used in any of three different modes — a detailed, long-term analysis; a quick analysis; and a short-term view, ideally suited to fix-and flip.

RealData software for real estate investors use Excel as their engine, so they offer you a familiar landscape on which to work. But you can easily go further by expanding on our products to customize them for your specific needs. In this second video, we show you some of the ways you can leverage the power of Excel to extend the functionality of RealData software.

To watch now, just click here.

And stay tuned for our next video, about using the custom menu that all RealData products add to Excel to make your work easier.

####

Copyright 2020,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

Get the most out of your RealData software

We’re always happy to help when users — and potential users — call to ask about a particular capability of our software. And that makes us stop to realize that applications like Real Estate Investment Analysis, Pro Edition have so many powerful features, sometimes real gems can be hidden in plain site. We’re pleased to say that we’ll be be delivering a series of short videos to highlight some of those features. You can watch the first of these right here:

Yeah, we could have come up with a sexier name than “modes,” but we’re real estate guys, not fashion designers. What really matters is that this video shows you how REIA is really three programs in one. Did you know you could even use it to evaluate a fix and flip project?

We have several more videos like this in the pipeline on topics that we get questions about, but we would very much like to hear what you want. Maybe something to do with entering data about commercial leases, or perhaps a feature that’s specific to multifamily? Maybe more detail on using the month-by-month analysis?

Please tell us. We want to know.

####

Copyright 2020,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

Are you involved in real estate education?

We’re reaching out to our followers who teach real estate investment, development, or finance to let you know that our Real Estate Investment Analysis course is available for the virtual classroom – now with volume academic pricing.

For more than a decade I’ve devoted much of my professional life to investor education, as a writer, Columbia adjunct professor, and through my company RealData. As you may know, a few years ago I created an online video course, Introduction to Real Estate Investment Analysis. It has grown to include a broad range of topics that are key to understanding how income-producing properties work, and how investors, developers, lenders, and others evaluate their financial dynamics.

With so many schools and colleges now needing to provide good content for a virtual learning environment, we’ve re-deployed the course as a resource that instructors can add to their existing curricula. We now offer volume academic pricing at a significant discount, depending on class size.

For an overview, including access to sample lessons, go to the course home page.  To see a complete course outline, click here.

If you’re involved in real estate or financial education, then I hope that this can help you provide meaningful content to your remote learners. To get a quote for volume licenses for student use or to discuss this further, please email me at education@realdata.com.

— Frank Gallinelli

####

Copyright 2020,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

Opportunity Zones = Defer or Avoid Capital Gains Tax

The end of the year compels many people to think about tax planning, which in turn prompts us to highlight a feature of the new tax law that could provide significant benefit to real estate investors. It has to do with what are called “Opportunity Zones.”

These zones are economically distressed, low-income communities, and according to the Wall Street Journal the zones encompass almost 9,000 census tracts with a population of nearly 35 million. A list of the zones can be downloaded from this IRS page

In a nutshell, the benefit to investors is that they can defer the capital gains on an existing investment until the end of 2026 by rolling those gains into an Opportunity Zone project. In addition, they can avoid capital gains on the new investments in the zone if they hold them for at least 10 years

Like a number of provisions in the Tax Cut and Jobs Act, not all of the details were in place when the law was passed, but the IRS did in fact release regulations about this on October 19, 2018. Apparently there are still some loose ends and the IRS in their FAQ says they will be “…providing further details, including additional legal guidance, on this new tax benefit” over the next few months.   

Those who enjoy parsing the tax code can peruse the current version of the regulations.  You can find more readable summaries at National Real Estate Investor or here if you have an online subscription to the Wall Street Journal

A key takeaway from the Journal article is that this tax break appears to have been designed to give investors reasonable flexibility. For example, it cites that “…as long as 70% of a business’s tangible property is in a zone, the business doesn’t lose its ability to qualify for the tax break.” The regulations so far don’t seem to have a lot of hidden trap doors or “gotchas.” 

It would appear that this tax break provides an opportunity for investors to free up capital that is sitting dormant in properties they’re reluctant to sell because of what would otherwise be a capital gains tax burden. Now investors should be able to benefit from at least one if not two  tax breaks, and at the same time do something positive for their communities.

What do you think? Are you likely to pursue a project in an Opportunity Zone?

— Frank Gallinelli

View a sample lesson from my video course,
“Introduction to Real Estate Investment Analysis”

####

Copyright 2018,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

If we’ve seemed a bit quiet lately…

“You never write. You never call.”

Well, not exactly, but if we’ve seemed a bit quiet lately it’s not because we’re ignoring our loyal followers and customers. Rather, our email service provider hit a bump in the road over the past few weeks, so we’ve been kind of trapped under the cone of silence.

We won’t bother you with the techy details, but they’ve got it all sorted now, so we’re back on track. But if you tried to sign up for the RealData Dispatch or our real estate investor education newsletter recently, there’s a good chance that you never saw your confirmation email and so you’re not on our list.

That would be a shame, because we send out a stream of good, informative material to our subscribers. That includes ebooks, videos, and other resources. We do that because we value our followers, we want you to do well in your real estate activities – and, of course, we want you to remember who we are. And yes, we do mix in an occasional marketing message, but not terribly often.

If you tried to subscribe recently – or even if you didn’t and would like to do so now – we encourage you to use the sign-up box in the right-hand column of this page.

Then check your email inbox for a message asking you to confirm that it was really you who subscribed.

Thanks. As always, we wish you spectacular success in your real estate investing.

— Frank Gallinelli

Macintosh Users – Important Info Regarding Excel Compatibility

We have been enthusiastic users of Macintosh computers since the early days of RealData. In fact ours were among the first business applications available on the Mac in 1984. There are plenty of die-hard Mac users in our customer ranks, but even they will be frustrated with an apparent Excel 2016 bug which now affects our products.

At this time, all RealData software for Mac will run on both Excel 2011 and Excel 2016 (aka Office 365).  However, if you have the latest Excel 2016 for Mac, then you will not be able to print any images, including graphs, to PDF reports. Thankfully this does not affect hard printing of reports.  We have not been able to come up with a workaround, so wait we must until Microsoft patches this issue.  UPDATE!  This issue has been fixed in the May 23, 2018 release of Office 2016.  Be sure to update to the latest release.

An important tip for all Mac users – be sure to update Excel to the latest release and also be sure to use the latest build release of your RealData products.  For most of our products, only the latest release of the latest version of each will run on Excel 2016.

For more info on updating Excel, see our knowledge base article: https://www.realdata.com/content/knowledgebase/excel-2011-how-to-check-version-and-how-to-update/