Recording loans

Purpose

The “Loans” screen lists the loans that finance your properties, including the lender, the remaining principal, the monthly payment and the final due date. This data feeds into the remaining principal, the debt service and the post-debt cash flow displayed in “Returns” and “Forecast”.

The “Repayment schedule” tab details the interest and principal portion, as well as the remaining balance for each instalment, in order to prepare a renegotiation or a refinancing.

Where to find it

1. Investment
2. Loans

“Loans” and “Repayment schedule” tabs.

Steps

1. Click on “New” in the “Loans” tab.
2. Select the financed property, and then enter the “Lender”, the reference and the “Type”: “Amortising” or “Interest only”.
3. Specify the “Principal”, the “Interest rate (%)”, the “Term, months” and the start date, and then save.
4. Open the “Repayment schedule” tab and select the loan to be viewed.
5. Click on “Export” to obtain the table in CSV format.

Good to know

• The repayment schedule displays the total interest, the total repaid and the remaining balance as of today.
• An “Interest only” loan repays the principal only at the final instalment, which is reflected in the table and the projections.
• The schedule is calculated based on the entered data, so please verify it against the schedule provided by your bank.

Related guides

• Asset managementMeasuring investment returnsTrack rents, occupation, vacancy, returns, cash flow, value and debt, in order to export the rent roll of your portfolio.
• Asset managementEstablishing a forecastProject rents, costs, income, debt and value over several years according to your assumptions, and save your scenarios.
• Asset managementProducing the owner reportGenerate a PDF report with indicators, a rent chart, a comment, and a rental status, then send it by e-mail to the owner.
• PortfolioManaging buildingsRegister your buildings, their photos and their owner, and track the occupancy rate of each one from a single list.