Does anyone have spreadsheets that they care to share on here, for analyzing potential IPs? I have done a few basic ones over the years, here is my latest go. You can look at trademe for hours but, like internet dating (I've heard), you just want to quickly analyze and move on if it doesn't stack up.
My background is that my wife and I used to own a share in an IP, bought 12 years ago, sold five years ago. We have talked about getting one of our own for a while and are getting interested in the the idea now, but would have to borrow 100%. And I enjoy working with spreadsheets.
Is this one accurate enough to give an idea of what might happen, from both the cashflow and accounting perspectives?
It attempts to compare three properties - 1, 2 and 3. The first block showing cashflow, the second block showing the accounting for the same three properties. The expenses columns down the right aren't part of the comparisons on the left. They're just there to show my expenses figures.
I can't post pictures or attachments, hopefully this comes out ok...
My background is that my wife and I used to own a share in an IP, bought 12 years ago, sold five years ago. We have talked about getting one of our own for a while and are getting interested in the the idea now, but would have to borrow 100%. And I enjoy working with spreadsheets.
Is this one accurate enough to give an idea of what might happen, from both the cashflow and accounting perspectives?
It attempts to compare three properties - 1, 2 and 3. The first block showing cashflow, the second block showing the accounting for the same three properties. The expenses columns down the right aren't part of the comparisons on the left. They're just there to show my expenses figures.
I can't post pictures or attachments, hopefully this comes out ok...
Property | Loan | Interest | Term | Cashflow => | Rent in | minus Expenses | minus Repayments | equals Cashflow | Anually | Expenses | Cost | |
1 | $280,000 | 6.50% | 30 | - | $510 | $120 | $408 | -$18 | -$953.19 | Accounting | $600 | |
2 | $330,000 | 6.50% | 30 | - | $420 | $120 | $481 | -$181 | -$9,423.04 | Advertising | $0 | |
3 | $370,000 | 6.50% | 30 | - | $460 | $120 | $539 | -$200 | -$10,374.93 | Bank Fees | $150 | |
Body Corp | $0 | |||||||||||
Cleaning | $0 | |||||||||||
Communications | $0 | |||||||||||
Property | Loan | Interest | Term | Accounting => | Rent in | minus Expenses | minus Interest | equals Profit | Annually | Computers | $0 | |
1 | $280,000 | 6.50% | 30 | - | $510 | $120 | $350.00 | $40 | $2,070 | Consumables | $0 | |
2 | $330,000 | 6.50% | 30 | - | $420 | $120 | $412.50 | -$113 | -$5,860 | Fire system | $0 | |
3 | $370,000 | 6.50% | 30 | - | $460 | $120 | $462.50 | -$123 | -$6,380 | Ground maintenance | $0 | |
Insurance | $2,000 | |||||||||||
Internet | $0 | |||||||||||
Keys | $0 | |||||||||||
Laundry | $0 | |||||||||||
Light Heat and Power | $0 | |||||||||||
Maintenance | $1,000 | |||||||||||
Property Manager | $0 | |||||||||||
Rates | $2,500 | |||||||||||
Rubbish | $0 | |||||||||||
Software | $0 | |||||||||||
Stationery | $0 | |||||||||||
EXPENSES TOTAL | $6,250 |
Comment