Find Jobs
Hire Freelancers

Simple financial modelling sales predictions based on current years sales job (excel)

£20-250 GBP

Completed
Posted over 5 years ago

£20-250 GBP

Paid on delivery
Problem: I’m looking for someone who is available immediately to work on this today. I need some help from someone who has good experience in both excel and financial business modelling to help predict customer sales for the year going forth (Feb ’19 – Jan ’20). We have three income streams - Two of these streams have unlimited sales potential - The Third stream is limited in the amount it can increase by. Sales of the third equalled 70% of capacity in the last year. So we can only increase those by sales by a maximum of 30%. There are some variables we need to take into consideration, because we are scaling our operation. Number of active email marketing subscribers - New registrations - Unsubscribes Seasonality - we’d like the forecasts to take into account seasonal fluctuations - but this is difficult because number of subscribers varied through last year Recruits - we are increasing our database by 16,000 customers monthly. - So predictions made for sales need to cumulative on that basis. I’ve gathered much of the data, but I’m having trouble creating the correct formulas etc, to extract the figures I need. Imagine this is quite a quick job from someone who has done this before. My original thought was to base all of the sales on last years, then use the % increase in customer database size to calculate sales on a cumulative basis, and then take a sum of those sales and then divide those sales back into seasonality fluctuations which we observed in the previous year, but I’m unsure of whether this is the way it should be done. Objective To add in the correct formulas to properly and explain the logic to me in simple terms so that I understand the correct way to model these predictions. I have a file ready with the data you need. I think budget around £50 is good for this job, I think it's probably 1 or 2 hours work for the right person.
Project ID: 18643952

About the project

11 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Greetings I am a specialist in excel with 15+ years' experience in financial modeling and valuation modeling. I am a Chartered Accountant and can start today. Look forward to hear from you Thanks, RRC
£85 GBP in 3 days
4.9 (85 reviews)
7.3
7.3
11 freelancers are bidding on average £61 GBP for this job
User Avatar
CHECK MY SAMPLE WORK (I AM AVAILABLE TO START RIGHT AWAY) HI. I am an affiliate chartered accountant with 9+ years of experience. i have prepared financial models for clients based in US, UAE, KSA, Pakistan, UK etc. by carrying out the market research in their specific areas. I have prepared financial models, business plans & feasibilities for restaurants, manufacturing, trading, services, IT sector etc. i can deliver you within 3 - 4 days time. In my deliverables, i will provide you excel sheet containing financial model, a separate assumptions sheet completely linked with financial statements. It helps my clients making changes in future quite easy. I can prepare your financial model with better quality and presentation. Please contact and discuss the details.
£70 GBP in 1 day
4.8 (268 reviews)
7.6
7.6
User Avatar
Dear Sir, I am a chartered accountant and a professional finance expert. I have worked with many start ups, business models for my clients. I have read your requirements and know how to complete your financial model within 3_4, hours. Please contact me and check my sample work. Thanks Omair
£60 GBP in 1 day
4.9 (55 reviews)
5.7
5.7
User Avatar
Financial modelling: I will start this job now and complete within few hours. ( Today). Dear Sir / Madam, I am a Chartered Accountant / Certified Public Accountant having more than 11 years’ experience in Financial modelling. Please discuss in detail over chat now as I did 100 projects on financial modelling in different platform including Freelancer.com. Report: Both in excel and word based on clients’ requirement Coverage: 1. Assumption and drivers 2. Sales Forecast 3. Income Statement 4. Balance Sheet 5. Cash Flow Statement 6. Loan Schedule 7. Supporting Schedules 8. Valuation- DCF Approach 9. NPV, IRR- Viability of the project 10. Sensitivity Analysis 11. Charts and graphs 12. Ratio Analysis with Interpretation Project handled through Freelancer.com only: 1. https://www.freelancer.com/projects/accounting/Build-financial-statements-for-new/?w=f 2. https://www.freelancer.com/projects/data-entry/Project-for-Ashis-Kumar-18544116/?w=f 3. https://www.freelancer.com/projects/excel/require-project-report-for-bank/?w=f 4. https://www.freelancer.com/projects/business-analysis/Proposal-for-Horticulture-Farming/?w=f 5. https://www.freelancer.com/projects/excel/Update-Financial-Model/?w=f 6. https://www.freelancer.com/projects/accounting/income-statment-balance-sheet/?w=f 7. More project is available through my profile 8. Quality of work is available through portfolio Good to know you! Thanks & Regards Ashis Kumar Jena (CA, CPA)
£50 GBP in 0 day
4.5 (64 reviews)
6.1
6.1
User Avatar
Hello, I would like to check your data and discuss more about this. I work as financial analyst in international bank for more than 5 years. My clients are corporate clients and for all long term financing we need to prepare cash flow forecasts. So I think I may help you with your issues. If you are interested, contact me. Best regards.
£50 GBP in 2 days
5.0 (41 reviews)
5.6
5.6
User Avatar
Greetings! I am Qualified Accountant and Business Analyst with ten years of experience in financial planning, forecasting and management accounts. Please PM to discuss. Thank you.
£100 GBP in 3 days
5.0 (14 reviews)
5.1
5.1
User Avatar
Hello sir, I can help you with financial modeling. I am working in this industry since 2008-9. I have all skills and competence to provide you quality paper.
£100 GBP in 1 day
4.7 (39 reviews)
5.2
5.2
User Avatar
Yes, I am available for you, I will do it immediately ....................................................................................................
£66 GBP in 3 days
4.9 (2 reviews)
2.4
2.4
User Avatar
Hello! i'll deliver you today with quality work. I am interested in your job. Maybe there are freelancers that are bidding on this project. You will select one of them that can provide you good result you want. They will say that they are expert in this field and I can also tell you so . But I like the behavior than a word. I will prove my skills with my work and if you give me a chance to work with you , I will do my best for perfect result. Chat Conversation End
£20 GBP in 3 days
5.0 (3 reviews)
1.3
1.3
User Avatar
Hi. I am a CPA (USA) and a Chartered Accountant from India. I have an experience of more than 10 years in the field of accounting, taxation, budgeting, auditing, business planning, financial management, etc. My clientele includes businesses from different sectors of the industry including banks, insurance companies, manufacturers, small businesses. I have done this type of job earlier for my clients mostly for borrowers of my clients. The cutting edge of my services include timely completion of work and minimum response time. Looking forward to working with you. Thanks Prerana Dokania
£44 GBP in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
LONDON, United Kingdom
5.0
4
Payment method verified
Member since Aug 18, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.