Find Jobs
Hire Freelancers

Assemble a tax calculation formula in excel from the gross price to the net amount

$30-250 USD

Completed
Posted 12 months ago

$30-250 USD

Paid on delivery
I have an excel with a tax formula where I have the net amount and the tax rates and I arrive at the total gross amount. I would like to assemble the reverse excel formula, where I have the final gross value, aliquots and arrive at the tax values. As per the excel attachment: The current formula is starting from the net value of 6.51 in the yellow field, using the aliquots, and arrives at the value of 10.00 green cell I would like a new excel formula, where I have the gross value of 10.00 starting from the green cell, use the tax rates and calculate the ICMS ST Value (blue cell). *only use the gross final amount and percentage rates to arrive at the ICMS-ST tax amount ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Tenho um excel com formula de impostos onde tenho valor liquido e as aliquotas dos impostos e chego no valor total bruto. Gostaria de montar a formula do excel reverso, onde tenho o valor bruto final, aliquotas e chegar nos valores dos impostos. Conforme o anexo do excel: A formula atual está partindo do valor liquido 6,51 do campo amarelo, utilizando as aliquotas e chega ao valor de 10,00 celular verde Gostaria de uma nova formula do excel, onde tenho o valor bruto de 10,00 partindo do celula verde, usar as aliquotas dos impostos e calcular o ICMS ST Valor(celula azul). *somente utilizar o valor final bruto e as porcentagem de aliquotas para chegar no valor do imposto ICMS-ST
Project ID: 36357710

About the project

35 proposals
Remote project
Active 1 yr 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
$0 USD in 1 day
5.0 (92 reviews)
5.5
5.5
User Avatar
Hello there, I have understood your requirement, I am expert in reverse engineering of anything, i will complete your task after 15 minutes of being assigned, and with the quality you need, and this project will complete within hour taking formatting time, So i am ready to serve you my expertise. thank yoiu Mihir Panchal
$40 USD in 1 day
5.0 (2 reviews)
1.6
1.6
35 freelancers are bidding on average $81 USD for this job
User Avatar
I am an expert in Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel Flow Chart, Excel Cash Flow, Excel Balance Sheet, Excel Waterfall Model, Excel Forecasting Models, Excel Prediction Models, Forecasting, Excel ROI, Excel Financial Ratio analysis, Investment, -> Financial modelling and projections, Cash flow, Balance Sheet, Trial Balance, -> Business valuation, Financial reports, Business analysis, Income Tax, Tax Return -> Economic research & analysis of Big.
$30 USD in 7 days
5.0 (133 reviews)
6.9
6.9
User Avatar
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project creating an excel formula that fits your needs. I'm very responsible and kind, I will always send you the files on time and with the best quality. Send me a message and I'll start working on your project. Kind regards, Giovanni.
$30 USD in 1 day
4.9 (47 reviews)
6.7
6.7
User Avatar
Hello, I examined your project description, and I confirm I can handle those tasks perfectly, as I am an expert in Excel, Tax, Mathematics. I am prepared to handle projects requiring Excel, Mathematics skills. Please come over chat and discuss your requirement in a detailed way. Zied B.
$130 USD in 1 day
4.7 (75 reviews)
5.4
5.4
User Avatar
Hello sir/ madam I checked your project description. I can do Microsoft Excel task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saaniya.
$30 USD in 1 day
4.8 (121 reviews)
5.5
5.5
User Avatar
Hello, I can help you calculate net amounts starting from a given gross amount. I have checked your formulas, and I can quickly and easily provide you with a new one to deliver the results you need. I am a Data Analyst with extensive experience in building nested formulas. Please feel free to contact me for any additional details. Thank you a lot. Best regards, Emilia
$30 USD in 1 day
5.0 (23 reviews)
4.7
4.7
User Avatar
Hi there, I have read your requirement and check the attachment. I can make you the very best work completion with 100% accuracy in said time. I have expertise in Excel Automation using VBA, Excel Dashboards & Excel Advance formulas. Please open the chat so we can discuss this project in details. Thanks Ghulam
$99 USD in 2 days
5.0 (19 reviews)
3.9
3.9
User Avatar
Hello, I like your project and I am passionate about mathematics. So I have already started working on the formulas.
$50 USD in 1 day
5.0 (1 review)
3.5
3.5
User Avatar
Hello there, I am expert in Excel invoices and formula working I also added gross tax calculationon invoices. Please feel free to join me in chat and lets start working now. I have checked the attached excel file and I am confident that I can do this job efficiently. I am waiting for your response. Thank you. Have a good day. Regards, Waqas
$30 USD in 1 day
5.0 (5 reviews)
3.1
3.1
User Avatar
Hey.. I am an Excel expert. I want to assist you in this project and want to assure you that you will get a professional output from me.. Lets do it..will do asap. Please click on chat button to discuss more..
$85 USD in 1 day
5.0 (7 reviews)
2.9
2.9
User Avatar
Greetingsi I am RANDHIR KUMAR faculty of Mathematics for 11th. 12th. I.I.T Jee and also for degree levels having 27 years experience I promise your assignment will complete within given time period with 100%:client satisfaction I am also member of international Mathematics contest USA feedback forum
$140 USD in 2 days
3.3 (7 reviews)
3.0
3.0
User Avatar
Hi, Greetings of the day! I am Varshil Desai a Chartered Accountant qualified with All India Rank 17. I am expert in Advanced Excel and can easily help you with your calculations starting from Gross amount instead of current net amount. Please feel free to connect for further discussion. Regards, Varshil Desai
$30 USD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
Hello sir, Firstly I like to say you that Mathematics is my fashion.I can solve any types mathematical problems and I am very much comportable in excel equations. Secondly, I have over 03 years of experience in data entry, and I am familiar with various data entry software, including Microsoft Office, Microsoft Excel and Google Sheets. I am proficient in typing at a high speed while ensuring the accuracy of the data. I can handle large volumes of data quickly and accurately, while ensuring that the data is organized and easy to use.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Greetings! Hope you are doing well! Thanks for sharing your project requirement with us. I think you're looking for someone to Assemble a tax calculation formula in excel from the gross price to the net amount. I have more than 12 years of experience as senior accountant an International NGO. I also check your attached excel sheet. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. We will complete the work as per requirement and am also READY to start this project RIGHT NOW! So, please take a moment to chat with me. Sincerely, Sathi Thanks
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, this is a relatively simple math problem, I have the math and Excel skills to finish this in one hour. I can guarantee I will finish this within one hour and a half or you won't have to pay anything. If any changes are required after that, I will solve that as well, until you are completely satisfied. Let me know if you have any questions. Kind regards, David.-
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hİ I came across your relevant job posting on [job board / website] and read it with great interest. I believe I have the experience in working with websites or Excel spreadsheets, particularly in tax calculations and formulas. Therefore, I am hoping for an opportunity to work with you as your employee. [Highlight your relevant skills and experiences, mentioning relevant projects, success stories, and relevant expertise.] Some of the skills I can offer include: Understanding and implementing complex tax formulas using my Excel skills Understanding and reversing the relationships between net and gross values Making accurate calculations using aliquots (rates) and percentages Attention to precision, accuracy, and timely delivery in tax calculations Attached, you will find some examples of Excel spreadsheets I have used in previous projects. [Important Note: Follow the employer's instructions carefully, attach any necessary documents, or follow the application process.] I am excited to share more details about my qualifications, references, and other documents with you. I am eager to discuss with you in more detail how I can add value to your project. I hope you will consider my application for your evaluation. I am looking forward to speaking with you at your convenience. Sincerely, Ali Kurt
$126 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir madam I am fully experienced this project and I am sure this project is best results for me Thanku
$110 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Solution is READY. Have gone through the file and understand that you are looking for a formula which when applied to cell in green would provide you the cell in Blue. A reverse calculation for ease of application in normal day to day life. This is easy to work out. Will take "an hour" to provide the solution. Happy to share the file. Regards.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am expert in excel, advanced excel and mathmatics please consider my profile i will finish your project ASAP
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
MInha entrega será 100% confiável, rápida e tenho certeza que atenderá as expectativas, tenho 3 anos que trabalho com excell
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Freelancer anderson Costa Rica Skills in excel macro and pivot tables, word and data entry. Recently acquired experience in excel macro for Walmart
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BRAZIL
Sao Paulo, Brazil
0.0
0
Payment method verified
Member since Dec 19, 2011

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.