100% Unique Excel Templates!
  • Accounting in Excel
  • Financial Statements
  • Cash Flow Forecasts
  • Payroll & Leave
  • Management Accounts
  • Fixed Assets Registers
  • Business Valuations
  • Product Costings
And A Lot More!
  • Try Before You Buy!
  • Click the Trial buttons and enable our 100% safe trial version macros to try out the templates...
  • No Macros? View Our Samples!
  • Click the Sample buttons to view the layout of the templates in a file format that cannot be edited...
  • Ready To Buy?
  • Simply click the Buy Now buttons to add the appropriate template to your shopping cart...
  • Download all our unique templates!
  • Register for a full membership in order to download ALL 40+ of our unique templates!
  • Special Offer
  • Click to select & buy any 3 of our unique templates for only ZAR800!
  • Register
  • Click to register & buy ALL 40+ of our templates for only ZAR3,000!
34 Business Valuation Template
Compile an informal valuation of a business based on the discounted future cash flow projections. Net annual cash flows are discounted at the weighted average cost of capital (WACC) to calculate net present value (NPV), internal rate of return (IRR) and an estimated business valuation. All the valuation calculations are based on both a three year and a five year period.
  • Suitable for all business owners and buyers & sellers of businesses
  • Automated 5 year annual cash flow projections
  • Cash flow projections compiled from template assumptions
  • Customize the 23 default expense items (and add more)
  • 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
35 Loan Calculation & Analysis Template
Compile a loan account statement by using the same methodology as used by most financial institutions. Monthly loan repayments, daily interest calculations and capitalization of interest on the last day of each calendar month. 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. Includes a loan repayment forecast for remaining loan period.
  • Suitable for loans subject to monthly repayment & daily interest
  • Automated loan account statement based on limited user input
  • Automated calculation of interest & monthly interest capitalization
  • Multiple ad hoc loan repayments & interest rate changes
  • Automated monthly loan account summary
  • Loan forecasts for remaining scheduled & ad hoc loan repayments
  • Calculates interest saving resulting from ad hoc loan repayments
  • Accommodates increased instalments & lump sum repayments
36 Loan Account Statement Template
Compile a loan account statement for any loan that is repaid on a monthly basis and subject to daily interest calculations. Accommodates variable interest rates and ad hoc loan repayments. 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. The template is a simplified version of our Loan Calculation & Analysis template and contains no loan repayment forecast.
  • Suitable for loans subject to monthly repayment & daily interest
  • Automated loan account statement based on limited user input
  • Automated calculation of interest & monthly interest capitalization
  • Multiple ad hoc loan repayments & interest rate changes
  • Automated monthly loan account summary
37 IFRS Fixed Assets Register Template
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. Only accommodates depreciation calculations on a straight line basis.
  • Compile a comprehensive fixed asset register with limited input
  • Record asset acquisition, disposal & revaluation transactions
  • Automatically calculates 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
  • Roll forward or back for future or past financial reporting periods
38 Basic Fixed Asset Register Template
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 even a daily basis.
  • 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
  • Roll forward or back for future or past financial reporting periods
  • Depreciation on straight-line, diminishing value or double diminishing
  • Does not accommodate revaluations & tax values
Show List