Join Mailing List

For latest news and information about Treasury and Financial Markets, enter your details below:

Model Design and Audit

Print Preview Send to a Friend Share

Model Design and Audit Workshop, (One Day)

What's it about?

Spreadsheets are used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, financial analysis and forecasting. In short banks rely on the information to run their business.

But sometimes it isn't right.

One reason can be that the spreadsheet model is simply not robust.

This course is designed for those who would like to effectively utilise the powerful features of Excel without falling into the common traps.

The course will explore the use of Excel as an audit and analysis tool, as well as selected features that help prepare accurate reports and work papers.

The programme is taught using formal lectures combined with practical and interactive case studies and exercises to reinforce the concepts covered in each teaching session.

Emphasis is placed on delegates gaining practical, hands-on experience of the design and auditing of financial models in Excel.

Comprehensive product notes and modelling software will be provided for future reference.  

Delegates also receive a full pack of templates for future reference.

You will learn how to construct and audit models from templates including:

  • The principles of spreadsheet best practice
  • The objectives governing model design and construction
  • The structured methodology for different types of models
  • How to design accurate models
  • The techniques for efficient model construction and robustness
  • A range of auditing techniques
  • The tools for auditing and testing models to ensure accuracy
  • How to apply auditing techniques

Course requirements: delegates will be expected to have finance knowledge and a working knowledge of Excel.

Related Documents

Free to ViewTreasury Audit Training 100% relevant

Free to ViewTreasury Consulting > Product design 57% relevant

Free to ViewTreasury Consulting > System design 57% relevant

Registration RequiredQuick Guides > Rogue Trading 50% relevant

In March 2008 the FSA issued Market Watch No. 25. In this report the FSA highlights the measures firms should consider when reviewing systems and controls used to protect against the risk of a rogue trader. Overall the newsletter is helpful and the FSA correctly identifies and comments on a number of issues. Whilst not formal guidance the newsletter from Markets Division contains a number of surprising comments that if followed could lead to problems with the regulator.

Registration RequiredRegulation > Consultation Paper 09/17: A Specialist Sourcebook for Building Societies June 2009 50% relevant

1st August 2009

The general thrust of the CP is that Societies must prove that they have both the management and the systems capable of effectively dealing with the risks they face. This is part of the enhanced supervisory approach now adopted by the FSA. It states that systems and controls must match the level of complexity in a firm's business model. The FSA will adopt a more interventionist approach in order to ensure this is the case. The proposal is that building societies and the regulator will determine whether the risk management policies adopted are appropriate. Where they are not the Society can either simplify its business or improve its risk management. The FSA also intends to limit societies diversifying their business without a full assessment of capital adequacy. The FSA has considered applying similar CP 17 guidance to the banking sector but has decided on account of the "lack of homogeneity" that this would not be practical and in their case a firm-by-firm approach is more appropriate. The CP addresses treasury and lending. It contains five approaches to treasury management, three areas of treasury guidance and three approaches to lending. Consultation closes on 5th September 2009 with implementation due in early 2010 when a new Building Societies Sourcebook (BSOCS) will replace IPRU-BSOC.

Registration RequiredRegulation > Consultation Paper 08/24 Stress and scenario testing December 2008 28% relevant

12th April 2009

The FSA wants to see more stress and scenario testing in firms. Senior management should be involved. Previous assumptions have been too relaxed. Stress testing should be in detail with the mitigating actions rehearsed. Reverse stress testing is introduced as a method of identifying critical events. The FSA is not going to tell you how to do this, it's up to you. However firms can expect greater challenge on the assumptions made.