Question

Land trusts, also known as conservancies, are not-for-profit organizations dedicated to protecting wildlife habitat and natural...

Land trusts, also known as conservancies, are not-for-profit organizations dedicated to protecting wildlife habitat and natural lands by acquiring ownership rights and transfer of development rights (conservation easements) either thru donation or purchase. This series of cases follows a small land trust through the process of budgeting. Case I requires students to develop and analyze an annual line-item budget and translate that budget, and additional information, into a quarterly cash budget. Case II requires students to convert the line-item budget into a functional budget. Further information is employed by students to create a flexible budget. Actual numbers have been obscured while remaining true to the problems faced by the organization.

Chippewa Watershed Conservancy: Not-for-profit Budgeting

Case I: Line-item and Cash Budgets

INTRODUCTION

The Chippewa Watershed Conservancy (CWC) is a small (one staff person) land trust operating in the Mt. Pleasant, Michigan area. Founded in 1985, the CWC has protected 3,494 acres in the Central Michigan area and ranks in the top 10 out of more than 40 conservancies in Michigan in acreage protected. They can be found on the web at www.chippewawatershedconservancy.org.

Brief History

The CWC operated on a volunteer basis from 1985 until 2004. During that time period volunteers performed all management functions and succeeded in protecting more than four square miles of wildlife habitat in five counties. However, it became apparent that due to the increasing number of protected parcels and the evolution of legal requirements and management standards that the CWC needed professional leadership. In 2004 a part-time employee was hired. That position was increased over the next several years to a full-time Executive Director status. Over that time period management responsibilities were transferred from volunteers to the Executive Director. Members of the Board of Directors (BOD) continue to serve in a volunteer capacity; however, most of the management of the organization is now performed by the Executive Director. Some technical functions, such as legal review of conservation easements, annual audit, and some routine accounting are contracted out. Members of the BOD, and other volunteers, continue to help with membership, fundraising, stewardship, and new project evaluation.

The BOD is extremely concerned that the CWC be managed so that it is sustainable. The commitments of land trusts are, by their very nature, long-term (actually perpetual). Therefore, the CWC must ensure that they have a business plan and budget that will ensure their long-term survival.

The Current Situation

The Executive Director is formulating an Operating Budget recommendation for the next year. He has made a series of assumptions based on previous year performance and expectations about the coming year. He is particularly concerned about increased energy costs and a likely recession that may hold down contributions and foundation support. The CWC wants to budget for a 5% (of total expense) surplus to provide protection against unforeseen events.

Your role is to prepare the budget for the following (next) year based on the assumptions adopted by the Executive Director and the budget for the current year. You will also be asked to analyze the results of those budget assumptions.

  

Assumptions for NEXT budget year:

Revenue: Special events will increase by 30% due to a new event. Contributions will increase by 20% due to new membership drives. Grants will fall by half due to the end of a current grant. Interest income will be unchanged from the current year, but endowment income will be up 20% due to large endowment contributions in the current and previous years.

Expenses: Special events will increase by 30% due to an additional event while there will be a 20% increase in fundraising, newsletter, and postage expenses. The staff person has already been notified that he should not expect a raise. All other expenses, with the exception of payroll tax, which is proportional to wages, will increase by 10%.

Current Year Budget

Revenue:                                    Timing:

Special Events          $8,000.     1stqtr. 10%, 2ndquarter 60% and 3rdquarter 30%

Contributions         $40,000.     1stqtr. 20%, 2ndqtr. 20%, 3rdqtr. 10%, 4thqtr. 50%

Grants                    $40,000.     4thquarter 100%

Endowment Income $5,000.     25% each quarter

Interest Income         $1,600      interest on operating fund (1% prev. qtr. ending bal.)

Total Revenue         $94,600.

Expenses:

Travel                        $4,000.     1stand 2ndquarters 20%, 3rdquarter 35%, 4thquarter 25%

Special Events          $8,000.     1stquarter 20%, 2ndquarter 50%, 3rdquarter 30%

Conferences              $2,000.     3rdquarter

Fundraising               $6,000.     1stquarter 20%, 2ndquarter 30%, 4thquarter 50%

Insurance                  $4,000.     1stquarter

Newsletter                 $5,000.     25% each quarter

Postage                      $3,000.     25% each quarter

Professional Fees      $5,000.     1stquarter 70% and 10% each remaining quarters

Publicity                    $3,000.     25% each quarter

Salary                      $38,000.     25% each quarter

Supplies                    $4,000.     25% each quarter

Payroll Taxes            $3,800.     10% of “Salaries and Wages” each quarter

Telephone                 $1,200.     25% each quarter

Total Expense         $87,000.

2)   Prepare a quarterly cash budget for the next year. Assume all revenue and expenses occur on the last day of each quarter. Also assume a $40,000 beginning cash balance. Add 1% each quarter based on the beginning of quarter cash balance (.01 x beginning of quarter cash balance) as interest income. Re-calculate the “Interest Income” line item for the year.

      a)  Does the CWC have adequate cash reserves to get them thru the year?

      b)  How large (calculated both as a dollar amount and as a percent of annual expense) is the

            lowest quarterly ending cash balance?

      c)  If they lack sufficient cash flow, what might they do to correct the problem?

      d)  Why did the Interest Income line item increase (decrease) from the budgeted amount?

Homework Answers

Answer #1

(a) CWC required a reserve of 5% of total expense to get it thru the year, which is 1280, 1080, 1040 and 950 for 1st, 2nd, 3rd and 4th quater respectively. And cash balance for respective quaters are 26050, 18900, 6011 and 48450. So the cash balace is adequate to get CWC thru the year.

(b) Lowest quaterly ending cash balance is 6011 and it is approximately 29% of that quater total expense.

(c) They may take a loan from bank or try to decrease or defer their cash outflows and increase or try to collect their cash inflows as early as possible.

(d) As Interest income is receivable on the balance of cash held in bank account. So if the balance is more, then the amount of interest will increase and vice versa.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Land trusts, also known as conservancies, are not-for-profit organizations dedicated to protecting wildlife habitat and natural...
Land trusts, also known as conservancies, are not-for-profit organizations dedicated to protecting wildlife habitat and natural lands by acquiring ownership rights and transfer of development rights (conservation easements) either thru donation or purchase. This series of cases follows a small land trust through the process of budgeting. Case I requires students to develop and analyze an annual line-item budget and translate that budget, and additional information, into a quarterly cash budget. Case II requires students to convert the line-item budget...
Taos Museum of Southwestern Arts and Crafts The Taos Museum of Southwestern Arts and Crafts (TMSAC)...
Taos Museum of Southwestern Arts and Crafts The Taos Museum of Southwestern Arts and Crafts (TMSAC) presents rotating exhibits of the works of artists and artisans from the Southwestern United States. Historically, the museum has derived its funding from three sources: grants, annual memberships, and visitor revenues. For its next fiscal year, TMSAC expects to receive $564,000 in grants from various sources. It also expects 1,255 people to be supporting members of the museum. On average, supporting members each give...
The Halls Gap Wildlife Park offers a unique Australian wildlife experience. The park offers a scenic...
The Halls Gap Wildlife Park offers a unique Australian wildlife experience. The park offers a scenic comfortable nature walk around the facilities, with the chance to get up close and personal to some of Australia’s most famous native animals. With over 100 kangaroos roaming free, around the park, there is an opportunity to experience hand feeding these amazing animals. Visitors also have a chance to interact with koalas, wombats, and a variety of reptiles ranging from snakes to lizards and...
for the scenario below: 1) Apply the qualitative analysis by identifying at least 3 issues in...
for the scenario below: 1) Apply the qualitative analysis by identifying at least 3 issues in the above process. Analyse these issues by using a. Adding-value and Waste Analysis b. Issue register, If you find that there are more than three issues, you can focus on the three issues that have the highest impact. 2). Calculate the cycle time efficiency of the as-is process. You can assume a working week of 40 hours. In case there is missing information, you...
Buddies is a charitable organization that sponsors group activities and provides adult companionship for troubled youths...
Buddies is a charitable organization that sponsors group activities and provides adult companionship for troubled youths from single-parent families. Buddies screens, trains, motivates, and supervises the adult volunteers, who are paired with children referred by local agencies and by parents concerned with their children’s future. The organization provides a service that can augment any professional help a child may be receiving. But its main role is one of prevention by providing a meaningful adult relationship for a child before the...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the new accounting period. All real accounts are closed but not the nominal accounts. All balance sheet accounts are closed. All temporary accounts are closed but not the permanent accounts. All permanent accounts are closed but not the nominal accounts. 4.A wholesaler is an intermediary that buys products from manufacturers or other wholesalers and sells them to consumers.Immersive Reader (1 Point) True False 5.The Merchandise...
Beth R. Jordan lives at 2322 Skyview Road, Mesa, AZ 85201. She is a tax accountant...
Beth R. Jordan lives at 2322 Skyview Road, Mesa, AZ 85201. She is a tax accountant with Mesa Manufacturing Company, 1203 Western Avenue, Mesa, AZ 85201 (employer identification number 11-1111111). She also writes computer software programs for tax practitioners and has a part-time tax practice. Beth is single and has no dependents. Beth was born on July 4, 1972, and her Social Security number is 123-45-6789. She wants to contribute $3 to the Presidential Election Campaign Fund. The following information...
Team 5 answer the questions What are 4 key things you learned about the topic from...
Team 5 answer the questions What are 4 key things you learned about the topic from reading their paper? How does the topic relate to you and your current or past job? Critique the paper in terms of the organization and quality. Incentive Systems             In this paper, we will focus primarily on financial rewards that companies use to attract, retain and motivate the brightest and most talented candidates in the labor market. By providing a reward system that...
Unhealthy Accounting at HealthSouth PROBLEM In 1996, key executives of HealthSouth, one of the nation’s largest...
Unhealthy Accounting at HealthSouth PROBLEM In 1996, key executives of HealthSouth, one of the nation’s largest providers of health care services, began a massive fraud that eventually amounted to $2.7 billion. HealthSouth is a textbook case of unbridled greed combined with a lack of corporate governance, which illustrates the difficult situation that auditors face when clients perpetrate a massive, collusive fraud. HealthSouth was founded in 1984 by Richard Scrushy and coworkers at Lifemark, a Houston-based company that owned and managed...
Read the attached articles about the proposed merger of Xerox and Fujifilm. Utilizing your knowledge of...
Read the attached articles about the proposed merger of Xerox and Fujifilm. Utilizing your knowledge of external and internal analysis, business and corporate strategy, and corporate governance, please discuss the following questions: 1. What is the corporate strategy behind the merger of Xerox and Fujifilm? 2. Why did Xerox agree to the merger? Is this a good deal for Xerox? Discuss the benefits and challenges they face with the merger. 3. Why did Fujifilm agree to the merger? Discuss the...