Free Property Portfolio & LTV Tracker
Keep property values, finance balances, equity and loan-to-value in one place. The Fructus Property Portfolio & LTV Tracker gives landlords a structured view of their portfolio and borrowing without having to maintain separate property and mortgage spreadsheets.
Free. Excel workbook, version 1.0. Enter your email once to unlock Fructus resources on this browser.
A clearer view of value, borrowing and equity.
The workbook brings your property and finance records together, including debt by lender and scheduled debt service. It calculates useful portfolio information from the records and assumptions you enter; the figures are not guaranteed outcomes or predictions.
What the workbook calculates
- 01Property-level debt
- 02Equity
- 03LTV
- 04Purchase-price appreciation
- 05Recorded-cost uplift
- 06Scheduled debt service
- 07Portfolio valuation
- 08Portfolio debt
- 09Weighted portfolio LTV
- 010Valuation/debt data coverage
Useful for landlords who want one structured overview of portfolio values, finance balances and equity.
Start with a spreadsheet. When managing the portfolio across spreadsheets becomes the problem, Fructus brings connected property information into one workspace.
This workbook is an informational tool only, not financial, mortgage, tax, legal or investment advice. Figures depend on the data and assumptions you enter; calculated values are not guaranteed outcomes or predictions of future values, borrowing or returns. Take independent professional advice before making decisions.