Following the "Total Taxable Income" and "Total Income Tax" calculations --
setup a new tax rate (same exact calculations) for the rows
1. "TOTAL AMOUNTS FOR PREFERENTIAL CAPITAL GAIN RATES" (links to calc worksheet for new rate calculation that you add)
2. "Total Capital Gain Tax" (pulls from the calc worksheet based on rate calculation).
This is already setup, you are just setting it up for a different rate schedule for this different calculation. So, you just need to follow the calculations that are there.
Preferably someone who understands the named ranges and v-lookup since that's what the calculations are.
See 3 minute video going over it here: [login to view URL]
52 freelancers are bidding on average $23 for this job
Hello Sir/Maam. I want to help you with your tax calculation template. I have done similar project in the past. And I assure you with high quality output.
I will deliver the wanted work in high quality without any mistakes and in quickly as possible Relevant Skills and Experience I have high experience in accounting and data entry (excel sheets)
I am student of bachelor of commerce and i can do all jobs realated to this. Relevant Skills and Experience I have experience of 5yrs on ms Excel , ms office and i also work in tally.
I'm very hard working man I've good typing skills i'll complete my task in the given time . I'll be furnished according to your demand. You will must be happy about my working.