Saturday, January 31, 2009

Schapiro endorsed by Senate

Written by David Jetuah

Accountancy Age

The US Senate has given its backing to Mary Schapiro's selection as the new head of the Securities and Exchange Commission.New SEC chair announced



Schapiro has said she will put the IFRS roadmap under the microscope as one of her first key objectives when she takes office.

'I will take a deep breath and look at this entire area carefully'

The roadmap is the blueprint for IFRS adoption in the US, but Schapiro has hinted that she may not automatically rubber stamp the proposals.

Announcing a New Study of IFRS Readiness at U.S. Companies

A research study designed to assess the readiness of U.S. companies to move to International Financial Reporting Standards (IFRS) has been launched as part of a newly-formed alliance between The Hackett Group, Inc. (HCKT ) and the Institute of Management Accountants (IMA).

The study will evaluate a range of key issues around IFRS adoption, including: companies’ planned timelines for IFRS adoption; the expected impact on organization, processes, and technology; implementation practices, including expected investments; and plans for internal education. The study will launch this month and deliver results in June. It will be open to members of the IMA network, Hackett’s advisory programs, and the Hackett Performance Network.

"The SEC’s roadmap for U.S. public companies to transition to IFRS is still very much in flux. But there’s already tremendous concern about its potential impact, IFRS is very different from the rules-based GAAP system that U.S. companies currently use, and the transition will take significant planning and effort. By participating in this study, companies will be able to better understand the readiness issues, gain insight into what other companies are doing, and begin to develop an understanding of what the emerging best practices are. It should help them reduce the cost and confusion that will be associated with the transition."


Hackett Senior Business Advisor William Marchionni

Friday, January 30, 2009

Fortune 100 Best Companies to Work For

Rank Company Job
growth
U.S.
employees
1 NetApp 12% 5,014
2 Edward Jones 9% 34,496
3 Boston Consulting Group 10% 1,680
4 Google 40% 12,580
5 Wegmans Food Markets 6% 37,195
6 Cisco Systems 7% 37,123
7 Genentech 5% 10,969
8 Methodist Hospital System 1% 10,535
9 Goldman Sachs 2% 14,088
10 Nugget Market 22% 1,536
11 Adobe Systems 9% 4,255


For Full list please click here

As might be expected, the Big Four Accountancy firms all feature on the Fortune 100 Best Companies to Work For list, but all of them are lagging behind a smaller, less well known company.

Plante and Moran, a financial services firm based in Michigan USA, features on the list for the 11th year running and, coming in at 42nd, is the highest ranked certified public accounting firm.

According to Bill Hermann, managing partner at the firm, the secret of the company's success is based on a simple plan which has been exercised over its 85-year history.

"We strive to be 100 per cent jerk-free and that has allowed us to find and retain talented staff who provide quality service to our clients," he said.

In tough economic times it is even more important that clients are able to deal with accountants who are "smart, trained, motivated and happy to serve", he added.

Plante and Moran is the 12th largest accountancy firm in the US and also has offices in China and Mexico.

Thursday, January 29, 2009

IASB holds first financial crisis advisory group meeting in London

The first meeting of the Financial Crisis Advisory Group, took place on Tuesday 20th January in London. These proceedings were captured by audio webcast and broadcast live at the time of the meeting - they have also now been released as an archived web stream file.


The meeting's agenda included:

General Overview Session and Issues Briefing:

  • - Financial Reporting Issues Overview - Sir David Tweedie & Robert Herz
  • - Briefing on IASB and FASB Joint and Separate Projects - Gavin Francis & Russell Golden
  • - Overview of SEC Report on Mark-to-Market Accounting - James Kroeker
  • - Remarks of Other Observers:
  • Basel Committee of Banking Supervisors - Sylvie Matherat
  • Committee of European Securities Regulators - Fernando Restoy
  • International Association of Insurance Supervisors - Monica Mächler
  • Japan Financial Services Agency - Junichi Maruyam

After lunch the sessions addressed:
  • Issues Discussion.
  • Where did financial reporting help identify issues of concern, or create unnecessary concerns, during the credit crisis?
  • Where could financial reporting standards have provided better transparency to help either anticipate the crisis or respond to it more quickly?

Go the the IASB website here to access these files in full and for free

Tuesday, January 27, 2009

The KPMG SOX 404 compliance Institute


404 Institute members have always played a vital role in determining our agenda. Five years after the adoption of Section 404 became mandatory; our members report that compliance activities are continuing to be integrated into the corporate environment. As a result, members previously focused entirely on compliance are taking on increasingly operational roles. Given these dynamics the Institute is expanding its focus to meet your evolving needs by continuing to offer guidance and thought leadership on the broader set of financial management issues that affect you.

To help address your needs, we will cover a range of topics in addition to section 404 compliance - including financial reporting, and risk and controls. This will enable us to continue providing you with an open forum where ideas can be exchanged and leading practices developed on issues that impact you most.

We invite you to explore our updated Web site to find the wider range of topics and events we're scheduling to help you address the broader scope of issues you face.

This puts it in perspective

More than a billion people are using the internet


THE number of people going online has passed one billion for the first time, according to comScore, an online metrics company. Almost 180m internet users—over one in six of the world's online population—live in China, more than any other country. Until a few months ago America had most web users, but with 163m people online, or over half of its total population, it has reached saturation point. More populous countries such as China, Brazil and India have many more potential users and will eventually overtake those western countries with already high penetration rates. ComScore counts only unique users above the age of 15 and excludes access in internet cafes and via mobile devices.

Thursday, January 22, 2009

It’s about Career development, not Professional development…



The Institute of Chartered Accountants of Ireland ICAI now offers a range of post-qualification programmes. These programmes are designed specifically to meet the requirements of members and cover a range of technical and broad business skills.

2009 IFRS Diploma Book Now!


Diploma in IFRS


The 2009 Diploma in IFRS is now open for booking . In 2008 the courses were oversubscribed so early booking is advisable to secure your place.

The course has since its inception in 2004 has firmly established itself as Ireland's premier qualification in IFRS and has even developed a reputation overseas. Over 500 people have 'graduated' from the course including accountants in Luxemburg, the USA and Canada as well as Ireland, Switzerland and the UK.

The course is offered by a taught option in Dublin or by distance/home study, in 2009 there are a number of exciting new features on the distance programme including

  • New exam venues in addition to Dublin; Belfast, London, New York
  • Online tutorial sessions
  • Extra tutorial sessions, (two days) Belfast only


Other programmes currently available include:

New upcoming programmes

In addition to the existing portfolio of post-qualification programmes, a number of new specialist courses are in development in areas including:

Wednesday, January 21, 2009

SEC Under fire

Extract from The Economist

The economic crisis has cast a shadow over the SEC's progress in other areas. Christopher Cox’s SEC has led the push for greater global regulatory co-operation and for American firms to adopt international financial reporting standards (IFRS). It has democratised disclosure of company accounts using interactive databases. Mr Cox has also forced more transparency on executive pay, belying his pre-SEC reputation as a friend of Big Business.

All in all, however, the crisis has exposed the SEC as a cracked piston in a sputtering regulatory engine that dates back to the 1930s. Agencies regulate firms “according to what they were born as, not what they do today,” complains Harvey Pitt, a former SEC chairman. An example is the nonsensical separation of oversight for securities, performed by the SEC, and derivatives, done by the Commodity Futures Trading Commission (CFTC).

Mr Obama has talked about the need for regulatory consolidation. Mary Schapiro, who is due to succeed Mr Cox later this month, pending Senate approval, has publicly advocated merging the two agencies. This would require a doctrinal ruling, since the CFTC’s approach is far more principles-based than that of the SEC, which cleaves to hard rules. It would also call for some deft politics, since they are overseen by separate congressional committees, for whose members disbandment would mean an end to juicy campaign contributions from financial firms.

Bigger changes may be afoot. Regulation will probably be extended to new areas, such as credit-default swaps, which may fall to the SEC. But, under one proposal, the SEC would be replaced by a new business-conduct regulator, with some of its present activities going to other agencies; it has already lost some powers to the Federal Reserve, which is carving out a role as a systemic-risk watchdog. Although a career gamekeeper, Ms Schapiro is said to be more concerned with redrawing the regulatory architecture than protecting turf. That may be just as well. More...

Tuesday, January 20, 2009

IFRS Summit in Canada January 27-28 2009

by Darla Sycamore

There will be a Summit on IFRS for Canada on January 27 - 28, 2009. The two day event will deal with practical issues on IFRS and representatives from various companies will be speaking on a number of issues related to IFRS conversions. The organizations represented at the Summit include:


  • Accounting Standards Board Canada
  • International Financial Reporting Interpretations Committee (IFRIC)
  • Microsoft Corporation
  • Bombardier Inc
  • AltaGas Ltd
  • The Finance Group
  • Canadian Financial Executives Research Foundation
  • Homes Trust Company
  • Hydro One
  • Axiotron
  • HEC Montreal
  • egX Group Inc.
  • The Kidney Foundation of Canada
  • Agrana Fruit US Inc
  • Canam International
  • Agrium Inc.
  • TD Bank Financial Group
  • Gildan Activewear Inc,

The session will deal with private company issues and small/medium size businesses as well as public company issues. The topics include "the usual suspects".

  • Project management for IFRS
  • IFRS1 Implementation issues
  • Property, Plant and Equipment
  • Mergers and Acquisitions
  • Fair Value Accounting

See here for more details

Monday, January 19, 2009

IFRS - its not just about numbers.


It is also a people story: For starters, who should be trained (and when), who should provide the training, and what impact will an early mastery of IFRS have on an accountant's career?

That last question brings an easy answer from those in a position to provide IFRS training, including college professors and professional services firms.

For career advancement purposes, gaining bona fide expertise in international standards in the short term may be a sure ticket to bountiful career rewards.

"It's one of two very hot areas, fair value being the other one, anybody becoming an expert in either of those areas has a guaranteed career for many years."

H. David Sherman,
Professor at Northeastern University and a former SEC academic.

Read more...

Sunday, January 18, 2009

Early Adoption of IFRS may win investor confidence


A voluntary, early adoption of the International Financial Reporting Standard (IFRS) by Indian companies would help allay concerns of overseas investors, particularly in the wake of the Satyam scam, a senior Infosys executive said.

India has agreed to use IFRS as its accounting standard from fiscal 2011-12.

"It’s very important for India to reiterate commitment to IFRS and ask large companies to adopt it a year earlier. It will send a very strong signal that India stands for the highest standards in the world."


TV Mohandas Pai, Infosys director for HR, education & research and administration.


Read more...

Lexington Seminars - Specialist IFRS & USGAAP Training Provider


by David Goldman at Lexington Seminars

Lexington Seminars has established itself as a leading independent specialist provider of international accounting seminars (IFRS & US GAAP). With offices in Orlando Florida, we provide in company training delivered at a time and place of the client's choice.


Courses

Course 1020: IFRS Overview, with US GAAP Comparison

Duration: 3 days

This three-day interactive workshop is a step-by-step overview of the technical issues involved in IFRS and the critical differences between IFRS and US GAAP. The seminar is presented using financial statements, case studies, and extensive examples. Course topics include: Financial statement presentation and specific disclosures (segment reporting, events after the reporting period, cash flow statement, related parties, accounting policies/changes in estimates/errors, discontinued operations) | Revenue recognition | Recognition and measurement of assets (property, plant & equipment, borrowing costs, investment property and intangible assets) including the accounting treatment of impairment and assets held for sale | Contingencies and non-financial liabilities (including those for employee benefits) | Share-based payment | Foreign currency transactions | Investments in associates and joint ventures | Inventories | Overview of business combinations, including a recap of the January 2008 revisions | Consolidated financial statements, including special purpose entities | Financial instruments, including the IFRS 7 disclosure requirements | First-time adoption of IFRS | Comparison of the Conceptual Frameworks for IFRS and US GAAP | Discussion of significant differences between IFRS and US GAAP | Expected future developments (update on the IASB-FASB convergence project, status of global accounting convergence, Exposure Drafts, other IASB projects and work agenda). Please contact us for a price quote.

The following comprehensive course list is designed to meet a wide range of training requirements. If you need more assistance in identifying the adequate courses, please contact us for a personal consultation about your training requirements or to discuss an in-company (on-site) course.

Blog

Lexington Seminars is launching a Blog that will allow people interested in IFRS to post their comments, experiences and needs as they relate to IFRS.

Click here to check it out:

We welcome any participation in the Blog. We want to develop a global message board, a sounding board, about the importance of a world-wide universal set of accounting standards.

Friday, January 16, 2009

New SEC chief might slow push for IFRS

From Smart Brief

Mary Schapiro, President-elect Barack Obama's nominee to lead the Securities and Exchange Commission, testified Thursday before a Senate committee that she would aggressively reshape the SEC's enforcement efforts. Schapiro said that she would move quickly to create a new process for handling tips received by the agency, and she indicated there may be a need to expand the authority of the PCAOB. Schapiro said she has concerns with the SEC's current road map for transitioning U.S. public companies to International Financial Reporting Standards. Journalofaccountancy.com (01/16) FinancialWeek (01/15) Financial Times (01/15)

Wednesday, January 14, 2009

IFRS 'facing a critical year'...


The prospect of a global accounting language is a welcome one, but 2009 will be a critical year for the adoption of International Financial Reporting Standards (IFRS), according to one expert.

Will Rainy, global head of IFRS at Ernst and Young, explained that as an International Accounting Standards Board moratorium on the issuing of new standards has now come to an end, companies using IFRS face a wave of new standards and interpretations.

He said: "With almost 500 pages of new or revised standards and interpretations, companies face a major challenge getting up to speed on and correctly applying the new requirements."

The changes could have an impact on things such as IT systems, merger deals and share-based payment plans as well as accounting, Mr Rainey added.

Yesterday, Fitch Ratings claimed that 2009 will be a pivotal year for accounting. Fair value will be a particular focus, the firm stated.

Tuesday, January 13, 2009

Will reducing interest rates help?

There is a good deal in Evan Davis's remarks this morning on Today that all the fuss about whether the Bank of England should cut interest rates may be the equivalent of bald men arguing over who should have the comb - and his apology to my old friend Roger Bootle, a follicularly challenged economist, was priceless.

To return to my boring refrain of the past 18 months, the biggest problem for our economy is not the price of money but the availability of it. Banks are contracting the amount they lend. So the question is whether a cut in the Bank of England's policy rate to a historic low would increase the supply of credit.

In normal times, a cut in the Bank Rate would help to boost the flow of new lending. But right now it's not clear that a reduction would have much positive impact

The reason is that the main headache for the banks is that both regulators and markets are forcing them to hold more capital relative to their loans, their assets.

The risks of lending are perceived to have increased. So lenders to banks and also the FSA officials paid to stop banks falling over want them to hold more capital as a cushion against future credit losses.

Capital is scarce. The main source of it right now is us, taxpayers. Banks aren't keen to be nationalised to any greater extent than happened last year. So the route the banks are taking to boost the ratio of their capital to assets is to lend less, to deleverage (to use that ghastly euphemism).

Here's the good news. When interest rates are cut, that provides an opportunity for banks to generate capital. How so?

Well if banks fail to pass on the reduced cost of funds to borrowers, such as companies and those with mortgages, banks' profits increase, which in turn boosts capital (so long as banks don't pay out the profits as dividends). To put it another way, if banks make greater profits from lending that's one of the best incentives for them to lend more.

Here's the less good news. With interest rates so low, banks are under intense and understandable political and populist pressure to maintain interest rates for savers while still passing on the rate cut to borrowers.

In other words, they are under massive pressure to generate reduced profits from lending - which of course serves as a disincentive to lend.

And as the Bank of England's Bank Rate moves closer to zero, the louder is the clamour for the banks to keep rewarding savers while charging next-to-nothing for loans.

Which would squeeze profit margins till the pips squeak.

And there's a further drain on their profit margin as interest rates fall, which is that there's an unstoppable shrinkage in the margin between their average lending rate and the 0% rate banks always pay to the millions of us who keep some of our money in current accounts that never pay interest.

All of which is to say that cutting the Bank Rate now that rates are so low won't cure the disease that's afflicting the economy - the shortage of credit. And there's a risk that cutting rates to almost zero could make the illness worse.

Which is why it won't be too many weeks before we see policies that would be the equivalent of giving a comb to a hairy economist.

These, as I've been saying for some time, would involve taxpayers lending more to businesses and households, the further nationalisation of the credit-creation system.

What's still unclear is what form this nationalisation will take.

It could involve taxpayer guarantees for some bank loans. It could involve extracting loss-making assets or toxic loans from banks, to give the banks greater confidence that their capital won't be eroded. It could involve the state taking direct control of the provision of some credit to the real economy.

There's a massive amount of work on all this going on in the Treasury. And ministers are doing a great deal of agonizing about it all. The results of that agonising matter a great deal more than whatever decision is taken today by the Bank of England on interest rates.

Monday, January 12, 2009

China overtakes Germany

A Chinese farmer transports his produce.
Many Chinese people have not benefited from the boom

The Chinese government has increased its estimate of how much the economy grew during 2007. Read original article.

The revision means China's economy overtook Germany's to become the world's third largest in 2007.

Gross domestic product expanded 13%, up from an earlier estimate of 11.9%, to 25.7 trillion yuan ($3.5 trillion).

The figures underscore China's emergence as an economic superpower, although the country's growth rate is expected to have dropped to 9% in 2008.

China's government is taking measures to try and ease the slowdown.

The government has launched a 4 trillion yuan ($586bn) stimulus package and has promised measures to help struggling exporters and vehicle and steel makers.

Individually, most of China's more than one billion people remain poor.

Germany's GDP per person was $38,800 in 2007 compared with $2,800 in China, which has wide disparities between rich and poor.

China's economy has grown tenfold in the past 30 years.

Merrill Lynch economist Ting Lu predicted that it will overtake Japan as the world's second largest economy in "only three or four years".

IFRS implications for the CIO


by Sarah JohnsonIn the nation's finance departments, the wince-inducing memories are still fresh of having to lean on IT for help deciphering Sarbanes-Oxley. Yet CFOs are being faced once more with turning to their technology counterparts for guidance in a major financial reporting project.

The job this time — converting to a new accounting language — could require changes to IT systems, too.

Accounting experts are recommending that those conversations begin now, as the Securities and Exchange Commission inches toward mandating that all U.S. publicly traded companies use international financial reporting standards. (more...)



Trade credit insurance tightens

An essential element in the government's forthcoming package to stem the pernicious shrinkage of credit in the economy will be measures to compensate for the devastating impact on many companies of the withdrawal of trade credit insurance.

That probably sounds deeply dull and technical. But please read on, because this stuff matters to all of us.

For smaller companies, the importance of trade credit insurance is often that they can't borrow from banks, unless they've insured their sales to corporate customers.

The banks make this stipulation because it absolves them from having to assess the credit-worthiness of their borrowers in detail - because at least part of the credit risk has been laid off to an insurance company.


So the availability of such insurance is literally a matter of life and death for many businesses.

Woolworths is one of the more extreme examples.

When insurers would no longer provide cover to Woolies' suppliers in the autumn, that was the penultimate nail in the coffin of the ailing general retailer - because suppliers insisted that Woolworths pay cash upfront to them for orders, which meant that Woolies was forced to draw on its borrowing facilities, which in turn took the retailer up to the limit of what its bankers were prepared to lend.

And the rest is the sorry story you know: the demise of a historic high street name that was forced to liquidate everything so that the bankers could get their money back.

The point is that trade credit insurance is central to hundreds of billions of pounds in trade and the provision of finance to companies of all sizes.

When it's withdrawn, as has been happening for months, small companies are unable to fulfil valuable orders placed by big companies and those bigger companies lose access to vital supplies.

So a rational decision by insurers to scale back their cover on sales to companies perceived as vulnerable to our economic contraction is rippling through the economy in a damaging way: cover is being withdrawn because we appear to be in a sharp recession, and its withdrawal is making that recession significantly worse.

Part of the problem is that the insurers seem to me to have massively underpriced the cover they provide. Just as banks charged ludicrously low rates of interest during the years of the credit bubble, so the trade credit insurers insured hundreds of billions of pounds of trade for tiny premiums.

According to statistics from the Association of British Insurers, there were £334m of premiums written by the insurers in 2007, covering £282bn of sales by British companies.

Or, to put it another way: insurers were receiving premiums equivalent to the turnover of a medium-size business to protect more than 20% of the output of the entire British economy.

Scary or what?

Those aggregated premiums were equivalent to a minute 0.1% of the sum insured - down from 0.26% in 1995. Which would only make economic sense in a world where there are never recessions.

One illustration that the premium was too low is that claims received by insurers in 2008 are likely to have been rather more than total aggregated gross premiums received in the previous year, extrapolating from trends in the first nine months of the year.

But the insurers have been protecting themselves from the worst losses by simply withdrawing cover for new orders to companies seen as weak. In other words, unlike insurance provided to you and me on our homes, for example, the trade credit insurers have been able to withhold protection as soon as they detected stormy conditions.

To restate the painful paradox: insurance designed to give confidence to companies that they would be paid by corporate customers is being scaled back in a way that's magnifying the woes of businesses big and small.

What's to be done?

Well, in France, a new system is being implemented whereby taxpayers are sharing the insurance risk with private-sector insurers on supplies to viable companies.

And I would expect the Business Department and the Treasury to implement a similar system of co-insurance by taxpayers.

But that can only be a short-term solution.

In the longer term, the supply of finance to small and medium-size businesses has to be overhauled, so that the viability of those businesses is no longer dependent on insurance that's only available when the sun is shining.

New US Travel rules

Statue of Liberty, New York

The Foreign Office is warning that thousands of tourists could be turned away at US airports and ports, as a new online entry system comes into effect.

Read original article here.

Esta Website


From 12 January, visitors from countries which do not need visas will need to fill in an electronic form at least 72 hours before they travel.

Those who have not registered risk being detained and sent back home.

The Foreign Office fears some people do not know about it and critics say it might put people off visiting the US.

The new online registration scheme replaces the green I-94 forms that people on short term visits to the US had to fill in on the flight and hand to customs on arrival.

Security approval

America welcomes nearly 60 million tourists a year and about 50 million of those travel without the formality of a visa.

Britain is one of the countries that signed up to the visa waiver programme, but from Monday, new rules apply.

Electronic applications - known as Esta (Electronic System for Travel Authorisation) - have to be approved by the US Department of Homeland Security.

The Foreign Office is concerned that people who may not have heard of Esta and booked their trip before enforcement of the new rule may be caught out
FO spokesperson

Once an application is approved, it will be valid for all visits to the US for a two-year period.

The US Embassy in London said so far 99.6% of the applications have been approved - most within four seconds.

Michael Restovich, from the US Department of Homeland Security, said: "We want to keep the bad people out. We don't want to restrict commerce, we don't want to restrict tourism.

"We want to make sure the people getting on that aircraft or that sea vessel are clear to come to the United States and are risk-free."

The Foreign Office said it was "particularly concerned that people who may not have heard of Esta and booked their trip before enforcement of the new rule may be caught out".

Andrew Spice, of Post Office Travel Services, said: "Problems may also occur if UK tourists travel to the US via another country - like Canada or the Caribbean Islands - and don't realise they will need the Esta to gain entry."

Neal Weston from the British Air Transport Association, which represents UK-registered airlines, such as British Airways and Virgin Atlantic, said its members who fly to the US were fully prepared for the new system.

No charge

Abta - the Travel Association - believes it will help speed up the immigration process.

Frances Tuke, from Abta, said it had been reminding members about the Esta deadline for several months.

"We would advise people thinking about going to the US to fill in Esta before booking or as soon as they book because if it is rejected, it can take up to six weeks to get an appointment at the US embassy for a visa," she said.

She recalled British singer Yusuf Islam, formerly known as Cat Stevens, who was sent back to London from the US after his name was found on a "watchlist" in 2004, and said the new system should help prevent such incidents.

With an extra layer of intrusive bureaucracy, I think a lot of people will be deterred, if not simply confused
Travel expert Simon Calder

Esta is free but she warned that searches for Esta online brought up numerous websites offering to process the application in return for personal details and a fee.

Critics say it will be an inconvenience for business travellers and could prove a disincentive to people who like to travel spontaneously and book last-minute weekend breaks to US cities.

Simon Calder, travel editor of the Independent, said: "There are many, many draws the United States has but with an extra layer of very intrusive bureaucracy, I think a lot of people will be deterred, if not simply confused."

The Credit crunch in Numbers

Tim Harford (image copyright: Fran Monks)
BBC Radio 4 and iPlayer
Subscribe to the podcast
As the downturn takes hold, BBC Radio 4's More or Less programme looks at the maths behind the credit crunch. Read original article.

Since 2007, presenter and economist Tim Harford has been exploring and explaining the numbers which have contributed to - and have characterised - the global economic downturn.

He met the mathematicians at the heart of the City - and found out why some say they are to blame for the financial crisis.

He uncovered the flaws of the bankers' bonus system, and discovered a mathematical error which might have led the banks into trouble.

He interviewed quantitative finance expert Paul Wilmott and The Financial Times journalist Gillian Tett.

And he met the guardians of what could be the financial world's most important number.

You can listen to all of Tim's reports here.

PAUL WILMOTT, QUANTITATIVE FINANCE EXPERT

Paul Wilmott is a lecturer in financial mathematics and runs the profession's most popular website.

Paul Wilmott

He is a fan of quantitative finance - but he thinks that its misuse has played a part in creating the current banking crisis.

In November 2007, More or Less asked whether the financial mathematicians known as "quants" - short for quantitative analysts - were to blame for what was then being termed "the credit squeeze".

WHO ARE THE QUANTS?
Paul Wilmott discussed his concerns with Professor William Perraudin of the Tanaka Business School at Imperial College London.

Tim Harford chaired the discussion.

The risks of risk management

In December 2008, Tim invited Paul Wilmott back to talk about the problems in more detail.

Banks and hedge funds rely on highly-paid mathematicians and economists - "quants" - to evaluate risk.

So why did they not they see the credit crunch coming?

Paul Wilmott says some mathematicians have a tendency to get fixated on the numbers, failing to think about the big picture.

RISKY RISK MANAGEMENT

He posed a scenario.

Imagine you are at a magic show. The magician takes an ordinary pack of 52 playing cards, and gives it to a man in the audience to shuffle. He then asks a volunteer to think of a card. "The ace of spades," she replies.

The magician turns to the man with the pack of cards and removes a single card from the deck. What is the probability that the card is the ace of spaces?

To hear the answer listen to the interview, or read Paul Wilmott's article on the risks of risk management.

A fundamental mathematical error

Paul Wilmott says an additional cause of the credit crunch is that people simply got their sums wrong.

GETTING THE SUMS WRONG
He told More or Less these errors might have contributed to the mispricing of financial derivatives, and thus to the travails of the banks, the credit crunch, and the economic downturn.

The maths of the bonus system

Many traders were paid bonuses if they made money.

And yet, collectively, their trades bankrupted some banks and nearly bankrupted many more.

THE TRADER'S DILEMMA
Why did traders, paid for performance, all make the same mistake at the same time?

Paul Wilmott set out the trader's dilemma.

AT HOME WITH THE QUANTS
In October 2007, Tim Harford got a glimpse into the world of the quants.


William Hooper
The most successful of these talented mathematicians will come up with mathematical formulae that make them and their bank or hedge fund employers millions of pounds per year.

They are highly secretive about their work, not wanting others to know the details of their systems.

MEET THE QUANTS
But one of them, William Hooper, invited Tim Harford into his beautiful London home.

Read more about quantitative analysts

A trader's apology

William Hooper has since left the world of finance to start his own business.

He has been reflecting on the global economic problems and the question of who is to blame - read A trader's apology.

GILLIAN TETT, THE FINANCIAL TIMES
Gillian Tett is an assistant editor of the Financial Times and oversees the global coverage of the financial markets.


Gillian Tett
Five years ago, she was shocked to discover what she says could best be described as an iceberg in the middle of the City.

The role of the media

She was studying media coverage of the City and began to realise journalists were doing lots of stories on stocks and shares, mergers and acquisitions, but nothing on what had become a much bigger part of finance - the credit and derivative markets.

She says business journalists were simply not covering the City in a representative way.

THE FINANCIAL ICEBERG

You had a small part of the financial system bobbing above the water but a vast shadowy mass of activity pretty much hidden beneath the waves.

And hidden not just from ordinary people, but hidden from politicians, from many regulators, and unfortunately from much of the media too.

UNDERSTANDING LIBOR

The London Interbank Offered Rate - LIBOR - has been dubbed the financial world's most important number.

A view of the City

Published each day in the UK, it is the rate at which the banks lend to each other and it influences over $150 trillion (£100 trillion) of funds worldwide.

The Libor number is compiled by putting together the estimates of the cost of borrowing from at least eight banks, and then discarding the highest and lowest of the sample to leave an average rate which then becomes the daily 'Libor Fix'.

LIBOR

But the figure's validity is being questioned, with critics dubbing it "the rate at which banks won't lend".

Tim Harford was granted exclusive access to the operations centre where the daily rate is compiled.

More or Less is broadcast on BBC Radio 4. To find out more, visit the programme website, or subscribe to the More or Lesspodcast.

Monday, January 5, 2009

Spreadsheet skills: exorcising phantom links

man in striped shirt at laptopAs part of our new series providing solutions to common spreadsheet issues encountered by finance professionals, we look at how to locate and remove unintended links. By Liam Bastick, associate director with BPM Analytical Empowerment.


Query

Whenever I open certain Excel workbooks, I get a message asking if I want to update the links. I’m unsure how to search my workbook to find out what these links are. Please help!



Update Links Prompt (Excel 2003)

Advice

In this instance, the user wishes to find the links and decide individually whether they should be retained or removed. (If the intention is merely to remove them, you may wish to consider the free Microsoft add-in, Delete Links Wizard.)


The first step is to ascertain what type of links you have. One way of doing this is to select Edit-->Links in Excel 2003 or earlier, or use the Connections section of the Data tab (see graphic below) in Excel 2007. Also Alt + E + K, the keyboard shortcut, works in all versions of Excel.


Location of Edit Links in Excel 2007

However this command will not be available in all instances. If it is, you will probably have Formula Links. If Edit-->Links is available, a dialog box will appear.


Edit Links dialog box (illustration)

There may be more than one file linked. Upon inspection, you may notice that one or more file may simply be an older version of the active workbook. If so, the active workbook can be substituted for each file in turn by clicking on the Change Source button (Alt + N) and following the directions. This will remove these referencing errors.


You may not have access to some files and this may cause errors if the file is inadvertently updated. By selecting the Break Link button, these links can be replaced by their current values. This action cannot be undone so you may wish to save the file beforehand in order to rectify errors.

Formula links

If you do have formula links, it is relatively straightforward to search for them:

  • Close all workbooks except the active workbook with the links in.
  • In Excel 2003 / earlier, on the Edit menu, click Find. In Excel 2007, click on Find & Select on the Editing section of the Home tab – or use Ctrl + F in all versions.

Location of Find & Select in Excel 2007

  • Click Options
  • In the Find what box, enter [
  • In the Within box, click Workbook
  • In the Look In box, click Formulas
  • Click Find All
  • In the box at the bottom, look in the Formula column for formulas that contain [
  • To select the cell with a link, select the row in the box at the bottom.

Find Dialog box (illustration)

Other ‘phantom’ links

There are other types of links - often referred to as ‘phantom’ links as they are harder to locate than formula links. But once you know, it’s easy!

Name links

This is probably the most common cause of phantom links: names that reference ranges in other workbooks.

Using Define Name in Excel 2003 or earlier or Name Manager in Excel 2007 (or Ctrl + F3), we can get a list of all the names in the workbook:


Define Name (Excel 2003 or earlier)

Name Manager (Excel 2007)

By scrolling through the list of names and examining the ‘Refers to’ section (a little cumbersome prior to Excel 2007, admittedly), names referring to other workbooks or containing erroneous references such as #REF! can be changed or deleted.

Chart links

If you have charts in your workbook, there are various places where hidden links could be lurking. Click on each text box or title and examine the formula bar, , for references to other workbooks.


Click on each data series in the chart and examine the SERIES formula for external references. These links can be removed by copying (as values!) the data located into the active workbook.

Object links

External references can also be attached to objects. The simplest way of reviewing objects in a workbook is to use the highly underrated Go To-->Special function (use the F5 function key and then click Special). In the next dialog box, select Objects, then click OK.


Go To Dialog Box Go To Special: Selecting Objects


By pressing the Tab key and examining the formula bar, each object can be reviewed in turn for external references.

And finally…

Once you have completed the above process, unless your workbook includes web queries containing parameters (this could be an article in itself), all links should now have been reviewed. If the intention was to remove all such links, simply save and reopen once all deletions have been made.

If you have a spreadsheet query, email liam.bastick@bpmglobal.com or visit the BPM website.

Back to Insight front page