WHY IS FINANCIAL MODELLING BECOMING AN AREA OF FOCUS FOR THE ACCOUNTING AND FINANCE COMMUNITY?

Like most services, the financial modelling space and related tools are continuously being challenges to create more value for their users, in particular our community. Of course, as finance becomes more embedded in key decisions and positions itself as a genuine value creator, the ability to model and help shape decisions through the right models is becoming more and more important.

OUR RESIDENT EXPERT

Lance Rubin is a financial modelling expert across a range of diverse businesses and sectors. With over 20 years experience as an investment banker and CFO, he has developed strong capabilities across a range of products and markets with a deep understanding of debt markets and the broader financial markets.He has worked with all layers of business, from operational to Board level. This positions him very well for working with CFOs, Finance teams and accountants of all background in the work he and his team delivers.

Lance works with individuals and teams around:

1. Using the most advanced technology in financial modelling to help business leaders with their most complex strategic problems. This includes model building and the implementation of tools to drive efficiency and performance.

2. Educating and up-skilling accounting and finance professionals to more effectively leverage financial modelling skills and tools to solve problems, increase the quality and speed of decisions, and create value in their role.

3. Building bespoke financial models for complex decisions and organisations

EXAMPLE PROJECTS - COMPLEX FINANCIAL MODEL BUILDS BY LANCE RUBIN & TEAM

Equipment Leasing & Funding – created a 3 way integrated model for their commercial asset finance business using their cloud based accounting system which enabled them to forecast their future revenue and balance sheet using an expected internal rate of return, growth rates and term of the receivables.

Not For Profit– built a 40 year cash flow model on youth homelessness to assist the client in discussions with the NSW Government on a social benefit bond.

Multiple Healthcare Providers – Built models for 3 tenders concurrently as part of a NSW Government chronic illness RFP process. Models were used to support each client’s bid.

Property – assisted the company with a triple stapled capital raising for their unlisted property trust and expansion of their Adina brand into Denmark and Germany. Multi currency and tax treatments across development and operating periods created additional complexity.

FMCG – built a 3-way financial model for the food distribution business to enable them to secure more favourable debt funding terms and better insight into their cash flow.

FinTech – built a fully integrated financial model for the fintech start-up (fund and fund manager) leveraging their core lending system and their cloud based accounting package.

FinTech –undertook some credit modelling analysis on their loan book having regard for the PD, EAD and LGD across the portfolio on each individual loan.

Financial Services – audited the complex income and capital unit model that was used to support annuity products and the life company valuation of the capital unit. The model was built by an actuary and was highly controversial and complex resulting in a restatement of results and removal of the CEO.

Property Transactions & Private Equity – developed models for a number of property transactions on behalf of the bank and the property private equity fund which included land sub-division, retail and commercial construction projects.

Banking – developed numerous reporting, pricing and valuation models including an unlisted equity valuation model, daily trading desk performance model and numerous multi currency product and markets models.

Banking – created operational models, project management tools including Gantt charts to measure staff utilisation and progress tracking in order to report and optimise processes and capacity utilisation over peak period.

Banking – redesigned 26 bespoke spreadsheets used across the entire portfolio of businesses to drive consistency in driver based planning and forecasting.

Affordable Housing – built a PPP style 30 year financial model to support their bid to the NSW Government for the development and operations of services under the Social and Affordable Housing Fund (SAHF) initiative. The model was used to successfully bid and complete commercial close.

Not For Profit – built a financial model to support their bid to the Queensland government as part of a social benefit bond to target youth recidivism (re-offending).

Not For Profit – built a financial model to support their bid to both the Queensland and NSW governments as part of a social benefit bond to target the stable housing of families. Their existing program J2SI (journey to social inclusion) was used a basis for the bid.

StartUp – built an early stage tech start-up financial model for the events management business. The model assisted with CEO with a capital raising and discussions with potential investors as well as existing owners

WANT TO WORK OUT WHICH SERVICE FITS YOUR NEEDS?
BOOK IN A FREE DISCOVERY SESSION WITH AN EXPERT FROM OUR TEAM

We will take time to understand your goals, plans and the development you are exploring to help you make the best decision. It is in our interest as much as yours to make sure you have a fantastic experience and find growth in working with The Outperformer