Audio Conference Info Callin 866 363 6079 Passcode

Audio Conference Info ØCall-in #: 866 -363 -6079 ØPasscode: 851 497 0973 Issues With Consolidated Financial Statements Webinar Series Part 1 - Advanced Issues in Consolidation: Practical Solutions for the Resolution of Common Consolidating Headaches Friday, October 5, 2012 3: 00 -4: 00 PM ET Presenters: Gayle Harrold and Winell Belfonte STRENGTH MATTERS® Best Practices in Financial Reporting Webinar Series Made possible by the generous support of The John D. and Catherine T. Mac. Arthur Foundation

About STRENGTH MATTERS A national collaborative sponsored by Neighbor. Works® America, Housing Partnership Network (HPN), and Stewards of Affordable Housing for the Future (SAHF), with ongoing support from The John D. and Catherine T. Mac. Arthur Foundation. Our partners also include: Calvert Foundation Enterprise Community Loan Fund F. B. Heron Foundation Ford Foundation Housing Assistance Council Housing Partnership Fund Local Initiatives Support Corporation Low Income Investment Fund Mercy Loan Fund Neighbor. Works® Capital

Website Info www. strengthmatters. net Ø Please register if you have not already. Ø Site provides access to over 20 financial reporting best practices papers and other resources. Ø Upcoming Webinars and recordings of past sessions are posted. Ø

Click “Member access” to register www. strengthmatters. net

Getting Started All participant lines will now be muted. Ø Have a question? Please use the Chat feature and send the Presenter (Gayle Harrold) or the Host (Francie Ferguson) your question. Ø To ask via phone, please wait for a pause in the presentation and un-mute your phone to speak: #6. Ø

Learning Objectives Identify key challenges to consolidating financial statements. Ø Evaluate options to address common hurdles in consolidating. Ø Apply practical solutions learned today in your organization’s consolidating process. Ø

Agenda Ø Ø Ø So you are already consolidating… It seemed like it would be straight forward… Balance Sheet Eliminations-overview Income Statement Eliminations-overview Development Fees, Intercompany Receivables & Payables and Investment Accounts Charts of Accounts Classification Issues Non-Controlling Interests Cash Flows Financial Statement & Implementation Issues Conclusion Strength Matters Web Site

So you are already consolidating… Ø You have determined what you own, how much you own of it and whether or not you control the day to day decision making for each entity Ø You have identified your intercompany balances/transactions Ø The companies to be consolidated all have the same year end or are within 3 months of the parent company’s year end Ø When you consolidate, you lose a few brain cells over…. • eliminating entries • controlling and non-controlling interests

It seemed like it would be straight forward… And then…. . Ø Ø Ø Development Fees – are there options for eliminating these fees? Your intercompany receivables are reserved at the parent company level Your investment in your subsidiaries does not align with the equity in the deal You self-manage but the properties use a different chart of accounts You use property management companies each of whom uses a different chart of accounts AND….

…don’t forget… Ø Non-controlling interests – how should this be calculated & reflected in your financial statements Ø You know what you should eliminate…. but it is a manual process or your audit firms pulls it together at year end.

Other issues to address? Ø Are there other obstacles you have encountered that you’d like us to discuss today? Ø Please use #6 to unmute your phone to ask a question, or use the Chat function via Web. Ex.

Balance Sheet Eliminations Ø Notes Receivable/Payable Ø Development Fees Receivable/Payable Ø Interest Receivable/Payable Ø Asset Management Fee/Incentive Fees Receivable/Payable Ø Operating Deficit Loans Receivable/Payable Ø Due to/from accounts Ø Development Fees capitalized in Building Costs Ø Investment Accounts/Partnership Capital Accounts

Income Statement Eliminations Ø Interest Income/Expense Ø Asset Management Fee/Incentive Fee Income (Expense) Ø Resident Service Fee Income/Expense Ø Other fees between entities Ø Development Fee Income Ø Depreciation Expense for capitalized development fees Ø Distributions to partners

Development Fees Removing your development fees from the project’s building costs – accounts potentially affected: Ø Property’s Books • Building Costs • Accumulated Depreciation • Depreciation Expense Ø Sponsor’s Books • Development Fee Revenue • Net Assets • Deferred Development Fees

Elimination of Development Fees Ø Direct approach: • Remove cost from building • Remove accumulated depreciation • Remove current year depreciation expense • Remove undepreciated value of development fee from net assets

Elimination of Development Fees 1996 Cumulative Fee capitalized by 2004 Straight Line - 27. 5 years Depreciation per year Years of service 1996 - 2011 Accumulated Depreciation 1997 - 2011 $ 1, 144, 615. 00 27. 5 $ 41, 622. 36 15. 67 652, 222. 44 2007 Cumulative Fee capitalized in 2007 $ 134, 123. 00 Straight Line - 27. 5 years 27. 5 Depreciation per year $ 4, 877. 20 Years of service 1996 - 2011 4. 17 Accumulated Depreciation 1997 - 2011 20, 321. 67 2009 Fee Capitalized in 2009 Straight Line - 20 years Depreciation per year Years of service 1996 - 2011 Accumulated Depreciation 1997 - 2011 Total Building - Total Capitalized Fee Straight Line – see above Depreciation per year Accumulated Depreciation Net Assets Entry to Eliminate Un-depreciated Development Fee December 31, 2011 Building - Capitalized fee Accumulated Depreciation Expense Net Assets $ 36, 579. 00 $ 1, 828. 95 $ 3. 00 5, 486. 85 total $ 1, 315, 317. 00 $ 48, 328. 51 678, 030. 95 685, 614. 56 dr cr 1, 315, 317 678, 031 48, 329 685, 615 1, 363, 646

Elimination of Development Fees Ø Can you consider the margin on development fees received? Ø If you have a history of tracking your overhead costs and have a means of determining what your profit on development fees are then you can consider eliminating only the profit, not the entire development fee. Ø If you can consider the margin, than only the profit is eliminated, not the cost of development fees ( actual overhead incurred by the sponsor).

Questions? Ø Please use #6 to unmute your phone to ask a question, or use the Chat function via Web. Ex.

Intercompany Receivables & Payables Ø Sponsor has a note & interest receivable that is fully reserved • Eliminate the reserve against net assets, then eliminate the note & interest receivable against the payable Ø Sponsor records fees on a cash basis, property records them on an accrual basis • Eliminate the fee recorded by the sponsor – will have portion of income/expense that remains un-eliminated

Investment Accounts Ø Investment account on parent companies books does not align with their equity in the underlying entity • Misstated investment accounts result from a failure to record losses, excess losses have been recorded (tax basis used or losses in excess of investment recorded) or distributions have not been properly recognized by the parent Ø These findings may require a prior period adjustment

Sample Eliminations Worksheet 12/31/2011 New Madison Park IV - Related Party Balances Assets Buildings Accumulated Depreciation Investment New MPIV LP Note & Interest Receivable from NMPIV LP Development Fee & Interest Receivable Due from New MPIV LP - Company 33 Total Assets Liabilities & Fund Balance Note & Interest Payable from NMPIV LP Development Fee & Interest Payable Sponsor Loan from Parent Beginning Net Assets Contributed capital Impact on Net Income (Loss) Total Liabilities & Fund Balance (DR) CR Co 10 & 33 GL of MPDC $ 245, 000 $ 30, 000. 00 $ 275, 000. 00 $ 685, 615 $ - $ 352, 226 $ 1, 037, 841 $ 1, 312, 841. 00 Income Statement Neighborhood Network Fees pd to MPDC $ 57, 780 Property Distributions Received $ 271, 946 Incentive Management Fee paid $ 7, 500 Interest Income/Expense recorded on Notes Payable Interest Income/Expense recorded on Developer Fees $ 15, 000 Subtotal $ 352, 226 Depreciation Total Income Statement Impact $ 352, 226 (DR) CR GL of New MP IV LP $ 1, 315, 317 $ (678, 031) $ 637, 286 $ 245, 000 $ 30, 000 $ - $ 271, 946 $ 128, 609 $ 675, 555 1, 312, 841. 00 $ 57, 780 $ 7, 500 $ 15, 000 $ 80, 280 $ 48, 329 $ 128, 609

Questions? Ø Please use #6 to unmute your phone to ask a question, or use the Chat function via Web. Ex.

Charts of Accounts Ø Your charts of accounts are not aligned • While it would be ideal to have the same chart of accounts for all entities, it is not typical. • Approach – consider grouping the companies with like charts of accounts and then prepare summary entries by financial statement line item only to accomplish the consolidation

Classification Issues Ø Reserves are recorded somewhere between current and long term assets on your properties’ financial statements • reserves for operations & escrows for insurance and taxes should be classified as restricted current assets. • replacement reserves should be classified as restricted longterm assets Ø The property records certain expenses differently than you would at the parent company level. – e. g. - payroll is recorded within Repairs & Maintenance at the property level but should be recorded as payroll expense on the statement of functional expense by the non-profit parent • consider how material the classification issue is – if material, calculate and post an entry to the consolidation to adjust

Classification Issues Ø Classification of Cash • If your financials present your properties in a column that is separate from your parent company, then all of the properties’ cash should be classified as nonrestricted. • If you issue single column consolidated statements, then the cash for those properties that are not whollyowned should generally be classified as restricted

Non-Controlling Interests & Eliminations Ø How much of your eliminating entry is to be made against your net income and net assets and what is to be eliminated from the non-controlling interests’ share of net income and net assets? Ø Reporting requirements – Your statement of changes in net assets requires that both your net assets and the non- controlling interest in net assets is presented by net asset classification – unrestricted, temp restricted and perm restricted. • Keep a roll-forward of your non-controlling interests and update it annually with their share of income/expense & distributions

Sample: Non-Controlling Interests December 31, 2011 New Madison Park IV - Related Party Balances Impact of Eliminations on Net Assets and Non-Controlling Interest Parent Company Unrestricted New MP IV GP Net Assets CR (DR) 1% Items eliminated from Net Income (loss) impacting Net Assets Depreciation Expense Network Fees Incentive Fees Interest on Development Fees Distribution to MPDC Impact of Items to be eliminated from Net Assets Distribution from Partner's Capital to Parent by MPIV Unamortized Developer Fee Total Eliminations from Net Assets on Balance Sheet Net Asset Rollforward Beginning Balance of Net Assets/Minority Interest before net loss and eliminating entries (see cap rollforward) Net Income Distributions Ending Net Asset Balance, after Net Income Total Eliminations from Net Income Elimination of Distribution from Net Assets Ending Net Asset Balance, after eliminations $ 57, 780 $ 7, 500 $ - $ 271, 946 $ 337, 226 $ 733, 944 $ 1, 071, 170 New MP IV LP Non-Controlling Interest CR (DR) 99% $ 483 $ 578 $ 75 $ 150 $ - $ 1, 286 $ 47, 846 $ 57, 202 $ 7, 425 $ 14, 850 $ 127, 323 $ 271, 946 $ - $ 273, 232 $ (415, 939) $ 127, 323 $ 250, 846 $ 2, 033 $ (271, 946) $ 201, 257 $ (181, 298) $ (685, 853) $ 270, 806 $ 1, 286 $ 271, 946 $ 273, 232 $ 127, 323 $ (412, 620) $ 398, 129 New MP IV Total $ 48, 329 $ 57, 780 $ 7, 500 $ 15, 000 $ 128, 609 $ 271, 946 $ 400, 555 $ (165, 093) $ 203, 290 $ (453, 244) $ (415, 047) $ 128, 609 $ 271, 946 $ 400, 555 $ (14, 492)

Sample Roll-Forward of Net Assets

Questions? Ø Please use #6 to unmute your phone to ask a question, or use the Chat function via Web. Ex.

Cash Flows Eliminations & the Cash Flows Ø Use the cash flows prepared for each property and then layer on your eliminating entries Ø Eliminating entries = Change in related party balances last year =/- the change in the related party balance this year

Financial Statement/Implementation Issues First Year Issues - Ø Will you present a single stand alone audit without comparative statements or restate the prior period presented? Ø If you present a stand alone audit, your opinion will refer only to that audit – may/may not be allowed by your external users. You will need to restate opening net assets so you will still have to consider the impact of consolidation on the prior year. Ø If you restate, you will restate the prior year’s financials, including opening net assets so you really need to look at consolidation issues/eliminating entries going back two years.

Financial Statement/Implementation Issues Ongoing Issues – Ø Where do eliminations occur? – depends upon whether you issue single column consolidated financials or consolidating financials – this will change as your company grows/changes Ø What is the most efficient way to capture eliminating entries? • Set up eliminations company • Code all related party accounts so that you can easily run reports to identify all accounts to be considered for consolidation/elimination purposes

Conclusion Ø Consolidation of controlled entities can involve a significant amount of upfront investigation to identify assets/liabilities & revenues/expenses to be eliminated Ø If your intercompany accounts are not in balance, you may have current or prior period adjustments to contend with Ø You may need to reconsider your consolidated financial statement format - new columns? Consolidating statements instead of consolidated for more transparent results Ø Although this presentation will show you how to consolidate using Excel, automation of the process is preferred and will depend upon your financial software. Excel, while useful, will not be your friend in the end.

Questions? Ø Please use #6 to unmute your phone to ask a question, or use the Chat function via Web. Ex.

www. strengthmatters. net Visit the Strength Matters Website, and REGISTER to access: Ø 21 White Papers addressing numerous accounting and reporting topics • Consolidations White Papers – 3 a, 3 b & 4 a, 7 Ø Templates for • Management’s Discussion & Analysis • Cash Flow forecasting • Summary of Debt Template • Project Pipeline Template…. . and more!

Contact Information Ø Gayle Harrold: 617 -849 -6224, gharrold@madison-park. org Ø Winell Belfonte: 301 -961 -5546, winell. belfonte@reznickgroup. com Ø Frances Ferguson: 512 -441 -5441, fferguson@nw. org Ø Lindsay Wells, 617 -821 -0463, consult. lwells@gmail. com

Stay Tuned! Upcoming Webinars: Ø Parts 2 & 3 in the Issues With Consolidated Financial Statements Series • Part 2: Financial Statement Formats - Maximizing Readability for Your Board and External Users (Fall 2012 date TBD) • Part 3: Consolidated Financial Statements 101 (early 2013 date TBD) Ø More Webinars coming in 2013! Visit www. strengthmatters. net to view recorded Webinars and download presentations.

Evaluation Ø Please help us improve future sessions! Ø Complete the Evaluation in the Polling panel on the right side of your screen before you exit the Web. Ex meeting. Ø Thank you!