A charity I work with has received $250,000 in tax credits to issue to their donors. This means that, when a donor gives a contribution, they receive a credit equal to 50% of their gift.
- John Smith gives $1000
- he receives a tax credit equal to half his donation (in this case $500)
I need an excel spreadsheet that can track:
1. Who the donor is (name cell - the spreadsheet user keys in: John Smith)
2. How much the donor has donated (data input cell - the spreadsheet user keys in: $1000)
3. What amount of tax credit the donor is entitled to (calculation cell: donation x .50)
4. How many tax credits remain (if the above were the only gift, this would be $249,500). There will be many gifts: I need the "Remaining Tax Credits" to keep track of this.
25 freelanceria on tarjonnut keskimäärin 21 $ tähän työhön
Hi, Mathematics, Statistics, MS Excel, MS Access & VBA expert with over 8 years of experience.Understood the requirements and ready to start. Can update and work as desired. Thanks
Hey, I'm interested in your project. Please send me message so that we can discuss more details over it. I have 4 years of working experience in this field.