Average weekly Sunday morning collections are $20,390 except for two weeks in December, which have historically shown a doubling of normal weekly giving. Typical Sunday attendance is around 850 persons, split fairly evenly between the three services. HCC also hosts Wednesday night activities for both children and teenagers. In addition, HCC strives to serve its community by being involved in serving at a local soup kitchen, outreach to the homeless community, serving at local food pantries, and serving incoming refugee families. The church does not want to see their outreach to the community decrease and, therefore, $100,000 in annual outreach obligations must be met before any additional funds can be spent on additional capital improvement or expansion. The paid pastoral staff includes the following positions with salaries and benefits: Senior Pastor, responsible for preaching, $80,000. Worship Pastor, responsible for planning and leading music ministry, $45,000. Youth Pastor, responsible for administrating and overseeing ministry to teenagers, $45,000. Reaching and Sending Pastor, responsible for administering and overseeing programs that minister to people outside of the church body, $38,000. Adult Discipleship Pastor, responsible for administering and overseeing programs that minister to adults attending HCC, $40,000. Children’s Pastor, responsible for administering and overseeing programs that minister to children through age 12, $42,000. Yearly operating costs (excluding the salaries, benefits, and outreach obligations) are $200,000 at the old site and $175,000 at the new site. In addition, HCC is paying the $1.8 million mortgage monthly over 20 years at 5.45 percent. This amount is in addition to the other operating costs. HCC elders request that 10 percent of revenues be set aside each year as cash reserves for unexpected expenses and opportunities. Data Projections for Options 1, 2, and 3 The estimated cost to staff a second preaching pastor is $85,000 per year in salary and benefits. The elders have determined that additional administrative expenses equivalent to 10 percent of non-preaching pastors’ salaries and benefits would need to be incurred if Option 2 is chosen. The estimated costs for purchasing and utilizing video equipment are listed in Table 1. The average life expectancy for the video equipment is estimated at five years, except for the cameras, which have an expected life of ten years each. Cost of building a room for video equipment at new site: $17,500. Potential future costs for adding data storage and video-editing capabilities are listed in Table 2. These expenditures are not needed initially, and can be delayed two years in the future. The life expectancy of this additional equipment is estimated at five years, except for the workstation, which has an indefinite life. The weekly operation of the video equipment would be provided by church volunteers. Most of the service depends upon volunteers. Most of the musicians, technicians, ushers, greeters, childcare workers, and Sunday school teachers are not paid staff. This would be another area that would draw upon the pool of volunteers to staff this ministry. HCC has seen significant growth during its 30-year history. Therefore, after significant discussion, the elders estimate that growth in attendance will be 30 persons each year (cumulative) for the next five years if either Option 1 or Option 3 is selected. Revenues received are expected to increase proportionally. No growth is foreseen if Option 2 is selected. Forecasting beyond five years is less reliable and growth beyond 1,000 attendees leads to the need for additional support staff in other areas.

Questions 5. Provide a cash flow analysis, similar to the analysis of the current year prepared in the prior question, for each of the three alternatives for the coming five years. For each option, determine how many people must attend in order to breakeven for all five years, in addition to the margin of safety (in attendees) for each year based on projections.

6. Calculate the net present value (NPV) of each option. In order to cover the cost of debt, the operating costs, and the projected growth, assume an 8 percent discount rate for Options 1 and 2. Option 3 introduces a new methodology for conducting the sermons and includes more permanent costs of fixed assets; therefore, a 10 percent discount rate is appropriate for Option 3. In addition, for each option determine the smallest yearly attendance growth that will make the option viable.

7. What additional types of information, including qualitative measures, would you need in order to assess the validity and appropriateness of each of the three options? What additional questions need to be answered in order to make an assessment? Table 1 Initial Purchase Cost of Video Equipment Item Cost Three cameras $21,500 HD projectors and adaptors $7,800 Video switcher $6,000 Hyperdeck shuttle/SSD drives $ 4,750.00 Tripods/Heads $ 4,500.00 Zoom controls $ 2,850.00 VGA converters $ 600.00 Monitors $ 550.00 SDI distribution $ 500.00 DVD player w/HDMI $ 400.00 Sxs card/SD card $ 300.00 Ethernet switch $ 100.00 Total $ 49,850.00 Table 2 Potential Future Costs of Video Equipment Items Cost Workstation for recording and editing video $ 5,000.00 Monitors $ 250.00 Video card $ 1,000.00 Video software (Final Cut Studio) $ 300.00 Data storage server $ 2,400.00 3-monitor camera view board $ 1,000.00 Total $ 9,950.00

Answer rating: 100% (QA)

5 Option 1 Year 1 Income 20390 Expenses 200000 Mortgage 18 million Outreach 100000 Reserves 2039 Net Income 4649 Year 2 Income 21219 Expenses 200000 M... View the full answer