Case 4.5: Promoting All Students’ Success (PASS)
BACKGROUND
The small not-for-profit Christine Chang started in graduate school, Promoting All Students’ Success (PASS), was more successful than she had imagined. She had taken an education policy course in graduate school in which she learned about the disparities in achievement gaps due to chronic underfunding in public schools. Her interest in after-school tutoring followed recent changes in state policy that would require students to pass a series of end-of-year exams to qualify for graduation. However, the last three years of operating budget deficits resulted in cutbacks in after-school programs and services, including after-school tutoring and test-prep courses. The state was also unwilling to fund these programs, arguing that learning and test prep should happen during regular school hours. Students, particularly those from low- and middle-income families who needed assistance, would fail their qualifying exams because they could not access free or low-cost after-school tutoring sessions.
Recognizing this need, Chang enlisted friends, including students taking courses at the School of Education, and began offering free after-school tutoring services at local high schools. They started by reaching out to schools over the summer, and by August 2018, they had more students than they could handle. It was evident to her that there was an urgent need to provide after-school tutoring services – it was time for her to launch Promoting All Students’ Success or simply PASS!
FINANCIAL INFORMATION
In November 2018, a local newspaper ran a story about PASS’s efforts which attracted the interest of a local entrepreneur, Charles Duncan. Duncan had been a borderline student in high school and had been lucky to graduate, so he contacted Chang to discuss her program.
Chang and Duncan met up the day before Christmas. At that meeting, Chang briefed Duncan on her initial thoughts on PASS’s operational structure, including inviting Duncan to serve as the chair of the Board of Directors for PASS. Duncan was impressed enough with Chang’s vision and offered her a $100,000 low-interest loan to turn PASS into a full-time venture. As he wrote her the check, Duncan noted there would be a conflict of interest, as he was PASS’s initial and sole investor. Nevertheless, he knew Chang needed his support, and he would be able to use his networks to solicit additional financial support for the organization.
Chang immediately deposited the funds in a checking account. She went home to celebrate the holiday with her family, knowing she had an exciting year ahead of her (for FY 2018, see Statement of Financial Position).
- Chang was daunted by Duncan’s generosity – but knew there was much work to do. She resigned from her position at a local nonprofit and rented office space, signing a one-year $1,750 per month lease. Rent for the space is on the first of each month.
- On January 5, 2019, PASS officially opened for business. Chang’s first order of business was to invest $20,000 of the $100,000 she had received from Duncan. She wanted to make sure she could earn interest on these funds. After conversations with a local bank manager, she decided to engage the services of an investment manager and invest the funds in a low-risk US equities mutual fund. She wrote a check for $20,000 on the 8th of January.
- Utilities (e.g., electric, water and sewer, garbage) for the new office space are expected to average $350 per month. Payments on outstanding balances were due on the 15th of the following month.
- Chang was initially the only employee at PASS serving as the Executive Director, lead tutor, and chief fundraiser. On January 10, 2019, the board voted to pay Chang a salary of $3,500 per month and contribute an additional $315 toward her health insurance. Payroll was processed at the end of each month, and all salaries and benefits were paid on the 7th of the following month.
- Following the approval of an operating budget at the first board meeting, Chang took advantage of an after-Christmas sale at Best Buy. The computers, laptops, tablets, phones, and printers worth $15,250 were paid in cash. Chang expected the computing equipment would have a useful life of 4 years and no salvage value. She anticipates applying the straight-line depreciation method to account for depreciation expense.
- Chang also took advantage of a back-to-school sale at a local office supply and bookstore store. She purchased $1,375 in student workbooks and teaching supplies to distribute to students enrolled in area schools and used others in the tutoring sessions. The bookstore owner heard about PASS and Chang’s work and offered to donate $150 in teaching supplies per month. Chang expected the first delivery on February 1, 2019. Deliveries were due by the 10th of each month. Given the number of students participating in the program and visits to school districts and other learning centers, Chang does not expect excess teaching supplies or resources to remain at the end of each fiscal year.
- By March 2019, Chang and Duncan had some fundraising successes. Duncan had received commitments from his network of family, friends, and business associates. They had agreed to provide PASS with $18,750 in unrestricted public support. The donors agreed to make payments on these commitments in July ($3,500), August ($5,000), October ($4,000), and December ($2,500). Duncan expected a few of the donors would likely not make payments on their commitments. PASS would need to report adjustments to revenues of $750 to account for uncollectable pledges. The remainder of the pledges will be received by February 2020.
- Chang worked hard to prepare and submit a grant proposal to the McNamara Foundation. After an intensive vetting process, she received the news that the foundation would support PASS’s efforts in closing the achievement gap. On April 2, 2019, she received a check for $30,000 from the foundation. The foundation did not impose any restrictions on the $30,000 grant.
- Despite initial successes, Chang and the Board of Directors realized they could not run the program strictly through grants and contributions – the school districts would need to cover a share of the costs of the tutoring program. In April, Chang reached out to the school districts she worked with and told them there would be a $125 in-school tutoring fee per student per month. Students would receive tutoring services from September through May. Teachers and other school administrators knew this was well below what it would cost them to provide the services. Two of the five school districts agreed to pay the tutoring fee. They each signed up 25 students. Beginning October 1, Chang billed the school districts monthly for services provided in the previous month. She gave the school districts one month to pay the invoice. In other words, if she sent a bill for September tutoring services on October 1, payment would be due by October 31. Even though the districts never paid early, they did make payments within the 30-day grace period.
- Chang spent the summer preparing to expand the program in the fall. She hired seven part-time tutors at $17.50 per hour for 80 hours each month. Tutors signed 9-month contracts beginning September 1. To keep costs down and ensure the workload was manageable, Chang and the volunteers from the School of Education continued to tutor students at the various school districts. Payroll was processed at the end of each month, and all salaries and benefits were paid on the 7th of the following month.
- Chang also decided that transportation was the organization’s most pressing need, particularly with the seven new tutors on board. After shopping around, she decided to purchase two certified pre-owned vehicles for a total of $42,000. She made a $7,000 down payment and took out a five-year loan at 4.5% interest to finance the rest. Monthly payments of $652.51 are due at the beginning of each month, starting September 1 (see Exhibit 1).In six years, the vehicles are expected to have a salvage value of $10,000. Vehicles are to be depreciated on a straight-line basis with partial-year depreciation pro-rated based on the number of months in service.
- Insurance on the two vehicles was $1020 per quarter. Payments were due in advance. Chang made two payments before the end of the year – on September 1 and again on December 1. The team would coordinate their schedules so the vehicles would be available for tutoring visits. They drove quite a few miles and used an average of $250 per month in gas.
- On December 1, 2019, Chang received more good news from the Sloane Stephens Foundation (SSF). Having heard about PASS’s work in the community, the SSF awarded PASS a $25,000 grant. The SSF grant comes with restrictions. PASS was to invest the money and use the earnings to subsidize as many participants as possible. Doing so would allow more students to participate in the program at no cost to the school districts. After depositing the check, she initiated a wire transfer to the low-risk US equities fund. Upon receipt of the fund transfer, Chang briefly talked with the investment manager, who told her that these additional funds would not yield returns by the end of PASS’s fiscal year as the transfer occurred in the last month of the fiscal year.
- By Christmas 2019, Duncan was impressed enough with Chang’s work and PASS’s accomplishments that he agreed to forgive $40,000 of the $100,000 loan. To account for the loan forgiveness, PASS would need to recognize the value of the forgiven loan as revenue without donor restrictions. Even so, Duncan expected to receive payment on the balance of the loan and interest as agreed. Chang anticipated paying $10,000 of principal plus 3 percent interest on the outstanding balances by December 31, 2019. Going forward, Chang anticipated making an annual payment on the outstanding principal of $10,000.
- Before the end of the year, Mrs. Hughes and four other parents came to Chang’s office. They had heard about PASS’s work and student achievements to date. They wanted to enroll their children in the tutoring program starting in January 2020. They knew they would not be able to cover the full cost of PASS’s services. They had raised $2,250 amongst themselves and hoped Chang would agree to tutor their children in the upcoming year. Chang was unsure she could provide the service directly to students without the additional vetting and review process the school districts provided her. She accepted the deposit from the parents but knew this was an issue she needed to bring to the board’s attention.
- On January 5, 2020, the investment manager reported to Chang and the nonprofit board that PASS’s investment account balance was $48,748.
The Board expected to meet at the start of the new year to review events of the past year. Chang was excited about all PASS achievements and the future. Ahead of the meeting, Duncan asked Chang for copies of PASS’s financial statements to evaluate the organization’s financial position and operating performance. Chang panicked. While she had kept good records, she had not prepared any formal financial documents. Looking back, she wished she hadn’t avoided that financial management course in graduate school!
ASSIGNMENT
Demonstrate the impact of each transaction on the organization’s assets, liabilities, or net assets using the following Microsoft Excel Template ( https://bit.ly/44V9yk9).
Use the transaction sheet to execute transactions and prepare the Basic Financial Statements for PASS, including a Statement of Financial Position (or Balance Sheet), a Statement of Activities (or Income Statement), and a Statement of Cash Flows. In preparing the Basic Financial Statements, you may assume that on January 1, 2019, PASS reported $100,000 in cash and $100,000 in long-term liabilities (with $10,000 due in 2019) and zero ($0) in net assets. The fiscal year ended December 31, 2019. Revenues for the year can be reported as either without donor restrictions or with donor restrictions.
In 200 words or less, provide the board of directors (BOD) with an assessment of PASS’s financial performance and operating position.
Hint: You’ll need to estimate nonprofit financial ratios that are relevant to your assessment. The Nonprofit Financial Assessment Worksheet could inform your assessment of the nonprofit’s strengths and weaknesses. Be aware that you will not have sufficient information to calculate every ratio listed in the text.
Promoting All Students’ Success was developed by Professor Ross Rubenstein and is included here with modifications.
EXHIBIT 1
Tutoring Service Vehicles: The vehicles were purchased for $42,000. In six years, they are expected to have a salvage value of $10,000. Vehicles are to be depreciated on a straight-line basis with partial-year depreciation pro-rated based on the number of months in service/use.
The payment schedule for the loan is as follows:
Value of Vehicles | $42,000 | |||
Loan | $35,000 | |||
Annual Percentage Rate (APR) | 4.50% | |||
Loan Period (Years) | 5 | |||
Payment (per month) | $652.51 | |||
Payment Due First of | Car Loan Payment | Interest Payment | Principal Payment | Remaining Balance |
Sept-19 | $652.51 | $131.25 | $521.26 | $34,479 |
Oct-19 | $652.51 | $129.30 | $523.21 | $33,955.53 |
Nov-19 | $652.51 | $127.33 | $525.17 | $33,430.36 |
Dec-19 | $652.51 | $125.36 | $527.14 | $32,903.22 |
Jan-20 | $652.51 | $123.39 | $529.12 | $32,374.10 |
Feb-20 | $652.51 | $121.40 | $531.10 | $31,843.00 |
Mar-20 | $652.51 | $119.41 | $533.09 | $31,309.90 |
Apr-20 | $652.51 | $117.41 | $535.09 | $30,774.81 |
May-20 | $652.51 | $115.41 | $537.10 | $30,237.71 |
Jun-20 | $652.51 | $113.39 | $539.11 | $29.698.60 |
Jul-20 | $652.51 | $111.37 | $541.14 | $29,157.46 |
Aug-20 | $652.51 | $109.34 | $543.17 | $28,614.29 |
Sep-20 | $652.51 | $107.30 | $545.20 | $28.069.09 |
Oct-20 | $652.51 | $105.26 | $547.25 | $27,521.85 |
Nov-20 | $652.51 | $103.21 | $549.30 | $26,972.55 |
Dec-20 | $652.51 | $101.15 | $551.36 | $26,421.19 |
Total Interest Payment | Total Principal Payment | |||
2020 | $513.24 | $2,096.78 | ||
2021 | $1,348.04 | $6,482.03 |