(15 points) The organization held a fundraising campaign in August to raise money for the construction of an education building. The campaign asked for donations to be given over a four wear period. One of the fundraising efforts was to send a mass mailing to everyone who donated to the Church during the past three years. Due to the mass mailing, the following promises to give were received by the Church: a. Becky Smith $10,000 per year b. William Scott $25,000 per year c. Scot King - $35,000 per year d. Beth Wilson $15,000 per year e. Thomas Ladd - $1,000,000 one-time gift f. Betsey Johnson - $5,000 per year g. Kelly Williams -- $75,000 per year h. Margaret Frye $55,000 per year i. Joe Lewis $25,000 per year j. Tommy White $15,000 per year a. Using Excel, prepare a schedule of promises to give. b. Using historical data from past campaigns, you estimate that 3% of pledges will not be received. Calculate the amount deemed uncollectible. c. Calculate and record the discount amount of the future pledges receivable using a discount rate of 3%. d. Prepare the journal entry(ies) to record the above activity. (15 points) The organization held a fundraising campaign in August to raise money for the construction of an education building. The campaign asked for donations to be given over a four wear period. One of the fundraising efforts was to send a mass mailing to everyone who donated to the Church during the past three years. Due to the mass mailing, the following promises to give were received by the Church: a. Becky Smith $10,000 per year b. William Scott $25,000 per year c. Scot King - $35,000 per year d. Beth Wilson $15,000 per year e. Thomas Ladd - $1,000,000 one-time gift f. Betsey Johnson - $5,000 per year g. Kelly Williams -- $75,000 per year h. Margaret Frye $55,000 per year i. Joe Lewis $25,000 per year j. Tommy White $15,000 per year a. Using Excel, prepare a schedule of promises to give. b. Using historical data from past campaigns, you estimate that 3% of pledges will not be received. Calculate the amount deemed uncollectible. c. Calculate and record the discount amount of the future pledges receivable using a discount rate of 3%. d. Prepare the journal entry(ies) to record the above activity