Complicated set of financial forecasts required for loan company
- or -
Post a project like this3466
£200(approx. $248)
- Posted:
- Proposals: 8
- Remote
- #582295
- Awarded
Business Consultant; Business Strategy; Business Planner and Certified Translation Services
London
Business Plan Expert, Financial Planner, Investors' Pitch Deck, Accounting & Bookkeeping
Karachi
296326117542328852355073443720489945692376721376
Description
Experience Level: Expert
General information for the business: Loan finance company
Kind of support: Forecast
Description of support work: Fee negotiable i am unsure of expected fee!
We are a small loan company specialising in short term property loans (bridging loans)
We are going through a funding round and require a set of financial forecasts generated. We would also like the forecast file as well so that we can edit and amend the the forecasts to tailor them to each investor.
All of the categories required are on the attached spreadsheet.
The forecast would ideally also incorporate a formula for loan turnover.
Extra notes: Notes regarding loan turnover:
These loans will do one of four things during their lifetime
1. They will run for an agreed period of time (usually between 1 and 18 months)
2. They will default and have their interest rate doubled
3. They will be renewed at the end of their term by us for a fee
4. They will default and be repossessed
We expect an average loan term of 6 months. Of the above scenarios we expect the following to apply:
1. They will run for an agreed period of time (usually between 1 and 18 months) - 59.5% of loans will do this
2. They will default and have their interest rate doubled - 7.5% of loans will do this
3. They will be renewed at the end of their term by us for a fee - 30% of loans will do this
4. They will default and be repossessed - 3% of loans will do this
Average loan size will be £150,000 and average loan interest rate is 1.2% per month of loan balance. The following fees apply to the scenarios:
1. They will run for an agreed period of time (usually between 1 and 18 months) - Arrangement fee must be editable but an average of 2.25% will apply to loans
2. They will default and have their interest rate doubled - Average rates are 1.2% so rate doubles to 2.4%
3. They will be renewed at the end of their term by us for a fee - 10% fee applies of loan balance
4. They will default and be repossessed - rate doubles and default fees from solicitors apply, usually £4,000-£8,000
Ideally the forecasting template will be able to calculate that with a £1m investment we would process x number of loans at an average of £150k per loan and perform under the above conditions and then produce income calculations accordingly.
Kind of support: Forecast
Description of support work: Fee negotiable i am unsure of expected fee!
We are a small loan company specialising in short term property loans (bridging loans)
We are going through a funding round and require a set of financial forecasts generated. We would also like the forecast file as well so that we can edit and amend the the forecasts to tailor them to each investor.
All of the categories required are on the attached spreadsheet.
The forecast would ideally also incorporate a formula for loan turnover.
Extra notes: Notes regarding loan turnover:
These loans will do one of four things during their lifetime
1. They will run for an agreed period of time (usually between 1 and 18 months)
2. They will default and have their interest rate doubled
3. They will be renewed at the end of their term by us for a fee
4. They will default and be repossessed
We expect an average loan term of 6 months. Of the above scenarios we expect the following to apply:
1. They will run for an agreed period of time (usually between 1 and 18 months) - 59.5% of loans will do this
2. They will default and have their interest rate doubled - 7.5% of loans will do this
3. They will be renewed at the end of their term by us for a fee - 30% of loans will do this
4. They will default and be repossessed - 3% of loans will do this
Average loan size will be £150,000 and average loan interest rate is 1.2% per month of loan balance. The following fees apply to the scenarios:
1. They will run for an agreed period of time (usually between 1 and 18 months) - Arrangement fee must be editable but an average of 2.25% will apply to loans
2. They will default and have their interest rate doubled - Average rates are 1.2% so rate doubles to 2.4%
3. They will be renewed at the end of their term by us for a fee - 10% fee applies of loan balance
4. They will default and be repossessed - rate doubles and default fees from solicitors apply, usually £4,000-£8,000
Ideally the forecasting template will be able to calculate that with a £1m investment we would process x number of loans at an average of £150k per loan and perform under the above conditions and then produce income calculations accordingly.
Projects Completed
90
Freelancers worked with
71
Projects awarded
49%
Last project
19 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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