Complex Financial Modelling for Loan book
- or -
Post a project like this2058
$$$
- Posted:
- Proposals: 12
- Remote
- #1841535
- Awarded
ACCA, CFA Expert in Bookkeeping, Financial Reporting,Forecasting,Forensic Auditing, Management Accounting, Auditing,
Microsoft Certified Advance Excel Specialist¦Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦Excel related any Work¦Macros of Excel¦

187566126116143076328852443720590552102270213764241406416147683315880891987689





Description
Experience Level: Expert
We need a financial model to be created for a loan company. The sheets should include:
1 P&L
2 Balance sheet
3 Expenses
4 space to input volume of loans split between two differing types of loans
5 A control sheet to input fundings costs, average loans amounts etc to drive the figures throughout the sheet
A current version of the spreadsheet is attached to the job. The critical part to ensure as much of this as possible is driven by control tabs so that we can scale up the business model. As volume increases the sheet should allow for each expense to be increased accordingly to avoid inputting figures in manually. The sheet must calculate our fees and our funding requirements as a result of our growing loan book.
I would expect a conference call to discuss the job with people interested in carrying out the task as we have previously done this spreadsheet and ended up loosing a lot of time and trying to do it ourselves!
The budget is currently open as I do not know how complex someone will find this modelling nor do I know how long it will take a competent person.
1 P&L
2 Balance sheet
3 Expenses
4 space to input volume of loans split between two differing types of loans
5 A control sheet to input fundings costs, average loans amounts etc to drive the figures throughout the sheet
A current version of the spreadsheet is attached to the job. The critical part to ensure as much of this as possible is driven by control tabs so that we can scale up the business model. As volume increases the sheet should allow for each expense to be increased accordingly to avoid inputting figures in manually. The sheet must calculate our fees and our funding requirements as a result of our growing loan book.
I would expect a conference call to discuss the job with people interested in carrying out the task as we have previously done this spreadsheet and ended up loosing a lot of time and trying to do it ourselves!
The budget is currently open as I do not know how complex someone will find this modelling nor do I know how long it will take a competent person.

Alistair M.
100% (90)Projects Completed
84
Freelancers worked with
67
Projects awarded
50%
Last project
31 Aug 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Alistair - are you working to any particular timescales here?
Alistair M.02 Jan 2018Hi we are looking to get this done ASAP to be honest, thatbsaid we also want the right person and done correctly so if this pushes back the timescale then that is not annissue
564078
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies