Home | Log in | Join Now! | Blog | Contact    Subscribe to the InvestEd Forum feed (new threads) via RSS
InvestEd :: Wealth Education for Australian Investors

Living on Equity Spreadsheet

 
LinkBack Thread Tools
Old 08-11-2007, 11:45 PM   #31
Member
 
Posts: 190
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
Old 09-11-2007, 06:32 AM   #32
The Rule of 72
 
Posts: 1,365
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
Member
 
MichaelWhyte's Avatar
 
Posts: 798
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +10. The time now is 06:26 PM.

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