Find Jobs
Hire Freelancers

Excel genius and financial expert

$30-250 AUD

Concluído
Publicado há aproximadamente 5 anos

$30-250 AUD

Pago na entrega
I'm needing to create/ amend a cash flow statement for forecasting purposes to show a tiered commission structure for multiple clients so that the relevant commission percentages are applied on a monthly cumulative basis i.e. if total revenue is $0-$500k per annum they receive 6% commission (applied to that months revenue). As soon as 500k (total) is hit within the year a new commission structure kicks in so that the revenue between 500k and 1m receives 8% commission etc etc. as represented on the attached doc . As an example if by Aug client #1 has hit $682k in revenue the calc would recognize that all revenue from $0-$500k should be charged at 6% for the months in which that revenue was realized, then the revenue between $500k-$1m should be charged at 8% so in this example the $182k (the amount of revenue over $500k) is charged at 8%. The tiered commissions levels have been highlighted in orange, the client commission (where the formula needs to be entered) is in yellow, the revenue that is driving the commission percentage is highlighted in green I'm needing a 24 hour turnaround and want to pay close to the low end of the price range as it's not a particularly complex task.
ID do Projeto: 18680054

Sobre o projeto

42 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi there, I have created many different types of similar tiered commission based calculators in Excel throughout my career and I am confident I can add in the required formulas and logic to ensure that the client commissions are calculated according to your desired tiered logic that you've described. I believe we have quite a time difference, but if you are reading this proposal now, I would be able to craft the required formulas in right now and have this ready for you to start testing immediately. Hopefully we can work together! Thanks either way, Shaun
$100 AUD em 1 dia
5,0 (80 avaliações)
6,5
6,5
42 freelancers estão ofertando em média $119 AUD for esse trabalho
Avatar do Usuário
Hi, I can create/ amend a cash flow statement for forecasting purposes to show a tiered commission structure for multiple clients so that the relevant commission percentages are applied on a mont... Read More please share details regards Rashid.
$155 AUD em 3 dias
4,9 (437 avaliações)
7,9
7,9
Avatar do Usuário
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 AUD em 4 dias
4,9 (296 avaliações)
7,7
7,7
Avatar do Usuário
I am a qualified professional accountant, APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 13 years of experience. I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Javed
$133 AUD em 3 dias
4,9 (580 avaliações)
7,9
7,9
Avatar do Usuário
Greetings! I am qualified accountant and financial analyst with ten years of experience in financial analysis and excel. Please PM to discuss. Thank you.
$150 AUD em 3 dias
4,8 (91 avaliações)
6,9
6,9
Avatar do Usuário
I can create for you a KPI Analysis Module in Excel to calculate the staff performance and its commission based on chosen parameters. The performance reports show results per period, person, working group and company levels. during the process, Excel validates the information, prepares a creates a structured database and pivot tables which enables to develop templates reports independently. the module is secured by usernames and passwords. About me: I am a financial expert and a guru in Excel/VBA/Macro. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I develop financial modules and financial projections including business valuation & terminal valuation methodology & ratios (INPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Furthermore, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.
$250 AUD em 3 dias
4,8 (87 avaliações)
7,0
7,0
Avatar do Usuário
Greetings! I have reviewed the file and understand the calculations. I can set up the formula for Commission as explained in Project Description. The requirement is straightforward. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan
$30 AUD em 1 dia
5,0 (166 avaliações)
6,7
6,7
Avatar do Usuário
Greetings I am a specialist in excel and financial models and am keen to help you with the requirements. Look forward to hear from you. Thanks, RRC
$250 AUD em 1 dia
4,8 (88 avaliações)
6,7
6,7
Avatar do Usuário
Hi, I am a qualified and experienced Chartered accountant and I am providing book keeping services using Quick Books, Xero, Myob and other most commonly used accounting software to various clients in UK, Australia, Canada and USA for the last 8 years. I also provide services like Financial Statements preparation and financial analysis, Data entry, Posting of transactions, Payroll preparation and disbursement, Bank reconciliation, Tax filling and other tasks associated with book keeping functions. I am positive that I am the right person for this job. Cost of Services: The cost quoted is initial cost that is subject to revision after looking at the amount of work. Looking forward to hear from you soon. Thank you.
$111 AUD em 3 dias
5,0 (70 avaliações)
6,4
6,4
Avatar do Usuário
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Ok. It is just setting up one formula over. Willing to take up your project. Thank you, Regards.
$50 AUD em 1 dia
4,9 (84 avaliações)
6,0
6,0
Avatar do Usuário
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$120 AUD em 1 dia
4,8 (77 avaliações)
5,7
5,7
Avatar do Usuário
* PLEASE CHECK OUT MY PORTFOLIO TO SEE PREVIOUS BUSINESS PLANS- https://www.freelancer.com/u/Sonny85 * Hi, I'm a Professional Financial Analyst and a Business Writer, I can develop and deliver a bespoke financial model in excel as desired with quality and precision. All content will be delivered within the stipulated time and budget with all revisions as deemed necessary. Please visit my profile to view previous work samples and drop me a message to discuss further details. Sincerely, S. S.
$156 AUD em 1 dia
4,9 (32 avaliações)
5,7
5,7
Avatar do Usuário
CHECK MY SAMPLE WORK HI. I am an affiliate chartered accountant (CPA) with 9+ years of experience. i have prepared financial models, excel templates & reports for clients based in US, UAE, KSA, Pakistan, UK etc. by carrying out the market research in their specific areas. I have advanced level proficiency in excel and can ensure minimum manual entry by maximizing automation. I can prepare your financial model with better quality and presentation. Please contact and discuss the details.
$120 AUD em 1 dia
4,6 (93 avaliações)
6,1
6,1
Avatar do Usuário
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$144 AUD em 3 dias
4,6 (45 avaliações)
5,6
5,6
Avatar do Usuário
Hello! Excel genius is at your service. I have worked on various cash flow statements and am confident to take your project and deliver to you the work within 24 hours. Requesting you to please come on chat. Regards, Yogesh
$125 AUD em 1 dia
5,0 (32 avaliações)
5,3
5,3
Avatar do Usuário
Hi, I am a CPA and ACA with 10 years’ experience in the accounting,forecasting, financial modeling, financial projection, Sales Forecast, cash flow forecast, bookkeeping, preparation of financial statements, profit and loss statement, cash flow statement, review and reconciliation of accounts, bank reconciliation, tax statements, Tax returns, the filing of returns, Quarterly & Annual reports etc. With this vast experience in financial services, I believe I can help you with this. Looking forward to hearing back from you and complete the task as per your requirements. Please note that this is just a tentative offer as the actual price can only be given after analysis of the workload.
$120 AUD em 3 dias
5,0 (11 avaliações)
5,0
5,0
Avatar do Usuário
Hello. How are you? I am highly interested to work on the "Excel genius and financial expert". I am a full stack Excel expert. I have more than 7 years experience in "Accounting, Business Analysis, Excel, Finance, Visual Basic". I will make sure the best quality service. Let us work together. Best regards, Yang L.
$155 AUD em 3 dias
4,6 (26 avaliações)
5,0
5,0
Avatar do Usuário
Hi I am a very experienced statistician, data scientist and financial analyst I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$250 AUD em 3 dias
4,9 (13 avaliações)
4,9
4,9
Avatar do Usuário
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .
$155 AUD em 3 dias
5,0 (5 avaliações)
4,4
4,4
Avatar do Usuário
Hi, I saw you repost your project, I'm trying to make a macro formula to make it easier to use. I hope with the function, you can use it in any layout you want. I'm waiting for your reply. Thanks
$55 AUD em 0 dia
5,0 (41 avaliações)
4,5
4,5
Avatar do Usuário
Hello there, I am an Excel coder and also Financial controller and I can do this task for you. Cashflow report is very familiar with me and I can do this task within 1 hour. Contact me and we will start right now. Thanks.
$40 AUD em 1 dia
5,0 (26 avaliações)
4,0
4,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
North Bondi, Australia
5,0
10
Método de pagamento verificado
Membro desde out. 28, 2012

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.