Excel Southampton Placement Programme
Duncton, Nr. Petersfield, West Sussex
Duncton is a vehicle finance business based at Petersfield. Founded in 1992, they have demonstrated steady growth
since then. Their main business is lending money to consumers to allow them to buy cars. Duncton survived the
credit crunch and recession and now has a very strong market position thanks to their very conservative lending
principles and their focus on developing a high quality team. In November 2010, they raised £150m in new
finances to allow them to grow into the gap left by the lack of competitors due to the recession. Currently, Duncton
is the ‘last man standing’ in a growing market.
One placement opportunity is available:
What is being offered?
Duncton is in need of someone who can perform financial and risk analyses of existing and new business lines.
Duncton has invested in new systems to manage the business and to allow them to extract data to assess financial
performance and risk levels in subsets of their customer and potential customer base. This job will specifically
involve working on the assessment of risk on higher levels of loan to value (LTV) business and the assessment of
two new product lines they are considering:
(1) High LTV business – they need to consider the likely result of increasing their loan to value ratios from
about 80% of the retail cost of a car to 100% of retail value. The analysis will include spreadsheet work to
assess the effect on a number of business critical outputs including:
a. Sales volumes
b. Default rates
c. Loss given default
d. Sensitivity analysis on the above
e. Voluntary termination rates
(2) New business lines – they are considering starting lending below their usual lower limit, and also the
impact of using new arrears management technology. Each of these requires a new business plan to
support the development, including an assessment of key risk factors.
The successful candidate will be expected to:
Carry out an analysis of the Duncton customer base using the data output of the Duncton Book
Build a model of risk analysis for a given portfolio of customers
Build basic spreadsheet business plans
Write draft reports of the above
1. Intern Personal Specification
How to be
Criteria Essential Desirable assessed
Qualifications, Knowledge and Experience
Specific Degree criteria or equivalent
professional qualifications / experience Application
Strong Data Analysis Skills
A high level of numeracy coupled with Application
experience of producing and analysing Interview
complex statistical data from multiple
Experience / knowledge of any particular
systems? - Excel
Planning and Organising:
Organisational ability and ability to work Application
to strict deadlines and manage several Interview
projects at one time.
Problem Solving and Initiative:
Strong ‘critical thinking’ and analytical Interview
Management and Teamwork:
Ability to work independently or as part Application
of a team Interview
Ability to manage time appropriately to
complete desired work.
Communicating and Influencing:
High level of written and verbal Application
communication skills including the ability Interview
to present complex information in a
concise and user-friendly way.
Able to make confident presentations to Interview
a range of different audiences.
Ability to build good relationship with a Application
wide range of colleagues across the Interview
Ability to negotiate and persuade a
range of stakeholders on a range of Interview
issues to ensure timely delivery of
Good oral and written presentation skills Application
Other Skills and Behaviours:
Attention to detail Application
Excellent IT skills including Microsoft
e.g. Willingness to travel Note – their office
ability to get to
work under own
The applications process with run from Tuesday 12th July to Midnight, Monday 18th July 2011.
Application submission should take the form of a CV and a completed Internship application form
(downloadable from the website), which should be submitted to firstname.lastname@example.org
Successful candidates will be short listed and may be invited to attend a formal interview
Please Note: If invited for interview, you may be requested to bring an example of your work.
Deadline for submission of a CV and Application Form is Midnight Monday 18th July 2011
Remuneration and leave entitlement
Interns will be treated as fixed-term, part-time employees of the company and will receive a competitive pay
package worth £252.36 gross per week (£7.01 per hour), in addition to the value of the professional experience
gained. As temporary members of staff, interns will accrue pro rata annual leave, for the period worked. Requests
for annual leave must be submitted for approval in a timely fashion, may only be taken with the consent of the line
manager and will normally be taken at the end of the assignment.
Duration and hours
Interns will work 36 hours per week Hours of work each week will be arranged with the line manager, taking into
account of the needs of the project and general office hours.
Support will be provided to the student throughout this internship by the project supervisor. The internship start
date will be announced at interview.
If you are not available to start on this particular date but believe you have the skills and interest we are looking for,
please contact us, email@example.com
Please find below deadlines for each stage of the application process.
Milestone Delivery Date
Opportunities Advertised to Students Tuesday 12th July 2011
Closing Date for Student Applications Midnight, Monday 18th July 2011
Internships Start* TBA
*Please note that dates are indicative and are subject to change