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
2018
Open to Public Inspection
For calendar year 2018, or tax year beginning 01-01-2018 , and ending 12-31-2018
Name of foundation
MCFARLAN CHARITABLE CORPORATION
 
Number and street (or P.O. box number if mail is not delivered to street address)700 E KEARSLEY
 
Room/suite
City or town, state or province, country, and ZIP or foreign postal code
FLINT, MI48503
A Employer identification number

38-1390531
B Telephone number (see instructions)

(810) 235-3077
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$27,697,625
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) 30,502
2 Check bullet.............
3 Interest on savings and temporary cash investments 1,073 1,073 1,073
4 Dividends and interest from securities... 450,136 450,136 450,136
5a Gross rents............      
b Net rental income or (loss)  
6a Net gain or (loss) from sale of assets not on line 10 297,548
b Gross sales price for all assets on line 6a 7,418,433
7 Capital gain net income (from Part IV, line 2)... 297,548
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)....... 2,265,030   2,265,030
12 Total. Add lines 1 through 11........ 3,044,289 748,757 2,716,239
Operating and Administrative Expenses 13 Compensation of officers, directors, trustees, etc.        
14 Other employee salaries and wages......        
15 Pension plans, employee benefits.......        
16a Legal fees (attach schedule)......... 22,770   21,764 1,006
b Accounting fees (attach schedule)....... 13,935      
c Other professional fees (attach schedule).... 1,528,082 136,982 974,716 375,138
17 Interest...............        
18 Taxes (attach schedule) (see instructions)... 53,134 2,224 44,785 3,832
19 Depreciation (attach schedule) and depletion... 295,751   295,751
20 Occupancy.............. 374,184   295,308 78,875
21 Travel, conferences, and meetings....... 51,459   19,514 10,361
22 Printing and publications..........        
23 Other expenses (attach schedule)....... 979,792   732,244 222,452
24 Total operating and administrative expenses.
Add lines 13 through 23.......... 3,319,107 139,206 2,384,082 691,664
25 Contributions, gifts, grants paid....... 306,433 306,433
26 Total expenses and disbursements. Add lines 24 and 25 3,625,540 139,206 2,384,082 998,097
27 Subtract line 26 from line 12:
a Excess of revenue over expenses and disbursements -581,251
b Net investment income (if negative, enter -0-) 609,551
c Adjusted net income (if negative, enter -0-)... 332,157
For Paperwork Reduction Act Notice, see instructions.
Cat. No. 11289X Form 990-PF (2018)
Form 990-PF (2018)
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............. 132,467 70,147 70,147
2 Savings and temporary cash investments......... 259,327 2,219,277 2,219,277
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)      
b Investments—corporate stock (attach schedule)....... 9,399,865 Click to see attachment10,497,925 10,909,117
c Investments—corporate bonds (attach schedule)....... 11,439,283 Click to see attachment7,945,751 7,947,557
11 Investments—land, buildings, and equipment: basis bullet  
Less: accumulated depreciation (attach schedule) bullet        
12 Investments—mortgage loans.............      
13 Investments—other (attach schedule)..........      
14 Land, buildings, and equipment: basis bullet10,108,423
Less: accumulated depreciation (attach schedule) bullet4,319,021 6,025,033 Click to see attachment5,789,402 5,789,402
15 Other assets (describe bullet) Click to see attachment659,047 Click to see attachment762,125 Click to see attachment762,125
16 Total assets (to be completed by all filers—see the
instructions. Also, see page 1, item I) 27,915,022 27,284,627 27,697,625
Liabilities 17 Accounts payable and accrued expenses..........    
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) Click to see attachment308,743 Click to see attachment259,599
23 Total liabilities (add lines 17 through 22)......... 308,743 259,599
Net Assets or Fund Balances Foundations that follow SFAS 117, check here bullet
and complete lines 24 through 26 and lines 30 and 31.
24 Unrestricted..................    
25 Temporarily restricted...............    
26 Permanently restricted...............    
Foundations that do not follow SFAS 117, check here bullet
and complete lines 27 through 31.
27 Capital stock, trust principal, or current funds........    
28 Paid-in or capital surplus, or land, bldg., and equipment fund    
29 Retained earnings, accumulated income, endowment, or other funds 27,606,279 27,025,028
30 Total net assets or fund balances (see instructions)..... 27,606,279 27,025,028
31 Total liabilities and net assets/fund balances (see instructions). 27,915,022 27,284,627
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 30 (must agree with end-of-year figure reported on prior year’s return) ...............
1
27,606,279
2
Enter amount from Part I, line 27a .....................
2
-581,251
3
Other increases not included in line 2 (itemize) bullet
3
 
4
Add lines 1, 2, and 3 ..........................
4
27,025,028
5
Decreases not included in line 2 (itemize) bullet
5
 
6
Total net assets or fund balances at end of year (line 4 minus line 5)—Part II, column (b), line 30 .
6
27,025,028
Form 990-PF (2018)
Form 990-PF (2018)
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 AETNA P 2017-10-25 2018-11-29
b ISHARES INTERMED CREDIT BOND P 2011-01-24 2018-10-24
c AMERICAN FINL GROUP P 2017-09-01 2018-02-09
d PINNACLE WEST CAP CORP P 2017-08-23 2018-07-24
e CORECIVIC INC P 2017-10-11 2018-02-08
PRINCIPAL FINANCIAL GROUP P 2016-10-20 2018-07-16
CVS HEALTH CORP P 2018-11-29 2018-11-29
SANDERSON FARMS P 2016-02-25 2018-05-18
DELUXE CORP P 2011-08-09 2018-02-09
TRANSOCEAN LTD P 2017-04-10 2018-03-13
DIAMOND OFFSHORE DRILLING P 2018-01-16 2018-05-18
US TREASURY BOND DUE 02/15/45 P 2017-12-07 2018-08-27
DTE ENERGY P 2001-06-26 2018-01-16
US TREASURY BOND DUE 02/15/45 P 2017-12-07 2018-04-06
INTEL CORP P 2011-01-01 2018-02-09
US TREASURY NOTE DUE 10/31/18 P 2017-11-17 2018-10-31
ISHARES 0-5 YEAR TIPS BOND P 2016-12-26 2018-01-16
US TREASURY NOTE DUE 10/31/18 P 2017-09-28 2018-10-31
ISHARES 0-5 YEAR TIPS BOND P 2017-01-11 2018-10-24
US TREASURY NOTE DUE 03/15/18 P 2019-02-25 2018-03-15
ISHARES 0-5 YEAR TIPS BOND P 2017-01-11 2018-01-16
US TREASURY NOTE DUE 03/15/18 P 2017-02-14 2018-03-15
ISHARES 0-5 YEAR TIPS BOND P 2017-02-14 2018-10-24
VIAD CORPORATION P 2017-10-18 2018-02-08
ISHARES FLOATING RATE BOND P 2013-12-18 2018-03-13
ISHARES FLOATING RATE BOND P 2015-10-22 2018-03-13
ISHARES FLOATING RATE BOND P 2017-01-11 2018-03-13
(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 116,000   74,163 41,837
b 131,350   132,407 -1,057
c 161,479   49,891 111,588
d 234,837   268,583 -33,746
e 95,505   122,445 -26,940
242,097   237,353 4,744
19   19  
285,479   225,016 60,463
137,497   38,793 98,704
195,670   254,200 -58,530
115,915   122,110 -6,195
455,820   479,961 -24,141
281,632   220,192 61,440
225,771   239,980 -14,209
128,377   26,624 101,753
500,000   500,000  
49,953   50,130 -177
1,500,000   1,498,242 1,758
147,513   151,335 -3,822
1,000,000   1,000,000  
49,953   50,445 -492
500,000   500,000  
245,854   252,272 -6,418
108,424   120,605 -12,181
152,786   151,978 808
152,787   151,192 1,595
203,715   202,949 766
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       41,837
b       -1,057
c       111,588
d       -33,746
e       -26,940
      4,744
       
      60,463
      98,704
      -58,530
      -6,195
      -24,141
      61,440
      -14,209
      101,753
       
      -177
      1,758
      -3,822
       
      -492
       
      -6,418
      -12,181
      808
      1,595
      766
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 297,548
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 -64,354
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))
2017      
2016      
2015      
2014      
2013      
2
Total of line 1, column (d) .....................
2
 
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
 
4
Enter the net value of noncharitable-use assets for 2018 from Part X, line 5......
4
 
5
Multiply line 4 by line 3......................
5
 
6
Enter 1% of net investment income (1% of Part I, line 27b)...........
6
 
7
Add lines 5 and 6........................
7
 
8
Enter qualifying distributions from Part XII, line 4,.............
8
 
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 (2018)
Form 990-PF (2018)
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: 1986-12-18(attach copy of letter if necessary–see instructions)
b Domestic foundations that meet the section 4940(e) requirements in Part V, check 1 N/A
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  
3 Add lines 1 and 2........................... 3  
4 Subtitle A (income) tax (domestic section 4947(a)(1) trusts and taxable foundations only. Others enter -0-) 4  
5 Tax based on investment income. Subtract line 4 from line 3. If zero or less, enter -0- ..... 5  
6 Credits/Payments:
a 2018 estimated tax payments and 2017 overpayment credited to 2018 6a  
b Exempt foreign organizations—tax withheld at source...... 6b
c Tax paid with application for extension of time to file (Form 8868)... 6c  
d Backup withholding erroneously withheld ........... 6d  
7 Total credits and payments. Add lines 6a through 6d.............. 7  
8 Enter any penalty for underpayment of estimated tax. Check here if Form 2220 is attached. 8  
9 Tax due. If the total of lines 5 and 8 is more than line 7, enter amount owed.......Bullet 9  
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 2019 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$   (2) On foundation managers.bullet$  
e
Enter the reimbursement (if any) paid by the foundation during the year for political expenditure tax imposed
on foundation managers.bullet$  
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 2018 or the taxable year beginning in 2018? See the instructions for Part XIV.
    If "Yes," complete Part XIV .............................
    9
    Yes
     
    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 (2018)
    Form 990-PF (2018)
    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 ofbulletSTACEY WELFORD CPA, PRESBYTERIAN VILLAGES OF MI Telephone no.bullet (248) 281-2037

    Located atbullet26200 LAHSER ROAD STE 100SOUTHFIELDMI ZIP+4bullet48033
    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 2018, 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 2018?.............
    1c
     
     
    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 2018, did the foundation have any undistributed income (lines 6d
    and 6e, Part XIII) for tax year(s) beginning before 2018?.............
    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 2018 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 2018.)..................
    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 2018?
    4b
     
    No
    Form 990-PF (2018)
    Form 990-PF (2018)
    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
    ROBERT BESSERT PRESIDENT/DI
    000.00
    0 0 0
    700 E KEARLSEY ST
    FLINT,MI48503
    DAVID MILLHOUSE TREASURER/DI
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    LOUISE MCARA VICE PRESIDE
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    MARY SNELL DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    ELEANOR BROWNELL DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    JOHN MCINTOSH DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    KATHRYN BOLES DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    DONNA FRY DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    CHARLES TOMMASULO DIRECTOR
    000.00
    0 0 0
    700 E KEARLSEY
    FLINT,MI48503
    LAURA BOWER DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    LENNETTA CONEY DIRECTOR
    000.00
    0 0 0
    700 E KEARSLEY ST
    FLINT,MI48503
    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  
    Form 990-PF (2018)
    Form 990-PF (2018)
    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
    PRESBYTERIAN VILLAGES OF MI CONTRACT LABOR 1,248,453
    26200 LAHSER RD STE 300
    SOUTHFIELD,MI48033
    PRESBYTERIAN VILLAGES OF MI MGT FEES/TECH S 111,111
    26200 LAHSER RD STE 300
    SOUTHFIELD,MI48033
    Total number of others receiving over $50,000 for professional services.............bullet  
    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 OPERATION OF HOMES FOR ELDERLY WOMEN AND SENIORS WITH LOW AND MODERATE INCOME (285 UNITS TOTAL) 691,664
    2 SUPPORT OF OTHER IRC SEC. 501(C)(3) ORGANIZATIONS 306,433
    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  
    2  
    All other program-related investments. See instructions.
    3  
    Total. Add lines 1 through 3.........................bullet  
    Form 990-PF (2018)
    Form 990-PF (2018)
    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
    21,859,819
    b
    Average of monthly cash balances.......................
    1b
    1,179,820
    c
    Fair market value of all other assets (see instructions)................
    1c
    728,957
    d
    Total (add lines 1a, b, and c).........................
    1d
    23,768,596
    e
    Reduction claimed for blockage or other factors reported on lines 1a and
    1c (attach detailed explanation) .............
    1e
     
    2
    Acquisition indebtedness applicable to line 1 assets..................
    2
     
    3
    Subtract line 2 from line 1d.........................
    3
    23,768,596
    4
    Cash deemed held for charitable activities. Enter 1 1/2% of line 3 (for greater amount, see
    instructions) .............................
    4
    356,529
    5
    Net value of noncharitable-use assets. Subtract line 4 from line 3. Enter here and on Part V, line 4
    5
    23,412,067
    6
    Minimum investment return. Enter 5% of line 5..................
    6
    1,170,603
    Part XI
    Distributable Amount (see instructions) (Section 4942(j)(3) and (j)(5) private operating foundations and certain foreign organizations check here bullet and do not complete this part.)
    1
    Minimum investment return from Part X, line 6....................
    1
     
    2a
    Tax on investment income for 2018 from Part VI, line 5......
    2a
     
    b
    Income tax for 2018. (This does not include the tax from Part VI.)...
    2b
     
    c
    Add lines 2a and 2b............................
    2c
     
    3
    Distributable amount before adjustments. Subtract line 2c from line 1............
    3
     
    4
    Recoveries of amounts treated as qualifying distributions................
    4
     
    5
    Add lines 3 and 4............................
    5
     
    6
    Deduction from distributable amount (see instructions).................
    6
     
    7
    Distributable amount as adjusted. Subtract line 6 from line 5. Enter here and on Part XIII, line 1 ...
    7
     
    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
    998,097
    b
    Program-related investments—total from Part IX-B..................
    1b
     
    2
    Amounts paid to acquire assets used (or held for use) directly in carrying out charitable, etc.,
    purposes...............................
    2
    60,120
    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,058,217
    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
     
    6
    Adjusted qualifying distributions. Subtract line 5 from line 4..............
    6
    1,058,217
    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 (2018)
    Form 990-PF (2018)
    Page 9
    Part XIII
    Undistributed Income (see instructions)
    (a)
    Corpus
    (b)
    Years prior to 2017
    (c)
    2017
    (d)
    2018
    1 Distributable amount for 2018 from Part XI, line 7  
    2 Undistributed income, if any, as of the end of 2018:
    a Enter amount for 2017 only.......  
    b Total for prior years:20, 20, 20  
    3 Excess distributions carryover, if any, to 2018:
    a From 2013......  
    b From 2014......  
    c From 2015......  
    d From 2016......  
    e From 2017......  
    fTotal of lines 3a through e........  
    4Qualifying distributions for 2018 from Part
    XII, line 4: bullet$ 1,058,217
    a Applied to 2017, but not more than line 2a  
    b Applied to undistributed income of prior years
    (Election required—see instructions).....
     
    c Treated as distributions out of corpus (Election
    required—see instructions)........
     
    d Applied to 2018 distributable amount.....  
    e Remaining amount distributed out of corpus 1,058,217
    5 Excess distributions carryover applied to 2018.    
    (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 1,058,217
    b Prior years’ undistributed income. Subtract
    line 4b from line 2b ..........
     
    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......
     
    d Subtract line 6c from line 6b. Taxable amount
    —see instructions ...........
     
    e Undistributed income for 2017. Subtract line
    4a from line 2a. Taxable amount—see
    instructions .............
     
    f Undistributed income for 2018. Subtract
    lines 4d and 5 from line 1. This amount must
    be distributed in 2019 ..........
     
    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) .......
     
    8 Excess distributions carryover from 2013 not
    applied on line 5 or line 7 (see instructions) ...
     
    9Excess distributions carryover to 2019.
    Subtract lines 7 and 8 from line 6a ......
     
    10 Analysis of line 9:
    a Excess from 2014....  
    b Excess from 2015....  
    c Excess from 2016....  
    d Excess from 2017....  
    e Excess from 2018....  
    Form 990-PF (2018)
    Form 990-PF (2018)
    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 2018, 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) 2018 (b) 2017 (c) 2016 (d) 2015
    332,157 324,196 264,853 481,815 1,403,021
    b 85% of line 2a ......... 282,333 275,567 225,125 409,543 1,192,568
    c Qualifying distributions from Part XII,
    line 4 for each year listed .....
    1,058,217 1,263,143 1,088,484 1,219,707 4,629,551
    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 ....
    1,058,217 1,263,143 1,088,484 1,219,707 4,629,551
    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...
    780,402 817,752 787,546 781,236 3,166,936
    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 (2018)
    Form 990-PF (2018)
    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
    VALLEY AREA AGENCY ON AGING
    711 N SAGINAW ST
    FLINT,MI48503
    NONE   RSVP PROGRAM 45,000
    VALLEY AREA AGENCY ON AGING
    711 N SAGINAW ST
    FLINT,MI48503
    NONE   CRISIS INTERVENTION PROGRAM 45,000
    COURT STREET VILLAGE NON-PROFIT HOU
    727 EAST ST
    FLINT,MI48503
    NONE   GENERAL OPERATIONS 45,000
    COURT STREET VILLAGE NON-PROFIT HOU
    727 EAST ST
    FLINT,MI48503
    NONE   NICE INITATIVE AND NEIGHBORHOOD PROJ 32,100
    WHALEY HISTORICAL HOUSE
    624 E KEARSLEY ST
    FLINT,MI48503
    NONE   GENERAL OPERATIONS 64,333
    MOTT COMMUNITY COLLEGE
    1401 E COURT ST
    FLINT,MI48503
    NONE   FAMILY LIFE CENTER 50,000
    FLINT PLANETARIUM
    1310 E KEARSLEY ST
    FLINT,MI48503
    NONE   CAPITAL IMPROVEMENTS 25,000
    Total .................................bullet 3a 306,433
    bApproved for future payment
    Total .................................bullet 3b  
    Form 990-PF (2018)
    Form 990-PF (2018)
    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
    aAMTS RECEIVED FROM RESIDENT         2,204,021
    bMISCELLANEOUS INCOME         61,009
    c
    d
    e
    f
    gFees and contracts from government agencies          
    2 Membership dues and assessments....          
    3 Interest on savings and temporary cash
    investments ...........
        14 1,073  
    4 Dividends and interest from securities....     14 450,136  
    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 ............
        14 297,548  
    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)..   748,757 2,265,030
    13Total. Add line 12, columns (b), (d), and (e)..................
    13
    3,013,787
    (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.)
    1A MCFARLAN WAS FORMED TO OPERATE HOMES FOR ELDERLY WOMEN
    1A AND SENIORS WITH LOW TO MODERATE INCOME.
    1A MCFARLAN CHARGES RESIDENTS RENTS FOR LODGING FACILITIES
    1A AND SERVICES RENDERED.
    1B MCFARLAN COLLECTS MISCELLANEOUS INCOME IN CONNECTION
    1B WITH THE FACILITIES RENTED TO ITS RESIDENTS.
    Form 990-PF (2018)
    Form 990-PF (2018)
    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 (2018)
    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
    2018
    Name of the organization
    MCFARLAN CHARITABLE CORPORATION
     
    Employer identification number

    38-1390531
    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) (2018)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2018) Page 2
    Name of organization
    MCFARLAN CHARITABLE CORPORATION
     
    Employer identification number
    38-1390531
    Part I
    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
    GRACE I KLEINPELL TRUST  
    106 SOUTH MAIN STREET - 16TH FLOOR
     
    AKRON, OH44308

    $ 13,572


    (Complete Part II for noncash contributions.)
    (a)
    No.
    (b)
    Name, address, and ZIP + 4
    (c)
    Total contributions
    (d)
    Type of contribution
    2
    ALICE TOWNSEND TRUST FBO MCFARLAN  
    106 SOUTH MAIN STREET - 16TH FLOOR
     
    AKRON, OH44308

    $ 16,930


    (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) (2018)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2018)
    Page 3
    Name of organization
    MCFARLAN CHARITABLE CORPORATION
     
    Employer identification number

    38-1390531
    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
     
    $    
    (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) (2018)
    Schedule B (Form 990, 990-EZ, or 990-PF) (2018)
    Page 4
    Name of organization
    MCFARLAN CHARITABLE CORPORATION
     
    Employer identification number

    38-1390531
    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) (2018)

    Additional Data


    Software ID:  
    Software Version:  

    TY 2018 AccountingFeesSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    ACCOUNTING 13,935      

    Note: To capture the full content of this document, please select landscape mode (11" x 8.5") when printing.

    TY 2018 DepreciationSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Description of Property Date Acquired Cost or Other Basis Prior Years' Depreciation Computation Method Rate /
    Life (# of years)
    Current Year's Depreciation Expense Net Investment Income Adjusted Net Income Cost of Goods Sold Not Included
    BUILDING 1974-06-30 664,376 664,376 S/L 40.0000        
    ARCHITECT FEES 1975-06-30 2,760 2,760 S/L 39.0000        
    ELECTRICAL 1975-06-30 905 905 S/L 39.0000        
    SOUTH WING 1976-06-30 68,710 68,710 S/L 38.0000        
    SOUTH WING 1977-12-31 8,025 8,025 S/L 37.0000        
    KITCHEN COOLING 1980-12-19 1,066 1,066 S/L 10.0000        
    WINDOW REPLACEMENT 1989-10-02 5,781 5,781 S/L 10.0000        
    EXPANSION 1991-07-01 544,929 361,016 S/L 40.0000 13,623   13,623  
    PORCH ENCLOSURE 1990-01-23 3,800 3,800 S/L 10.0000        
    29 GFIC 1993-12-24 843 843 S/L 5.0000        
    CHILLED WATER COIL 1993-05-03 5,500 5,500 S/L 10.0000        
    FIRE ALARM/SMOKE DETECTOR 1994-06-30 12,575 12,575 S/L 10.0000        
    REMODEL 2 ROOMS 1994-10-01 2,597 2,597 S/L 10.0000        
    SANITARY DRAIN 1994-12-14 2,232 2,232 S/L 10.0000        
    WROUGHT IRON RAIL 1994-07-26 675 675 S/L 10.0000        
    REMODEL 2 ROOMS 1995-04-11 11,029 11,029 S/L 10.0000        
    REMODEL SUITE 207 1995-10-30 9,146 9,146 S/L 10.0000        
    BASEMENT PARTITION 1995-06-27 928 928 S/L 10.0000        
    PORCH ENCLOSURE 1995-11-27 1,500 1,500 S/L 10.0000        
    PORCH ENCLOSURE 1996-01-08 3,960 3,960 S/L 10.0000        
    REMODELING 4 ROOMS T SUITES 1996-07-17 18,756 18,756 S/L 10.0000        
    ROOM 219 REMODELING 1997-10-20 11,229 11,229 S/L 10.0000        
    HANDRAIL 1998-01-05 570 570 S/L 10.0000        
    KITCHEN EXHAUST SYSTEM 1998-05-04 4,200 4,200 S/L 10.0000        
    AIR CONDITIONING UNIT 1998-06-29 2,950 2,950 S/L 10.0000        
    3 CEILING FANS 1998-08-03 1,025 1,025 S/L 10.0000        
    STAIRTREADS 1998-10-05 1,714 1,714 S/L 7.0000        
    LIGHT FIXTURES 1998-11-16 3,339 3,339 S/L 10.0000        
    REMODEL KITCHEN CABINET 1998-12-22 5,119 5,119 S/L 10.0000        
    CONVERT SUITES 202 7 204 1998-12-22 11,941 11,941 S/L 10.0000        
    CIRCUITS 1998-12-30 2,000 2,000 S/L 10.0000        
    HUMIDIFICATION SYSTEM 1999-01-11 11,687 11,687 S/L 10.0000        
    CONVERT SUITES 100 & 102 1999-12-13 13,256 13,256 S/L 10.0000        
    CONVERT SUTIES 103 & 105 1999-12-13 12,469 12,469 S/L 10.0000        
    ELEVATOR MODERATIONS 1999-07-20 9,985 9,985 S/L 10.0000        
    LIMESTONE BASE 2000-06-05 2,190 2,190 S/L 7.0000        
    REMODEL ROOMS 215 & 217 2000-06-05 12,584 12,584 S/L 10.0000        
    LIMESTONE BASE 2000-06-12 864 864 S/L 7.0000        
    ARCHITECT FEES 1999-12-13 2,072 2,072 S/L 10.0000        
    PARK WHITING-ADDITIONS 2001-04-18 8,500 3,633 S/L 39.0000 217   217  
    RANDOLPH PIPER-ADDITION 2001-04-23 500 214 S/L 39.0000 12   12  
    GOULD ENGINEERING-ADDITION 2001-06-18 7,000 2,962 S/L 39.0000 179   179  
    PARK WHITING-ADDITIONS 2001-07-18 56,626 23,836 S/L 39.0000 1,452   1,452  
    PARK WHITING-ADDITIONS 2001-08-22 20,935 8,768 S/L 39.0000 536   536  
    STATE OF MICHIGAN-ADDITIONS 2001-08-28 10,950 4,586 S/L 39.0000 281   281  
    PARK WHITING-ADDITIONS 2001-10-30 21,222 8,797 S/L 39.0000 544   544  
    PARK WHITING-ADDITIONS 2001-10-31 20,308 8,418 S/L 39.0000 521   521  
    PARK WHITING-ADDITIONS 2001-12-05 18,000 7,423 S/L 39.0000 462   462  
    PARK WHITING-ADDITIONS 2001-12-11 82,860 34,171 S/L 39.0000 2,124   2,124  
    PARK WHITING-ADDITIONS 2002-01-14 126,740 51,996 S/L 39.0000 3,250   3,250  
    PARK WHITING-ADDITIONS 2002-02-08 77,433 31,602 S/L 39.0000 1,985   1,985  
    PARK WHITING-ADDITIONS 2002-03-05 95,480 38,763 S/L 39.0000 2,449   2,449  
    PARK WHITING-ADDITIONS 2002-04-04 108,416 43,783 S/L 39.0000 2,780   2,780  
    PARK WHITING-ADDITIONS 2002-05-10 103,718 41,665 S/L 39.0000 2,659   2,659  
    PARK WHITING-ADDITIONS 2002-06-06 211,435 84,483 S/L 39.0000 5,422   5,422  
    PARK WHITING-ADDITIONS 2002-07-11 319,646 127,039 S/L 39.0000 8,196   8,196  
    PARK WHITING-ADDITIONS 2002-08-08 218,353 86,315 S/L 39.0000 5,598   5,598  
    PARK WHITING-ADDITIONS 2002-10-02 76,239 29,811 S/L 39.0000 1,955   1,955  
    PERMITS-ADDITIONS 2002-10-08 13,688 5,352 S/L 39.0000 351   351  
    PARK WHITING-ADDITIONS 2002-11-18 102,062 39,473 S/L 39.0000 2,617   2,617  
    PARK WHITING-ADDITIONS 2002-12-09 66,337 25,656 S/L 39.0000 1,701   1,701  
    PROPERTY PURCHASE DEPOSIT 2002-12-31 2,000 769 S/L 39.0000 51   51  
    PARK WHITING-ADDITIONS 2002-09-05 233,180 91,678 S/L 39.0000 5,979   5,979  
    REMODEL BATHROOM 2002-05-13 7,850 7,850 S/L 10.0000        
    BUILDING 2003-02-01 134,044 51,269 S/L 39.0000 3,437   3,437  
    ALARM SOUNDERS 2004-06-01 1,489 1,489 S/L 5.0000        
    DRIVEWAY REBUILD 2004-09-13 5,750 5,750 S/L 5.0000        
    FENCING 2005-09-06 7,167 5,893 S/L 15.0000 478   478  
    FENCE-THOMPSON ST 2005-11-15 1,905 1,545 S/L 15.0000 127   127  
    SHOWER REPAIR 1992-05-01 2,230 2,230 S/L 7.0000        
    STOVE 1997-12-09 3,410 3,410 S/L 5.0000        
    4 42" ROUND TABLES 1990-06-05 3,134 3,134 S/L 5.0000        
    FURNITURE 1991-07-01 11,901 11,901 S/L 5.0000        
    GARBAGE DISPOSAL 1992-05-01 960 960 S/L 5.0000        
    TABLE & CHAIRS 1992-07-14 492 492 S/L 5.0000        
    STORAGE LOCKERS 1992-07-28 1,971 1,971 S/L 5.0000        
    LOCKERS 1995-01-24 598 598 S/L 7.0000        
    TIME CLOCK 1995-03-02 540 540 S/L 5.0000        
    TRACK LIGHTING 1995-04-11 688 688 S/L 7.0000        
    2 REFRIGERATORS 1995-10-30 594 594 S/L 5.0000        
    CABINETRY 1995-04-11 2,671 2,671 S/L 7.0000        
    LIGHT FIXTURES 1996-01-20 2,583 2,583 S/L 7.0000        
    PORCH FURNITURES 1997-07-10 2,520 2,520 S/L 5.0000        
    COMPUTER DESK 1997-08-11 422 422 S/L 5.0000        
    FREEZER 1998-05-06 3,662 3,662 S/L 5.0000        
    6 LOUNGE CHAIRS 1998-06-16 482 482 S/L 5.0000        
    PANELS FOR BASEMENT 1998-07-06 442 442 S/L 5.0000        
    NEW FURNITURE 1998-12-04 20,000 20,000 S/L 5.0000        
    FREEZER 1998-12-15 3,014 3,014 S/L 5.0000        
    DINING ROOM CHAIRS 1999-02-15 9,452 9,452 S/L 5.0000        
    2 LOVE SEATS, 1 SOFA, 2 LAMPS 1999-03-09 6,691 6,691 S/L 5.0000        
    CARPET SCUBBER 2000-12-04 1,599 1,599 S/L 5.0000        
    BARBARA KOEGEL INT.-FURNITURE 2001-10-11 25,000 25,000 S/L 5.0000        
    FURNITURE AT WHALEY 2001-12-31 1 1 S/L 1.0000        
    11 PASSENGER BUS 2002-02-11 36,796 36,796 S/L 5.0000        
    TELEPHONE SYSTEM 2002-12-05 27,801 27,801 S/L 5.0000        
    BARBARA KOEGEL-FURNITURE 2002-09-18 45,705 45,705 S/L 5.0000        
    SATELLITE SYSTEM 2002-05-14 22,000 22,000 S/L 5.0000        
    MAILBOXES 2002-06-17 935 935 S/L 5.0000        
    REFRIGERATORS 2002-09-18 1,791 1,791 S/L 5.0000        
    SECURITY SYSTEM 2002-10-03 27,697 27,697 S/L 5.0000        
    FURNITURE 2003-01-14 31,106 31,106 S/L 5.0000        
    EXERCISE 2003-06-09 355 355 S/L 5.0000        
    TABLES AND CHAIRS 2003-11-10 1,689 1,689 S/L 5.0000        
    FLAG POLE 2003-12-10 835 835 S/L 5.0000        
    SNOW THROWER 2004-01-14 699 699 S/L 5.0000        
    TABLE AND CHAIRS 2004-02-11 1,800 1,800 S/L 25.0000        
    CREDENZA 2004-02-11 750 750 S/L 5.0000        
    LAWN MOWER 2004-04-28 377 377 S/L 5.0000        
    CREDENZA 2004-06-24 785 785 S/L 5.0000        
    CHAIRS 2004-05-10 280 280 S/L 5.0000        
    DIRECT TV 2004-07-19 7,702 7,702 S/L 5.0000        
    REFRIGERATORS 2004-08-09 2,800 2,800 S/L 5.0000        
    DIRECT TV 2004-08-16 979 979 S/L 5.0000        
    CURBING 2004-10-08 1,042 1,042 S/L 5.0000        
    COPY MACHINE 2004-11-17 3,395 3,395 S/L 5.0000        
    12 CHANNEL DIGITAL SYSTEM 2005-01-24 4,000 4,000 S/L 5.0000        
    CHAIN SAW 2005-02-07 59 59 S/L 3.0000        
    GENERATOR 2005-03-09 75,802 75,802 S/L 10.0000        
    BIRD AVIARY 2005-05-09 5,159 5,159 S/L 5.0000        
    AIR CONDITIONING UNIT 2005-05-11 1,009 1,009 S/L 5.0000        
    6 REFRIGERATOR 2005-08-15 1,194 1,194 S/L 5.0000        
    3 BATTERY BACK UP UNITS 2005-08-29 378 378 S/L 3.0000        
    GENERATOR 2006-06-05 4,114 4,114 S/L 10.0000        
    COVER FACIA & TECTUM REPAIR 2006-10-16 19,360 19,360 S/L 10.0000        
    REROUT UNDERGROUND WIRING 2006-11-07 6,551 6,551 S/L 10.0000        
    2 PICTURES 1993-07-07 925              
    5 PICTURES 1993-10-07 800              
    LAUNDRY MACHINE 2007-02-26 11,433 11,433 S/L 7.0000        
    WATER HEATER 2007-03-26 8,850 8,850 S/L 7.0000        
    GAS DRYER 2007-06-11 652 652 S/L 7.0000        
    GAZEBO/PLANTERS 2007-06-18 3,876 3,876 S/L 10.0000        
    ARMCHAIRS 2008-04-07 1,600 1,600 200DB 7.0000        
    WASHER - RECEIVED IN TRADE FOR ASSET 99 2008-05-12 550 550 S/L 5.0000        
    LAWN MOWER 2008-05-15 1,258 1,258 S/L 5.0000        
    SECURITY SYSTEM 2008-09-15 13,637 12,728 S/L 10.0000 909   909  
    SIGN - RECEIVED IN TRADE FOR ASSET 154 2008-10-15 4,450 4,450 S/L 5.0000        
    FENCE 2008-10-15 8,265 5,097 S/L 15.0000 551   551  
    STORM DRAIN REPAIR 2009-08-17 6,585 5,488 S/L 10.0000 658   658  
    LANDSCAPING - RECEIVED IN TRADE FOR ASSET 6 2010-11-01 9,300 9,300 S/L 5.0000        
    TURBO AIR 2 DOOR REFRIDGERATOR (BASEMENT) 2011-08-24 3,145 3,145 S/L 5.0000        
    2006 JOHN DEER LX178 RIDING LAWNMOWER 2011-10-17 1,000 1,000 S/L 5.0000        
    LANDSCAPING 2011-06-15 5,827 5,827 S/L 5.0000        
    BLDG - CSV WEST 2011-02-10 1,226,903 306,726 S/L 27.5000 44,614   44,614  
    LAND - CSV WEST 2011-02-10 136,322              
    CARPETING - CSV WEST 2011-12-01 40,710 38,905 200DB 5.0000 722   722  
    BLDG - CSV EAST 2011-02-10 1,642,000 410,500 S/L 27.5000 59,709   59,709  
    LAND - CSV EAST 2011-02-10 182,445              
    ROOF REPAIR - CSV EAST 2011-06-22 96,500 38,886 150DB 20.0000 4,321   4,321  
    ROOF REPAIR - CSV EAST 2011-10-13 98,607 37,419 150DB 20.0000 4,589   4,589  
    2012 CHEVROLET IMPALA 2012-09-12 22,901 14,782 S/L 5.0000 1,875   1,875  
    SIGN - DEPOSIT 2012-12-11 3,872 2,812 S/L 7.0000 553   553  
    CARPET - LOBBY 2012-07-15 22,000 22,000 S/L 5.0000        
    PAINT, RAILING, PLUMBING, ETC 2012-07-15 10,950 8,603 S/L 7.0000 1,565   1,565  
    HP LAPTOP 2012-07-01 763 763 S/L 5.0000        
    406 THOMPSON STREET - DEMOLISHED 2012-12-26 15,108              
    FURNISHINGS 2012-07-24 40,675 40,675 S/L 5.0000        
    DECORATING 2012-11-13 11,750 11,750 S/L 5.0000        
    SIGN 2012-12-11 3,872 2,811 S/L 7.0000 554   554  
    CARPET - UNIT 202 2012-04-05 1,430 1,430 S/L 5.0000        
    CARPET - UNIT 246 2012-04-05 771 771 S/L 5.0000        
    CARPET - UNIT 328 2012-05-22 1,063 1,063 S/L 5.0000        
    CARPET - UNIT 332 2012-05-22 884 884 S/L 5.0000        
    VINYL - UNIT 249 2012-06-14 749 749 S/L 5.0000        
    CARPET - UNIT 249 2012-07-11 751 751 S/L 5.0000        
    CARPET - UNIT 248 2012-07-11 761 761 S/L 5.0000        
    CARPET - UNIT 109 2012-07-11 759 759 S/L 5.0000        
    CARPET - UNIT 303 2012-09-07 862 862 S/L 5.0000        
    CARPET - UNIT 223 2012-09-28 1,092 1,092 S/L 5.0000        
    CARPET - UNIT 319 & 304 2012-10-12 1,053 1,053 S/L 5.0000        
    CARPET - UNIT 340 2012-10-19 777 777 S/L 5.0000        
    CARPET/VINYL - UNIT 121 2012-09-21 1,789 1,789 S/L 5.0000        
    CARPET - UNIT 128 & 337 2012-11-23 977 977 S/L 5.0000        
    ELEVATOR REPAIRS 2012-09-01 8,509 3,026 S/L 15.0000 567   567  
    LANDSCAPING 2012-08-30 3,725 1,324 S/L 15.0000 249   249  
    BOILER REPAIR 2012-12-13 4,679 3,398 S/L 7.0000 668   668  
    CARPET - HALLWAY 2012-02-28 15,857 15,857 S/L 5.0000        
    VINYL - UNIT 116 2012-03-29 1,051 1,051 S/L 5.0000        
    FLOORING - UNIT 333 2012-03-29 1,127 1,127 S/L 5.0000        
    CARPET - UNIT 201 2012-02-17 706 706 S/L 5.0000        
    CARPET - UNIT 124 2012-11-26 1,691 1,691 S/L 5.0000        
    LANDSCAPING 2012-08-30 7,455 2,651 S/L 15.0000 497   497  
    FURNACES (15) 2012-09-19 126,435 44,252 S/L 15.0000 8,429   8,429  
    SIGN 2012-12-11 3,872 2,811 S/L 7.0000 554   554  
    REFRIDGERATORS (2) - 613.74 EACH 2012-03-31 1,227 1,227 S/L 5.0000        
    REFRIDGERATORS (2) - 613.74 EACH 2012-03-31 1,227 1,227 S/L 5.0000        
    DISHWASHER 2012-04-02 638 638 S/L 5.0000        
    REFRIDGERATORS (2) - 550.14 EACH 2012-06-02 1,100 1,100 S/L 5.0000        
    GE ELECTRIC RANGE 2012-06-02 562 562 S/L 5.0000        
    REFRIDGERATOR 2012-06-02 550 550 S/L 5.0000        
    VINYL - UNITS 104 & 240 2012-03-31 1,424 1,424 S/L 5.0000        
    UNITS 202, 306, 335, & 334 2012-08-24 3,177 3,177 S/L 5.0000        
    FLOORING - UNITS 218, 223, 235 2012-11-14 4,841 4,841 S/L 5.0000        
    418 THOMSON - DEMOLISHED 2012-01-01 58,071              
    424 THOMSON - DEMOLISHED 2012-01-01 49,119              
    DELL COMPUTERS/MONITORS (3) 2013-01-30 3,410 3,353 S/L 5.0000 57   57  
    2012 ARIENS SNOWBLOWER 2013-01-21 1,362 1,339 S/L 5.0000 23   23  
    REDECORATING (FRANCES KATE JAMES) 2013-02-20 4,952 4,787 S/L 5.0000 165   165  
    SECURITY SYSTEM 2013-06-20 27,055 24,350 S/L 5.0000 2,705   2,705  
    ROOF 2013-04-30 170,000 28,848 S/L 27.5000 6,182   6,182  
    SECURITY SYSTEM 2013-08-22 19,592 16,979 S/L 5.0000 2,613   2,613  
    UPSTAIRS SITTING ROOM REMODEL 2013-06-24 28,311 8,493 S/L 15.0000 1,888   1,888  
    SOS GE ELEC FS RNG JBS15M 2013-04-29 593 395 S/L 7.0000 85   85  
    SOS GE ELEC FS RNG JBS15M 2013-05-03 563 375 S/L 7.0000 81   81  
    CABINETS - UNIT 235 2013-09-20 1,627 461 S/L 15.0000 108   108  
    2 MADELINE LOVESEATS - RESPA ROOM 2013-11-06 1,078 898 S/L 5.0000 180   180  
    SIGN - FINAL PAYMENT 2013-02-12 2,535 1,781 S/L 7.0000 362   362  
    BUILDING - CSVE MSHDA LIABILITY 2011-02-10 100,000 18,182 S/L 27.5000 3,636   3,636  
    BUILDING - CSV WEST MSDHA LIABILITY 2011-02-10 100,000 18,182 S/L 27.5000 3,636   3,636  
    FURNACES 2014-07-01 972,000 122,236 S/L 27.5000 35,346   35,346  
    PARKING LOT LIGHTS 2014-07-01 3,284 766 S/L 15.0000 219   219  
    PARKING LOT LIGHTS 2014-07-01 4,536 1,058 S/L 15.0000 303   303  
    BOILER 2014-08-15 71,278 8,856 S/L 27.5000 2,592   2,592  
    CHILLER 2014-07-15 64,595 8,221 S/L 27.5000 2,349   2,349  
    KITCHEN ISLAND 2014-07-21 6,885 855 S/L 27.5000 251   251  
    STOVE/RANGE (2) 2014-07-15 4,321 3,025 S/L 5.0000 864   864  
    KITCHEN FLOOR REDO (3) 2014-10-08 8,043 5,228 S/L 5.0000 1,608   1,608  
    CABINETRY (50% DOWN PMT) 2014-11-18 4,871 546 S/L 27.5000 177   177  
    SUMP PUMPS REPLACED (2) 2014-09-17 7,300 863 S/L 27.5000 265   265  
    WANDER GUARD 2014-01-31 38,103 21,320 S/L 7.0000 5,443   5,443  
    DISHWASHER 2014-10-16 3,941 1,783 S/L 7.0000 563   563  
    LAND 2014-09-01 35,800              
    LAND 1994-10-01 83,800              
    REPLACE ROOFING ON ALL BUT NEW BLDG ADDITION 2015-08-18 46,033 4,076 S/L 25.0000 1,841   1,841  
    NEW ELEVATOR 2016-06-01 97,180 6,155 S/L 25.0000 3,887   3,887  
    ZERO-TURN LAWN MOWER 2016-04-01 6,500 2,275 S/L 5.0000 1,300   1,300  
    VAN 9973 (PARTIAL COST - SHARE WITH CSW) 2016-07-25 23,060 6,534 S/L 5.0000 4,612   4,612  
    VAN 9973 (PARTIAL COST - SHARE WITH CSE) 2016-07-25 16,699 4,731 S/L 5.0000 3,050   3,050  
    FIRE ALARM PROTECTION SYSTEM 2017-10-31 94,503 630 S/L 25.0000 3,780   3,780  
    2018 DIAMOND VIP BUS 2018-08-01 60,120   S/L 5.0000 5,010   5,010  

    Note: To capture the full content of this document, please select landscape mode (11" x 8.5") when printing.

    TY 2018 GainLossSaleOtherAssetsSch
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Name Date Acquired How Acquired Date Sold Purchaser Name Gross Sales Price Basis Basis Method Sales Expenses Total (net) Accumulated Depreciation
    11 PASSENGER BUS 2002-02 PURCHASE 2018-07     36,796       36,796

    TY 2018 InvestmentsCorpBondsSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Name of Bond End of Year Book Value End of Year Fair Market Value
    CORPORATE BONDS 7,945,751 7,947,557

    TY 2018 InvestmentsCorpStockSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Name of Stock End of Year Book Value End of Year Fair Market Value
    CORPORATE STOCK 10,497,925 10,909,117

    TY 2018 LandEtcSchedule2
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Category / Item Cost / Other Basis Accumulated Depreciation Book Value End of Year Fair Market Value
    LAND IMPROVEMENTS 88,152 70,219 17,933 17,933
    BUILDING AND IMPROVEMENTS 8,756,700 3,652,910 5,103,790 5,103,790
    FURNITURE, FIXTURES, ETC. 580,126 555,298 24,828 24,828
    VEHICLES 122,780 40,594 82,186 82,186
    LAND 560,665   560,665 560,665


    TY 2018 LegalFeesSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    LEGAL FEES 22,770   21,764 1,006


    TY 2018 OtherAssetsSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Description Beginning of Year - Book Value End of Year - Book Value End of Year - Fair Market Value
    FUNDED RESERVES 585,101 695,229 695,229
    SECURITY DEPOSITS 73,946 66,896 66,896


    TY 2018 OtherExpensesSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Description Revenue and Expenses per Books Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    EXPENSES        
    DUES & SUBSCRIPTIONS 4,135   2,109 2,026
    OFFICE EXPENSE 48,816   40,094 8,721
    OTHER ADMINISTRATIVE COSTS 35,620   10,833 4,782
    ADVERTISING AND MARKETING 40,217   28,785 6,342
    SERVICES TO RESIDENTS - FOOD 69,401   35,397 34,004
    SERVICES TO RESIDENTS - TRANS 9,368   7,110 2,258
    SERVICES TO RESIDENTS - ACTIV 31,152   19,257 11,895
    SERVICES TO RESIDENTS - BEAUT 16,610   8,472 8,138
    SERVICES TO RESIDENTS - OTHER 3,626   1,850 1,776
    MAINTENANCE AND OPERATING EXP 616,593   497,237 119,356
    INSURANCE 104,254   81,100 23,154


    TY 2018 OtherIncomeSchedule2
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Description Revenue And Expenses Per Books Net Investment Income Adjusted Net Income
    AMTS RECEIVED FROM RESIDENTS 2,204,021   2,204,021
    MISCELLANEOUS INCOME 61,009   61,009


    TY 2018 OtherLiabilitiesSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Description Beginning of Year - Book Value End of Year - Book Value
    SECURITY DEPOSITS 58,012 57,866
    LOAN PAYABLE - MSHDA 200,000 200,000
    LOAN PAYABKE - PVM 33,734  
    ESCHEATS PAYABLE 1,486 788
    PAYROLL TAXES WITHHELD 15,511 945


    TY 2018 OtherProfessionalFeesSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    MANAGEMENT FEES 85,971   68,595 17,376
    CONTRACTED LABOR AND BENEFITS 1,303,636   768,377 357,030
    INVESTMENT MANAGEMENT FEES 136,982 136,982 136,982  
    EMPLOYEE BENEFIT PLANS ADMIN FEE 1,493   762 732


    TY 2018 TaxesSchedule
    Name:
    MCFARLAN CHARITABLE CORPORATION
    EIN:
    38-1390531
    Category Amount Net Investment Income Adjusted Net Income Disbursements for Charitable Purposes
    FOREIGN TAX WITHHELD 2,224 2,224 2,224  
    PROPERTY TAXES 50,910   42,561 3,832