We’ve been hiding our bundles under a bushel! Find out more >>

800-899-6060

New Updates Add Waterfall Returns to On Schedule and C/I Development programs

Need waterfall returns for your equity partners in your development projects?  You asked and we have delivered by adding this new feature to both our On Schedule and C/I Development programs.  This feature is available at no charge to customers with licenses of the latest versions of these products.  At this time, this feature is available for Windows products only.

Update your software to version 5, build 1.16 for On Schedule and version 6, build 1.17 for CID by clicking on the “Check for Updates” button on the Welcome worksheet of your product, or by logging into your customer account and downloading the latest installer file.

What are Waterfall Tiers?

With this new option, you can now configure IRR achievement hurdles for your limited partners / non-managing members. Enter up to four different tiers with different IRR rates, just as in our REIA Professional program.

waterfall

 

If you have a license of a previous version of On Schedule or CID, consider upgrading to gain access to this and other powerful new features.  See our upgrade page for pricing and more information.


Loan payments, escrow and other monthly considerations

Question from a Customer:

“With regards to the loan amortization, does the loan calculation take into account an escrow account or is there a section to enter separate escrow account payments? Or is it easier to book the annual taxes and insurance separate letting the loan calculator calculate just the payment and loan balance?”

Answer:

Thanks for your question. The amortization schedule on the RealData Calculator is designed to focus strictly on the loan itself, tracking the principal and interest portion of each payment, and the ongoing balance. It gives you the option of dealing with  lot of real-world loan scenarios, such as interest-rate changes, extra payment to principal, and skipped payments. The escrow account, however, is something that is separate from the loan, and we think it’s best not to let that obscure the tracking of the loan.


New Short-Term Analysis Mode in REIA Pro

Today we are releasing build 1.07 for Windows and build 1.13 for Macintosh of our REIA Professional product to add a third “short term” analysis mode.  This is a free update for all those who have a license for REIA Pro v17.

Select the mode on the General Settings worksheet:

By making this selection, the software reveals a set of worksheets that are specific to a 24-month analysis.  In a typical short-term scenario, you plan to purchase a property, do some renovations, and then resell within two years.

With the addition of this feature, we can now say that REIA Pro has all the features that REIA Express has, plus many more.  See a feature comparison of the two REIA Products for more information.


C / I Development build 1.12 “Better in Blue”

Today we are releasing a build 1.12 of Commercial Industrial Development in version 6. In this build we have completely changed the color / theme from green to blue.  At one time, we used color to differentiate the products but currently we are standardizing on a business blue appearance.

This update also includes a number of fixes to the printed reports and provides a bit more uniformity in the presentation.  It’s a free update for anyone who has a license of version 6 of the software.


New, Improved PDF Printing for Macintosh Products

Yesterday, we released free updates across all of our Macintosh products that brings new PDF printing functionality and ease of use for PDF report creation.  Our new solution includes a utility file (called rdpdfutil) which resides in the same folder as the RealData software product and replaces the need for CUPS-PDF.

What exactly does this new utility do?

In short, it wraps up individual PDF files into one single document just as we do on our Windows products.  It also allows you to save your reports to any location that you choose, unlike CUPS.  Printing to PDF on a Mac now is equivalent to the advanced functionality we have had on Windows.

How does it work?

Print reports like you have always done by opening the RealData Menu and selecting Print Reports.  Tick the “Print to PDF” checkbox, then click the Print button.

PDF print dialog

 

Soon after, a dialog box will appear that asks you where you would like to save the PDF report.  Be sure to rename the report to something that makes sense for your project.

What else do I need to know?

When you install your Mac product, by default we prompt you to save the product to your Mac’s Applications folder.  Some users may wish to move this folder to another location, but note that in order for our PDF printing solution to work, you must retain the default install location with Applications.  Do not change the folder name.  Unfortunately, this is a limitation of the Mac OS that we could not work around.

 


Software updates: All Macintosh products, REIA Pro and Express

Today we have completed many updates which span the entire product line for both Windows and Macintosh. The changes include:

– code modification for all Mac products to accommodate changes in the new Mavericks operating system. If you are using Mavericks, then be sure to login to your customer account and download the latest release of your software. The new code fixes problems when printing both to physical printers and to PDF.

– In REIA Pro we have added PV, CFAT and Sale Proceeds after Taxes to our popular Decision Maker dashboard. We also have improved error reporting on both the Commercial Income and Residential Income worksheets as well as several bug fixes for printing and data display.

– IN REIA Express we have fixed several display issues in the Residential Income worksheet which have been reported by some users.

All of these updates are free of charge for those who have a license for a current version of the software product. RealData maintains separate product releases for Windows and Macintosh users as part of our effort to provide an optimal user experience in each operating system.

If you need assistance with upgrading your software, please open a support ticket by sending us an email.


Real Estate Investing: Time to Remember the Lessons of History

As the summer 2013 begins to cool off, many real estate markets are finally starting to heat up. For a lot of folks, who have slogged through five of the worst economic years in memory, it feels a bit like we’ve just been released from the locked trunk of a car.

The temptation now is to celebrate our release from investing confinement by jumping back into the market with both feet. Before we do so, however, it would be wise to reflect on a few of the lessons of recent history.

There were many reasons for the financial meltdown, but one of the biggest surely was the belief that real estate inexorably increases in value over time. To many people, that looked like a law of nature. The reality turned out to be different, and now, as property values start to rise, we have to resist the temptation to start believing this all over again. If not, we will simply create another bubble and repeat the cycle.

Another cause of that meltdown was the tendency to dismiss or completely ignore investment fundamentals.  Real estate simply couldn’t fail to do well (after all, they’re not making any more of it), and we didn’t really need to think too hard about our investments because, surely, they would work out happily in the end.

Savvy investors always knew that this wasn’t necessarily true; they knew that income-producing real estate could go up, down, or sideways.  Time, all by itself, does not create value; the ability of a property to produce income is what creates value, and so the prudent investor would take nothing for granted and always carefully weigh a property’s prospects for generating income today and in the future.

The beginnings of a general economic recoveryand, in particular, a real estate recovery may signal that we can and should get back into the game, but it doesn’t mean that we can return to pre-2008 thinking and disregard the fundamentals that ought to guide our investment decisions:  For example:

Due Diligence: This is just as important in good times as in bad. We need to examine thoroughly and critically all of the financial data we can get our hands on about a potential investment property.  Are the rents really as represented? Are the operating expenses as portrayed by the seller reasonable and complete? Have we done a thorough assessment of the property’s physical condition?

It is essential to remember that a property doesn’t live in a vaccum, so our due diligence needs to extend beyond the individual property and include the local market as well.  What is the prevailing capitalization rate for properties of this type in this market? What kind of rents are similar buildings actually getting, and what are the asking rents in properties that may be in competition with us for tenants? What is the current vacancy rate in this market, and has it been rising or falling? What is the general business climate, and in what direction is it headed?

Cash Flow:    We always need to make hard-headed projections about the prospects for current and future cash flow. Too often we see investors, motivated to make a purchase and get on the presumed gravy train, put together the numbers they want to see.  They ignore the potential for vacancy and credit loss. They ignore setting some of their potential cash flow aside each year as a reserve to pay for that new roof or new HVAC system a few years down the road. We should make best-case, worst-case, and in-between projections to give ourselves a sense of the range of possible outcomes.

It is important to be realistic about cash flow projections. Excessive leverage may seem like a great advantage on the day you close the purchase, but the high debt service may also result in very weak or even negative cash flow. Are you really prepared to support your property out of your own pocket, to absorb unexpected expenses or loss of revenue?

The Long View: We seldom buy an income property with the expectation of flipping it for short-term profit. Rather, our plan is probably to buy and hold so we can derive an annual cash flow plus a long-term gain when we sell. If that is indeed our plan, then we need to forecast the property’s performance not just for one year, but for a likely holding period—perhaps five, seven or ten years—and to compute an Internal Rate of Return for that holding period. Doing so can be especially valuable when we are looking at more than one property that we might purchase.  Which one appears likely to give us the best overall return within our investment horizon?

The Last Word: Investing in real estate can be a profitable move in just about any economic climate if we proceed wisely, so to answer our initial question: Yes—if we’ve been on the sidelines, then this is a fine time to get back in.  But as with any other kind of investment, we can just as easily lose money as make it if we charge ahead without doing our homework and without going through the kind of fundamental analysis and projection that is essential to smart investing. Success in real estate investing, as in most endeavors, doesn’t just happen by good luck or chance. We have to work at it and have our head in the game. The luck will follow.

— Frank Gallinelli

####

Your time and your investment capital are too valuable to risk on a do-it-yourself investment spreadsheet. For more than 30 years, RealData has provided the best and most reliable real estate investment software to help you make intelligent investment decisions and to create presentations you can confidently show to lenders, clients, and equity partners. Learn more at www.realdata.com.

 

Copyright 2013,  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.

How to Create Best-Case and Worst-Case Property Analyses in REIA Professional

You already know that pro forma property analysis is an essential part of due diligence before jumping in and spending your money on a real estate investment.  You also know the value of the pro forma analysis is only as good as the care and consideration you give to all your assumptions about the purchase, operation and sale of the property.  Part of being a cautious and calculating investor is to consider best-case assumptions, worst case assumptions and some case in between.  Fortunately, this is an easy matter with RealData’s REIA Professional.

Here’s how:

  1. Create your initial analysis with REIA Pro with a complete set of assumptions.  It does not matter whether these are conservative or aggressive, just save the file with an appropriate name such as “300 Main Street conservative.xltm”
  2. After saving, use Excel’s Save As function to save a copy of the file with a new name.  That file might be  “300 Main Street aggressive.xltm”  Repeat the process for your third case.
  3. Adjust the data in the second two files to match the case.  Save the files.
  4. Open our Comparison Analysis add-on for REIA.
  5. Click the Add Property button to include all three of the files you have created for your property.  You will then see a side-by-side comparison of key metrics for all of the three cases.

Also consider using our new Decision Maker worksheet right within REIA Pro.  This unique dashboard tool allow you to see how 21 metrics (such as Cash on Cash and IRR) change as you change key assumptions about your purchase.  Change purchase price, vacancy rate, loan terms, etc.

Use these exercises to determine just how well your property might perform under a variety of future occurrences.

 


Update – Personal Financial Statement for Macintosh

We have just rolled out a small but significant update, build 1.79, to the Mac edition of our Personal Financial Statement (PFS) product.

This update brings the popular Import utility from PFS Windows to the Mac along with the User Worksheets feature which is common to all our products.

personal-financial-statement-new-features

 

For those of you unfamiliar with this feature, User Worksheets gives one the ability to add / edit / delete additional worksheets within our product to extend and customize product functionality to fit your specific needs.

The Import utility makes quick work of drawing in all your information from an earlier PFS version 4 workbook.  Just open your old financial statement along with the new blank financial statement template – with one click, all data copies to the new file.

Note that RealData maintains two separate editions for all our products for Windows and Macintosh.  This is essential to assure our products work correctly as intended.  We always develop and test each release on respective Windows and Mac computers.

 


Start Evaluating Investment Properties Today

Get Free Demo