Spreading the risk? Errors, risks and techniques in spreadsheets
Article Abstract:
The integrity and bottom-line accuracy of spreadsheets used in accounting can be maintained if subtle errors are prevented. To prevent errors, distinguish number cells from formula cells, double-check formulas which have been copied, and name ranges used in formulas. Other guidelines include avoiding constants in formulas, using a single output structure, repeating input values from other spreadsheets, breaking down complicated formulas using multiple spreadsheets, and adding validation formulas to check the results.
Publication Name: Australian CPA
Subject: Banking, finance and accounting industries
ISSN: 1440-8880
Year: 1998
User Contributions:
Comment about this article or add new information about this topic:
Corporate collapse: who's to blame?
Article Abstract:
The factors that can lead to corporate collapses are discussed. Particular attention is given to the role of external auditors, who must be fully independent and be able to establish whether the firm will continue as a going concern.
Publication Name: Australian CPA
Subject: Banking, finance and accounting industries
ISSN: 1440-8880
Year: 2001
User Contributions:
Comment about this article or add new information about this topic:
Oil-fired up
Article Abstract:
An Australian accountant presents his experiences of working with oil firms operating on Norway's west coast. He has been particularly involved in work arising from merger activity.
Publication Name: Australian CPA
Subject: Banking, finance and accounting industries
ISSN: 1440-8880
Year: 2000
User Contributions:
Comment about this article or add new information about this topic:
- Abstracts: Seeing the big picture. Intangible assets and the need for speed. End game or new game: Standard setting should be properly managed to minimize future Senate interventions
- Abstracts: Project insurance: managing the risks. Risk, rewards, and performance. Credit derivatives: new methods for risk management
- Abstracts: Strategic management: unravelling the puzzle. Keeping tabs on treasury. Managing cash flow: taking a strategic view