Assemble a tax calculation formula in excel from the gross price to the net amount
Budget: $30 – $250 USD
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
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