Thanks for creating this nearly 3 years ago. I can’t believe I missed this gold nugget. I know NY is a bit different with the tax on tax so is it possible to create an explicit CCR formula for NY with $0 DAS? In my exploration on this exact topic, the only way I could make it work is with the solver in Excel.
Many thanks for your kind words. Much appreciated!
Yes. I haven’t done it for NY. Let me get into it and I’ll get back to you within the next day or so and provide you with the formula.
Kindest regards,
John
1 Like
Below is an update and improved version that includes detailed explanations and amends a few very minor errors.
Calculating NY CCR, Payment, Taxes.pdf (449.5 KB)
1 Like
Thank you! That explains the dark art perfectly.
You’e very welcome.