Jatoil Limited - Renewable Energy in Vietnam
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
Client Industries
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
- Corality is building its global presence with an office in Perth
-
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!
- “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)
Jatoil Limited - Renewable Energy in Vietnam
"As a result of Corality’s work, we have more confidence in presenting our models and analysis to sophisticated players in any forum."
Jatoil Limited's mission is to be a socially, environmentally and economically sustainable producer of renewable energy. Jatoil’s business is based, initially, on establishing projects in Asia to grow jatropha curcas, a small, hardy, long-lived tree. The fruit of the tree contains oil seeds which are suitable for commercial biofuel production.
Advantages of Jathropa as a biofuel feedstock
Most of the world's biofuel feedstocks compete with resources that could also be used for food production. Jatropha is a second generation feedstock that can be grown economically on land with poor soils, making it suitable for cultivation on marginal land. Jatropha can represent a valuable income source in developing countries, helping to increase energy security and improving the living standards of rural communities.
Jatoil's commitment to social and environmental sustainability is supported by its partnerships with local established companies to leverage networks and knowledge and by its relationships with farmer co-operatives. Jatoil also has forged partnerships with a number of experts to ensure the application of leading industry practices, and with non-government / aid organisations to ensure probity in the Jatoil operations. The project in Vietnam is an excellent example of this collaboration.
“Corality’s work made our access to capital that much easier. The more robust your models are the less time you spend explaining and the quicker you get to a decision.”
Paul Hogan, General Manager, Jatoil
Sophisticated markets need sophisticated financial models
Jatoil plays in the international arena. As such, any financial modelling must be robust and comprehensively answer the questions of a variety of users with a multitude of disciplines. There is no room for ’financial typos’, as Paul Hogan, General Manager, Jatoil explains. “Sophisticated investors and financially literate merchant bankers place a lot of stock in the accuracy of your numbers.
If they find silly mistakes, your entire presentation becomes suspect.” Jatoil turned to Corality. “They supplied an independent, third eye to our models. Their ability, as specialists, to come in and understand exactly what was required was ideal for us as an end user.”
Why a third party for financial model audit?
Many would suggest it’s almost impossible to audit your own models. Paul agrees, “You get too close, you tend not to question your own assumptions to the detriment of your end result.” Having a third party specialist financial modelling company like Corality “helps you question your inputs, strengthen and expand your assumptions and enable your output to become clearer and more succinct,” says Paul.
He goes on to say, “Our thinking was tested every step of the way. The depth that Corality had to go to in order to understand our original model forced us to re-engage with our assumptions and evaluate new ones.”
Flexibility to meet our needs
Jatoil had very specific needs. As Paul explains, “Our business cuts across international boundaries, through various funding, taxation and legal regimes. We needed a company who could understand our own model and then suggest relevant, feasible alterations.
They (Corality) took our reasonably well developed model and checked our mechanics and suggested best-practice improvements. Corality made sure it linked to the business case and by doing that ensured evaluators got out of it what they needed to.”
Savings in time and money
Raising money in the current international environment is no easy task. Models are challenged in a far more vigorous way than ever before - to the betterment of all. Paul Hogan feels that, “Corality’s work made our access to capital that much easier.
The more robust your models are the less time you spend explaining and the quicker you get to a decision.” The truth of it is if your models contain errors you may not get a second opportunity to present your case. Getting it right first time round saves time and money. In many cases, the Corality work can even improve the underlying business models.
Financial modelling specialists provide broad service
The beauty of having specialists review your own models and recommend improvements is that they’re not locked into your own assumptions. As Paul Hogan suggests “a specialist, such as Corality is hooked into the mechanics of modelling. They understand where the traps are and understand implicitly what the prospective audience of merchant bankers and other professionals are looking for.”
“This just saves you time and money; you don’t have to go back with ‘revised figures’, you’re immediately impressive.“
Working with Corality
Preparing robust financial models is a matter of trust, delivered out of respectful, helpful relationships. Corality believes the time spent in getting to know a business will repay itself in the quality of its work and a long-term mutually rewarding relationship. Paul Hogan agrees, “They’ve engaged with our business on a smaller level and seem happy to grow with us in the longer term.” He continues, “And it makes sense for us to go back to them.
“As a listed company we have a responsibility to present robust, ‘typo free’ financial models. Corality’s independent and professional model review delivers peace of mind.”
Paul Hogan, General Manager, Jatoil
They know our business intimately and we’ll spend less time briefing them in the future.“ Paul highlighted some specific factors in working with Corality. “They’re quite happy to share their methodology and the staff are very instructive. Overall it’s been a good experience for us.”
The Corality financial model audit process
Corality’s understanding of the material and commercial issues that clients must contend with have lead them to a rigorous set of procedures that result in models clients can rely on in the most sophisticated of environments.
“They invariably find the weak spots,” says Paul. “And importantly, Corality understands that a good model is one that connects to the business case. Their suggestions helped maintain that focus.”
Would you recommend Corality?
Paul Hogan has the last word. “Yes, we would. They were originally recommended by our Company Secretary and they’re certainly up there with first tier providers and potentially more cost effective.”
Upcoming Courses
Testimonials
"We engaged Corality to help us build a business case regarding our project to manufacture solar cells in Australia. Corality spent time to consider our business, and understand the financial drivers and items of variation in our business. They provided us a with a robust model with excellent analysis and scenario capabilities, which exceeded our expectations, presenting a transparent and comprehensive view of our entire business case."
Nickolas Fejer, Project Manager
