Aging of contributions receivable

The following represents the aging of contributions receivable for McKenzie Health Foundation for

the historical years ended June $30,2020,2019,2018,2017,2016,$ and $2015.$ Contributions receivable

vary significantly by year; however, contribution revenue has been fairly stable over the five$-$year

period.

Fiscal Year$-$End

$6/30/20206/30/20196/30/20186/30/20176/30/20166/30/2015$

Total contributions receivable $$995,800$ $$1,306,220$ $$942,300$ $$1,840,300$ $$566,200$ $$446,250$

Allowance for uncollectible contributions $28,67136,28126,53462,31119,81717,670$

Total contribution revenue $21,545,46022,505,38220,501,49022,559,54422,418,37622,087,080$

Aging of contributions receivable

$030$ days $$494,000$ $$357,200$ $$414,200$ $$1,400,300$ $$566,200$ $$413,250$

$3160$ days $28,600468,600319,000440,000033,000$

$6190$ days $418,200480,420209,100000$

$>90$ days $55,00000000$

$$995,800$ $$1,306,220$ $$942,300$ $$1,840,300$ $$566,200$ $$446,250$

a$)$ Prepare a report showing the allowance as a percentage of receivables and receivables as a

percentage of contribution revenue.

Round percentages to one decimal.

Fiscal Year$-$End

$6/30/20206/30/20196/30/20186/30/20176/30/20166/30/2015$

Allowance as a percentage of receivables Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Receivables as a percentage of contribution revenue Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

b$)$ Prepare a report showing the percentage of receivables in each aging category.

Round percentages to one decimal.

Fiscal Year$-$End

$6/30/20206/30/20196/30/20186/30/20176/30/20166/30/2015$

Aging of contributions receivable

$030$ days Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

$3160$ days Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

$6190$ days Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

$>90$ days Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$

Answer

$0$