You work for a non-profit organization that receives monthly contributions that vary seasonally throughout the year. Contributions normally peak at the end of the year, but the NPOs expenses are steadily incurred throughout the year. Typically, total annual contributions cover all annual expenses, but the seasonal nature of the contributions can pose a cash flow problem if the NPO does not have enough cash on hand to cover expenses each month before the end of the year. The projected total contributions for each month of the next year are listed in the table below. Monthly expenses are Personnel: $32,000, Facilities: $8,000, Overhead: $16,000, and Programs: $4,500. At the beginning of the current year, the NPO has a cash balance of $19,500 on hand.

1. Build a spreadsheet model for this problem. Use your model to determine whether or not the NPO will have cash flow problems during the year. If the NPO does have cash flow problems, identify the month(s) for those problems.

2. Identify the minimum initial cash balance necessary to prevent any cash flow problems for the NPO during the year.

3. Create a line chart that plots monthly contributions, monthly expenses, and monthly cash balance (end of month) on the same chart.

Month	Contribution
January	$52,210
February	$56,000
March	$58,340
April	$55,020
May	$61,890
June	$59,520
July	$60,060
August	$59,996
September	$61,005
October	$63,780
November	$68,112
December	$74,085