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.
Đã trao cho:
25 freelancer đang chào giá trung bình $21 cho công việc này
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