Home | Log in | Join Now! | Blog | Contact    Subscribe to the InvestEd Blog via RSS
InvestEd :: Wealth Education for Australian Investors




Welcome to InvestEd.

You are currently viewing our site as a guest which gives you limited access to view most discussions, articles and other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please:


If you have any problems with the registration process or your account login, please contact support.

Living on Equity Spreadsheet

 
LinkBack Thread Tools
Old 08-11-2007, 11:45 PM   #31 (permalink)
lorrimer
Member
 
Posts: 165
Join Date: Jun 2006
Location: Brisbane, Queensland
Quote:
Originally Posted by MichaelWhyte View Post
Quite right.

I was getting a bit lazy in aportioning the debt at the correct rate. But this was overstating my interest expense because it was showing all against the margin loan rate, and not some of it against the property (LOC) rate.

Here ya go. Fixed up and now showing me a few thousand better off and actually slightly positive on my cash flow from investments. So, I'm actually marginally positive cash flow and growing at $125K pa. Not too shabby for a start...

Cheers,
Michael.

PS The reason the margin loan is at $550K is because of $50K capitalised interest on the original $500K loan.
Michael,
If you are going to capitalise your interest on the margin loan, then your cash flow would actually increase by 47300 as you are not actually paying that money out, but still getting a lovely tax deduction
Only your LVR is suffering as a consequence
lorrimer is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
   
 
Hide these adverts with a Free Membership
Old 09-11-2007, 06:32 AM   #32 (permalink)
crc_error
The Rule of 72
 
Posts: 1,346
Join Date: May 2007
Location: Melbourne, VIC
I'm just trying to get my head around this LOE..

Looking at the final spreadsheet, you state a 16% return on equity.. correct me if I'm wrong, but that return isn't really that spectacular? am I missing something?
crc_error is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 09-11-2007, 08:52 AM   #33 (permalink)
MichaelWhyte
Member
 
MichaelWhyte's Avatar
 
Posts: 796
Join Date: Oct 2005
Location: Sydney, NSW
Quote:
Originally Posted by lorrimer View Post
Michael,
If you are going to capitalise your interest on the margin loan, then your cash flow would actually increase by 47300 as you are not actually paying that money out, but still getting a lovely tax deduction
Only your LVR is suffering as a consequence
Quite right! Lazy again...

To be honest, LOE is not part of my strategy. I just plugged my numbers in the spreadsheet to see what it looked like. I haven't tweaked the spreadsheet to allow for capitalising of interest costs, so it assumes they're all paid for in the year they're incurred. No biggie. I looked at this more from an "investigation" perspective than an "implementation" one. Just doing it out of idle interest. My actual retirement plan spreadsheet is a lot more robust and is based on spending net passive income and using no LOE. I do however draw the growth in value on my properties out and margin it at 50% into managed funds annually, thereby maintaining my property LVR at 80%. But that's a whole other discussion and not one for this LOE thread.

Cheers,
Michael.
__________________
Goal: Financial independence by 2015
Plan: Focussing on Resi property development in the short term to build in equity and improve cash flow.
Status: Development site procured and DA approval achieved. Intend to commence construction mid-2009.
MichaelWhyte is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools


All times are GMT +10. The time now is 11:07 PM.

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.0.0
Some graphics originally by vBStyles.com

Copyright © 2006 Investor Education Pty Ltd (ACN 114 677 226)
Site by Hampel Group