Model build, Beverage start-up
The client required a financial model to support fundraising efforts.
Though the client had excellent financial and commercial acumen, a model was required to present the financial information in a suitable format for funding purposes.
We conducted a workshop to understand the products and business processes. Armed with in-depth information, we then designed and built a business planning financial model in Microsoft Excel that included a five-year forecast: presenting the data on a monthly and annual basis.
The model consisted of Integrated Financial Statements with a built-in dashboard presenting KPIs and an overview of the investors’ return on equity.
The model also included direct and indirect cash flows to assist in optimal working capital management. The model was built according to best practice – instilling confidence in the investors’ decision-making.
The client was able to present financial data in an acceptable format for investors to assess – presenting the model with confidence, outlining the relevant outputs, and highlighting their return on investment.
The model is now used as an operating model with easily updateable inputs and assumptions that the client finds beneficial and user-friendly. The client returns regularly to us to develop the model in line with business expansion.
Other case studies
Get in touch with us
"When PPS began working with us, it was following on from the failed attempts of several other organisations. As soon as George came on board it was clear he understood our complex business structure and immediately assisted us with required modelling of a major transaction, as well as creating a modelling centre of excellence to help guide our team in the future.
Further to that, he redesigned our modelling suite, simplifying models without losing functionality, pruning unnecessary modules in a structured way so that the models were all fully operational throughout the transformation. His incredible and vast technical knowledge is matched with a very measured, pragmatic, can-do and professional approach which made him a value adding and exceptional partner for me and the Team."Cristina ArangoHead of Financial Planning and StrategyArqiva
"George joined us as a visiting lecturer for the 2020-21 academic year to teach our final year students financial appraisal modelling. George is a highly experienced educator and industry professional in this area and was able to successfully adapt his teaching to undergraduate students.
He is very supportive, engaging and is able to explain concepts in different ways to help all the students understand. This was in spite of the forced online nature of our delivery due to Covid restrictions. His materials, assessment and examples are well structured and industry-led and the students and colleagues have enjoyed his classes and we very much look forward to working with George again."Mig Farinas-AlmeidaPrincipal Lecturer, Financial Information Analysis and ManagementUniversity of Greenwich
"PPS helped us when organising the EFPP Belgrade conference.
They brought a wealth of financial knowhow to the table and were key in helping us maintain liquidity throughout the long build-up to the conference.
They created detailed forecasts, kept track of costs, and built an integrated model to take payment information directly from source, allowing us to focus on the operational activities.
When the preparation for our next conference began, we did not hesitate in reaching out to PPS again."Dr. Tija DespotovicGASB
"We were lucky enough to have George in to work on some business specific modelling projects, and it was very evident he has exceptional modelling skills and the ability to really take Excel to another level.
Even given high levels of complexity that he was able to work with, it was always accompanied by clear and simple articulation of his modelling approach and workings. His attention to detail shone through, and combined with a very evident focus on model planning, structure and audit functionality (all of which I think are all too often overlooked), we achieved a great outcome and I learnt a lot about best practice in just a short time.
George is a great collaborator, friendly, approachable and was a pleasure to work with!"Christopher WoodleyBusiness ManagerAberdeen Standard Investments
"I was very impressed with George's ability to solve problems. He always had a smile was eager to help.
We worked together on an infrastructure bid, George was my “go-to” excel modelling expert. I highly recommend George for any financial modelling challenges."Kirsten Van Zyl ACMA CGMAAssociate ConsultantSNC-Lavalin Atkins
"George and I worked together as joint advisors for National Grid on a complicated regulatory finance project while at different consulting firms.
George was seconded as a modeller and developed a revised version of the regulator's financial model in order to test the gaps and limitations. I was part of the team that peer reviewed and stress tested his work.
I found George's modelling and finance skills to be first rate and he was a great collaborator taking on board our observations in the spirit of delivering excellence to the client. In the process, I learnt a lot about best practice modelling. More importantly, the common client was thoroughly impressed with George's efforts too."Sahil AgarwalPower, Utilities and Infrastructure, Infrastructure Advisory GroupKPMG UK
"I had the pleasure of working with George on the West Coast Partnership bid team back in 2018.
George identified what needed to be achieved and then built the various constituent elements of the excel model to allow us to achieve a fantastic end result that exceeded my expectations and that was suitable for submission to the Department For Transport.
The depth of understanding and ability to translate this into a sophisticated functioning excel model is a rare commodity, George is one of the best in his field."Nathan JacobsFinance Business PartnerAvanti West Coast
"It's rare for people to have access to a modelling expert like George.
I attended one of his project finance courses after being assigned to a new role at work, in an area I had limited background in. After two days of intensive financial modelling training, I felt fully confident to take on my new responsibilities.
I was particularly impressed with how he distilled complex problems into small steps, using examples from my industry throughout. His patience coupled with his dry sense of humour made a challenging topic enjoyable to tackle. George is and will remain my point of contact for all Excel Financial Modelling questions."Vanja MandrapaAssistant Internal AuditorLilly Drogerie
"The early stages of a career in financial modelling can be a little overwhelming, and I was so lucky to have access to the knowledge and experience of George.
The support and training I received from him were invaluable as it meant I was able to not just reinforce the skills I already had, but also learn new ones that meant I could take my models to the next level, helping me get ahead of the pack."Antonis PapademetriouAssistant Manager, Forensic & Integrity ServicesEY
- Making your financial model look professional Back in school, teachers always gave a few extra marks to the students who set out their workings in...
- Sparklines in Excel are great little visual representations of your data. They make it easier for users to gain insight into a whole block of...
- The SUMIF function allows you to sum values in a given range, provided the corresponding cells in another range satisfy a chosen criterion. The SUMIFS...