Excel is perfectly designed to organize financial data into traditional accountancy tables. Excel also provides several functions that are designed to perform common accountancy and financial analysis calculations. Therefore, if you have a small business, Excel may be all you need to maintain full records of your accounts.
The following pages show how to use Excel functions to perform common accounting calculations.
| Compound Interest Formula |
| Depreciation & Amortization in Excel |
The following pages show how to use Excel formulas to perform calculations relating to the time value of money.
| Excel Present Value Calculations |
| Excel Future Value Calculations |
| Analysis of a Single Cash Flow in Excel |
| Analysis of an Annuity in Excel |
The following pages provide templates of common accountancy documents, including a typical balance sheet, a profit and loss account and a cash flow statement.
| Balance Sheet Template |
| Profit and Loss Template |
| Cash Flow Statement Template |