Find Jobs
Hire Freelancers

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

£20-250 GBP

Completato
Pubblicato circa 5 anni fa

£20-250 GBP

Pagato al completamento
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.
Rif. progetto: 18643952

Info sul progetto

11 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 giorni
4,9 (85 valutazioni)
7,3
7,3
11 freelance hanno fatto un'offerta media di £61 GBP
Avatar dell'utente
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 giorno
4,8 (268 valutazioni)
7,6
7,6
Avatar dell'utente
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 giorno
4,9 (55 valutazioni)
5,7
5,7
Avatar dell'utente
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 giorno
4,5 (64 valutazioni)
6,1
6,1
Avatar dell'utente
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 giorni
5,0 (41 valutazioni)
5,6
5,6
Avatar dell'utente
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 giorni
5,0 (14 valutazioni)
5,1
5,1
Avatar dell'utente
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 giorno
4,7 (39 valutazioni)
5,2
5,2
Avatar dell'utente
Yes, I am available for you, I will do it immediately ....................................................................................................
£66 GBP in 3 giorni
4,9 (2 valutazioni)
2,4
2,4
Avatar dell'utente
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 giorni
5,0 (3 valutazioni)
1,3
1,3
Avatar dell'utente
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 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED KINGDOM
LONDON, United Kingdom
5,0
4
Metodo di pagamento verificato
Membro dal ago 18, 2015

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.