![property evaluator spreadsheet property evaluator spreadsheet](https://db-excel.com/wp-content/uploads/2019/01/property-evaluator-spreadsheet-in-real-estate-investment-property-evaluator-spreadsheets-for-real-601x350.gif)
- #PROPERTY EVALUATOR SPREADSHEET FULL#
- #PROPERTY EVALUATOR SPREADSHEET SOFTWARE#
- #PROPERTY EVALUATOR SPREADSHEET SERIES#
The checkbox in cell C9 needs to be selected if the property is purchased by an entity that is registered for value added tax (VAT) purposes. The bond amount is calculated by deducting the deposit amount from the property purchase price and the bond period in years needs to be entered in cell B8.
#PROPERTY EVALUATOR SPREADSHEET FULL#
The property purchase price should be the full purchase price as per the deed of sale and the deposit amount should be the cash portion of the purchase price. The property purchase date determines the monthly or annual periods that are included on the CashFlow, Results and MonthAmort sheets. Users are required to enter the property purchase date, property purchase price, deposit amount and bond period in cells B5 to B8 on the Input sheet.
![property evaluator spreadsheet property evaluator spreadsheet](https://i.pinimg.com/736x/12/23/84/12238409541f0ec5bae6ed970dc206e2.jpg)
Most of the user input fields are included on the Input sheet and we'll therefore start by providing guidance on each of the user input fields on this sheet. This section of the instructions provides more information on the user input that is required in this template. If any of these variables need to be amended, the appropriate values can simply be entered on this sheet and all the template calculations will be updated automatically. Variables - this sheet includes all the residential property calculation variables that have been incorporated into the template calculations. All the values on this sheet are automatically calculated based on the input values and calculations that are included on the other sheets. Results - this sheet contains a comprehensive analysis of the forecasted property investment return. The only user input that is required is specifying the forecasted annual capital growth rates. The ad hoc repayments that are entered on the AdHoc sheet are automatically included in the monthly amortization table.ĬashFlow - this sheet includes a comprehensive property cash flow calculation that is based on the input variable values on the Input sheet and the monthly amortization table that is calculated on the MonthAmort sheet. The monthly interest rates are determined by deducting the rate discount that is specified in cell F6 from the prime interest rates that are entered on the PrimeRate sheet. MonthAmort - this sheet includes a monthly bond amortization table that incorporates variable monthly interest rates and ad hoc bond repayments. All the ad hoc bond repayments that are entered on this sheet are automatically included in the monthly amortization table based on the monthly periods in column A. The interest rates that are entered on this sheet are included in a monthly amortization table after deducting a rate discount that is specified by the user.ĪdHoc - this sheet facilitates including ad hoc bond repayments in the monthly amortization table on the MonthAmort sheet. PrimeRate - this sheet includes monthly prime interest rates from January 2000 to December 2050. Input - this sheet includes most of the input variable values that need to be specified in order to calculate an accurate property investment return forecast. The following sheets are included in this template: By comparing the results that are produced by these templates, users are able to measure actual investment return against initial expectations. The property investment forecast template enables users to compile an accurate investment forecast and the buy to let and primary residence property investment templates enable users to compile an accurate analysis of the actual investment return that is achieved. Note: We highly recommend using this template in conjunction with Property Reality's unique buy to let and primary residence property investment templates. The template forms part of the unique range of innovative residential property templates that are available on the Property Reality website (We highly recommend that you visit Property Reality in order to view samples of all the templates that are included in their comprehensive template subscription! If you are only interested in a residential property investment forecast template, you can buy this template by using our shopping cart. This template is provided courtesy of Property Reality.
#PROPERTY EVALUATOR SPREADSHEET SERIES#
Users are required to specify input values for a comprehensive series of property variables and the template automatically calculates a comprehensive, accurate investment return forecast on an annual and cumulative basis.
#PROPERTY EVALUATOR SPREADSHEET SOFTWARE#
The functionality that has been included in the template is comparable to any property software solution - in fact, we guarantee that you will not find a more practical and comprehensive residential property forecast solution anywhere else. This template enables users to calculate a comprehensive residential property investment forecast for any property investment or primary residence over any investment period between 1 month and 20 years.