rounding total values including and excluding tax

£10-20 GBP

Closed

Posted

almost 2 years ago

£10-20 GBP

Paid on delivery

rounding total values including and excluding tax, Need advise on what approach to follow. We have 2 items: Total payable value: Item 1 costs: 4.29 Item 2 costs: 12 Tax: For item 1 is: 5% For item 2 is: 12.5% Ex Vat (calculated from Total value): Item 1: 4.0857 Item 2: 10.6667 Now the calculations will go: Item 1: 4.0857 * 5% = 0.204285 (rounded to 2 digits decimal - 0.20) Item 2: 10.6667 * 12.5% = 1.3333375 (rounded to 2 digits decimal - 1.33) Total for basket = 16.29 (as ex vat value is calculated from total value) Total from [login to view URL] + taxes: 4.0857 + 0.204285 + 10.6667 + 1.3333375 = 4.289985 + 12.0000375 = 16.2900225 (rounded to 2 digits: 16.29) If I loose the precision on calcs (for example I calculate tax value from 2 digit decimal number, ex 4.09 * 5%), it will create chain reaction which will enlarge total value to 16.30 (after rounding), so it will create another set anomalies that will affect total value as well. Anyone has a good idea?

Project ID: 33731989

About the project

15 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

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

15 freelancers are bidding on average £24 GBP for this job

@daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Financial Analyst and Excel expert holding years of experience in Financial Analysis, Financial Modeling and Corporate Finance. Lets discuss your project in detail and how I am highly suitable for this.

£15 GBP in 1 day

4.8

(217 reviews)

7.0

@AccountantArman

"Sir, Shall we discuss it on chat.? I am Excel and Tax Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 6 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Financial statements, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. It is my 4th month month here and i have 92 5 stars reviews here here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, excel, QuickBooks and auditing related work with quality, efficiency and on reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar"

£20 GBP in 1 day

5.0

(107 reviews)

6.2

@Nsarker1242

Hi client, I'm an Associate professor good knowledgeable about economics Analysis, Home economics, Applied economics. I am an expert in financial analysis using R program code. Feel free to contact me. Best regards, Thanks! N S.

£15 GBP in 1 day

5.0

(1 review)

3.1

@DWSol

Responsive Website Designing/Developmentrounding total values including and excluding tax Hi, rounding total values including and excluding tax, Need advise on what approach to follow This is Sairus Khalil from DW Solution online. I'm certified in web designing and development by freelancer.com. You can also check the certificate in my profile. • DW Solution Online is providing Responsive Website designing & Development Services We have been designing and developing websites for different industries since 2015, we have very experienced project managers, team leads, web/graphic designers and programmers. We have worked on almost all commonly used programming languages, frameworks, open source, databases, difference API integration, payment integration, SMS integration, CRM customization etc. Due to our vast experience working for different industries and business domains, our team now take any new challenges and deliver the project according to client's requirements. All you need is to explain your idea to us, send us written requirements or share your requirements. Some of the programming languages are mentioned below: Skills: ASP.NET/MSSQL, C#, VB.NET, PHP/MySQL, WordPress, Joomla, OsCommerce, OpenCart, CS-Cart, WooCommerce, Drupal, Magento, CodeIgniter, Yii, Zend etc. Node.JS, React JS, Angular JS, iPhone & Android App development, WebServices/Back-end development. Our team is very skilled in the following; - Custom Website Development - Open Source Development & customization - E-Commerce Solution - Content Management (CMS) - Website Re-Designing - IT Consulting - Website Maintenance & Support. • Feel Free to contact.

£20 GBP in 7 days

4.6

(1 review)

2.6

@mramzantariq6

Hi there, I'm Chartered Accountancy student and I deal with such kind of calculations every day. I've expertise in tackling with such tricky figures as is my field. Do hit me up to discuss details. Looking forward to help you out. Regards, MRT

£10 GBP in 1 day

5.0

(2 reviews)

1.2

@remuslupinhp

Hi Friend, I can automate these tasks for you using power query and macros in excel. In future, you will only have to input data and you will get the result automatically. Please give me a chance to work on this task. I am sure, you wont be disappointed. Lets have a chat so I can clear my doubts and you can give any more instructions. Thanks

£15 GBP in 1 day

5.0

(1 review)

1.3

@erikaschittone

Apply from the beginning, the recounting formula in the value of the cost. Item 1 Item 2 Costs 4,09 10,67 % - Tax 5,0% 12,5% Tax 0,20 1,33 Total 4,29 12,00 Total Item 1 +Item 2 16,29

£27 GBP in 40 days