Full article now published: Reducing Risk in Excel Modelling

Blog

Blog

Blog

Blog

all posts

tags

Full article now published: Reducing Risk in Excel Modelling

by Rickard Warnelid on January 7 2011

The full article ‘Reducing Risk in Excel Modelling’ has now been published in the global Society of Actuaries (SOA) newsletter.

In this article I share the top 10 tips for how to reduce errors in excel modelling. Amongst other tips, it illustrates the importance of being transparent with key calculations and assumptions, when to use high-end models to verify more detailed models, how consistency makes it easier for the end user to understand and review a model and how to be flexible to allow assumptions to change. It also discusses how to asses team capability in order to decrease modelling risks by consulting professional service providers and implementing best-practice modelling standards.

Click here to read the full article on the SOA website.

Corality is a supporter of the Society of Actuaries and follow their commitment to education and research on actuarial trends, public policy issues and further expansion of the actuarial profession. The SOA vision is for actuaries to be a leading profession in the measurement and management of risk.

COMMENTS

Post new comment

The content of this field is kept private and will not be shown publicly.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

Need a financial model audit?

Need a financial model audit?

Do you want to find our more about our financial model audit services??

Read more about Corality

Upcoming Courses

Best Practice Project Finance Modelling
Sydney
30 May - 31 May 2012
Best Practice Project Finance Modelling
London
11 June - 12 June 2012
Advanced Project Finance Modelling
London
13 June - 14 June 2012

Bloggers

Laura Dean

Laura Dean

Laura is our creative and motivated Marketing Coordinator.

Rickard Warnelid

Rickard Warnelid

Rickard Warnelid is the Managing Director of Corality Financial Group.

Peter Weatherston

Peter Weatherston

Peter is a UK qualified accountant with 10+ years experience in financial modelling and financial model auditing.

Bing Chien Quek

Bing Chien Quek

Bing is Corality's in-house VBA expert. He has worked on numerous projects as well as facilitated VBA training courses internationally.

Caroline Wiroth

Caroline Wiroth

Caroline is Corality’s Marketing Manager. She has over 8 years of experience in sales, marketing and Public Relations.

Tim Heng

Tim Heng

Tim has a wide range of experience in analytics and modelling across a number of different industry sectors (corporate banking, vehicle finance, credit risk and marketing analytics).

Blake McNaughton

Blake McNaughton

Blake McNaughton is an Associate based in Corality’s Head Office in Sydney, Australia.

Haydn Palliser

Haydn Palliser

Haydn is an Associate at Corality with a wealth of experience in structured finance, consulting and is a chartered professional engineer.

Cathryn Fish

Cathryn Fish

Cathryn is our energetic and super organised Training Experience Manager.

Nick Crawley

Nick Crawley

Nick Crawley is the Chairman and Head of Consulting of Corality Financial Group.

Grace Utama

Grace Utama

Grace Utama is a financial modelling expert, with particular expertise in advanced Excel techniques and VBA Macros.

Have a question or comment? We would love to hear from you. More contact options

We respect your email privacy.

Sitemap | Terms | Privacy © Copyright 2012 Corality Financial Group