Jan 25 2020 10:03 PM - edited Jan 25 2020 10:05 PM
I am trying to do the reverse of what I have attached. This is a very basic set of formulas that start with a base premium, then add in a state tax that is the base premium + 2 fees (they can vary every year) multiplied by a set percentage. Then do the exact same with a second percentage (another tax) of the base + the 2 fees. I can input the base premium and come up with the final every time with no issue. What I am trying to do is the exact opposite, start with the final number (including all fees and taxes) and let it tell me what each percentage is, and ultimately the base premium. It will save a ton of time trying to back into numbers to get the final desired outcome.
Any help would be greatly appreciated. I am by no means an excel wizard (obviously) but do better than most.
Thanks
Jan 25 2020 10:31 PM
SolutionHi @Josh Ranew
You may use below formula that will tell base premium on the basis of final premium:
=((C15-C11)/(1+C9+C10))-C7-C8
Revised file is also attached for your reference, hope it will be helpful.
Thanks
Tauqeer
Jan 25 2020 10:51 PM - edited Jan 25 2020 10:52 PM
Thank you so much! I have been beating my head against the wall on this one. I knew it was simple (really simple now that i see it) but I just couldn't get it!
Thanks
Jan 25 2020 10:31 PM
SolutionHi @Josh Ranew
You may use below formula that will tell base premium on the basis of final premium:
=((C15-C11)/(1+C9+C10))-C7-C8
Revised file is also attached for your reference, hope it will be helpful.
Thanks
Tauqeer