Customer support
Thomson CPD Helpline
Thomson CPD’s Customer Service Team will be pleased to assist you with any questions about installing or using Financial Templates Toolkit. Phone Free Call 1800 036 186 Monday to Friday between 8.45 am and 5.30 pm Eastern Standard Time. Thomson CPD would appreciate any feedback or suggested improvements for Financial Templates Toolkit. Please email any comments to cpd.ftt@thomson.com.au (or you can click on feedback button on templates) or phone Free Call 1800 036 186.
Financial Templates Toolkit
User guide
Minimum computer requirements Installation Date format Getting started Finding your way around Opening templates Printing Templates Customer support Frequently asked questions
Frequently asked questions
For Frequently asked questions on Financial Templates Toolkit or other Thomson CPD electronic products, please visit our web site at www.cpd.com.au and select FAQ.
Thomson Legal & Regulatory Limited ABN 64 058 914 668 35 Cotham Road, Kew, VIC 3101 Tel: (03) 9205 0600 Fax: (03) 9853 0342
8
FTT 0804
Minimum computer requirements
Financial Templates Toolkit is designed to operate on computers with the following minimum specifications: 32 bit (Win 98, 2000, Me, XP, NT 4.0) Processor RAM Display Hard Disk Pentium 166 32Mb VGA (SVGA) 28Mb
Getting started
Financial Templates Toolkit is installed in a program group named CPD Business Tools.
Windows 98, 2000, Me, XP and NT 4.0
Click on the Start button and scroll up to Programs, CPD Business Tools and select Financial Templates Toolkit.
Financial Templates Toolkit is compatible with Microsoft Excel 97 and above and Internet Explorer 5.50 and above .
Installation
To install Financial Templates Toolkit, place your CD-ROM into the appropriate drive. Some PC systems will automatically start the installation program. (If the program starts automatically, simply follow the on-screen step-by-step instructions.)
Windows 98, 2000, Me, XP and NT 4.0
From the Start menu select Run and enter the installation command:
Driveletter:\SETUP
The Driveletter: will be your CD-ROM drive identification, e.g. D:\SETUP. This will initiate the InstallShield Wizard, which will prompt you for information about yourself and your computer, and then complete the installation for you.
Date format
To ensure calculations are correct it is essential that the date format is set to the Standard Australian setting of dd/mm/yy. To rectify go to the Control Panel (Setting|control panel) and double click on the icon labelled Regional Settings. When the dialogue box is open click on date tab. Ensure that the short date setting is either in the format dd/MM/yy or dd/MM/yyyy and that the long date format is d MMMM yyyy. Once you have opened the program, Financial Templates Toolkit will be displayed on screen. When asked if you wish to enable macros, click Enable Macros. This will ensure hyperlinks and calculations are enabled. Thomson CPD have checked this product for viruses.
2
3
Finding your way around
Template Menu
These tabs appear at the top of your template. Click on them and their sub-menus to move between the template screens.
Reports
Click on these tabs after you have entered your data to view the reports for each template, or to print all or any of them.
Feedback
Email any comments and suggestions about the template by clicking on this tab.
Entry Data
The greyed out tab reminds you which work sheet you are currently working on. Click on this tab when you are ready to fill in the dat entry fields.
Help
Click here to see guidance on understanding and working with the template.
Grey shaded cells
Enter data into these cells. Don’t enter data into yellow shaded cells (these show calculation results) or unshaded cells.
Need help? Call Thomson CPD’s Customer Service Team on Free Call 1800 036 186
4
5
Opening templates
Once you have installed Financial Templates Toolkit, there are two ways to open the templates.
Printing
To print workpapers, graphs and reports, we recommend you use the Print control boxes located on the templates. These boxes are either located on the Data Entry worksheet or on the individual worksheets and contain preset print areas to ensure all your data is printed when requested. If you choose to use File | Print from the Microsoft Excel menu, please ensure you set your print area before selecting Print. To set your print area in Excel 97, highlight the area you wish to print and select File | Print area | Set print area.
1. Main Menu
The templates are categorised under the topics on the main menu. Clicking on a topic will take you to a short description of the templates. Clicking on the title will allow you to open the template.
Templates
Borrowings
• Borrowing Cost Capitalisation • Loan Cost Amortisation • Loan Scheduler • • • • Petty Cash Manager Present Value Methods Recoverable Amount Calculator Trial Balance to Accounts Converter Hire Purchase Calculator Hire Purchase vs Lease vs Borrow Lease Amortisation Lease Classification
Financial Analysis
• • • • • • • Amortisation Methods Analytical Ratios Asset Valuation Break Even Volumes Break Even Numbers Budget Generator Reconciliation Generator
Leases
• • • •
2. Microsoft Excel Templates
If you have Microsoft Excel open, you can open a Financial Templates Toolkit template by selecting File | New from the Microsoft Excel menu and going to the tab titled FTT. Once you have clicked on this tab, you will see the template titles displayed. Doubleclick the title of the template you wish to open.
Revenue Recognition
• Interest Accrual — Compounding Monthly • Interest Accural — Other • Percentage Completion — Construction Contracts
Financial Statements
• Accruals and Prepayments Calculator • Annual Leave Calculator • Asset Revaluation Scheduler • Bank Reconciliation • Cash Flow Statement • Depreciation Schedule • Director/Executive Remuneration • Expense Classifier • Financial Reporting Decision Trees • Long Service Leave
Taxation
• • • • • • • Accounting for Income Tax CGT Quick Calculator Compliance Calendar and Tracker SGC Levy Calculator Tax Depreciation Schedule Tax Effect Accounting Tax Effect Accounting (Super fund)
7
6