About us
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
About Corality
all posts
-
Conferences
- Terrapinn Corporate Finance World, Sydney – Project finance modelling
- Excellence in oil and gas – Sydney 2009
- Corality’s Liam Bastick discusses presenting at the CPA Management Conference and CPA Congress around Australia
- Summer Drinks in Sydney - You're Invited!
- CPA Australia Congress, Dr. Liam Bastick
- Modelling Risk, Return and Ranking
- Cash Flow Management For Critical Decision Making
- Key Driver Analysis Modelling
- Forecasting Techniques and Financial Modelling
- The ICAA Accounting Conference 2011
- The Newcastle Convention 2011
- National Infrastructure Awards 2011 - The Oscars of Infrastructure
- EuSpRIG: Corality presents SMART financial modelling in London, Greenwich
- Corality presents seminar on Business Analytics and Decision Analysis for the Institute of Chartered Accountants
- CPA Sydney Congress
- Financial modelling for gold projects and flying sharks at The Gold Symposium
- Strong speaker line up at The Gold Symposium, Sydney
- Corality continues its seminars on best practice standards in financial modelling for CPA Australia
- The CFO Crystal Ball: Powerful Financial Modelling for Strategic Planning
-
Corporate News
- Corality is a BRW 2011 Fast Starter
- SMART, Navigator’s best practise modelling methodology is here!
- Corality Gallery Opening - 16th of June, Sydney
- Corality hosts seminar at the London Business School
- Corality Gallery Opening
- Corality clients nominated in the Ernst & Young ‘Entrepreneur of the Year’
- Strategic merger - Corality and Navigator form the Corality Financial Group
- Excel workshops and live model builds with Corality at the CPA Expo
- Mines and Money Conference and Exhibition
- Peter Weatherston: Head of Consulting, financial modelling expert and whisky connoisseur
- Corality Financial Group - the start of a new era
- Banks approve US$138 million for the Wetar copper project
- Corality wins high profile Desertec equity model build job
- Rickard Warnelid – Top 40 business leader under 40
- Corality writes article series about financial modelling for CIMA
- Solar flair – Corality in the press
- Corality sponsors Macquarie University with award for academic excellence
- Investing in iron ore projects – Corality in the press
- Corality’s new MD, Rickard Warnelid
- Corality celebrates rapid growth nomination - BRW 2012 Fast Starter
- Corality attends The Resources and Energy Symposium, Broken Hill
-
Excel
- Corality check-lists in Excel using Webdings
- Are you using the Share Workbook functionality in Excel?
- What level of input Data Validation is needed in Excel?
- Excel lovers celebrate like crazy - Day 40,000 is here!
- ‘Zoom to selection’ with VBA to improve presentation of Excel financial models
- “Input cell reference is not valid” – how to create a Data Table in ANY sheet
- Scenario analysis for freaks - 13 silly options
- Excel and VBA password security
- VBA and Conditional Formatting in Excel
- OFFSET function and tracing formulae
- Financial model review – try this at home!
- IF-fetishism and named-range-bonanza
- Excel forecasting methods and how to assess forecast accuracy
- Full article now published: Reducing Risk in Excel Modelling
- CPA - Excel Secrets and Shortcuts
- Excel 2007 vs. 2010 – What's new
- Spreadsheet skills: hiding formulae
- Worst practice financial modelling
- Spreadsheet skills: Being Sensitive with data tables
- Excel shortcuts – get your Excel shortcuts cheat sheet
- Make Excel history and win a free financial modelling course!
- Corality Excel challenge - Congratulations Daniel Ferry!
- Spreadsheet Errors – Research by Professor Panko
- Sumwise – will it start a spreadsheet revolution?
- Should we use SUMPRODUCT?
- Desktop sharing – Using Skype to get Excel help from your friends
- So what can you do with an Excel spreadsheet
- Your guide to Excel Mapping Software
- Edward Tufte: Information Design and Data Visualisation
- Best practice financial modelling - Dilbert you should try it!
- Three simple ways to improve communication in your financial model
-
Financial model audit
- What is ‘Usual Practice’ for Calculating Project NPV?
- The time zone advantage in financial model audit iterations
- Do you love clients? Join the team.
- Sorry, but your financial model looks like Berlin (before 1989)!
- Can new spreadsheet infrastructure assist financial model audits in real-time?
- 4 Free alternatives to a financial model audit
- What is an ‘iteration’ in a financial model audit?
- Controlling costs in the financial model audit process
- Top 10 tips to reduce errors in excel modelling
- Seasons Greetings
-
Financial modelling industry
- Stand-alone financial modelling can destroy your company
- Charles Darwin, genetics and financial modelling
- www.fimodo.com – New financial modelling website
- 14 steps to improved marketing in your financial model
- You have an ugly baby!
- ‘Financial Modelling Expertise’ – Digit Advisory in Sydney
- “I built the worst financial model in the world!”
- Financial model audit analyst - What is the ideal background?
- What is the ideal background of a financial model audit analyst?
- Recruiting two financial modelling analysts in Sydney
- Does the world need pro bono financial modelling?
- My top 3 ‘Cityboy’ moments
- Career booster for senior financial model auditor
- Leighton and CBA win Queensland school PPP Project
- Australia’s fantastic internet infrastructure project
- Operis Analysis Kit (OAK 4.00) – time to upgrade?
- Rock Financial Modelling – Emma McPherson goes independent
- New Member of the Corality Team
- We’re recruiting!
- New Royal Adelaide Hospital PPP Project
- London – New financial model audit specialist in town!
- LinkedIn Group – Financial Modelling in Excel
- Pitfalls of utilising Cloud computing for spreadsheet modelling
- Debt Service Cover Ratio (DSCR) sculpting in Project Finance Modelling - the easy way!
- Regulatory change makes financial planning sector ripe for M&A
-
Training
- Debt-sculpting using VBA and Goal Seek
- Public training courses for financial model auditors?
- Financial modelling training on a shoestring
- Corality Financial Group hosts seminar at the Frankfurt School of Finance & Management
- Business Case Modelling Sydney - 6 & 7 December 2011
- Financial Modelling for Mining Projects training
- Corality training - lunchtime training sessions for PKF Australia
tags
all tutorials
-
Excel - Advanced
- Calculate NPV without Excel formulae
- LOOKUP instead of VLOOKUP and HLOOKUP
- Custom formats in Excel
- Data Validation in Excel
- Goal Seek function in Excel
- Range names in Excel
- Excel Data Tables in any sheet
- An iterative approach to calculating the Internal Rate of Return (IRR)
- How to use SUMPRODUCT
- Custom number formats - Formatting decimals
- Cashflow Available for Debt Service (CFADS)
- Benefits of using Excel shortcuts: get your shortcut sheet
- Cash Sweep Analysis in Project Finance
- Circular Interest – Interest on average balances
- Project Life Cover Ratio
-
Excel - Basic
- Array formulas in Excel
- ICAA Conference: Get Corality’s presentation and excel files
- Excel 2007 Styles Shortcut Tool
- Using trend lines to analyse patterns in historical data
- Excel offset function increases modelling risk
- Custom number formats - Formatting text
- Debt Sculpting to Target DSCR without VBA
- Calculate IRR in Excel
- Debt Service Reserve Account
- Organisational benefits of implementing best practice financial modelling
- Visual Basic for Applications (VBA)
About us
Corality is a full service analytical consulting firm specialising in financial modelling, advisory, model audits and training. We challenge traditional accounting and management consulting firms through our specialised and client-focused approach to analytical consulting.
Corality assists clients with everything from the initial review of current processes and financial models to the development of tailored analytical tools required for effective decision making. We offer analytical consulting and training courses in a large number of areas including investments, corporate finance, project finance, private equity, risk, strategy, operations, commercial and accounting.
Corality is part of the Corality Financial Group
Corality is part of the Corality Financial Group which also includes Navigator Project Finance. Corality Financial Group offers the industry’s most complete set of analytical consulting, training and advisory services.
International presence – we have offices in London, Melbourne, Singapore and Sydney
Corality works with organisations of all sizes, globally. The majority of Corality’s clients are based in Europe, the United States, Asia, the Middle East and Australia. We extend our global reach through our international presence and sophisticated technology. We work with you on your terms, wherever you are, independent of time zones and geographic locations.
Our client base spans a wide range of industries; from banking and finance, to construction and development through to retail and corporate clients. We understand the requirements of multi-billion dollar companies as well as the requirements of small and medium size firms, and we tailor our services to suit each client and project.
Full service analytical consulting – we deliver tailored and user-friendly solutions
Corality believes in a consultative approach to project management and problem solving. We work with analytical challenges at all levels, from rostering tools for staff to financial structuring of multi-billion dollar hospital investments. We utilise our expertise and knowledge about industry developments as well as our network of industry experts to take a big picture approach to each project. We work with each client to develop tailored and user-friendly analytical tools and Excel spreadsheet solutions to ensure our clients can make the right decisions every day.
“Our commitment to the highest possible level of client service is rewarded with an ever-increasing flow of repeat business from our long term clients and their contacts.” Nick Crawley, Managing Director
Multicultural workplace – we welcome diversity
Corality welcomes diversity and prides itself on being a multicultural workplace. Corality’s employees originate from Sweden, England, Cyprus, New Zealand, Scotland, China, South Africa, Malaysia, Australia, Serbia and Indonesia. We use this diversity to drive our competitive edge.
Consulting services – more about our consulting and advisory capabilities and the areas we work in
Financial modelling services – overview of our best practice financial modelling services and our modelling methodology SMART
Model auditing services – find out more about our model audits services including formal financial model audits, independent model reviews, analytical model review, tax and accounting review
Training services – find out why we are your one-stop-shop for financial modelling, project finance and general Excel training
Best practice modelling methodology – SMART
Corality is a strong advocate of best practice modelling. Our best practice financial modelling methodology, SMART, meets the needs of decision-makers and financiers across all major project finance industries. It decreases model risk and results in robust, transparent and user-friendly models suitable for analysis by all stakeholders.
More about the SMART modelling methodology.




