Find Jobs
Hire Freelancers

Excel genius and financial expert

$30-250 AUD

Selesai
Dibuat sekitar 5 tahun yang lalu

$30-250 AUD

Dibayar ketika dikirim
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 Proyek: 18680054

Tentang proyek

42 proposal
Proyek remot
Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 1 hari
5,0 (80 ulasan)
6,5
6,5
42 freelancer menawar dengan rata-rata $119 AUD untuk pekerjaan ini
Avatar Pengguna
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 dalam 3 hari
4,9 (437 ulasan)
7,9
7,9
Avatar Pengguna
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 dalam 4 hari
4,9 (296 ulasan)
7,7
7,7
Avatar Pengguna
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 dalam 3 hari
4,9 (580 ulasan)
7,9
7,9
Avatar Pengguna
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 dalam 3 hari
4,8 (91 ulasan)
6,9
6,9
Avatar Pengguna
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 dalam 3 hari
4,8 (87 ulasan)
7,0
7,0
Avatar Pengguna
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 dalam 1 hari
5,0 (166 ulasan)
6,7
6,7
Avatar Pengguna
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 dalam 1 hari
4,8 (88 ulasan)
6,7
6,7
Avatar Pengguna
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 dalam 3 hari
5,0 (70 ulasan)
6,4
6,4
Avatar Pengguna
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 dalam 1 hari
4,9 (84 ulasan)
6,0
6,0
Avatar Pengguna
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 dalam 1 hari
4,8 (77 ulasan)
5,7
5,7
Avatar Pengguna
* 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 dalam 1 hari
4,9 (32 ulasan)
5,7
5,7
Avatar Pengguna
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 dalam 1 hari
4,6 (93 ulasan)
6,1
6,1
Avatar Pengguna
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 dalam 3 hari
4,6 (45 ulasan)
5,6
5,6
Avatar Pengguna
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 dalam 1 hari
5,0 (32 ulasan)
5,3
5,3
Avatar Pengguna
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 dalam 3 hari
5,0 (11 ulasan)
5,0
5,0
Avatar Pengguna
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 dalam 3 hari
4,6 (26 ulasan)
5,0
5,0
Avatar Pengguna
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 dalam 3 hari
4,9 (13 ulasan)
4,9
4,9
Avatar Pengguna
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 dalam 3 hari
5,0 (5 ulasan)
4,4
4,4
Avatar Pengguna
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 dalam 0 hari
5,0 (41 ulasan)
4,5
4,5
Avatar Pengguna
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 dalam 1 hari
5,0 (26 ulasan)
4,0
4,0

Tentang klien

Bendera AUSTRALIA
North Bondi, Australia
5,0
10
Memverifikasi Metode pembayaran
Anggota sejak Okt 28, 2012

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.