For a investor it is very necessary to keep an eye on his investment. Buying a property needs a lot of effort and return on this investment depends of various factors. If you are trying to analyze how much ROI is there. How profitable and stable returns would be. Then you should calculate it in advance and work accordingly.
Though there plenty of calculators on internet, but having a spreadsheet has its own benefits. You can use it anywhere and anytime. Including the benefits of sharing. So here we are with various sheets that will make your life a bit easier.
The worksheet consist three tabbed sheets single family condo, Multi-unit and the last one is for student rental-payment. You have to fill in details like address, area sq feet and year in which it was built. Mortgage information, investment and monthly income. The cash flow will be generated automatically along with ROI.
Investment property record book
: user have to input data in multiple tabs about income and expenses of different estates. Then it will automatically generate the summary of account in a single sheet i.e ..summary.
Annual rental property management sheet : Multiple sheets for depicting the I&E of each month of year, which is further summed on 1 tab.
Two different sheets to manage inflows and outflows from a rental investment. It will further show its effect on the very first summary option sheet.
Adjustment for GST/HST along with income and expenses. (Canada). This one is not a calc, it is actually like a form. You have to fill in details like property address,gst/hst information. Sources of income and expenses. Automobile expenses and capital assets.