1 / 59

Example Title Screen # 1

Financial Analysis for Nonprofit Organizations. Example Title Screen # 1. Presented by: Karl Pnazek, CAP Services, Inc. John Hemming, Wipfli, LLP NASCSP Monitoring Training May 2006. Example Sub Title. Introduction .

nuwa
Download Presentation

Example Title Screen # 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Financial Analysis for Nonprofit Organizations Example Title Screen # 1 Presented by: Karl Pnazek, CAP Services, Inc. John Hemming, Wipfli, LLP NASCSP Monitoring Training May 2006 Example Sub Title © 2005 Wipfli LLP

  2. Introduction • Financial Analysis covers all aspects of an organization and can be incorporated into, and obtained from, many aspects of an organization, including: • Program reports • Program financial statements • Agency financial statements © 2005 Wipfli LLP

  3. Introduction • You will learn how organization’s should be looking at internal information and what you should be asking to ensure fiscal stability within the organization. © 2005 Wipfli LLP

  4. Introduction • Currently, what tools does the organization use? • How often do they use them? • How do they work? • What is their biggest frustration? © 2005 Wipfli LLP

  5. Agenda • What we will cover: • What information should the organization be looking at on a monthly basis? • Agency-wide information • Program information • Trends • Key numbers • Supporting information © 2005 Wipfli LLP

  6. Agenda • What information should the organization be looking at on an annual basis? • Agency-wide information • Analyticals • Program information © 2005 Wipfli LLP

  7. Schedule A Overview • How does all this fit together? • Easy!! It leads to a more productive and better informed organization!! Trends Reports Ratios Tax Returns Key #’s Audit I/S B/S © 2005 Wipfli LLP

  8. Topic 1 – Monthly Financial Procedures • Most important item to review is the agency-wide trial balance (How often is the organization reviewing their agency-wide trial balance? It should be monthly) (What should a monitor look for?) © 2005 Wipfli LLP

  9. Topic 1 – Monthly Financial Procedures FOUR (4) KEY QUESTIONS TO ASK AND ANSWER • What is it? • Where is it from? • What does it mean? • What do we do with it? © 2005 Wipfli LLP

  10. Topic 1 – Monthly Financial Procedures • First thing to know about the trial balance is where do the numbers come from. • Must have a review system in place that requires balances to be reviewed, reconciled, and adjusted on a regular basis. © 2005 Wipfli LLP

  11. Topic 1 – Monthly Financial Procedures • If the numbers aren’t supported by reliable information, the rest of analytical process is a waste of time. • Also, if numbers aren’t reliable the information reported to funding agencies, program directors and your board is incorrect. (And a waste of their time!) © 2005 Wipfli LLP

  12. Topic 1 – Monthly Financial Procedures • What should you be looking for on the agency-wide balance sheet? • Does the balance sheet balance?! • Does the bank reconciliation agree to the general ledger? • Are there any credit balances in the asset accounts? © 2005 Wipfli LLP

  13. Topic 1 – Monthly Financial Procedures • What should you be looking for… (continued) • Do subsidiary ledgers support the reported amounts on the balance sheet? • Did the organization buy any equipment this month with agency funds? Was it recorded properly? © 2005 Wipfli LLP

  14. Topic 1 – Monthly Financial Procedures • What should you be looking for… (continued) • Are there any debit balances in the liability accounts? • Was any new debt incurred? If so, was it recorded properly? (Can be a very detrimental adjustment at year-end if not recorded properly) © 2005 Wipfli LLP

  15. Topic 1 – Monthly Financial Procedures • Overall, does it look reasonable? Any odd looking accounts? If so, were they looked into? © 2005 Wipfli LLP

  16. Topic 1 – Monthly Financial Procedures • If the balance sheet is correct, then the revenues and expenses are usually correct, but may be misclassified. © 2005 Wipfli LLP

  17. Topic 1 – Monthly Financial Procedures • Next, analyze the individual program trial balances and results. • Any odd looking balances in the revenues? • Any odd looking balances in the expenses? © 2005 Wipfli LLP

  18. Topic 1 – Monthly Financial Procedures • Next, analyze the individual program trial balances...(continued) • Have all revenues been recorded properly? • What is the bottom line? Are they over spent? • Have they recorded all of your invoices properly or receivables properly? © 2005 Wipfli LLP

  19. Topic 1 – Monthly Financial Procedures • Next, analyze the individual program trial balances...(continued) • How is the program doing compared to budget? • Any significant over spent areas? • Do they need to get modification from their funding source? © 2005 Wipfli LLP

  20. Topic 1 – Monthly Financial Procedures © 2005 Wipfli LLP

  21. Topic 1 – Monthly Financial Procedures • A true budget reflects anticipated activity during certain times of the year, not equally throughout the year © 2005 Wipfli LLP

  22. Topic 2 – Annual Analytical Procedures • On the agency-wide trial balance, be sure that all accounts reconcile with supporting information © 2005 Wipfli LLP

  23. Topic 2 – Annual Information • Compare the year- end balances to prior year- end balances. • Can the organization explain the variances? © 2005 Wipfli LLP

  24. Topic 2 – Annual Information • What should you look for? • Is the cash balance up from prior years? If so, why? • Are their receivables down? • Are their payables down? • What is their deferred revenue balance? Each of these has a direct effect on their cash balance, both positively and negatively! © 2005 Wipfli LLP

  25. Topic 2 – Annual Information • Are their prepaid balances comparable to prior year? If not, why? • If they have increased, have their corresponding expenses increased too? • Or have their expenses not been recorded in the proper period? © 2005 Wipfli LLP

  26. Topic 2 – Annual Information • Does their physical inventory of property and equipment agree with their property and equipment on their general ledger. • Required to be done once every two years!! • If their property and equipment balances increased, has their depreciation expense increased? • If property and equipment is down, and disposals were sold, was the sale recorded properly? © 2005 Wipfli LLP

  27. Topic 2 – Annual Information • Are their accounts payable up? If so, are their overall expenses up as well? • Or, are they experiencing cashflow problems, which may become greater when carried over to the next year. © 2005 Wipfli LLP

  28. Topic 2 – Annual Information • Are their accrued wages up in proportion to the increase in wage rates? • Have they added new programs therefore adding new staff? If so, did their accrued vacation increase proportionately too? • What about other benefit accruals? Do they make sense given the level of employees? © 2005 Wipfli LLP

  29. Topic 2 – Annual Information • How do their deferred revenues compare to prior years? Can they explain the variances from prior years? • Finally, most important number to verify is net assets. Do they agree with their prior year audit? If not, why? • There should be NOadjustments to this account during the year. © 2005 Wipfli LLP

  30. Topic 2 – Annual Information • What other accounts do they have? What would account for their fluctuations? Can they explain the variances? © 2005 Wipfli LLP

  31. Topic 2 – Annual Information • Next, look at their income statement in comparison to prior years. • Are revenues up? • Did they get new programs? • Did they get increases in your existing programs? © 2005 Wipfli LLP

  32. Topic 2 – Annual Information • How do their overall expenses look? • Are salaries up? If so, is this increase comparable to wage increases, or did it come from new staff and new programs? (Remember to relate this to their balance sheet amounts for accrued payroll and benefits.) • Are they renting new facilities? • Or have their lease costs increased? • Are they budgeting for anticipated (or built in) rental cost increases? © 2005 Wipfli LLP

  33. Topic 2 – Annual Information • How does their depreciation expenses compare to prior years? Again, relate this to their balance sheet analysis for property and equipment. • How about interest expense? • Does it agree with their year end statement from their bank? • How have they planned for or budgeted for their insurance increases? © 2005 Wipfli LLP

  34. Topic 2 – Annual Information • Overall, what is their bottom line? • Excess revenues over expenses? • If so, why? • Fee for service activities? • Fund-raising campaign? © 2005 Wipfli LLP

  35. Topic 2 – Annual Information • Overall, what is your bottom line? • Excess expenses over revenues? • Are programs overspent? • Did they lose funding and not cut expenses? © 2005 Wipfli LLP

  36. Topic 2 – Annual Information • The organization should be able to answer all of these questions. They will be asked by all who use their statements. © 2005 Wipfli LLP

  37. Topic 3 – Audited Financial Statements • Parts of an Audit Report • Financial • Opinion • Statement of Financial Position • Statement of Activities • Cashflow Statement • Notes to the Financial Statements © 2005 Wipfli LLP

  38. Topic 3 – Audited Financial Statements • Parts of an Audit Report • Internal Control Over Financial Statements • Compliance and Internal Control Over Major Programs • Supplemental • Funding Source Requirements © 2005 Wipfli LLP

  39. Topic 3 – Audited Financial Statements • Footnotes to the financial statements provide the reader with information to further understand the financial information. • It describes the significant account policies. • Provides more detailed information to material account balances. © 2005 Wipfli LLP

  40. Topic 3 – Audited Financial Statements • Basis of Presentation • Accrual • How do they record grant awards? • Description of Cost Allocation Plan © 2005 Wipfli LLP

  41. Topic 3 – Audited Financial Statements • Other disclosures: • Concentration of cash, if cash balances are over $100,000 (the FDIC insured limit) • Terms of notes receivable and payable • Related parties • Subsequent events • Commitments and contingencies • Functional classification of expenses © 2005 Wipfli LLP

  42. Topic 3 – Audited Financial Statements • Other disclosures: • Retirement plan • Leases • Related parties • Property and equipment • Descriptions of material balance sheet items © 2005 Wipfli LLP

  43. Topic 3 – Audited Financial Statements • Other disclosures: • Revolving loans (housing) • Notes/mortgages payable • Changes in accounting policy • Prior period adjustments © 2005 Wipfli LLP

  44. Topic 3 – Audited Financial Statements • Schedule of Federal Expenditures has two purposes: • Fulfills A-133 requirements for disclosing expenses based on CFDA #’s (Catalog of Federal and Domestic Assistance). • Breaks down annual activity by individual grant. © 2005 Wipfli LLP

  45. Topic 3 – Audited Financial Statements © 2005 Wipfli LLP

  46. Topic 3 – Audited Financial Statements • Which programs do they subsidize on an annual basis? • How much reserves do they have on hand and how long will they last if they continue to subsidize? • Every program should be analyzed to gain information © 2005 Wipfli LLP

  47. Topic 3 – Audited Financial Statements • How should you use this schedule? • Review each grant and program to see if it appears reasonable • Which programs are overspent? • Which programs are under spent? • If there is an over expenditure, who is paying for it? • CSBG $$, Agency $$, private funding sources © 2005 Wipfli LLP

  48. Topic 3 – Audited Financial Statements • If a grant is completed, did they spend it all? • Are the individual line items in line within the grant budget? • If they didn’t spend it all, have they requested carryover? • Or do they have to return unspent funds? © 2005 Wipfli LLP

  49. Topic 3 – Audited Financial Statements • Are there any negative expenses? If so why? Is there something that should be reclassified? • What was the outcome of their agency activity? • Did they have to use reserves to fund overspent grants? • Did they add to your unrestricted net asset balance? Or take away? © 2005 Wipfli LLP

  50. Topic 3 – Audited Financial Statements • What is the balance of their temporarily restricted net assets? And what are they restricted for? • What is the balance of their unrestricted net assets? And how is it funded? i.e., property and equipment, receivables, loans, or cash? • If either one (temporarily or unrestricted net assets) is in a deficit position, this needs to be addressed ASAP!! © 2005 Wipfli LLP

More Related