Hi
I needed an easy to understand spreadsheet to show my bank manager so I sat down and created 1.
Sheet 1 is showing properties held in my name,
Sheet 2 is showing properties held in my Self Managed Super fund.
Sheet 3 is showing Personal + SMSF properties combined.
Sheet 4 (risk minimisation) was added to make my bank manager feel better.
The spreadsheet is not locked so you can change it to suit your needs.
Feel free to correct any mistakes or to make suggestions
Please note: the property values, incomes, rents and street names are fictitious. As you add more properties you can replace simple addition & subtraction functions with formulae but for this number of IP's it's not necessary.
Enjoy
I needed an easy to understand spreadsheet to show my bank manager so I sat down and created 1.
Sheet 1 is showing properties held in my name,
Sheet 2 is showing properties held in my Self Managed Super fund.
Sheet 3 is showing Personal + SMSF properties combined.
Sheet 4 (risk minimisation) was added to make my bank manager feel better.
The spreadsheet is not locked so you can change it to suit your needs.
Feel free to correct any mistakes or to make suggestions
Please note: the property values, incomes, rents and street names are fictitious. As you add more properties you can replace simple addition & subtraction functions with formulae but for this number of IP's it's not necessary.
Enjoy
Attachments
Last edited: