Form990-PF

Department of the Treasury
Internal Revenue Service

Return of Private Foundation
or Section 4947(a)(1) Trust Treated as Private Foundation
bulletDo not enter social security numbers on this form as it may be made public.
bulletGo to www.irs.gov/Form990PF for instructions and the latest information.
OMB No. 1545-0052
2019
Open to Public Inspection
For calendar year 2019, or tax year beginning 11-01-2017 , and ending 10-31-2018
Name of foundation
THE NORMAN AND ESTHER ALLAN FOUNDATION
 
Number and street (or P.O. box number if mail is not delivered to street address)27777 FRANKLIN ROAD SUITE 2500
 
Room/suite
City or town, state or province, country, and ZIP or foreign postal code
SOUTHFIELD, MI480348214
A Employer identification number

38-6089688
B Telephone number (see instructions)

(248) 351-3000
C bullet
G Check all that apply:

D 1. Foreign organizations, check here............. bullet
2. Foreign organizations meeting the 85%
test, check here and attach computation ...
bullet
E bullet
H Check type of organization:
F bullet
I Fair market value of all assets at end
of year (from Part II, col. (c),
line 16)bullet$2,085,263
J Accounting method:
 
(Part I, column (d) must be on cash basis.)
Part I Analysis of Revenue and Expenses (The total of amounts in columns (b), (c), and (d) may not necessarily equal the amounts in column (a) (see instructions).) (a) Revenue and
expenses per
books
(b) Net investment
income
(c) Adjusted net
income
(d) Disbursements
for charitable
purposes
(cash basis only)
Revenue 1 Contributions, gifts, grants, etc., received (attach schedule) 101,501
2 Check bullet.............
3 Interest on savings and temporary cash investments 15,096 15,096  
4 Dividends and interest from securities... 75,809 75,809  
5a Gross rents............      
b Net rental income or (loss)  
6a Net gain or (loss) from sale of assets not on line 10 339,224
b Gross sales price for all assets on line 6a 1,955,386
7 Capital gain net income (from Part IV, line 2)... 339,224
8 Net short-term capital gain.........  
9 Income modifications...........  
10a Gross sales less returns and allowances  
b Less: Cost of goods sold....  
c Gross profit or (loss) (attach schedule).....    
11 Other income (attach schedule).......      
12 Total. Add lines 1 through 11........ 531,630 430,129  
Operating and Administrative Expenses 13 Compensation of officers, directors, trustees, etc. 0 0   0
14 Other employee salaries and wages......        
15 Pension plans, employee benefits.......        
16a Legal fees (attach schedule)......... 5,903 0   0
b Accounting fees (attach schedule)....... 3,685 0   0
c Other professional fees (attach schedule)....        
17 Interest...............        
18 Taxes (attach schedule) (see instructions)... 4,365 89   0
19 Depreciation (attach schedule) and depletion...      
20 Occupancy..............        
21 Travel, conferences, and meetings.......        
22 Printing and publications..........        
23 Other expenses (attach schedule)....... 29,265 29,245   0
24 Total operating and administrative expenses.
Add lines 13 through 23.......... 43,218 29,334   0
25 Contributions, gifts, grants paid....... 1,125,000 1,125,000
26 Total expenses and disbursements. Add lines 24 and 25 1,168,218 29,334   1,125,000
27 Subtract line 26 from line 12:
a Excess of revenue over expenses and disbursements -636,588
b Net investment income (if negative, enter -0-) 400,795
c Adjusted net income (if negative, enter -0-)...  
For Paperwork Reduction Act Notice, see instructions.
Cat. No. 11289X Form 990-PF (2019)
Form 990-PF (2019)
Page 2
Part II Balance Sheets Attached schedules and amounts in the description column
should be for end-of-year amounts only. (See instructions.)
Beginning of year End of year
(a) Book Value (b) Book Value (c) Fair Market Value
Assets 1 Cash—non-interest-bearing.............      
2 Savings and temporary cash investments......... 80,676    
3 Accounts receivable bullet  
Less: allowance for doubtful accounts bullet        
4 Pledges receivable bullet  
Less: allowance for doubtful accounts bullet        
5 Grants receivable.................      
6 Receivables due from officers, directors, trustees, and other
disqualified persons (attach schedule) (see instructions).....      
7 Other notes and loans receivable (attach schedule) bullet  
Less: allowance for doubtful accounts bullet        
8 Inventories for sale or use..............      
9 Prepaid expenses and deferred charges..........      
10a Investments—U.S. and state government obligations (attach schedule) 442,118 Click to see attachment381,614 364,753
b Investments—corporate stock (attach schedule)....... 1,225,667 Click to see attachment899,883 1,113,401
c Investments—corporate bonds (attach schedule)....... 0 Click to see attachment43,821 42,218
11 Investments—land, buildings, and equipment: basis bullet  
Less: accumulated depreciation (attach schedule) bullet        
12 Investments—mortgage loans.............      
13 Investments—other (attach schedule).......... 779,853 Click to see attachment573,237 564,891
14 Land, buildings, and equipment: basis bullet  
Less: accumulated depreciation (attach schedule) bullet        
15 Other assets (describe bullet)      
16 Total assets (to be completed by all filers—see the
instructions. Also, see page 1, item I) 2,528,314 1,898,555 2,085,263
Liabilities 17 Accounts payable and accrued expenses..........   41,464
18 Grants payable.................    
19 Deferred revenue.................    
20 Loans from officers, directors, trustees, and other disqualified persons    
21 Mortgages and other notes payable (attach schedule)......    
22 Other liabilities (describe bullet)    
23 Total liabilities (add lines 17 through 22)......... 0 41,464
Net Assets or Fund Balances Foundations that follow FASB ASC 958, check here bullet
and complete lines 24, 25, 29 and 30.
24 Net assets without donor restrictions...........    
25 Net assets with donor restrictions............    
Foundations that do not follow FASB ASC 958, check here bullet
and complete lines 26 through 30.
26 Capital stock, trust principal, or current funds........ 0 0
27 Paid-in or capital surplus, or land, bldg., and equipment fund 0 0
28 Retained earnings, accumulated income, endowment, or other funds 2,528,314 1,857,091
29 Total net assets or fund balances (see instructions)..... 2,528,314 1,857,091
30 Total liabilities and net assets/fund balances (see instructions). 2,528,314 1,898,555
Part III
Analysis of Changes in Net Assets or Fund Balances
1
Total net assets or fund balances at beginning of year—Part II, column (a), line 29 (must agree with end-of-year figure reported on prior year’s return) ...............
1
2,528,314
2
Enter amount from Part I, line 27a .....................
2
-636,588
3
Other increases not included in line 2 (itemize) bullet
3
0
4
Add lines 1, 2, and 3 ..........................
4
1,891,726
5
Decreases not included in line 2 (itemize) bulletClick to see attachment
5
34,635
6
Total net assets or fund balances at end of year (line 4 minus line 5)—Part II, column (b), line 29 .
6
1,857,091
Form 990-PF (2019)
Form 990-PF (2019)
Page 3
Part IV
Capital Gains and Losses for Tax on Investment Income
(a) List and describe the kind(s) of property sold (e.g., real estate,
2-story brick warehouse; or common stock, 200 shs. MLC Co.)
(b)
How acquired
P—Purchase
D—Donation
(c)
Date acquired
(mo., day, yr.)
(d)
Date sold
(mo., day, yr.)
1 a PUBLICLY TRADED SEC-MERRILL LYNCH #689-03038 P    
b PUBLICLY TRADED SEC-MERRILL LYNCH #689-04532 P    
c PUBLICLY TRADED SEC-MERRILL LYNCH #689-04532 P    
d PUBLICLY TRADED SEC-MERRILL LYNCH #689-03781 P    
e PUBLICLY TRADED SEC-MERRILL LYNCH #689-03780 P    
PUBLICLY TRADED SEC-MERRILL LYNCH #689-03780(CIL) P    
PUBLICLY TRADED SEC-MERRILL LYNCH #689-03036 P    
PUBLICLY TRADED SEC-MERRILL LYNCH #689-03036(CIL) P    
PUBLICLY TRADED SEC-MERRILL LYNCH #689-03039 P    
PUBLICLY TRADED SEC-MERRILL LYNCH #689-04662 P    
PUBLICLY TRADED SEC-MERRILL LYNCH #689-03781(CIL) P    
(e)
Gross sales price
(f)
Depreciation allowed
(or allowable)
(g)
Cost or other basis
plus expense of sale
(h)
Gain or (loss)
(e) plus (f) minus (g)
a 193,752   211,845 -18,093
b 20,119   20,232 -113
c 15     15
d 225,923   149,930 75,993
e 489,313   379,999 109,314
49     49
609,207   418,674 190,533
10     10
394,279   412,051 -17,772
22,655   23,431 -776
64     64
Complete only for assets showing gain in column (h) and owned by the foundation on 12/31/69 (l)
Gains (Col. (h) gain minus
col. (k), but not less than -0-) or
Losses (from col.(h))
(i)
F.M.V. as of 12/31/69
(j)
Adjusted basis
as of 12/31/69
(k)
Excess of col. (i)
over col. (j), if any
a       -18,093
b       -113
c       15
d       75,993
e       109,314
      49
      190,533
      10
      -17,772
      -776
      64
2 Capital gain net income or (net capital loss) Bracket If gain, also enter in Part I, line 7
If (loss), enter -0- in Part I, line 7
Bracket 2 339,224
3 Net short-term capital gain or (loss) as defined in sections 1222(5) and (6):
If gain, also enter in Part I, line 8, column (c) (see instructions). If (loss), enter -0-
in Part I, line 8 ...................
Bracket 3  
Part V
Qualification Under Section 4940(e) for Reduced Tax on Net Investment Income
(For optional use by domestic private foundations subject to the section 4940(a) tax on net investment income.)

If section 4940(d)(2) applies, leave this part blank.
Was the foundation liable for the section 4942 tax on the distributable amount of any year in the base period?
If "Yes," the foundation does not qualify under section 4940(e). Do not complete this part.
1 Enter the appropriate amount in each column for each year; see instructions before making any entries.
(a)
Base period years Calendar
year (or tax year beginning in)
(b)
Adjusted qualifying distributions
(c)
Net value of noncharitable-use assets
(d)
Distribution ratio
(col. (b) divided by col. (c))
2018 84,500 2,799,015 0.030189
2017 222,207 2,732,193 0.081329
2016 138,371 2,903,254 0.047661
2015 115,000 2,906,928 0.039561
2014 100,000 2,547,701 0.039251
2
Total of line 1, column (d) .....................
2
0.237991
3
Average distribution ratio for the 5-year base period—divide the total on line 2 by 5.0, or by the number of years the foundation has been in existence if less than 5 years ......
3
0.047598
4
Enter the net value of noncharitable-use assets for 2019 from Part X, line 5......
4
2,868,309
5
Multiply line 4 by line 3......................
5
136,526
6
Enter 1% of net investment income (1% of Part I, line 27b)...........
6
4,008
7
Add lines 5 and 6........................
7
140,534
8
Enter qualifying distributions from Part XII, line 4,.............
8
1,125,000
If line 8 is equal to or greater than line 7, check the box in Part VI, line 1b, and complete that part using a 1% tax rate. See the Part VI instructions.
Form 990-PF (2019)
Form 990-PF (2019)
Page 4
Part VI
Excise Tax Based on Investment Income (Section 4940(a), 4940(b), 4940(e), or 4948—see instructions)
1a Exempt operating foundations described in section 4940(d)(2), check here Bullet and enter “N/A" on line 1. Bracket includes lines 1a and 1b
Date of ruling or determination letter:   (attach copy of letter if necessary–see instructions)
b Domestic foundations that meet the section 4940(e) requirements in Part V, check 1 4,008
hereBulletand enter 1% of Part I, line 27b...................
c All other domestic foundations enter 2% of line 27b. Exempt foreign organizations enter 4% of Part I, line 12, col. (b)
2 Tax under section 511 (domestic section 4947(a)(1) trusts and taxable foundations only. Others enter -0-) 2 0
3 Add lines 1 and 2........................... 3 4,008
4 Subtitle A (income) tax (domestic section 4947(a)(1) trusts and taxable foundations only. Others enter -0-) 4 0
5 Tax based on investment income. Subtract line 4 from line 3. If zero or less, enter -0- ..... 5 4,008
6 Credits/Payments:
a 2019 estimated tax payments and 2018 overpayment credited to 2019 6a 3,200
b Exempt foreign organizations—tax withheld at source...... 6b
c Tax paid with application for extension of time to file (Form 8868)... 6c 0
d Backup withholding erroneously withheld ........... 6d 0
7 Total credits and payments. Add lines 6a through 6d.............. 7 3,200
8 Enter any penalty for underpayment of estimated tax. Check here if Form 2220 is attached. 8 0
9 Tax due. If the total of lines 5 and 8 is more than line 7, enter amount owed.......Bullet 9 808
10 Overpayment. If line 7 is more than the total of lines 5 and 8, enter the amount overpaid...Bullet 10  
11 Enter the amount of line 10 to be: Credited to 2020 estimated taxBullet   RefundedBullet 11  
Part VII-A
Statements Regarding Activities
1a
During the tax year, did the foundation attempt to influence any national, state, or local legislation or did
Yes
No
it participate or intervene in any political campaign? ....................
1a
 
No
b
Did it spend more than $100 during the year (either directly or indirectly) for political purposes? (see Instructions
for definition).................................
1b
 
No
If the answer is "Yes" to 1a or 1b, attach a detailed description of the activities and copies of any materials
published or distributed by the foundation in connection with the activities.
c
Did the foundation file Form 1120-POL for this year?.....................
1c
 
No
d
Enter the amount (if any) of tax on political expenditures (section 4955) imposed during the year:
(1) On the foundation. bullet$ 0(2) On foundation managers.bullet$ 0
e
Enter the reimbursement (if any) paid by the foundation during the year for political expenditure tax imposed
on foundation managers.bullet$ 0
2
Has the foundation engaged in any activities that have not previously been reported to the IRS?.......
2
 
No
If "Yes," attach a detailed description of the activities.
3
Has the foundation made any changes, not previously reported to the IRS, in its governing instrument, articles
of incorporation, or bylaws, or other similar instruments? If "Yes," attach a conformed copy of the changes....
3
 
No
4a
Did the foundation have unrelated business gross income of $1,000 or more during the year?........
4a
 
No
b
If "Yes," has it filed a tax return on Form 990-T for this year?...................
4b
 
 
5
Was there a liquidation, termination, dissolution, or substantial contraction during the year?.........
5
 
No
If "Yes," attach the statement required by General Instruction T.
6
Are the requirements of section 508(e) (relating to sections 4941 through 4945) satisfied either:
  • By language in the governing instrument, or
  • By state legislation that effectively amends the governing instrument so that no mandatory directions
  • that conflict with the state law remain in the governing instrument?................
    6
    Yes
     
    7
    Did the foundation have at least $5,000 in assets at any time during the year? If "Yes," complete Part II, col. (c),
    and Part XV..................................
    7
    Yes
     
    8a
    Enter the states to which the foundation reports or with which it is registered (see instructions)
    bulletMI
    b
    If the answer is "Yes" to line 7, has the foundation furnished a copy of Form 990-PF to the Attorney
    General (or designate) of each state as required by General Instruction G? If "No," attach explanation .
    8b
    Yes
     
    9
    Is the foundation claiming status as a private operating foundation within the meaning of section 4942(j)(3)
    or 4942(j)(5) for calendar year 2019 or the taxable year beginning in 2019? See the instructions for Part XIV.
    If "Yes," complete Part XIV .............................
    9
     
    No
    10
    Did any persons become substantial contributors during the tax year? If "Yes," attach a schedule listing their names
    and addresses. ...............................
    10
     
    No
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 5
    Part VII-A
    Statements Regarding Activities (continued)
    11
    At any time during the year, did the foundation, directly or indirectly, own a controlled entity within the
    meaning of section 512(b)(13)? If "Yes," attach schedule. See instructions .............
    11
     
    No
    12
    Did the foundation make a distribution to a donor advised fund over which the foundation or a disqualified person had
    advisory privileges? If "Yes," attach statement. See instructions.................
    12
     
    No
    13
    Did the foundation comply with the public inspection requirements for its annual returns and exemption application?
    13
    Yes
     
    Website addressbulletN/A
    14
    The books are in care ofbulletJAFFE RAITT HEUER WEISS PC Telephone no.bullet (248) 351-3000

    Located atbullet27777 FRANKLIN ROAD SUITE 2500SOUTHFIELDMI ZIP+4bullet480345026
    15
    Section 4947(a)(1) nonexempt charitable trusts filing Form 990-PF in lieu of Form 1041 —check here .........bullet
    and enter the amount of tax-exempt interest received or accrued during the year ........bullet
    15
     
    16 At any time during calendar year 2019, did the foundation have an interest in or a signature or other authority over YesNo
    a bank, securities, or other financial account in a foreign country? .................
    16   No
    See the instructions for exceptions and filing requirements for FinCEN Form 114. If "Yes", enter the name of the foreign
    country bullet
    Part VII-B
    Statements Regarding Activities for Which Form 4720 May Be Required
    File Form 4720 if any item is checked in the "Yes" column, unless an exception applies.
    Yes
    No
    1a
    During the year did the foundation (either directly or indirectly):
    (1) Engage in the sale or exchange, or leasing of property with a disqualified person?
    (2) Borrow money from, lend money to, or otherwise extend credit to (or accept it from)
    a disqualified person?......................
    (3) Furnish goods, services, or facilities to (or accept them from) a disqualified person?
    (4) Pay compensation to, or pay or reimburse the expenses of, a disqualified person?
    (5) Transfer any income or assets to a disqualified person (or make any of either available
    for the benefit or use of a disqualified person)?...............
    (6) Agree to pay money or property to a government official? (Exception. Check "No"
    if the foundation agreed to make a grant to or to employ the official for a period
    after termination of government service, if terminating within 90 days.).......
    b
    If any answer is "Yes" to 1a(1)–(6), did any of the acts fail to qualify under the exceptions described in Regulations
    section 53.4941(d)-3 or in a current notice regarding disaster assistance? See instructions ........
    1b
     
     
    ........bullet
    c
    Did the foundation engage in a prior year in any of the acts described in 1a, other than excepted acts,
    that were not corrected before the first day of the tax year beginning in 2019?.............
    1c
     
    No
    2
    Taxes on failure to distribute income (section 4942) (does not apply for years the foundation was a private
    operating foundation defined in section 4942(j)(3) or 4942(j)(5)):
    a
    At the end of tax year 2019, did the foundation have any undistributed income (lines 6d
    and 6e, Part XIII) for tax year(s) beginning before 2019?.............
    If "Yes," list the years bullet20, 20, 20, 20
    b
    Are there any years listed in 2a for which the foundation is not applying the provisions of section 4942(a)(2)
    (relating to incorrect valuation of assets) to the year’s undistributed income? (If applying section 4942(a)(2)
    to all years listed, answer "No" and attach statement—see instructions.) ..............
    2b
     
     
    c
    If the provisions of section 4942(a)(2) are being applied to any of the years listed in 2a, list the years here.
    bullet20, 20, 20, 20
    3a
    Did the foundation hold more than a 2% direct or indirect interest in any business enterprise at
    any time during the year?......................
    b
    If "Yes," did it have excess business holdings in 2019 as a result of (1) any purchase by the foundation
    or disqualified persons after May 26, 1969; (2) the lapse of the 5-year period (or longer period approved
    by the Commissioner under section 4943(c)(7)) to dispose of holdings acquired by gift or bequest; or (3)
    the lapse of the 10-, 15-, or 20-year first phase holding period? (Use Schedule C, Form 4720, to determine
    if the foundation had excess business holdings in 2019.)..................
    3b
     
     
    4a
    Did the foundation invest during the year any amount in a manner that would jeopardize its charitable purposes?
    4a
     
    No
    b
    Did the foundation make any investment in a prior year (but after December 31, 1969) that could jeopardize its
    charitable purpose that had not been removed from jeopardy before the first day of the tax year beginning in 2019?
    4b
     
    No
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 6
    Part VII-B
    Statements Regarding Activities for Which Form 4720 May Be Required (continued)
    5a
    During the year did the foundation pay or incur any amount to:
    Yes
    No
    (1) Carry on propaganda, or otherwise attempt to influence legislation (section 4945(e))?
    (2) Influence the outcome of any specific public election (see section 4955); or to carry
    on, directly or indirectly, any voter registration drive?.............
    (3) Provide a grant to an individual for travel, study, or other similar purposes?
    (4) Provide a grant to an organization other than a charitable, etc., organization described
    in section 4945(d)(4)(A)? See instructions................
    (5) Provide for any purpose other than religious, charitable, scientific, literary, or
    educational purposes, or for the prevention of cruelty to children or animals?.....
    b
    If any answer is "Yes" to 5a(1)–(5), did any of the transactions fail to qualify under the exceptions described in
    Regulations section 53.4945 or in a current notice regarding disaster assistance? See instructions ......
    5b
     
     
    .........bullet
    c
    If the answer is "Yes" to question 5a(4), does the foundation claim exemption from the
    tax because it maintained expenditure responsibility for the grant?..........
    If "Yes," attach the statement required by Regulations section 53.4945–5(d).
    6a
    Did the foundation, during the year, receive any funds, directly or indirectly, to pay premiums on
    a personal benefit contract?.....................
    b
    Did the foundation, during the year, pay premiums, directly or indirectly, on a personal benefit contract? ....
    6b
     
    No
    If "Yes" to 6b, file Form 8870.
    7a
    At any time during the tax year, was the foundation a party to a prohibited tax shelter transaction?
    b
    If "Yes", did the foundation receive any proceeds or have any net income attributable to the transaction? ....
    7b
     
     
    8
    Is the foundation subject to the section 4960 tax on payment(s) of more than $1,000,000 in remuneration or
    excess parachute payment during the year? .................
    Part VIII
    Information About Officers, Directors, Trustees, Foundation Managers, Highly Paid Employees,
    and Contractors
    1 List all officers, directors, trustees, foundation managers and their compensation. See instructions
    (a) Name and address (b) Title, and average
    hours per week
    devoted to position
    (c) Compensation
    (If not paid, enter
    -0-)
    (d) Contributions to employee benefit plans and deferred compensation (e) Expense account,
    other allowances
    ARTHUR A WEISS TRUSTEE
    0.00
    0 0 0
    27777 FRANKLIN ROAD SUITE 2500
    SOUTHFIELD,MI480348214
    IRA J JAFFE PRESIDENT/TREASURER/TRUSTE
    1.00
    0 0 0
    27777 FRANKLIN ROAD SUITE 2500
    SOUTHFIELD,MI480348214
    JOEL S GOLDEN SECRETARY/TRUSTEE
    1.00
    0 0 0
    27777 FRANKLIN ROAD SUITE 2500
    SOUTHFIELD,MI480348214
    2 Compensation of five highest-paid employees (other than those included on line 1—see instructions). If none, enter “NONE."
    (a) Name and address of each employee paid more than $50,000 (b) Title, and average
    hours per week
    devoted to position
    (c) Compensation (d) Contributions to
    employee benefit
    plans and deferred
    compensation
    (e) Expense account,
    other allowances
    NONE
    Total number of other employees paid over $50,000...................bullet 0
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 7
    Part VIII
    Information About Officers, Directors, Trustees, Foundation Managers, Highly Paid Employees,
    and Contractors (continued)
    3 Five highest-paid independent contractors for professional services (see instructions). If none, enter "NONE".
    (a) Name and address of each person paid more than $50,000 (b) Type of service (c) Compensation
    NONE
    Total number of others receiving over $50,000 for professional services.............bullet0
    Part IX-A
    Summary of Direct Charitable Activities
    List the foundation’s four largest direct charitable activities during the tax year. Include relevant statistical information such as the number of organizations and other beneficiaries served, conferences convened, research papers produced, etc. Expenses
    1 N/A 0
    2  
    3  
    4  
    Part IX-B
    Summary of Program-Related Investments (see instructions)
    Describe the two largest program-related investments made by the foundation during the tax year on lines 1 and 2. Amount
    1 N/A 0
    2  
    All other program-related investments. See instructions.
    3  
    Total. Add lines 1 through 3.........................bullet0
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 8
    Part X
    Minimum Investment Return (All domestic foundations must complete this part. Foreign foundations, see instructions.)
    1
    Fair market value of assets not used (or held for use) directly in carrying out charitable, etc.,
    purposes:
    a
    Average monthly fair market value of securities...................
    1a
    2,807,173
    b
    Average of monthly cash balances.......................
    1b
    104,816
    c
    Fair market value of all other assets (see instructions)................
    1c
    0
    d
    Total (add lines 1a, b, and c).........................
    1d
    2,911,989
    e
    Reduction claimed for blockage or other factors reported on lines 1a and
    1c (attach detailed explanation) .............
    1e
    0
    2
    Acquisition indebtedness applicable to line 1 assets..................
    2
    0
    3
    Subtract line 2 from line 1d.........................
    3
    2,911,989
    4
    Cash deemed held for charitable activities. Enter 1 1/2% of line 3 (for greater amount, see
    instructions) .............................
    4
    43,680
    5
    Net value of noncharitable-use assets. Subtract line 4 from line 3. Enter here and on Part V, line 4
    5
    2,868,309
    6
    Minimum investment return. Enter 5% of line 5..................
    6
    143,415
    Part XI
    Distributable Amount (see instructions) (Section 4942(j)(3) and (j)(5) private operating foundations and certain foreign organizations check here right arrow and do not complete this part.)
    1
    Minimum investment return from Part X, line 6....................
    1
    143,415
    2a
    Tax on investment income for 2019 from Part VI, line 5......
    2a
    4,008
    b
    Income tax for 2019. (This does not include the tax from Part VI.)...
    2b
     
    c
    Add lines 2a and 2b............................
    2c
    4,008
    3
    Distributable amount before adjustments. Subtract line 2c from line 1............
    3
    139,407
    4
    Recoveries of amounts treated as qualifying distributions................
    4
    0
    5
    Add lines 3 and 4............................
    5
    139,407
    6
    Deduction from distributable amount (see instructions).................
    6
    0
    7
    Distributable amount as adjusted. Subtract line 6 from line 5. Enter here and on Part XIII, line 1 ...
    7
    139,407
    Part XII
    Qualifying Distributions (see instructions)
    1
    Amounts paid (including administrative expenses) to accomplish charitable, etc., purposes:
    a
    Expenses, contributions, gifts, etc.—total from Part I, column (d), line 26 ..........
    1a
    1,125,000
    b
    Program-related investments—total from Part IX-B..................
    1b
    0
    2
    Amounts paid to acquire assets used (or held for use) directly in carrying out charitable, etc.,
    purposes...............................
    2
     
    3
    Amounts set aside for specific charitable projects that satisfy the:
    a
    Suitability test (prior IRS approval required)....................
    3a
     
    b
    Cash distribution test (attach the required schedule) .................
    3b
     
    4
    Qualifying distributions. Add lines 1a through 3b. Enter here and on Part V, line 8, and Part XIII, line 4
    4
    1,125,000
    5
    Foundations that qualify under section 4940(e) for the reduced rate of tax on net investment
    income. Enter 1% of Part I, line 27b. See instructions.................
    5
    4,008
    6
    Adjusted qualifying distributions. Subtract line 5 from line 4..............
    6
    1,120,992
    Note: The amount on line 6 will be used in Part V, column (b), in subsequent years when calculating whether the foundation qualifies for
    the section 4940(e) reduction of tax in those years.
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 9
    Part XIII
    Undistributed Income (see instructions)
    (a)
    Corpus
    (b)
    Years prior to 2018
    (c)
    2018
    (d)
    2019
    1 Distributable amount for 2019 from Part XI, line 7 139,407
    2 Undistributed income, if any, as of the end of 2019:
    a Enter amount for 2018 only....... 105,171
    b Total for prior years:20, 20, 20 0
    3 Excess distributions carryover, if any, to 2019:
    a From 2014......  
    b From 2015......  
    c From 2016......  
    d From 2017......  
    e From 2018......  
    fTotal of lines 3a through e........ 0
    4Qualifying distributions for 2019 from Part
    XII, line 4: bullet$ 1,125,000
    a Applied to 2018, but not more than line 2a 105,171
    b Applied to undistributed income of prior years
    (Election required—see instructions).....
    0
    c Treated as distributions out of corpus (Election
    required—see instructions)........
    0
    d Applied to 2019 distributable amount..... 139,407
    e Remaining amount distributed out of corpus 880,422
    5 Excess distributions carryover applied to 2019. 0 0
    (If an amount appears in column (d), the
    same amount must be shown in column (a).)
    6Enter the net total of each column as
    indicated below:
    a Corpus. Add lines 3f, 4c, and 4e. Subtract line 5 880,422
    b Prior years’ undistributed income. Subtract
    line 4b from line 2b ..........
    0
    c Enter the amount of prior years’ undistributed
    income for which a notice of deficiency has
    been issued, or on which the section 4942(a)
    tax has been previously assessed......
    0
    d Subtract line 6c from line 6b. Taxable amount
    —see instructions ...........
    0
    e Undistributed income for 2018. Subtract line
    4a from line 2a. Taxable amount—see
    instructions .............
    0
    f Undistributed income for 2019. Subtract
    lines 4d and 5 from line 1. This amount must
    be distributed in 2020 ..........
    0
    7 Amounts treated as distributions out of
    corpus to satisfy requirements imposed by
    section 170(b)(1)(F) or 4942(g)(3) (Election may
    be required - see instructions) .......
    0
    8 Excess distributions carryover from 2014 not
    applied on line 5 or line 7 (see instructions) ...
    0
    9Excess distributions carryover to 2020.
    Subtract lines 7 and 8 from line 6a ......
    880,422
    10 Analysis of line 9:
    a Excess from 2015....  
    b Excess from 2016....  
    c Excess from 2017....  
    d Excess from 2018....  
    e Excess from 2019.... 880,422
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 10
    Part XIV
    Private Operating Foundations (see instructions and Part VII-A, question 9)
    1a If the foundation has received a ruling or determination letter that it is a private operating
    foundation, and the ruling is effective for 2019, enter the date of the ruling....... bullet
     
    b Check box to indicate whether the organization is a private operating foundation described in section or
    2a Enter the lesser of the adjusted net
    income from Part I or the minimum
    investment return from Part X for each
    year listed ..........
    Tax year Prior 3 years (e) Total
    (a) 2019 (b) 2018 (c) 2017 (d) 2016
             
    b 85% of line 2a .........          
    c Qualifying distributions from Part XII,
    line 4 for each year listed .....
             
    d Amounts included in line 2c not used directly
    for active conduct of exempt activities ..........
             
    e Qualifying distributions made directly
    for active conduct of exempt activities.
    Subtract line 2d from line 2c ....
             
    3 Complete 3a, b, or c for the
    alternative test relied upon:
    a “Assets" alternative test—enter:
    (1) Value of all assets ......          
    (2) Value of assets qualifying
    under section 4942(j)(3)(B)(i)
             
    b “Endowment" alternative test— enter 2/3
    of minimum investment return shown in
    Part X, line 6 for each year listed...
             
    c “Support" alternative test—enter:
    (1) Total support other than gross
    investment income (interest,
    dividends, rents, payments
    on securities loans (section
    512(a)(5)), or royalties) ....
             
    (2) Support from general public
    and 5 or more exempt
    organizations as provided in
    section 4942(j)(3)(B)(iii)....
             
    (3) Largest amount of support
    from an exempt organization
             
    (4) Gross investment income          
    Part XV
    Supplementary Information (Complete this part only if the foundation had $5,000 or more in
    assets at any time during the year—see instructions.)
    1Information Regarding Foundation Managers:
    aList any managers of the foundation who have contributed more than 2% of the total contributions received by the foundation
    before the close of any tax year (but only if they have contributed more than $5,000). (See section 507(d)(2).)
    bList any managers of the foundation who own 10% or more of the stock of a corporation (or an equally large portion of the
    ownership of a partnership or other entity) of which the foundation has a 10% or greater interest.
    2Information Regarding Contribution, Grant, Gift, Loan, Scholarship, etc., Programs:
    Check here bullet
    aThe name, address, and telephone number or email address of the person to whom applications should be addressed:
    bThe form in which applications should be submitted and information and materials they should include:
    cAny submission deadlines:
    dAny restrictions or limitations on awards, such as by geographical areas, charitable fields, kinds of institutions, or other
    factors:
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 11
    Part XV
    Supplementary Information (continued)
    3 Grants and Contributions Paid During the Year or Approved for Future Payment
    Recipient If recipient is an individual,
    show any relationship to
    any foundation manager
    or substantial contributor
    Foundation
    status of
    recipient
    Purpose of grant or
    contribution
    Amount
    Name and address (home or business)
    aPaid during the year
    FRANKEL JEWISH ACADEMY OF METROPOLITAN DETROIT
    6600 W MAPLE ROAD
    WEST BLOOMFIELD,MI48322
    NONE PUBLIC CHARITY EDUCATION 25,000
    YESHIVA BETH YEHUDA
    15751 WEST LINCOLN DRIVE
    SOUTHFIELD,MI48037
    NONE PUBLIC CHARITY EDUCATION 1,000,000
    UNITED JEWISH FEDERATION OF METROPOLITAN DETROIT
    6735 TELEGRAPH ROAD
    BLOOMFIELD HILLS,MI48303
    NONE PUBLIC CHARITY RELIGIOUS 100,000
    Total .................................bullet 3a 1,125,000
    bApproved for future payment
    Total .................................bullet 3b 0
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 12
    Part XVI-A
    Analysis of Income-Producing Activities
    Enter gross amounts unless otherwise indicated. Unrelated business income Excluded by section 512, 513, or 514 (e)
    Related or exempt
    function income
    (See instructions.)
    1Program service revenue: (a)
    Business code
    (b)
    Amount
    (c)
    Exclusion code
    (d)
    Amount
    a
    b
    c
    d
    e
    f
    gFees and contracts from government agencies          
    2 Membership dues and assessments....          
    3 Interest on savings and temporary cash
    investments ...........
        14 15,096  
    4 Dividends and interest from securities....     14 75,809  
    5 Net rental income or (loss) from real estate:
    aDebt-financed property......          
    bNot debt-financed property.....          
    6 Net rental income or (loss) from personal property          
    7 Other investment income.....          
    8 Gain or (loss) from sales of assets other than
    inventory ............
        18 339,224  
    9 Net income or (loss) from special events:          
    10 Gross profit or (loss) from sales of inventory          
    11 Other revenue: a
    b
    c
    d
    e
    12 Subtotal. Add columns (b), (d), and (e).. 0 430,129 0
    13Total. Add line 12, columns (b), (d), and (e)..................
    13
    430,129
    (See worksheet in line 13 instructions to verify calculations.)
    Part XVI-B
    Relationship of Activities to the Accomplishment of Exempt Purposes
    Line No.
    DownArrow
    Explain below how each activity for which income is reported in column (e) of Part XVI-A contributed importantly to
    the accomplishment of the foundation’s exempt purposes (other than by providing funds for such purposes). (See
    instructions.)
    Form 990-PF (2019)
    Form 990-PF (2019)
    Page 13
    Part XVII
    Information Regarding Transfers To and Transactions and Relationships With Noncharitable Exempt Organizations
    1
    Did the organization directly or indirectly engage in any of the following with any other organization described in section 501(c) (other than section 501(c)(3) organizations) or in section 527, relating to political organizations?
    Yes
    No
    a
    Transfers from the reporting foundation to a noncharitable exempt organization of:
    (1) Cash...................................
    1a(1)
     
    No
    (2) Other assets.................................
    1a(2)
     
    No
    b
    Other transactions:
    (1) Sales of assets to a noncharitable exempt organization....................
    1b(1)
     
    No
    (2) Purchases of assets from a noncharitable exempt organization..................
    1b(2)
     
    No
    (3) Rental of facilities, equipment, or other assets.......................
    1b(3)
     
    No
    (4) Reimbursement arrangements...........................
    1b(4)
     
    No
    (5) Loans or loan guarantees.............................
    1b(5)
     
    No
    (6) Performance of services or membership or fundraising solicitations................
    1b(6)
     
    No
    c
    Sharing of facilities, equipment, mailing lists, other assets, or paid employees..............
    1c
     
    No
    d
    If the answer to any of the above is "Yes," complete the following schedule. Column (b) should always show the fair market value
    of the goods, other assets, or services given by the reporting foundation. If the foundation received less than fair market value
    in any transaction or sharing arrangement, show in column (d) the value of the goods, other assets, or services received.

    (a) Line No. (b) Amount involved (c) Name of noncharitable exempt organization (d) Description of transfers, transactions, and sharing arrangements
    2a
    Is the foundation directly or indirectly affiliated with, or related to, one or more tax-exempt organizations
    described in section 501(c) (other than section 501(c)(3)) or in section 527? ...........
    b
    If "Yes," complete the following schedule.

    (a) Name of organization (b) Type of organization (c) Description of relationship
    Sign Here
    Under penalties of perjury, I declare that I have examined this return, including accompanying schedules and statements, and to the best of my knowledge and belief, it is true, correct, and complete. Declaration of preparer (other than taxpayer) is based on all information of which preparer has any knowledge.
    Bullet Bullet
    May the IRS discuss this return
    with the preparer shown below
    (see instr.)
    Signature of officer or trustee Date Title
    Paid Preparer Use Only Print/Type preparer's name Preparer's Signature Date PTIN
    Firm's name SmallBullet
    Firm's EIN SmallBullet
    Firm's address SmallBullet


    Phone no.
    Form 990-PF (2019)
    Additional Data


    Software ID:  
    Software Version:  


    Form 990PF - Special Condition Description:
    Special Condition Description
    Schedule B
    (Form 990, 990-EZ,
    or 990-PF)
    Department of the Treasury
    Internal Revenue Service
    Schedule of Contributors

    Arrow Bullet Attach to Form 990, 990-EZ, or 990-PF.
    Arrow Bullet Go to www.irs.gov/Form990 for the latest information.
    OMB No. 1545-0047
    2019
    Name of the organization
    THE NORMAN AND ESTHER ALLAN FOUNDATION
     
    Employer identification number

    38-6089688
    Organization type (check one):
    Filers of:
    Section:
    Form 990 or 990-EZ






    Form 990-PF




    Check if your organization is covered by the General Rule or a Special Rule.  
    Note: Only a section 501(c)(7), (8), or (10) organization can check boxes for both the General Rule and a Special Rule. See instructions.
    General Rule
    Special Rules
    ......... Arrow Bullet $  
    Caution: An organization that isn't covered by the General Rule and/or the Special Rules doesn't file Schedule B (Form 990,
    990-EZ, or 990-PF), but it must answer “No” on Part IV, line 2, of its Form 990; or check the box on line H of its Form 990-EZ
    or on its Form 990PF, Part I, line 2, to certify that it doesn't meet the filing requirements of Schedule B (Form 990,
    990-EZ, or 990-PF).
    For Paperwork Reduction Act Notice, see the Instructions
    for Form 990, 990-EZ, or 990-PF.
    Cat. No. 30613XSchedule B (Form 990, 990-EZ, or 990-PF) (2019)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2019) Page 2
    Name of organization
    THE NORMAN AND ESTHER ALLAN FOUNDATION
     
    Employer identification number
    38-6089688
    Part I
    Contributors
    Contributors (see instructions). Use duplicate copies of Part I if additional space is needed.
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
    1
    NORMAN ALLAN RESIDUARY TRUST
     
    27777 FRANKLIN ROAD SUITE 2500
     
    SOUTHFIELD, MI48034

    $ 101,501


    (Complete Part II for noncash contributions.)
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
     
     
     
     

    $  


    (Complete Part II for noncash contributions.)
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
     
     
     
     

    $  


    (Complete Part II for noncash contributions.)
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
     
     
     
     

    $  


    (Complete Part II for noncash contributions.)
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
     
     
     
     

    $  


    (Complete Part II for noncash contributions.)
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
     
     
     
     

    $  


    (Complete Part II for noncash contributions.)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2019)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2019)
    Page 3
    Name of organization
    THE NORMAN AND ESTHER ALLAN FOUNDATION
     
    Employer identification number

    38-6089688
    Part II
    Noncash Property (see instructions). Use duplicate copies of Part II if additional space is needed.
    (a)
    No. from Part I
    (b)
    Description of noncash property given
    (c)
    FMV (or estimate)
    (See instructions)
    (d)
    Date received
    1
    SECURITIES $ 101,501 2018-10-31
    (a)
    No. from Part I
    (b)
    Description of noncash property given
    (c)
    FMV (or estimate)
    (See instructions)
    (d)
    Date received
     
    $    
    (a)
    No. from Part I
    (b)
    Description of noncash property given
    (c)
    FMV (or estimate)
    (See instructions)
    (d)
    Date received
     
    $    
    (a)
    No. from Part I
    (b)
    Description of noncash property given
    (c)
    FMV (or estimate)
    (See instructions)
    (d)
    Date received
     
    $    
    (a)
    No. from Part I
    (b)
    Description of noncash property given
    (c)
    FMV (or estimate)
    (See instructions)
    (d)
    Date received
     
    $    
    (a)
    No. from Part I
    (b)
    Description of noncash property given
    (c)
    FMV (or estimate)
    (See instructions)
    (d)
    Date received
     
    $    
    Schedule B (Form 990, 990-EZ, or 990-PF) (2019)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2019)
    Page 4
    Name of organization
    THE NORMAN AND ESTHER ALLAN FOUNDATION
     
    Employer identification number

    38-6089688
    Part III
    Exclusively religious, charitable, etc., contributions to organizations described in section 501(c)(7), (8), or (10) that total more than $1,000 for the year from any one contributor. Complete columns (a) through (e) and the following line entry. For organizations completing Part III, enter the total of exclusively religious, charitable, etc., contributions of $1,000 or less for the year. (Enter this information once. See instructions.) Arrow Bullet$  
    Use duplicate copies of Part III if additional space is needed.
    (a)
    No. from Part I
    (b) Purpose of gift (c) Use of gift (d) Description of how gift is held
     
    (e) Transfer of gift
    Transferee's name, address, and ZIP 4 Relationship of transferor to transferee
     
     
         
     
    (a)
    No. from Part I
    (b) Purpose of gift (c) Use of gift (d) Description of how gift is held
     
    (e) Transfer of gift
    Transferee's name, address, and ZIP 4 Relationship of transferor to transferee
     
     
         
     
    (a)
    No. from Part I
    (b) Purpose of gift (c) Use of gift (d) Description of how gift is held
     
    (e) Transfer of gift
    Transferee's name, address, and ZIP 4 Relationship of transferor to transferee
     
     
         
     
    (a)
    No. from Part I
    (b) Purpose of gift (c) Use of gift (d) Description of how gift is held
     
    (e) Transfer of gift
    Transferee's name, address, and ZIP 4 Relationship of transferor to transferee
     
     
         
     
    Schedule B (Form 990, 990-EZ, or 990-PF) (2019)

    Additional Data


    Software ID:  
    Software Version:  

    TY 2017 AccountingFeesSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    ACCOUNTING 3,685 0   0

    TY 2017 InvestmentsCorpBondsSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Name of Bond End of Year Book Value End of Year Fair Market Value
    4000 CITIGROUP INC 3,985 3,825
    2000 ENTERPRISE PRODUCTS 2,331 2,139
    3000 GENERAL ELEC CAP CORP 3,474 3,097
    5000 JPMORGAN CHASE & CO 5,120 5,084
    5000 MICROSOFT CORP GLB 4,928 4,602
    3000 MORGAN STANLEY GLB 2,913 2,810
    4000 SHELL INTERNATIONAL FIN 3,696 3,631
    5000 VERIZON COMMUNICATIONS GLB 5,367 5,305
    2000 BP CAPITAL MARKETS PLC 2,010 1,958
    4000 WELLS FARGO & COMPANY 3,907 3,807
    6000 GOLDMAN SACHS GROUP INC 6,090 5,960

    TY 2017 InvestmentsCorpStockSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Name of Stock End of Year Book Value End of Year Fair Market Value
    27 SHS 3M COMPANY 5,301 5,137
    152 SHS ABBOT LABS 9,015 11,540
    75 SHS ABBVIE INC 6,041 5,839
    79 SHS ACCENTURE PLC 7,252 12,452
    71 SHS AGILIENT TECHNOLOGIES 4,921 4,600
    36 SHS AMDOCS LIMITED 2,148 2,278
    39 SHS ADOBE SYS DEL PV$ 7,624 9,585
    37 SHS AIR PRODUCTS&CHEM 5,571 5,711
    17 SHS ALIGN TECH INC 5,431 3,760
    18 SHS ALPHABET INC CL A 10,368 19,630
    9 SHS ALPHABET INC CL C 6,711 9,691
    140 SHS ALTRIA GROUP INC 9,379 9,106
    17 SHS AMAZON COM INC 9,882 27,166
    14 SHS AMEDISYS 781 1,540
    37 SHS AMERICAN EXPRESS COMPANY 3,706 3,801
    11 SHS AMERICAN STATES WATER COMPANY 209 673
    55 SHS AMERICAN TOWER REIT INC 7,554 8,570
    47 SHS AMGEN INC COM 7,728 9,061
    25 SHS AMN ELEC POWER CO 1,581 1,834
    37 SHS AON PLC 4,050 5,779
    20 SHS APPLE INC 2,778 4,377
    7 SHS ASSURANT INC 628 680
    18 SHS ASML HLDG NV NY REG 2,919 3,102
    28 SHS AT&T 904 859
    47 SHS BALL CORP 1,793 2,106
    44 SHS AUTOMATIC DATA PROCESSING 5,983 7,204
    57 SHS BARRICK GOLD CORP 753 715
    95 SHS BAXTER INTERNATIONAL 5,834 5,939
    171 SHS BB&T CORPORATION 7,469 8,406
    19 SHS BECTON DICKINSON CO 4,247 4,465
    19 SHS BEST BUY CO INC 894 1,333
    8 SHS BIOGEN INC 2,564 2,434
    14 SHS BLACKROCK INC 5,857 5,760
    23 SHS BOEING COMPANY 7,692 8,162
    4 SHS BOOKING HLDGS INC 2,552 7,498
    26 SHS BOOZ ALLEN HAMILTON HLDG 764 1,288
    68 SHS BRISTOL-MEYERS SQUIBB CO 4,030 3,437
    9 SHS BROADCOM LTD 2,329 2,011
    14 SHS BRUNSWICK CORP 900 728
    35 SHS BWX TECHNOLOGIES 1,369 2,046
    8 SHS BURLINGTON 1,306 1,372
    65 SHS CALIFORNIA WTR SVC GP DE 1,610 2,730
    80 SHS CAMEO CORP 962 858
    43 SHS CALLAWAY GOLF DEL COM 979 920
    24 SH CATERPILLAR INC DEL 1,385 1,577
    21 SHS CARS.COM INC 554 548
    17 SH CELANESE CORP DEL SER A 1,553 1,648
    67 SHS CENTERPOINT ENERGY 1,906 1,810
    16 SHS CARPENTER TECHNOLOGY 517 698
    29 SHS CHARTER COMMUNICATIONS 3,346 3,238
    28 SHS CHEVRON CORP 2,803 3,126
    53 SHS CHUBB LTD 7,409 6,620
    3 SHS CHURCHILL DOWNS INC 439 749
    54 SHS CIENA CORP 1,381 1,688
    31 SHS CIGNA CORP 5,230 6,628
    290 SHS CISCO SYSTEMS 10,133 13,268
    181 SHS CITIGROUP INC COM 10,540 11,848
    230 SHS CITIZENS FINL GROUP INC 1,771 2,615
    47 SHS COCA COLA 2,174 2,250
    32 SHS CODEXIS 330 498
    18 SHS COLGATE PALMOLIVE 1,268 1,072
    267 SHS COMCAST 8,192 10,183
    32 SHS COPART INC 1,327 1,565
    49 SHS CORNING INC 1,706 1,566
    13 SHS COSTAR GROUP 2,305 4,699
    7 SHS COSTCO 745 1,600
    66 SHS CROWN CASTLE 6,814 7,177
    130 SHS DANAHER CORP 3,890 5,666
    9 SHS DIAMONDBACKENERGY 1,002 1,011
    21 SHS DISNEY WALT CO COM STK 1,669 2,411
    5 SHS DOMINOS 1,000 1,344
    22 SHS DOLBY LABORATORIES 1,445 1,514
    90 SHS DUKE ENERGY CORP 7,693 7,437
    30 SHS DU PONT E I DE NEMOURS 1,572 1,618
    44 SHS DXC TECHNOLOGY CO 3,342 3,205
    4 SHS EAGLE MATERIALS INC 357 295
    14 SHS EAST WEST BANCORP 768 734
    86 SHS EATON CORP PLC 6,474 6,164
    57 SHS EBAY INC 1,715 1,655
    7 SHS EDWARDS LIFE SCIENCES 834 1,033
    52 SHS ELECTRONIC ARTS INC DEL 6,163 4,731
    11 SHS ELI LILLY & CO 1,161 1,193
    22 SHS ENCORE CAPITAL 883 559
    11 SHS EURONET WORLDWIDE INC 1,081 1,223
    32 SHS EOG RESOURCES INC 2,220 3,371
    36 SHS EXPEDIA 4,210 4,515
    37 SHS EXXON MOBIL CORP 3,093 2,948
    13 SHS FACEBOOK 1,043 1,973
    19 SHS FASTENAL COMPANY 852 977
    11 SHS FEDEX CORP DELAWARE 1,792 2,424
    42 SHS FERRARI NV 5,145 4,919
    97 SHS FIDELITY NATIONAL SVCS 6,941 10,098
    116 SHS FISERV INC 6,386 9,199
    52 SHS FORTINET INC 5,203 8,283
    94 SHS GENERAL MILLS 4,892 4,117
    60 SHS GODDAY INC 3,604 4,390
    44 SHS GOLDMAN SACHS GROUP INC 8,840 9,916
    28 SHS GRANITE CONSTRUCTION 999 1,280
    13 SHS GRAND CANYON EDUCATION 749 1,621
    7 SHS GUIDEWIRE SOFTWARE IN 315 623
    48 SHS HARTFORD FINL SVCS GROUP 2,291 2,180
    23 SHS HASBRO INC 1,899 2,109
    24 SHS HAWAIIAN ELEC INDS INC 852 895
    49 SHS HEARTLAND EXPRESS INC 975 954
    26 SHS BOOZ ALLEN HAMILTON HLDG 1,176 1,055
    21 SHS HERSHEY COMPANY 1,956 2,250
    37 SHS HILTON GRAND VACATION 1,483 994
    63 SHS HOME DEPOT 7,957 11,080
    84 SHS HONEYWELL INTL INC 18,119 21,868
    115 SHS HOSPITALITY PPTYS TRUST 1,159 1,050
    85 SHS HP INC 1,881 2,052
    51 SHS ILLINOIS TOOL WORKS 6,501 6,506
    16 SHS ILLUMINA INC 2,961 4,978
    60 SHS INGRESOLL-RAND PLC 5,489 5,756
    64 SHS INTEL 1,955 3,000
    130 SHS INTERCONTINENTAL EXCHANGE 7,110 10,015
    22 SHS INTUIT INC 2,542 4,642
    173 SHS JOHNSON & JOHNSON COM 20,687 24,218
    168 SHS JOHNSON CONTROLS 7,438 5,371
    263 SHS JPMORGAN CHASE & CO 19,558 28,672
    45 SHS KIMBERLY CLARK 4,775 4,694
    9 SHS LABORATORY AMER HLDS 1,282 1,445
    10 SHS LAUDER ESTEE COS 1,231 1,374
    54 SHS LAUREATE EDUCATION INC 1,004 804
    4 SHS LIGAND PHARMACEUTICALS INC 520 659
    35 SHS LINDE PLC 0 5,792
    26 SHS LIVE NATION 1,185 1,360
    77 SHS LOWE'S COMPANIES INC 7,532 7,332
    13 SHS LEAR CORP 1,758 1,728
    44 SHS LOCKHEED MARTIN CORP 13,395 12,929
    35 SHS LYONDELL BASELL INDUSTRIES 3,149 3,124
    7 SHS MANHATTAN ASSOCS INC 402 334
    75 SHS MARSH & MCLENNAN COS INC 5,311 6,356
    66 SHS MASTERCARD INC 4,117 12,849
    42 SHS MAXIM INTEGRATED PRODUCTS 2,225 2,101
    37 SHS MAXLINEAR INC CL A 901 718
    26 SHS MCKESSON CORPORATION COM 4,029 3,244
    15 SHS MCCORMICK NON VTG 1,532 2,160
    43 SHS MCDONALDS CORP 6,924 7,607
    142 SHS MEDRONIC PLC 11,098 12,754
    51 SHS MERCK AND CO INC 3,286 3,754
    125 SHS METLIFE INC 5,499 5,149
    50 SHS MICRON TECHNOLOGY 1,262 1,886
    431 SHS MICROSOFT CORP 31,356 46,035
    11 SHS MIDDLEBY CORP COM 1,280 1,235
    51 SHS MOODY'S CORP 6,960 7,419
    30 SHS MONSTER BEVERAGE 1,319 1,586
    46 SHS NASDAQ OMX GRP 1,828 3,989
    41 SHS NATL INSTRUMENTS CORP 1,455 2,008
    74 SHS NESTLE A REP RG 5,200 6,237
    34 SHS NETAPP INC 2,202 2,669
    11 SHS NETFLIX 1,965 3,320
    52 SHS NEXTERA ENERGY 7,471 8,970
    28 SHS NICE SYSTS LTD SPSD 1,141 2,966
    116 SHS NIKE INC 7,533 8,705
    38 SHS NORTHROP GRUMMAN 9,212 9,954
    22 SHS NVIDIA 4,215 4,638
    161 SHS PASSEGURO DIGITAL LTD 4,763 4,345
    87 SHS PAYCHECK 5,269 5,698
    109 SHS PAYPAL HOLDINGS INC 7,150 9,177
    90 SHS PEPSICO INC 9,522 10,114
    389 SHS PFIZER INC 13,557 16,750
    23 SHS PHILIPS 66 2,432 2,365
    123 SHS PHILIP MORRIS 10,487 10,833
    11 SHS PLANET FITNESS INC CL A 228 540
    53 SHS PNC FINANCIAL 4,980 6,810
    14 SHS PORTOLA PHARMACEUTICALS 342 276
    81 SHS PPG INDUSTRIES INC 8,363 8,512
    11.3 SHS PRAXAIR INC 1,872 1,861
    39 SHS PROCTER & GAMBLE 3,381 3,459
    30 SHS PROGRESSIVE CRP OHIO 1,184 2,091
    10 SHS PROOFPOINT 564 910
    70 SHS PURE STORAGE INC 1,475 1,413
    18 SHS RALPH LAUREN CORP 1,874 2,333
    61 SHS RAYTHEON CO DELAWARE NEW 9,316 10,677
    42 SHS REALTY INCM CRP MD 2,527 2,531
    11 SHS RED HAT 835 1,888
    32 SHS REPUBLIC SERVICES 1,366 2,326
    24 SHS RESIDEO TECHNOLOGIES INC 0 505
    6 SHS ROCKWELL AUTOMATION 959 988
    4 SHS ROGERS CORP 652 492
    58 SHS ROYAL DUTCH SHELL PLC 3,627 3,811
    77 SHS SABRE CORP 1,850 1,898
    93 SHS SALESFORCE COM INC 7,896 12,763
    105 SHS SCHLUMBERGER LTD 7,099 5,388
    41 SHS SEMPRA ENERGY 4,622 4,515
    46 SHS SENIOR HSG PPTYS 659 739
    10 SHS SHERWIN WILLIAMS 3,474 3,935
    17 SHS SIMON PROPERTY GROUP 2,719 3,120
    52 SHS SPROUTS FARMERS MARKET 1,404 1,398
    142 SHS STARBUCKS CORP 7,575 8,274
    70 SHS STATE STREET 6,390 4,813
    51 SHS STRYKER CORP 8,569 8,273
    20 SHS SUNTRUST BKS INC 1,414 1,253
    13 SHS SYNOPSYS INC 1,331 1,164
    19 SHS TARGET 1,444 1,589
    5 SHS TELEFLEX 1,278 1,204
    177 SHS TEXAS INSTRUMENTS 14,247 16,431
    28 SHS TMOBILE 1,625 1,919
    47 SHS THERMO FISHER SCIENTIFIC 6,405 11,065
    8 SHS TOTAL SYS SVCS INC 789 729
    111 SHS TRAVELERS COS INC 5,994 7,633
    18 SHS TRIMBLE INC 748 673
    12 SHS TRINET GROUP INC CALIF 621 564
    7 SHS ULTA BEAUTY 1,632 1,922
    2 SHS ULTIMATE SOFTWARE GROUP 396 533
    86 SHS UNITED HEALTH GROUP 14,068 22,476
    315 SHS UNION PACIFIC CORP 9,181 11,844
    203 SHS US BANCORP 9,033 10,611
    2 SHS VAIL RESORTS INC 329 503
    31 SHS VALERO ENERGY CORP NEW 2,395 2,824
    20 SHS VENTAS INC 1,129 1,161
    17 SHS VERISK ANALYTICS INC 1,324 2,037
    50 SHS VEEVA SYS INC 3,720 4,568
    28 SHS VIACOM INC NEW CL B 891 895
    14 SHS VIRTUSA 735 694
    117 SHS VISA INC CL A 2,334 16,128
    11 SHS WABTEC 973 902
    10 SHS WALMART 990 1,003
    76 SHS WEC ENERGY GROUP INC 4,843 5,198
    15 SHS WEIGHT WATCHERS 1,065 992
    171 SHS WELLS FARGO & CO NEW DEL 8,829 9,102
    10 SHS WEST PHARMACTL VSCS INC 929 1,059
    106 SHS WILLIAMS COMPANIES DEL 2,928 2,579
    12 SHS WOODWARD INC 633 884
    26 SHS WORDPLAY INC CL A 803 2,388
    84 SHS XCEL ENERGY INC 3,348 4,117
    70 SHS XILINX INC 5,278 5,976
    14 SHS XYLEM INC 720 918
    80 SHS ZOETIS INC 3,426 7,212

    TY 2017 InvestmentsGovtObligationsSch
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    US Government Securities - End of Year Book Value:

    381,614
    US Government Securities - End of Year Fair Market Value:

    364,753
    State & Local Government Securities - End of Year Book Value:


    0
    State & Local Government Securities - End of Year Fair Market Value:


    0


    TY 2017 InvestmentsOtherSchedule2
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Category/ Item Listed at Cost or FMV Book Value End of Year Fair Market Value
    1265 SHS AMERICAN EURO PACIFIC AT COST 47,447 60,854
    3468 SHS BARON SMALL CAP FD AT COST 84,796 106,334
    13953 SHS FIXED INCOME SHARES - SERIES C AT COST 166,816 138,693
    20705 SHS FIXED INCOME SHARES - SERIES M AT COST 148,640 140,399
    5623 SHS WESTERN ASSET SMASH SERIES EC AT COST 51,799 46,896
    1943 SHS WESTERN ASSET SMASH SERIES C AT COST 18,750 18,109
    5120 SHS WESTERN ASSET SMASH SERIES M AT COST 54,989 53,606

    TY 2017 LegalFeesSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    LEGAL 5,903 0   0


    TY 2017 OtherDecreasesSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Description Amount
    UNREALIZED GAIN ON DONATED SECURITIES 34,635


    TY 2017 OtherExpensesSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Description Revenue and Expenses per Books Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    INVESTMENT AND ADVISORY SERVICES 29,245 29,245   0
    ANNUAL CORPORATE UPDATE 20 0   0


    TY 2017 TaxesSchedule
    Name:
    THE NORMAN AND ESTHER ALLAN FOUNDATION
    EIN:
    38-6089688
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    FOREIGN TAX WITHHELD 89 89   0
    EXCISE TAX 4,276 0   0