– Excel file format (can also be used in Google Sheets and Numbers for Mac) – Instant download – start using it straight away! You can change their commission % to whatever number you like You can see different scenario’s of how much you’ll pay in property management fees depending on how much rent you charge per week/month/year. There is also a section to record refinance costs such as break-fees so you can determine the total true cost of refinancingĬalculate how much it costs to hire a property manager to perform regular inspections, keep up to date with legislation, handle the lease documents etc. credit card with no annual fee) and any specials or promotions. There is space to record upfront fees, annual fees, extras (e.g. You can compare fixed and variable interest rate loans for up to 3 lenders. Use this when you first obtain the mortgage, and also when you want to refinance. This spreadsheet will assist in calculating Capital Gains Tax and / or guide you to determine how much you need to sell the property for in order to make a profit. There are sections to record upfront repairs and renovations, as well as the sold price and selling costs. You can also use this to help determine if a property you are interested in purchasing is actually feasible (and the true costs). Use this to record how much you paid for the property (not just the selling price, all of the other on-costs too!) If you live in Australia, send this to your Quantity Surveyor when they are preparing your tax depreciation schedule This spreadsheet is not for repairs or regular ongoing expenses such as body corporate. Improvements made to the investment property (e.g. Once you’ve purchased a property you can transfer these forecasts to the ‘income and expenses’ tab This spreadsheet can be used before you even purchase a property so you know how much you’re up for. Pre-filled with more than 20 ongoing costs such as pool maintenance, gardening, pest control, smoke detector maintenance, insurance etc. Especially helpful if you have a share house with multiple tenants, or are leasing out rooms in the home you live in Make sure you’ve received all of the rental income you’re owed. Once they have been spent I change the font color to grey. This spreadsheet can be used for scenario analysis to see if a property you are interested in purchasing is likely to be positively or negatively geared. This version has the same income and expenses summary spreadsheet as version 1, but it can be used for any year and is not linked to a summary tab. The summary tab has a pie graph of expenses (by category) and a bar graph for income versus expenses. On each of these tabs is a pie graph of the expenses (by category) which will automatically update as you enter values into the spreadsheet, so you can see which expenses are big ticket items, where you might be able to cut back, and also to forecast future maintenance items.Īnything you enter in the tabs for each year will automatically populate the summary tab. The expense categories are pre-filled but you can type over the top of the existing categories and add your own in the blank rows as well. With these spreadsheets you can track positive or negative gearing and how much the property is truly costing you.įor each year, there is a tab to record income and expenses. Record income and expenses for your investment property for up to 10 years (1 tab / spreadsheet per year). I’ve made 2 versions of the spreadsheet: Version 1 Property spreadsheets (use for up to 10 properties).Rental property spreadsheets (use for 1 property).If you’d like a copy of these spreadsheets, they’re available from my online store or Etsy shop: Online store To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon). If you have an investment property as well, or want a spreadsheet to help you forecast how much it’s really going to cost (there’s been a lot more unexpected expenses than I thought there’d be), I’ve recorded a video walkthrough of my spreadsheets: Let’s take a closer look! Now I have an organized system for tracking income, expenses, forecasting future expenses, a comparison calculator when I want to refinance my loan, management fees calculator and spreadsheets I can send to my accountant at tax time. So I made an Excel spreadsheet which, over the years, has turned into many Excel spreadsheets. I want to be able to track it’s historical performance and forecast it’s future performance. I get an annual statement from my property manager but that’s after the year’s gone and is only a historical look at how my investment is performing. 5 Years ago I purchased an investment property.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |