produced by Montana Nonprofit Association
When: January 23, 30, February 6, 13, 20, 27 (Thursday) 6-part course
Time: 12:00 am – 1:00pm
Investment:
Session: MEMBER: $50.00 ; Not yet a member: $100.00
Series: MEMBER: $200.00 ; Not yet a member: $400.00
Go to Upcoming Educational List
Join MNA for a six week webinar series uncovering best practices and easy shifts to enhance your financial savvy and organizational efficiency.
Each session includes a downloadable and customizable Excel template, with instructions for long-term use, to streamline reporting and analysis in your organization.
January 23 | Ratio Analysis
January 30 | Budget Performance
February 6 | Cost/Benefit Analysis
February 13 | Revenue Projection Analysis
February 20 | Cash Flow Projection
February 27 | General Excel Tips and Tricks
WHO SHOULD ATTEND: Nonprofit leadership teams, financial officers, accountants, multi-hat nonprofit staffers
Course Outline
Ratio Analysis | Thursday, January 23, 2020
By the end of this session, participants will be able to:
- Understand which key financial ratios are important for monitoring financial health of an organization
- Calculate key financial ratios from financial statements
- Communicate to employees and stakeholders what each key financial ratio means and what it means for the health of the organization
Topics Covered:
- Financial Stability
- Financial Liquidity
- Operational Performance
- Efficiency
- Margins
+ Downloadable Template: MNA Ratio Analysis Template
Budget Performance | Thursday, January 30, 2020
By the end of this session, participants will be able to:
- Understand the importance of comparing organizational budget to actual financial performance.
- Report monthly and year-to-date (YTD) financial performance as compared to budget.
- Identify and analyze variances between actual and budgeted financial performance.
Topics Covered:
- Budget Building Basics
- Uploading and Downloading Reports out of Accounting System (e.g. QuickBooks)
- Monthly and YTD Variance Analysis
+ Downloadable Template: MNA Budget Performance Template
Cost/Benefit Analysis | Thursday, February 6, 2020
By the end of this session, participants will be able to:
- Understand the importance of analyzing full costs and full benefits of a project/program before initiating.
- Identify and analyze the full costs and full benefits of a proposed project/program.
- Understand the importance of the time value of money in considering a project’s proposed costs and benefits.
Topics Covered:
- Calculating Project/Program Costs
- Calculating Financial Value of Project/Program Benefits
- Analyzing using Time Value of Money
+ Downloadable Template: MNA Cost/Benefit Analysis Template
Revenue Projection Analysis | Thursday, February 13, 2020
By the end of this session, participants will be able to:
- Identify an organization’s major revenue sources.
- Identify and analyze the probability/likelihood and timing of receiving each source of revenue.
- Summarize the timing and probabilities of revenue to be received by the organization.
Topics Covered:
- Revenue Sources
- Probabilities and Risk
- Planning for Variances in Revenue
+ Downloadable Template: MNA Revenue Projection Analysis Template
Cash Flow Projection | Thursday, February 20, 2020
By the end of this session, participants will be able to:
- Identify an organization’s major sources of cash flow.
- Identify and analyze the timing of receiving cash flows.
- Identify and analyze net cash flow by comparing cash received to estimated cash expenses.
Topics Covered:
- Differentiating Revenue from Cash
- Projecting Cash Flow
- Identifying Net Cash Flows
+ Downloadable Template: MNA Cash Flow Projection Analysis Template
General Excel Tips and Tricks | Thursday, February 27, 2020
By the end of this session, participants will be able to:
- Better navigate and use Microsoft Excel
- Use essential Excel formulas for data summation and analysis
- Create a basic PivotTable for data analysis
Topics Covered:
- General Navigation Shortcuts
- Essential Formulas for Data Manipulation and Analysis
- Basic PivotTables
+ Downloadable Template: MNA’s Excel Tip Sheet
Adam Jespersen
Director of Innovation
Adam joined the Montana Nonprofit Association in 2019 as its first Director of Innovation after more than a decade of progressive experience in nonprofit management, leadership, fundraising, and grant writing. Raised in rural Montana, Adam received his bachelor’s degree from Carroll College and his master’s in business administration from the University of Montana. Trained and experienced in Lean management and person-centered design, Adam is passionate about helping people, teams, and organizations across Montana find their stride in being more effective and impactful and has been recognized for his ability to dive headlong into finding solutions and for his cooperative and thoughtful leadership approach. Adam lives in Helena with his wife and two daughters and enjoys hiking, skiing, and all that Montana has to offer.