Rickard Warnelid

Authors

Authors

Authors

Authors

Authors

Authors

all posts

tags

Rickard Warnelid

/Rickard Warnelid

Rickard Warnelid is the Managing Director of Corality Financial Group.

He has a wealth of project finance and financial modelling experience gained from a range of positions in Australia and Sweden.

He has been engaged by prestigious institutions in public and in-house project finance modelling training in Europe, the Middle East and Australasia.

Rickard was a founder of the world leading financial modelling consultancy Navigator Project Finance prior to being a Director of Corality. He was responsible for financial model audits and financial modelling of transactions of USD +15bn in Project Finance, M&A, Corporate Finance and Private Equity in Australia, US, Asia, Europe in sectors including PPP, Mining, Oil & Gas, Real Estate, Infrastructure, Chemicals.

Rickard.warnelid@corality.com

RECENT BLOGS

14 steps to improved marketing in your financial model

August 15 2009 -

In the majority of large transactions the information pack that is circulated will include a number of written documents (Information Memorandum (IM), etc) and a financial model.

4 Free alternatives to a financial model audit

April 2 2009 -

Not all financial models need to be formally audited or reviewed by an independent party. In some situations the modeler or the company about to rely on the model simply wants to increase their confidence in the financial model. In these situations, there are several alternatives that may be more appropriate than a full formal model audit.

Are you using the Share Workbook functionality in Excel?

July 15 2009 -

I was having a coffee this afternoon with Darren Miller, the CEO of Sumwise and the author of their blog with the topic ‘our fascination with financial modeling’.

Australia’s fantastic internet infrastructure project

April 15 2009 -

I was born in Stockholm, Sweden and lived there until I moved to Australia in 2003. Coming to Australia was like travelling back in time in regards to the “internet” used in Australia. Ads on TV still compared “broadband” to dial-up, a concept I couldn’t believe anyone was still using.

Can new spreadsheet infrastructure assist financial model audits in real-time?

April 16 2009 -

Anyone who has been through a financial model audit knows that it can, if not well managed, be a stressful experience with a lot of pressure on the modeller who has built the financial model

Career booster for senior financial model auditor

April 26 2009 -

Since the launch of the brand Corality in Dec 2008 (post the spin-off from Navigator Project Finance) we have seen a big upswing on financial model audit mandates and we are now recruiting to get us ready for busy years ahead.

Cash Flow Management For Critical Decision Making

February 22 2011 -

“Cash is King!” During the CPA Congress, Liam discussed techniques in managing your cash flow and avoiding common cash flow problems.

Charles Darwin, genetics and financial modelling

September 29 2009 -

Charles Darwin’s ‘survival of the fittest’ is a concept that most people with some sort of rational background agree to. Would Darwin say that these principles are working in financial modelling?

Controlling costs in the financial model audit process

March 10 2009 -

The total cost of a financial model audit is a topic I discuss with clients on a daily basis. Based on those discussions and our work auditing financial models we have found some simple rules that outline the main drivers of model audit fees.

Corality check-lists in Excel using Webdings

August 5 2009 -

Representing a corporate graphical profile in Excel is not always easy and can sometimes take a bit of work to get right. We have recently experimented a bit with the use of different fonts to improve the presentation of some recent financial models.

Corality clients nominated in the Ernst & Young ‘Entrepreneur of the Year’

July 4 2011 -

Ernst & Young recently announced the nominees for 2011 Ernst & Young ‘Entrepreneur Of The Year’ at the Carriageworks in Sydney.

Corality Excel challenge - Congratulations Daniel Ferry!

August 10 2011 -

In a recent blog we launched an Excel Challenge to see who could best emulate the smoothness of an iPhone in Excel. And the winner is…

Corality Gallery Opening

June 30 2011 -

It was a night to remember - great food, great wine and GREAT people! Thanks everyone for making it such a good night.

Corality Gallery Opening - 16th of June, Sydney

May 30 2011 -

Come join us on the 16th of June when we celebrate our BRW 2011 Fast Starter nomination, our expansion in London and Singapore and our new office in Sydney CBD.

Debt-sculpting using VBA and Goal Seek

September 10 2009 -

In project finance transactions it is common practice to use debt sculpting when sizing the debt - i.e. finding an appropriate level of debt from the lenders point of view. In our VBA training courses I have found that one of the most appreciated methods is what we refer to as the ‘sequential goal seek’ so I would like to share this method today.

Do you love clients? Join the team.

July 28 2009 -

With the global financial crisis slowing down we are seeing a significantly increased level of activity in the transaction  space. Most notably the mining / resources sector is now again full of life. PPP / infrastructure is continuously strong and is representing the majority of work at Corality at present.

Does the world need pro bono financial modelling?

June 5 2009 -

In the legal industry it is common practice for professionals to perform work ‘pro bono’ to support certain organisations or people in need.

EuSpRIG: Corality presents SMART financial modelling in London, Greenwich

July 12 2011 -

The EuSpRIG conference is a premier spreadsheet risk management conference and the place to be if you are serious about investigating, managing and controlling the myriad risks posed by corporate spreadsheets.

Excel 2007 vs. 2010 – What's new

March 30 2011 -

Excel 2010 comes with a number of key improvements – high performance computing, increased row limits, improved statistical functions, and more powerful data analytics with PowerPivot and Slicer.

Excel and VBA password security

March 29 2009 -

The data security of Excel spreadsheets is a joke. Anyone with half a talent can crack the passwords at most levels using either simple VBA code or one of the Russian password crackers on Google.

Excel lovers celebrate like crazy - Day 40,000 is here!

July 5 2009 -

You may not have noticed just yet, but today is actually day 40,000 in Excel and it probably warrants a tiny celebration for all Excel lovers out there.

Excellence in oil and gas – Sydney 2009

March 21 2009 -

I am attending the annual Excellence in oil and gas conference in Sydney on Monday and Tuesday next week. It will be interesting to see how the oil and gas sector is holding up given the drastic change in oil prices since last year’s conference.

Financial model audit analyst - What is the ideal background?

July 20 2009 -

Over the last few weeks we have been recruiting to fill two positions as Analysts at Corality specialising in financial model audits.

Financial model review – try this at home!

March 17 2009 -

If you are not in a position to engage an independent model audit company to perform an independent financial model review then the following check-list may be helpful.

Financial modelling training on a shoestring

April 21 2009 -

It is a well-known fact among financial modelling training companies that certain sectors of financial training benefit from economic slow-downs. The main reason for this counter-intuitive fact is that people are looking to polish their CV in case they would be made redundant.

Forecasting Techniques and Financial Modelling

March 2 2011 -

During the CPA Congress, Liam discussed common forecasting methods and the challenges involved in forecasting.

Full article now published: Reducing Risk in Excel Modelling

January 7 2011 -

Reducing Risk in Excel Modelling – read Rickard Warnelid’s article on the SOA website

IF-fetishism and named-range-bonanza

March 10 2009 -

There are different schools of thought when it comes to saying when a formula is too long. I personally like the ‘the shorter the better’ way of thinking. Ideally, in my view, all formulas should be shorter than half the formula bar in Excel.

Key Driver Analysis Modelling

February 28 2011 -

Dr Liam Bastick, Director of Corality (Melbourne) was invited to deliver a series of presentations and workshops at the CPA Congress. “Key Driver Analysis Modelling” was one of the topics.

Leighton and CBA win Queensland school PPP Project

April 20 2009 -

A consortium led by Leighton contractors has been awarded the AUD 1.1 billion contract for design, build and maintenance for seven schools on Queensland, Australia.

London – New financial model audit specialist in town!

March 4 2011 -

Corality is expanding with a permanent office in the City of London – please come by and say Hello next time you are in town!

Make Excel history and win a free financial modelling course!

June 22 2011 -

Help us master the challenges of rendering moving objects smoothly in Excel.

Modelling Risk, Return and Ranking

February 17 2011 -

The CPA Congress is a premium global event for strategic business leaders. Dr Liam Bastick, Director of Corality (Melbourne) was invited to deliver a series of presentations and workshops during the course of the event.

My top 3 ‘Cityboy’ moments

May 6 2009 -

Long overdue, I finished reading Geraint Anderson’s ‘Cityboy’ today. It was recommended to me by Ken Ghata at Terrapinn over a Sydney lunch a couple of months ago when we were discussing the financial markets and the industry’s general behaviour in times of financial crisis. Thank’s Ken, it was well worth a read!

New Member of the Corality Team

July 8 2010 - Liam Bastick has joined Corality as a Director, heading up the Melbourne office. He brings a wealth of knowledge and experience, with over two decades experience in modelling and corporate finance.

New Royal Adelaide Hospital PPP Project

December 14 2010 -

The South Australia Government announced the selection of the SA Health Partnership on Saturday, 11 December. The New Royal Adelaide Hospital (RAH) will be delivered as a Public Private Partnership (PPP) under the South Australian Government’s Partnership SA model.

OFFSET function and tracing formulae

March 23 2009 -

The OFFSET function in Excel can be a great servant but a terrible master if you do not know how to properly harness its potential. When using OFFSET it is important to keep a few things in mind.

Operis Analysis Kit (OAK 4.00) – time to upgrade?

April 13 2009 -

Operis, the developer of the spreadsheet review software OAK (Operis Analysit Toolkit) recently announced a new version OAK 4.00.

Public training courses for financial model auditors?

May 8 2009 -

When I have been presenting courses in the past for Terrapinn (project finance modelling) and Navigator Project Finance (financial modelling)  is has not been uncommon to have 1-2 model auditors from ‘the competition’ participating.

Recruiting two financial modelling analysts in Sydney

June 9 2009 -

We have now had an accepted offer for the role of Associate - Financial Model Audit and are now looking to further expand the team by taking on two financial modelling analysts.

Rock Financial Modelling – Emma McPherson goes independent

April 2 2009 -

The current financial crisis has resulted in many investment bankers stepping our of the protected world of a global investment bank to set up a boutique companies providing services to their existing network of bank and sponsors.

Scenario analysis for freaks - 13 silly options

May 13 2009 -

There are lots of different ways of building a solid scenario manager for efficient scenario analysis, and some are better than others.

Seasons Greetings

December 17 2010 -

A big thank you to all our clients.

SMART, Navigator’s best practise modelling methodology is here!

May 19 2011 -

It’s imperative for companies to adopt a well defined modelling methodology. This practice reduces model risk and increases user confidence and modelling productivity.

Sorry, but your financial model looks like Berlin (before 1989)!

April 29 2009 -

Following an initial review of a client’s financial model our team often has a conversation on the topic “what do you think of the model?”

Spreadsheet skills: Being Sensitive with data tables

May 11 2011 -

Liam Bastick wrote an article for CIMA to illustrate how to effectively use 1-D and 2-D Data Tables to conduct sensitivity analysis for NPV.

Stand-alone financial modelling can destroy your company

November 9 2009 -

Financial models are used for a number of reasons depending on the situation. All too often I see financial models being developed on the implicit assumption that they are to be used to analyse a project or transaction on a stand alone basis.

Summer Drinks in Sydney - You're Invited!

October 29 2010 -

We have the pleasure of inviting you to join the Corality team at the Chophouse on Bligh Street in Sydney to celebrate the return of Summer and Corality’s Monthly Drinks Function!

Sumwise – will it start a spreadsheet revolution?

August 24 2011 -

Sumwise is a web-based spreadsheet for financial modelling.

Terrapinn Corporate Finance World, Sydney – Project finance modelling

November 12 2009 -

On Sunday night I was contacted for a last minute change of schedule of the pre-conference financial modelling workshop of Terrapinn Corporate Finance World at the Marriott in Sydney. The organised presenter, Nick Crawley, MD of Navigator had cancelled due to health issues following his trip last week to Nigeria.

The time zone advantage in financial model audit iterations

December 1 2009 -

We audit your Excel PPP/PFI/Project Finance financial model while you are sleeping – The time zone advantage in using an Australian model audit company for European project finance/PPP/PFI projects.

Top 10 tips to reduce errors in excel modelling

December 13 2010 -

In my article, soon to be published in the Society of Actuaries newsletter, I share my top 10 tips to reduce errors in excel modelling.

VBA and Conditional Formatting in Excel

March 25 2009 -

The majority of the time at Corality we audit financial models or develop user friendly financial models for our clients. However, in a field that develops as quickly as financial modelling we need to make sure that we stay ahead of the competition - even in the long term.

We’re recruiting!

August 5 2010 -

Corality is currently looking for an experienced Associate and financial modelling Analyst.

Be part of building the business and shape your own role and share your passion for financial modelling with like-minded people!

What is an ‘iteration’ in a financial model audit?

March 10 2009 -

A typical financial model audit involves 3-4 iterations before an opinion letter is issued. There is no strict definition of what an ‘iteration’ actually is and it is worth exploring this concept a bit more.

What is the ideal background of a financial model audit analyst?

July 14 2009 -

Over the last few weeks we have been recruiting to fill two positions as Analysts at Corality specialising in financial model audits.

What level of input Data Validation is needed in Excel?

July 8 2009 -

The built in functionality for Data Validation in Excel is quite useful in my view and a lot of people would benefit from improving their knowledge in this area.

www.fimodo.com – New financial modelling website

September 15 2009 -

I have been active on a number of financial modelling websites over the years. So far I haven’t found anything that gives me what I am looking for so with the team at Corality I decided to do something about it.

You have an ugly baby!

August 17 2009 -

In the same way you wouldn’t tell a mother that her new born baby is not as cute as she would like to think, it can sometimes be challenging to communicate the quality of a financial model to the author.

‘Financial Modelling Expertise’ – Digit Advisory in Sydney

August 11 2009 -

On Tuesday this week I had the pleasure of having a very pleasant chat with John Stroud from Digit Advisory. Digit Advisory is a partnership of two principals who are both ex Babcock and Brown.

‘Zoom to selection’ with VBA to improve presentation of Excel financial models

June 1 2009 -

It is not always easy to ensure that a financial model presents well on all screen types and resolution settings. I notice frequently while working on spreadsheets on four different platforms...

“I built the worst financial model in the world!”

July 22 2009 -

There are numerous awards in the financial industry for strong performance and market leading developments and they are followed with a great deal of interest.

“Input cell reference is not valid” – how to create a Data Table in ANY sheet

May 29 2009 -

Working with Data Tables in Excel is essential knowledge to anyone active in financial modelling using Excel. Using Data Tables one can achieve amazingly powerful scenario analysis with consistent and graphically appealing outputs.

London

+44 20 3402 6034
133 Houndsditch
London EC3A 7BX, United Kingdom

Melbourne

+61 3 8610 6301
Level 3,480 Collins Street
Melbourne, Australia

Sydney

+61 2 9222 9222
Level 8, 200 George Street
Sydney 2000, Australia

Singapore

+65 6440 8803
One Raffles Quay, North Tower, Level 25, Raffles Place, Singapore 048583

Thank you for your interest in Corality. Please complete the form below and we will respond to your enquiry, or direct you to the appropriate area within our business.

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.

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

Testimonials

Dorado Ocean Resources

"Our experience with Corality was extremely impressive. They exceeded our expectations, I am simply amazed at the model's functionality and the range of information on their website. I am grateful for their dedicated team taking care of our assignment in an efficient and professional manner. We look forward to a robust long-term relationship."

Patrick E. Donohue, Chief Financial Office

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