tmmonline.nz  |   landlords.co.nz        About Good Returns  |  Advertise  |  Contact Us  |  Terms & Conditions  |  RSS Feeds

NZ's Financial Adviser News Centre

GR Logo
Last Article Uploaded: Thursday, February 22nd, 6:22PM

News

rss
Latest Headlines

Software: Residential Investment Property Analysis

Diana Clement continues our series on technology aids for property investors.

Monday, October 16th 2006, 12:00AM

by The Landlord


Simple spreadsheet, powerful results
Price: US$29 ($46)
Overall rating: 3 out of 5
Website: www.nzpi.co.nz


We all know the majority of investment properties are bought without proper analysis. Yet it seems there are almost endless opportunities to do your analysis using software, online or just with a plain old paper and pen.

Many investors use products such as RevIQ, PIA (Property Investment Analysis), RentalAnalyst and REAP and swear by them. But the cheapest is $129 and the most expensive more than $900.

For US$29 (NZ $46) you can get the Residential Investment Property Analysis (RIPA) spreadsheet. The product is two quite simple Microsoft Excel spreadsheets which allow you to enter data about a potential investment and then view forecasts for how that property will perform over 15, 20, and 25 years. One spreadsheet is for table mortgages and the other for interest only.

The ultimate purpose of this software is to eliminate guesswork and let you decide whether or not to buy a property based on the numbers, not a gut feeling. Sometimes what appears to be the ideal rental or investment simply isn’t. The numbers just don’t stack up.

In order to use the RIPA spreadsheet you’ll need some basic data – which you should be able to get from the estate agent selling the property. This includes the value of buildings, land, and chattels, and the estimated rent. You may need to play around with these figures and speak to a valuer if you’re unable to get a suggested figure from a real estate agent.

In total, you need to fill in 22 boxes relating to purchase price, loan variables, depreciation, estimated capital growth, your income and tax rates and so on. It’s not terribly onerous.

At the bottom of the entry screen is a summary showing you instantly whether the numbers stack up. There’s even a helpful message that says, “Making the required return?” with the answer “Yes” or “No” beside it.

Below, you see a cash flow analysis, a ten-year equity analysis, and a scenario analysis of the effect on net present value of the property of interest rates rises and/or rental level.

Being a spreadsheet, it’s possible to run ‘what-if’ scenarios anywhere in the software by simply changing one figure and seeing the effect on the ultimate cash flow over time or the equity growth.

It certainly doesn’t take many such calculations for the software to start paying its way; by encouraging you to buy a property you may not have considered otherwise, (assuming other factors such as location and rentability also stack up), or to stop you buying the house of your dreams that might prove an investment dog.

Once you’ve filled in the data, you can simply save it as you would a normal spreadsheet, and then start afresh with a new property.

It’s a simple download and install process. Once you’ve paid online it’s a matter of clicking on the .exe file, which installs the two spreadsheets on your computer and also the Word help file.

On the downside, this is a pretty basic spreadsheet. It doesn’t have an input wizard – to help those people who freeze at the site of a spreadsheet. Nor does it have help within the sheet. However, the document that comes with it describes all you need to know in pretty simple language.

As well, it doesn’t automatically produce graphs or reports that can be sliced and diced – unless you’re a power user of Excel. There is something about multicoloured graphs and charts that somehow make these programs come to life.

While the input screen has a bit of colour added to it and a bit of formatting, the remainder of the results screens are a sea of black and white figures and spreadsheet cells. They certainly do the job, but the numbers don’t jump off the page.

RIPA is not hugely different in its results from the Acumen Property Investment Spreadsheet, which costs NZ$29.95 on CD or $24.95 downloaded.

RIPA is not trying to be an all-singing and dancing REAP, PIA or RevIQ software. Its main competitor is Acumen Property Investment Spreadsheet.


Contact: www.nzpi.co.nz
System requirements:
· PC only, no specific Mac versions
· Microsoft Excel 97 or above.


Verdict: Simple property investment analysis software
Pros: Quick and easy to use. Anyone with a basic knowledge of spreadsheets will be away in seconds.
Cons: No input wizard, charts, graphs or reports that can be sliced and diced easily.


 

« Frequently Asked QuestionsSoftware: Viewbuild »

Special Offers

Commenting is closed

 

print

Printable version  

print

Email to a friend
News Bites
Latest Comments
Subscribe Now

Mortgage Rates Newsletter

Daily Weekly

Previous News

MORE NEWS»

Most Commented On
Mortgage Rates Table

Full Rates Table | Compare Rates

Lender Flt 1yr 2yr 3yr
AIA - Back My Build 6.19 - - -
AIA - Go Home Loans 8.74 7.45 7.05 6.85
ANZ 8.64 7.99 7.49 7.35
ANZ Blueprint to Build 7.39 - - -
ANZ Good Energy - - - 1.00
ANZ Special - 7.39 6.89 6.75
ASB Bank 8.64 7.39 6.89 6.65
ASB Better Homes Top Up - - - 1.00
Avanti Finance 9.15 - - -
Basecorp Finance 9.60 - - -
Bluestone 9.24 - - -
Lender Flt 1yr 2yr 3yr
BNZ - Classic - 7.35 6.89 6.79
BNZ - Green Home Loan top-ups - - - 1.00
BNZ - Mortgage One 8.69 - - -
BNZ - Rapid Repay 8.69 - - -
BNZ - Std, FlyBuys 8.69 7.95 7.65 7.45
BNZ - TotalMoney 8.69 - - -
CFML Loans 9.45 - - -
China Construction Bank - 7.09 6.75 6.49
China Construction Bank Special - - - -
Co-operative Bank - First Home Special - 7.15 - -
Co-operative Bank - Owner Occ 8.40 7.35 6.89 6.75
Lender Flt 1yr 2yr 3yr
Co-operative Bank - Standard 8.40 7.85 7.39 7.25
Credit Union Auckland 7.70 - - -
First Credit Union Special - 7.45 7.35 -
First Credit Union Standard 8.50 7.99 7.85 -
Heartland Bank - Online 7.99 6.69 6.45 6.19
Heartland Bank - Reverse Mortgage - - - -
Heretaunga Building Society 8.90 7.60 7.40 -
HSBC Premier 8.59 - - -
HSBC Premier LVR > 80% - - - -
HSBC Special - - - -
ICBC 7.85 7.05 6.85 6.59
Lender Flt 1yr 2yr 3yr
Kainga Ora 8.64 7.79 7.59 7.29
Kainga Ora - First Home Buyer Special - - - -
Kiwibank 8.50 8.35 7.89 7.65
Kiwibank - Offset 8.50 - - -
Kiwibank Special - 7.35 6.89 6.75
Liberty 8.59 8.69 8.79 8.94
Nelson Building Society 9.00 7.90 7.39 -
Pepper Money Advantage 10.49 - - -
Pepper Money Easy 8.69 - - -
Pepper Money Essential 8.29 - - -
Resimac - LVR < 80% 8.84 8.30 7.89 7.69
Lender Flt 1yr 2yr 3yr
Resimac - LVR < 90% 9.84 9.30 8.89 8.69
Resimac - Specialist Clear (Alt Doc) - - 8.99 -
Resimac - Specialist Clear (Full Doc) - - 9.49 -
SBS Bank 8.74 7.95 7.45 7.29
SBS Bank Special - 7.45 6.95 6.79
SBS Construction lending for FHB - - - -
SBS FirstHome Combo 6.19 7.05 - -
SBS FirstHome Combo - - - -
SBS Unwind reverse equity 9.95 - - -
Select Home Loans 9.24 - - -
TSB Bank 9.44 8.19 7.55 7.55
Lender Flt 1yr 2yr 3yr
TSB Special 8.64 7.39 6.75 6.75
Unity 8.64 6.99 6.85 -
Unity First Home Buyer special - - 6.45 -
Wairarapa Building Society 8.60 7.15 6.85 -
Westpac 8.64 7.89 7.49 7.25
Westpac Choices Everyday 8.74 - - -
Westpac Offset 8.64 - - -
Westpac Special - 7.29 6.89 6.65
Median 8.64 7.45 7.37 6.79

Last updated: 14 February 2024 1:37pm

About Us  |  Advertise  |  Contact Us  |  Terms & Conditions  |  Privacy Policy  |  RSS Feeds  |  Letters  |  Archive  |  Toolbox  |  Disclaimer
 
Site by Web Developer and eyelovedesign.com