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.
   
   
  This page lists our Fixed Assets, Loans & Valuations templates. Our 40+ unique templates are listed on the following template pages:  
  • 25 Business Valuation Template
This innovative template enables users to compile an informal valuation of a business based on the cash flow projections that are automatically compiled from the template assumptions. The net annual cash flows are discounted at the weighted average cost of capital (WACC) in order to calculate a net present value (NPV), internal rate of return (IRR) and an estimated business valuation. The flexible design of the template also enables users to perform sensitivities on the projected cash flow and financing of a business in order to evaluate how much the business is worth. All the valuation calculations are based on both a three year and a five year period. This template can also be used for service based businesses by simply specifying a 100% gross profit percentage.
  • Includes the following features:
  • Suitable for all business owners and buyers & sellers of businesses
  • Automated 5 year annual cash flow projections
  • Cash flow projections compiled from standard template assumptions
  • Customize the 23 default expense items and add additional expenses
  • Discounted cash flow calculation methodology
  • Calculates weighted average cost of capital (WACC)
  • Calculates net present value (NPV)
  • Calculates internal rate of return (IRR)
  • Calculates an estimated business valuation
  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. company valuation templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel company valuationClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. business valuation templateClick 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. excel business valuationClick 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 ($30 £24 €28) File Size: 176KB File Size: 69KB File Size: 139KB File Size: 54KB
  • 26 Loan Calculation & Analysis Template
This comprehensive loan calculation and analysis template enables users to compile a loan account statement by using the same methodology as used by most financial institutions. The template is based on monthly loan repayments, daily interest calculations and capitalization of interest on the last day of each calendar month. The template has been designed specifically for loans that are subject to variable interest rates (like home loans), accommodates the recording of ad hoc loan repayments and the recording of interest rate changes on any user defined effective date. Users are required to enter loan account transactions and a loan account statement and repayment forecast are automatically calculated in order to create an overall loan analysis for the entire loan period.
  • Includes the following features:
  • Suitable for any loan that is subject to monthly repayment & daily interest
  • Automated loan account statement based on limited user input
  • Automated calculation of interest and monthly interest capitalization
  • Accommodates multiple ad hoc loan repayments & interest rate changes
  • Automated monthly loan account summary
  • Includes loan forecasts for remaining scheduled & ad hoc loan repayments
  • Calculates interest saving resulting from ad hoc loan repayments
  • Forecast accommodates increased instalments and lump sum repayments
  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. loan calculationClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel loan templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel loan calculation templateClick 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. excel loan statement templateClick 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 ($30 £24 €28) File Size: 853KB File Size: 318KB File Size: 457KB File Size: 228KB
  • 27 Loan Account Statement Template
This template enables users to compile a loan account statement for any loan that is repaid on a monthly basis and subject to daily interest calculations. The template has been designed specifically for the analysis of loans that are subject to variable interest rates and also accommodates ad hoc loan repayments that fall outside the scope of standard amortization tables. Interest calculations are based on daily loan account balances (same calculation basis as used by most financial institutions) and an unlimited number of interest rate changes can be recorded. Loan account transactions need to be entered and a comprehensive loan account statement is automatically calculated. The template is a simplified version of our Loan Calculation & Analysis template.
  • Includes the following features:
  • Suitable for any loan that is subject to monthly repayment & daily interest
  • Automated loan account statement based on limited user input
  • Automated calculation of interest and monthly interest capitalization
  • Accommodates multiple ad hoc loan repayments & interest rate changes
  • Automated monthly loan account 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. loan accountClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. loan statement templateClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. excel loan account templateClick 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. loan account statement templateClick 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 ($22 £18 €21) File Size: 333KB File Size: 132KB File Size: 208KB File Size: 97KB
  • 28 IFRS Fixed Assets Register Template
This comprehensive template enables users to compile a complete fixed assets register which incorporates an unlimited number of fixed asset classes and fixed asset categories; facilitates recording asset additions, disposals, revaluations and impairments; automatically calculates monthly and year-to-date depreciation charges; calculates income tax values based on user defined asset tax codes; calculates deferred tax balances and includes a comprehensive automated journal report. The template has been designed specifically for the requirements of IFRS but can also be used to compile a simple fixed asset register which is only based on historical costs. Please note that the template only accommodates depreciation calculations on a straight line basis.
  • Includes the following features:
  • Compile a comprehensive fixed asset register with limited user input
  • Record asset acquisition, disposal & revaluation transactions
  • Automatically calculates monthly & year-to-date depreciation (straight line)
  • Accommodates unlimited number of asset codes & asset categories
  • Accommodates an unlimited number of asset revaluations
  • Automated calculation of tax values & deferred tax
  • Asset summary by category for general ledger journal purposes
  • Asset summary by class for financial statement purposes
  • Automated journal report for all fixed asset transactions
  • Easy to roll forward or back for future or past financial reporting periods
  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. excel fixed assetsClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. property plant & equipmentClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. fixed asset register templateClick 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. fixed assets registerClick 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 ($30 £24 €28) File Size: 1.06MB File Size: 264KB File Size: 387KB File Size: 138KB
  • 29 Basic Fixed Asset Register Template
This basic asset register template enables users to compile a complete fixed assets register which incorporates an unlimited number of fixed asset classes and categories; facilitates recording additions and disposals; automatically calculates monthly and year-to-date depreciation charges and includes an automated journal report. The template accommodates depreciation calculations based on the straight-line, diminishing value and double diminishing value calculation methods on a monthly or daily basis.
  • Includes the following features:
  • Compile a b basic fixed asset register with limited user input
  • Record asset acquisition & disposal transactions
  • Automatically calculates monthly & year-to-date depreciation
  • Accommodates unlimited number of asset codes & asset categories
  • Asset summary by category for general ledger journal purposes
  • Asset summary by class for financial statement purposes
  • Automated journal report for all fixed asset transactions
  • Easy to roll forward or back for future or past financial reporting periods
  • Depreciation on straight-line, diminishing value or double diminishing
  • Does not accommodate revaluations & does not include tax values
  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. diminishing valueClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. asset registerClick this button to open the trial version in Microsoft Excel and enable our 100% safe & secure trial version macro to try out the template. The .xls file format is appropriate for users of the 2003 version of Excel. asset register templateClick 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. fixed assets templateClick 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 ($30 £24 €28) File Size: 641KB File Size: 148KB File Size: 281KB File Size: 95KB
  This page lists our Fixed Assets, Loans & Valuations templates. Our 40+ unique templates are listed on the following template pages:  
                     
You have 0 templates in your cart