Mathematic formula for calculating final Sales Price after Tax and comissions
Budget: €8 – €30 EUR
Hi, I need a mathematic formula for calculating any sales price.
- The profit should be 5% after all deductions (sales tax 19%, commission 13% on the gross price).
- Sales tax 19% will be deducted from the final sales price
- 13% gross commission will be added to the gross sales price
- From the 13% gross commission, I get back 19% in sales tax
- Should work for any goods purchase price
My current formula doesnt work at all:
((PurchasePrice*1.05)*1.19)+((((PurchasePrice*1.05)*1.19)*1.13-(PurchasePrice*1.05)*1.19)-(((((PurchasePrice*1.05)*1.19)*1.13-(PurchasePrice*1.05)*1.19)*1.19)-(((PurchasePrice*1.05)*1.19)*1.13-(PurchasePrice*1.05)*1.19)))
- The profit should be 5% after all deductions (sales tax 19%, commission 13% on the gross price).
- Sales tax 19% will be deducted from the final sales price
- 13% gross commission will be added to the gross sales price
- From the 13% gross commission, I get back 19% in sales tax
- Should work for any goods purchase price
My current formula doesnt work at all:
((PurchasePrice*1.05)*1.19)+((((PurchasePrice*1.05)*1.19)*1.13-(PurchasePrice*1.05)*1.19)-(((((PurchasePrice*1.05)*1.19)*1.13-(PurchasePrice*1.05)*1.19)*1.19)-(((PurchasePrice*1.05)*1.19)*1.13-(PurchasePrice*1.05)*1.19)))