| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | This sheet calculates the amount to donate based on the cost AFTER tax credits are applied. | ||||||
2 | Enter values in the yellow highlighted cells. | ||||||
3 | |||||||
4 | DONATION TYPE | BCASF - 1 Time | BCASF - Monthly | Direct to KPC - 1 Time | KPC - Monthly | ||
5 | KPC % | 95% | 95% | 100% | 100% | ||
6 | Tax-Receipt | YES | YES | NO | NO | ||
7 | |||||||
8 | * I'D LIKE TO CONTRIBUTE: | $500.00 | |||||
9 | |||||||
10 | ** ANNUAL INCOME | <$250K | - | - | - | ||
11 | >$250K | - | - | - | |||
12 | |||||||
13 | # of Months (5 years = 60 months) | - | 60 | - | 1 | ||
14 | |||||||
15 | AMOUNT TO DONATE | $827.31 | $0.00 | $500.00 | $8.33 | ||
16 | TOTAL DONATED | $827.31 | $0.00 | $500.00 | $8.33 | ||
17 | |||||||
18 | TAX CREDIT | $327.31 | $0.00 | $0.00 | $0.00 | ||
19 | |||||||
20 | *** COST TO KPC | $41.37 | #NUM! | $0.00 | $0.06 | ||
21 | |||||||
22 | TOTAL COST TO YOU | $500.00 | $500.00 | $500.00 | $500.00 | ||
23 | |||||||
24 | KPC RECEIVES | $785.94 | #NUM! | $500.00 | $8.28 | ||
25 | |||||||
26 | * Enter the amount you'd like to contribute in total across all donations AFTER tax credits are applied. For monthly donations, the calculator will determine the amount to donate each month based on the number of months you enter (note that it assumes donations are split evenly across years). | ||||||
27 | ** Choose one. Annual incomes between approx. $247K - $253K receive a slightly different tax credit. | ||||||
28 | *** Cost to KPC includes a 5% fee to BCASF for all donations. Cost for monthly donations includes an 8% annual interest charge on the outstanding amount of the total commitment for the cost of bank financing plus a contingency for any donations that default prior to the full amount being donated. | ||||||
29 | |||||||