Annual Budget Formation

Nashville, US-TN America/Chicago 5 hours, 29 minutes ago Be the first to apply to this opportunity

Youth Development Multi-Week

Relevant Skills

Accounting

Budgeting

Cash Flow Forecasting

Financial Analysis

Apply Now

About the Opportunity

Black Lemonade operates on a calendar fiscal year (January to December), but the majority of our major institutional and public grantors operate on a July to June funding cycle. Because of this structural offset, our team must build a split-cycle annual operational budget: an "Actuals Budget" covering January through June based on fully secured revenue, and a "Proposed Budget" covering July through December based on anticipated grants, pending renewals, and fundraising projections. We need an expert financial strategist to build a dual-cycle budget template and forecasting framework that streamlines this complex process.

Managing split grant cycles alongside our internal fiscal year creates cash flow forecasting bottlenecks and makes mid-year reporting to our board complex. In the past, we have managed this using standard single-year spreadsheets, but they fail to capture the reality of our overlapping multi-year grants (such as NAZA, CFMT, and Maddox Fund). This manual workaround takes critical administrative time away from program expansion into Evansville and Memphis and makes it difficult to project operational needs accurately for the second half of the year.

By the end of this project, Black Lemonade will have an intuitive, automated budget model that bridges our calendar fiscal year with our funders' July to June cycles. The consultant will equip our leadership with a clear financial tool to track real-time secured revenue for Q1-Q2 while seamlessly modeling projected revenue, funding gaps, and restricted line items for Q3-Q4.

Custom Financial Matrix (Excel/Google Sheets): A multi-tab, automated master budget spreadsheet designed specifically for dual fiscal year tracking (Jan-Jun Secured vs. Jul-Dec Projected).
Grant Mapping & Revenue Waterfall Tool: A visual schedule that tracks restricted grant dollars across overlapping performance periods.
Standard Operating Procedure (SOP) & Training: A brief 1-page user guide and a 30-minute walkthrough session for our executive leadership.
Success Metric: Our leadership team can update actuals versus projections in under 30 minutes a month, clearly present cash flow health to the board, and instantly identify Q3-Q4 funding gaps to target with corporate asking.

About the Org

Location

Nashville, US-TN

Timezone

America/Chicago

Website

https://www.blacklemonade.org

Organization Mission

At Black Lemonade, we provide ongoing support to underserved youth by educating and equipping them with the tools they need to reach their full potential. By investing in those who face systemic barriers, we create pathways for all youth to thrive—because when we uplift the most vulnerable, we strengthen the entire community. (Founded to turn lemons into lemonade for minority and underserved communities so that we all may live more equitable lives.)

Member Since

Dec 2025

Completed Taproot Plus Partnerships

Program Focus Areas

Advocacy & Human Rights
Child & Teenage Education
Community Building
Diversity, Equity, & Inclusion
Employment & Job Training
Human Services
Social Justice
Youth Development

Other Needs from This Organization

See Similar Opportunities

See All

Opportunities

Philanthropy & Capacity Building Website development Multi-Week

The WildRoot Collective is seeking a web designer or developer to help us create a professional, user-friendly website that reflects our mission, programs, and community...

Posted

Education Messaging Multi-Week

We are searching for a volunteer who can lead our development of a new and improved mission and vision statement that will communicate our purpose and vision to a variety of...

Posted August 21, 2025

Community Development Other Multi-Week

As Girls in Gear continues to grow nationwide, we would like help establishing a corporate sponsorship strategy. Our goal is to obtain corporate sponsorships to support the...

Posted July 22, 2025