Across Model build, Model audit, wider transaction support and training in financial subjects, we help clients globally, by ”uncomplicating” the numbers.
For confidentiality reasons we can’t display all clients, however following are some examples of how we have helped clients:
All model types/ All Industries
Adani - 2016-2018:
Emma McPherson was engaged to assist in the Project financing of the Carmichael Mine & Rail Project- the largest thermal coal mine in Australia, including construction of a 388km rail line to Adani’s Abbott Point coal terminal – providing infrastructure to open the coal resources of the Galilee Basin. Her role was more than modelling : in addition to creating a financial model which aggregated > $2bn of capex and opex across 3 separate assets (Mine, Rail and Below rail) she was responsible for creating presentations for management and investors, review of due diligence and contracts, review of all BFS chapters for both mine and rail, and working with global Investors/ assisting their due diligence, on a regular basis. It was exciting to be part of a project that will provide thousands of jobs to Queenslanders as well as opening up a new resource basin in Australia, and providing cleaner coal to 300million Indians.
JLL: - 2015:
One of Italy’s premier commercial real estate firms JLL Italia, engaged RFM to audit and improve their financial model/ valuation tool that they use when approached to provide independent valuations. JLL is one of the premier firms providing valuation of multi-million Euro buildings, for potential investors such as Insurance companies and Pension Funds. The engagement required a detailed understanding of the Italian real estate sector and Italian fiscal / tax codes.
BHP Billiton: - 2014-2015:
BHP Billiton’s coal division, BMA, engaged RFM over 8 months in the Valuations area to execute a range of tasks from model audit to mine optimisation to sensitivity analysis. RFM has been consulting to other ASX listed coal miners since 2011, thus has coal- technical knowledge- essential to “hit the ground running” and assist our coal clients.
Guildford Coal: - 2013-2014:
Guildford Coal engaged RFM over an 8 month period to audit existing valuation models covering their Mongolian and Australian coal projects, as well as creating new company wide valuation Models. RFM was sent to Mongolia to undertake modelling on potential acquisition targets, as well as assisting the client in non quantitative areas: legal documentation and presentations for potential M&A transactions.
Julius Bär, Schweizer Privatbank - July 2014: Zurich, Switzerland
Rock Financial Modelling delivered 2 days advanced Excel training to a Julius Bär staffmember, one of Switzerlands leading private banks, and in such time took her from beginner to Advanced in Excel. The course was tailored to her requirements, focusing on managing, sorting and presenting large amounts of statistics, as well as automating from Excel into Powerpoint.
Glencore AG - July 2014: Baar, Switzerland
Rock Financial Modelling delivered 5 days intensive training to Glencore staff in advanced Financial Modelling, Investment Banking & Private Equity, and Mining Valuation. The course was tailored to the clients requirement in terms of both content and level of Modelling complexity.
Private Tuition - 2014: Zurich, Switzerland
RFM gave advanced Excel training to a Credit Suisse staffmember, from the marketing function, who wanted to learn advanced pivot tables and complex formulae. She started the course as a beginner, and after one day left as Advanced, knowing advanced techniques such as how to apply conditional formatting to data tables. She responded it was the best training she’d ever attended, she found the exercises we had devised as interesting , bordering on “fun”! , and in one day had learnt more than 10 years of Excel training.
Hult Business School - 2014: Lucerne, Switzerland
RFM gave training in financial modelling to staffmembers at Hult International Business School, in Lucerne, one of the leading global business schools (Financial Times 100 Top Business Schools 2014). Showing our flexible approach, in this training we didn’t teach any of our standard material, but rather received files from the client before the course with specific questions they had. They wanted to learn better ways to work with such large files ( >6000 data entries), and also error-shooting and file clean-up methods, when importing from Sales Force and CSV formats. The client’s feedback was that the course was very good, and they were very happy with the trainer, in particular saying he was very helpful in showing tools on how to clean up data, compare files, pivot tables etc. We have multilingual trainers across Europe- contact us today to see how we can help solve your work specific needs.
Private Tuition - 2013:
RFM gave 7 days private tuition to a young Chinese law graduate (Cambridge, UK) who was moving into mining/corporate finance and needed intensive training for job interviews. We had many discussions prior to the classes, and were able to tailor material specifically for him. He gave the course a 10/10 with the following comments ”Excellent materials that were thoroughly prepared and tailored to my individual requirements. Intense classes but managed to successfully cover a wide range of topics, from metals & mining to leveraged buyout and M&A merger models. The trainer was very responsive to questions and also provided impeccable answers. She was also very receptive to suggestions on changing content during the course and had other exercises in reserve to meet new content requests. This proved to be extremely crucial, as I had new interviews scheduled at the last minute that we hadn’t discussed, but she was able to adapt to my request”.
Contact us if you are serious about progressing your career.. or just want to complete your Excel work faster!
Barrick Gold Corporation - 2013: Cairns
RFM gave 4 days intensive financial modelling training to financial staff from Barrick Gold, PNG and Zambia.We were able to illustrate how many complex formulae can be easily constructed-as well as many timesaving tips and short-cuts The best feedback we can get is when students tell us they were able to go back to the office on Monday and implement everything they’d learnt – and create more efficient/cleaner financial models, that produce results quicker- and generally make their job easier- and this is what these attendees told us.
Gesam S.p.A. - 2013: Lucca, Italia
RFM gave private tuition in financial modelling to staff at Gesam S.p.A, one of Italy’s gas distribution companies. We received a brief of what the client needed to learn, including specific models he had to construct for his business line, and over two days of intensive classes we were able to teach such. The client’s feedback was that the course was even better than he expected it to be. The course was conducted in Italian by our financial modelling specialist in Italia, Marco Rossi, and all teaching materials (including 50 pages of Excel tutorials and examples) were all in Italian.We have multilingual trainers across Europe- contact us today to see how we can help “upskill” your staff- and dramatically improve their productivity in the office.
Siemens - Febuary 2013: Nuremberg
RFM consulted to Siemens AG in Nuremberg, Germany re construction of a new global, standard template financial model for one of their divisions, and also gave training to the team in Advanced Excel and Financial Modelling. The team were happy with the training and over 3 days learnt many new Excel functions, tips and short-cuts, and in general, faster ways to complete their Excel work.
Aquila Resources - May 2011 - July 2012:
Services performed: Audited, amended and updated existing financial models (across Aquila’s various Bowen Basin coal mines).
Purpose of Model/s: Equity Valuation
Details: Valuation of coal mines owned by Aquila Resources in Bowen Basin, Queensland: Washpool, Isaac Plains, Eagle Downs and various undeveloped EPC’s
Specific tasks: Audit and rebuild of original models, liaising with staff (from mine managers to geologists, chemical engineer, coal marketers) to update models and determine valuation. This required an understanding of the complete mining cycle (in order to interrogate the inputs) i.e. extraction, production, blending and processing, logistics (port and rail) , price re the various coal products (HCC, SHCC, SSCC, PVCI), their properties (ash content, volatile matter, crucible swelling index).
Aquila Resources - December 2011- February 2012:
Created a new project finance model for one of Aquila’s coal mines in Bowen Basin, Queensland, Australia.
Purpose of Model/s:
Calculating all the items mentioned above re coal mining, to arrive at the correct project cash flows, and then
Overlaying that with calculations for typical project finance ratios and outputs, i.e., CFADS, ICR, DCSR, PLCR, LLCR, payback analysis, cash-sweep analysis. Different potential debt products were also analysed ranging from DCM to ECM.
Kaplan Professional - 2009: Sydney
The founder of RFM, Emma McPherson was appointed to the panel for Kaplan’s subject Mining Valuation: Emma wrote and marked the exam, where students had to create a financial model based on the Annual Report of Avoca Resources (subsequently purchased by Anatolia Minerals).
Resource Generation - 2009: Botswana
RFM audited, amended and updated the existing financial model, and added valuation and project finance pages, re coal mines owned by Resource Generation, in Botswana, South Africa.
Serco - April - June 2009: Sydney
RFM created a new financial model for a bid to provide health services.
Euromoney plc/ Shinhan Bank Korea - September 2009: Hong Kong
Euromoney Training plc sub-contracted RFM to give 4 days training to 20 bankers from Korean bank, Shinhan, in the subject: “Financial Modelling for Mergers & Acquisitions”. The attendees gave an overall rating of 90% for the trainer and all responded that they would recommend the course to others.
Serco/Laing O'Rourke/Bombardier Transportation - October 2009 - March 2010: Sydney
RFM created a new financial model for Serco’s Bid for the operations contract of the proposed Sydney Metro underground rail system.
Serco - March 2010 - May 2011: Perth
RFM created a new financial model for Serco’s winning bid for the 20 year operations contract of the new Fiona Stanley Hospital, Perth, Australia.
Aquila Resources - May 2011 - July 2012: Brisbane
RFM audited, amended and updated existing financial models (across Aquila’s various Bowen Basin coal mines)
Evolution Mining - December 2011 - April 2012:
- Audited, amended and updated five existing financial models (across Evolutions five gold mines)
- Created a new company-level valuation model.
Aquilla Resources - January 2012: Queensland
RFM created a new project finance model for one of Aquila’s coal mines in Bowen Basin, Queensland, Australia.
Rock Financial Modelling - Italia - 28 August 2012: Milano
On 28 August we held the launch function for our first European office (in Milano, Italia) for Rock Financial Modelling. The party was held at the Milano Park Hyatt, and thankyou to all who came. We had attendees from the Italian Banking, Private Equity, Real Estate and Industry sectors thus it was an excellent evening of networking, and discussions re optimal financial modelling and how to value assets in the recessionary European environment.
Our office is at :
Piazza IV Novembre 7, 20124 Milano, ITALIA,
Phone +39 2 8734 3175
Associazione Italia - Australia - October 2012: Roma
The Founder of RFM has been appointed President, Consultative Council for Australian Business. Se sei un Italiano che vuole fare affari in Australia-possiamo aiutare, chiama noi in Italia on: +39 348 534 3475
UCL Resources Limited - December 2012: Namibia
RFM audited and added project finance calculations to UCL’s financial model re thir marine phosphate mine in Namibia.
Suncorp - December 2012:
RFM delivered Financial Modelling Training to Suncorp, with client feedback being a 10/10 for both the content and the trainer.
Laerdal - December 2012: Norway
RFM provided in-house group training to Norwegian company, Laerdal (a leading medical supply co.) in December 2012. Our client told us what their staff needed to learn and we tailored our courses accordingly. “Our Excel and Financial Modelling courses teach skills that can be used across all industries”.