LOADING
Click here to view your shopping cart contents and to proceed to the Checkout. All prices are once-off and there is no time limit on the use of our templates.
 
  • Special Offer - Save 70%
  • Buy all 11 of our Excel based
  • residential property templates
  • for only ZAR900!
  • Click Here!
 
  • 01 Property Investment - Forecast Template
This unique template enables users to calculate a comprehensive property investment forecast for any residential property investment on an annual & cumulative basis over any investment period between 1 month and 20 years. The template incorporates variable monthly interest rates, an unlimited number of ad hoc bond repayments, variable annual capital growth rates and property income tax & capital gains tax calculations. This is by far the most comprehensive & accurate residential property investment forecast solution for the South African residential property market.
  • Includes the following features:
  • Limited user input in order to compile comprehensive, automated forecast
  • Variable monthly interest rates & unlimited ad hoc bond repayments
  • Variable annual capital growth rates
  • Includes capital gains tax & income tax
  • Detailed monthly amortization table & detailed annual cash flow report
  • Comprehensive property investment return analysis
  • Net present value (NPV) and internal rate of return (IRR)
  • Annual return on equity (ROE) & rental yields
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. property investment forecastClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. investment property forecastClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR400 File Size: 344KB File Size: 142KB
  • 02 Property Investment - Buy to Let Template
This template enables users to record transactions for an unlimited number of buy to let property investments and to view a comprehensive analysis of annual & cumulative investment return on an individual property or portfolio basis. Users can create an unlimited number of property codes, record basic income & expense transactions for all properties and capture annual bond & market values for each property. A comprehensive annual & cumulative investment return analysis is produced based on this user input. This is by far the most comprehensive & accurate actual investment return calculation solution that is available for the South African residential property market!
  • Includes the following features:
  • Calculates annual & cumulative investment return per property or portfolio
  • Record monthly income & expense transactions
  • Record annual market values & outstanding bond amounts
  • Accommodates an unlimited number of properties
  • Automated tax invoice & detailed annual and monthly cash flow reports
  • Comprehensive property investment return analysis
  • Net present value (NPV) and internal rate of return (IRR)
  • Annual return on equity (ROE) & rental yields
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. property buy to letClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. buy to let propertyClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR400 File Size: 689KB File Size: 182KB
  • 03 Property Investment - Primary Residence Template
This template enables users to compile a comprehensive analysis of annual & cumulative investment return for any primary residence. The template can be used for multiple primary residences and includes the functionality to measure operational costs like water & electricity on a monthly basis. Users record monthly expenses and annual market values & outstanding bond amounts. The template produces an automated comprehensive investment return analysis which includes calculations of the annual & cumulative capital growth, the annual return on equity and the cumulative internal rate of return (IRR).
  • Includes the following features:
  • Calculates annual & cumulative investment return for any primary residence
  • Record monthly expense transactions
  • Record annual market values & outstanding bond amounts
  • Automatically calculates capital gains tax amounts based on exclusions
  • Detailed annual and monthly cash flow reports
  • Comprehensive property investment return analysis
  • Net present value (NPV) and internal rate of return (IRR)
  • Annual return on equity (ROE)
  • Includes monthly operational cost (water & electricity) analysis
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. primary residenceClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. buy propertyClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR400 File Size: 417KB File Size: 144KB
  • 04 Property Capital Gains Tax Template
This template enables users to calculate the capital gains tax that is payable when a residential property is sold. Users are required to enter the selling price, selling costs, initial transfer costs, total renovation costs, property purchase price and the total income from other sources. An entity form also needs to be selected and a checkbox can be selected if the property is a primary residence. The template includes calculations of the income tax on income from other sources and the combined taxable income (including the capital gain) as well as the capital gains tax amount and effective capital gains tax percentage.
  • Includes the following features:
  • Limited user input required
  • Calculates income tax calculation before & after capital gains
  • Calculates effective income tax rates before & after capital gains
  • Calculates effective capital gains tax percentage
  • Flexible design makes template easy to amend for future periods
  • Incorporates all capital gains tax primary residence exclusions
  • Suitable for individuals & corporate entities
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. property capital gains taxClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. property cgtClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 File Size: 100KB File Size: 41KB
  • 05 Property Income Tax Calculation Template
This template enables users to calculate the income tax that is payable on the residential property transactions that relate to the current income tax assessment period. Users are required to enter all the appropriate property transaction totals and the taxable income that is derived from other sources of income. An income tax amount is then calculated based on the income from other sources, the combined taxable income (including the residential property transactions) and only the residential property transactions.
  • Includes the following features:
  • Limited user input required
  • Calculates income tax calculation before & after property transactions
  • Calculates effective income tax rates before & after property transactions
  • Flexible design makes template easy to amend for future periods
  • Suitable for individuals & corporate entities
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. property income taxClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. property income taxClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 File Size: 96KB File Size: 38KB
  • 06 Transfer & Bond Cost Template
This template enables users to calculate an accurate estimate of the transfer and bond costs that will be incurred when purchasing a residential property. The template includes a transfer & bond cost calculation sheet, detailed transfer & bond cost tables and a sheet which includes all the cost variables that are used in the transfer & bond cost calculations. All the calculations in the template can be updated automatically by simply editing the appropriate default values that have been included on a separate sheet and it is therefore extremely easy to update the template calculations when changes in the default variables occur.
  • Includes the following features:
  • Limited user input required
  • Automated calculation of accurate transfer & bond costs
  • Flexible design makes it easy to update template
  • Includes all significant transfer & bond costs
  • Includes detailed automated transfer & bond cost tables
  • Suitable for individuals & corporate entities
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. property bond costClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. property transfer costClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 File Size: 130KB File Size: 53KB
  • 07 Bond Statement Template
This template enables users to compile a bond statement for any bond that is repaid on a monthly basis and subject to daily interest calculations. The template has been designed specifically for the analysis of bonds that are subject to variable interest rates and also accommodates ad hoc bond repayments that fall outside the scope of most standard amortization tables. Interest calculations are based on daily bond balances (same calculation basis as used by most financial institutions) and an unlimited number of interest rate changes can be recorded.
  • Includes the following features:
  • All bond transactions are entered by the user
  • Automated calculation of interest based on any transaction date
  • Automated calculation of statement balances after each transaction
  • Comprehensive bond statement compiled automatically
  • Accommodates an unlimited number of interest rate changes
  • Accommodates an unlimited number of ad hoc bond repayments
  • Automated monthly bond summary
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. bond statementClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. bond statement calculationClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 File Size: 227KB File Size: 98KB
  • 08 Bond Amortization Template
This template enables users to compile a monthly bond amortization table that accommodates variable monthly interest rates and an unlimited number of ad hoc bond repayments. The template also includes an annual bond amortization table that is compiled based on the appropriate amounts in the monthly bond amortization table. User input is limited to entering a bond amount, bond period, bond start date and an interest rate discount or premium in the appropriate input cells and entering monthly prime interest rates and ad hoc bond repayments on separate sheets.
  • Includes the following features:
  • Limited user input required
  • Accommodates variable monthly interest rates
  • Accommodates ad hoc bond repayments
  • Includes detailed monthly & annual amortization tables
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. bond amortizationClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. home loan amortizationClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 File Size: 223KB File Size: 92KB
  • 09 Effective Interest Rate Template
This template enables users to calculate an accurate estimate of the effective interest rate of a bond. The calculation is based on a standard amortization table that incorporates variable monthly interest rates. The monthly prime interest rates need to be entered by the user and a rate discount percentage is applied in order to determine the appropriate monthly interest rates. An amortization table that is automatically calculated is used to determine the effective interest rate at the end of each annual interval. The template also includes effective interest charts.
  • Includes the following features:
  • Limited user input required
  • Accommodates variable monthly interest rates
  • Includes detailed monthly amortization table
  • Calculates effective interest rate at the end of each annual period
  • Includes charts that display movement in effective interest rates
  Click this button to add the template to your shopping cart. All prices are once-off and the use of the templates is not restricted to any pre-determined period. bond amortizationClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xls file format is appropriate for users of the 2003 version of Excel. home loan amortizationClick this button to open the sample file in Microsoft Excel. Our sample files illustrate the layout & features of the template but cannot be edited. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top ZAR300 File Size: 207KB File Size: 90KB
  • 10 Bond Calculator Template
Bond calculators are also referred to as home loan calculators or mortgage calculators. The aim of this free Excel template is to enable users to calculate monthly bond repayments, determine the affordability of a home loan, calculate the interest savings that result from increased bond instalments and measure the sensitivity of bond repayments to changes in interest rates. After using this template, users will also gain an improved understanding of home loan amortization and specifically the timing of capital repayments on a bond.
Free Excel Template bond calculatorClick this button to download & open this free template in Microsoft Excel. The .xls file format is appropriate for users of the 2003 version of Excel. bond calculatorsClick this button to download & open this free template in Microsoft Excel. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top File Size: 398KB File Size: 145KB
  • 11 Capital Growth Calculator Template
This template enables users to calculate the capital growth that has been achieved on a residential property investment. Users are required to enter the property purchase price, property market value and the investment period (in months). The average annual capital growth is calculated based on the values that are specified by the user and the template also calculates property market values based on average capital growth percentages that are up to 5% more & up to 5% less than the calculated average capital growth calculation.
Free Excel Template property capital growthClick this button to download & open this free template in Microsoft Excel. The .xls file format is appropriate for users of the 2003 version of Excel. property price growthClick this button to download & open this free template in Microsoft Excel. The .xlsx file format should be used for all Excel versions after Excel 2003.
Return to Top File Size: 51KB File Size: 18KB
You have 0 templates in your cart