Google
RSS Feeds RSS | Views on ITInews | contact | terms of use | privacy 
 


Editorial Categories:

FINANCIAL SERVICES
ADVISERS & BROKERS
BANKING & BONDS
BUSINESS MANAGEMENT
COLUMNISTS
CONSUMER AFFAIRS
CRIME & FRAUD
ECONOMY & GLOBAL
EDUCATION & TRAINING
ESTATES & WILLS
HEALTHCARE INSURANCE
INDUSTRY & LEGISLATION
INSURANCE
INVESTING
LEGAL AFFAIRS
LIABILITY INSURANCE
LIFE INSURANCE
MARKETING
PEOPLE & COMPANIES
POLITICS
PROPERTY
RETIREMENT PROVISION
REVIEWS
ROAD ACCIDENT FUND
SHARES & UNIT TRUSTS
SHORT-TERM INSURANCE
TAXATION
TECHNOLOGY
VIEWS & LETTERS


Forthcoming Events:

No Upcoming Events



Save by getting insurance quotes


Proudly South AfricanInforming Consumers and Financial Advisors since 1988 | Click Here to Advertise
Car, household, life and business insurance quotes

News Article : Program tester
Category: Business Management : Software Reviews
Author:Nigel Benetton
Email:[email protected]
Posted:05 Jul 2005

 Email this article Comment on this Article  Print this article

Spreadsheet errors cause massive losses

Spreadsheet errors are causing massive losses on a global scale according to various reports. All industries are affected, not least the actuarial world of insurance risk and premium determination. And if insurers don’t find some way of verifying data they will end up misjudging risk and facing huge unexpected liabilities.

Adrian Miric, MD of Miricle Solutions, distributor of a spreadsheet auditing tool called Spreadsheet Professional, says that most insurance companies use complex spreadsheets for modelling the risks of their clients and actuarially determining premiums. Their models are run thousands of times on spreadsheets to determine risk under thousands of scenarios for a single policy. One small mistake, be it in an assumption or the underlying data, can make a big difference.

Actuaries must comply with the Financial Advisory and Intermediary Services (FAIS) Act, of course, which is intended to protect consumers’ rights in respect of advice from financial advisors or institutions. Advice based on erroneous figures caused by spreadsheet mistakes would obviously land insurance and financial companies in hot water.

Mr Miric says, “Research shows that over 80% of all spreadsheets contain mistakes. The spreadsheet horror stories being revealed on a monthly basis can affect and probably already have affected South African companies.”

International building materials company, James Hardie Industries, for instance, experienced a US$5 million actuarial overstatement resulting from advice it received from its consulting company in relation to the level of asbestos liabilities to which it was potentially exposed. The insurance recoveries were over-discounted due to spreadsheet errors.

No industry is immune from spreadsheet errors, he says.

A Canadian listed company, TransAlta, disclosed a loss of $24 million, possibly due to one of the most common sources of errors - the copy and paste function, along with the use of absolute and relative referencing in spreadsheets. TransAlta’s computer spreadsheet contained mismatched bids for transmission congestion contracts (TCCs). As a result, it bought more contracts at higher prices than intended. The actual value of TCCs was determined daily, based on changing supply, load and transmission conditions.

In another case City officials in Richmond, Virginia, miscalculated the amount of sales taxes generated at Stony Point Fashion Park during the first couple of months of operation. The mistake inadvertently inflated the figures by tens of thousands of dollars, which in turn meant the total sales estimate was overblown by millions of dollars. The city blamed the mistake primarily on an error in a spreadsheet formula, which amplified a subtotal amount.

In yet another case, a company projected gains of $200 million on a deal. The gains fell to $25 million when it was discovered there were misplaced parentheses in some very long spreadsheet formulas.

In the US the Sarbanes-Oxley Act has forced companies to focus on corporate governance and the controls in place throughout the organisation. It makes specific mention regarding the use of spreadsheets, particularly because they are easily accessible, changes made to them cannot be tracked easily and they are prone to error when they become even a little complex. Foreign offices of international firms are also affected by the legislation, which means that South African companies with US parents may have to improve the controls around their spreadsheets.

Mr Miric says regulators will soon start addressing the risks inherent in spreadsheets. In the US, a PricewaterhouseCoopers report already highlights the risks of spreadsheets with regard to the Sarbanes-Oxley Act.

“The only way a company can ensure its spreadsheets meet corporate governance and financial reporting requirements is to use a spreadsheet auditing tool,” he explains. “Even something as simple as learning to use Excel’s in-built auditing features will have a big impact.”

More information and free software downloads can be found at www.AuditExcel.co.za. For further information please call Adrian Miric, Miricle Solutions, on (011) 807 6718, or email: [email protected]

Comments:
There are no comments at this stage. Be the first to comment!
Please Login To Comment On an Article - Click here To Login

ITInews invites comments at the foot of each of its articles in which readers can respond freely - anonymously if they wish - to various topical issues and industry debates. However, comments submitted by readers that are defamatory or deemed, by the editors, to be racist or obscene will be deleted from the database. Furthermore, ITInews's editor would like to caution potential posters on its websites that while it welcomes robust debate, it will not hesitate to make the IP addresses of the authors of such defamatory statements available to the authorities, in the event of a court order compelling them to do so.



Get car, home, life and business insurance quotes in 3 easy steps



Join us today

Insurance Quotes


Car Insurance Quotes
Household Insurance Quotes
Business Insurance Quotes
Funeral Insurance Quotes
Life Insurance Quotes

Read the InsuranceQuotes Blog

Business Management - Software Reviews
Administration
Best Practices
Organisational culture
Practice Building
Software Reviews

More in Business Management : Software Reviews
Sorry, no other news...


Available Recruitment:
No Vacancies Listed...


ITM Website Design Cape Town
Copyright © 2005 - 2015 ITInews Online Publications (Pty) Ltd. All rights reserved Insurance Times & Investments Online and ITInews. ..::ISSN 1995-1256::.. No part of the materials including graphics or logos, available in this Web site may be copied, photocopied, reproduced, translated or reduced to any electronic medium or machine-readable form, in whole or in part, without specific permission from ITInews Online Publications (Pty) Ltd. Distribution for commercial purposes is prohibited.