Menotomy Diaper Service September 2016 MENOTOMY DIAPER SERVICES Exhibit 2. Operating Statements Fiscal Years 2012-2014 Exhibit 3. Estimated Monthly Revenue and Month-End Accounts Receivable For FY 2015 * After adjustments for bad debts. Three years ago, MDS had borrowed $1,800,000 from a life insurance company under a 16-year note secured by the company's property and equipment. The current portion of the note, and the related interest payments, were made in equal installments in March and September of each year. In preparing her financial forecasts for 2015 , Ms. Ringer planned to show separately the two principal payments, totaling $112,500, and the two interest payments, totaling $139,220. In FY 2015, MDS would need to repay George Wilson, one of its board members, \$290,700 for an interest-free loan that he had made to the company a few yeas ago. The payments would be in equal installments in December and March. The only other cash outflow Ms. Ringer anticipated was $140,860 due to an equipment manufacturer. The sum payable was non-interest-bearing and due in equal installments in June and September. She did not expect to incur a liability of this sort during FY 2015. Inventory, prepaid expenses, other assets, and contributed capital were expected to remain essentially unchanged during FY 2015. Given the company's growth plans, Ms. Ringer did not anticipate making any dividend payments for 2015. Menotomy Diaper Service September 2016 2 of 5 Although Mr. Jansen had not hesitated to grant MDS a line of credit, he had stressed the importance of the bank's credit regulations. For a line of credit of $2,000,000 or less, the bank required the borrower to maintain a compensating cash balance of $200,000 at all times. Also, the entire line of credit, including the $625,400 currently owed by MDS, was to be completely liquidated for at least one month during the year. Using the worksheet in Exhibit 4, Ms. Ringer began to prepare a monthly cash flow forecast for FY 2015 that, she hoped, would show how much money the company would need on a monthly basis. Assignment 1. Prepare the cash flow worksheet contained in Exhibit 4. What does this tell you about the operations of MDS? 2. Prepare pro forma financial statements for FY 2015 (including a statement of cash flows). What do these tell you about the operations of MDS? How can you reconcile the information in the cash flow worksheet with that in the financial statements? 3. Calculate those ratios that might be important to the bank for each year in the 4-year period. What do these ratios tell you about MDS? 4. What changes in financing policies took place in the most recent year as compared to previous years? 5. What recommendations would you make to Ms. Ringer? MENOTOMY DIAPER SERVICES Exhibit 4. Cash Flow Worksheet * Note: Total financing (decrease in cash plus increase in line of credit) must equal net outflow. Any net inflow first decreases the line of credit and then, if line of credit reaches zero, increases cash. In November 2014, Ms. Carolyn Ringer, Treasurer of Menotomy Diaper Services (MDS), was preparing some forecasts in conjunction with a loan request to the Norten Municipal Bank. Less than 8 months earlier, MDS had expanded its staff by 25 percent. At that time, the company had been in a secure financial position, and Ms. Ringer, anticipating no financial problems, had spoken to her board of directors in favor of the increase in services. However, in July, she realized that although MDS had begun training and paying the new staff in June, the company would not receive the additional revenue they generated until later in the year. With the expansion in both full and part-time staff, she realized that the company might not have the required amount of cash on hand. Faced with this situation, Ms. Ringer had gone to the bank to apply for a short-term line of credit to cover the additional costs. Mr. Jansen, the bank officer, had granted MDS a line of credit, which had reached over $625,000 by September 30,2014 . Although he had allowed the company to continue using its line of credit into its next fiscal year (which ran from October 1 to September 30 ) he had raised some important considerations. He explained that the bank was willing to continue a line of credit for the company but he was concerned that Ms. Ringer had not adequately anticipated the company's cash needs. He asked Ms. Ringer to present the bank at the outset with a detailed monthly statement of MDS's projected cash needs for fiscal year 2015. Consequently, Ms. Ringer began to review the company's financial statements (contained in Exhibits 1 and 2) and collect data that would help her plan for MDS's future cash requirements. BACKGROUND Menotomy Diaper Services had been founded by four retired nurses. Each founder had between 10 and 35 years of experience working with infants in Norten's hospitals. Realizing that parents increasingly were using cloth diapers, the nurses saw a need for a diaper service, and started their own company. At first, MDS was small and operated out of one person's home. The company then employed the four founders, a part-time laundry worker, and three drivers. Within a few years, the organization had outgrown its "office space" as well as its organizational structure. Moreover, demand for the company's services had risen at an average rate of 10 percent per year, and forecasts at that time indicated a steady increase at the 10 percent level. As a result, MDS underwent a gradual expansion. They purchased a small building in downtown Norten for management offices, as well as laundry facilities with ample parking for the company's delivery trucks. They also bought some of the vehicles and equipment they had previously rented. In the subsequent 10 years, the staff doubled. A few years later, in conjunction with increased use of cloth diapers by environmentally concerned parents, MDS was again faced with an increasing demand for its services. A poll taken at Norten's three hospitals in March 2014 indicated that there would be a 20 percent increase in the use of cloth diapers. MDS management estimated that net revenue would reach $8,100,000 in FY 2015, an increase of 16 percent over the 2014 level. Further growth of between $750,000 and $1,000,000 a year was expected during the next three years. Consequently, MDS was forced to decide whether to hold staff and services steady and take a risk that other diaper services would fill in the gaps or to launch an expansion program aimed at providing more services to a greater number of families in the Norten area. After examining MDS's financial position and talking to Norten's staff and customers about the company's services, the board voted overwhelmingly to expand. DATA Demand for MDS's services, like that for many other cloth diaper agencies, was seasonal. Over two thirds of the company's annual sales were made during the late fall, winter, and spring months. During summer, when people were on vacation, they shifted from cloth to disposable diapers. Exhibit 3 contains the forecasted monthly revenue for FY 2015. In making these projections, Ms. Ringer took into account the volume of activity during FY 2014, and the historic bad debt experience with MDS's customers. In terms of expenses, disbursements related to overhead and administration were $150,000 a month throughout FY 2015. Included in that figure was Ms. Ringer's estimate of the monthly interest on the Norten Municipal Bank line of credit. Contract service expenses were forecast at $9,000 a month, and were paid out each month. By contrast, supply purchases were projected at $34,200 per month; the company's policy was to charge these items and pay for each month's purchases in the following month. Employees were paid on the first of each month for earnings from the previous month. Starting in October, salaries and wages were expected to be $412,500 a month, except for June, when many employees would be on vacation and some part-time wages would be eliminated; payments in July would thus decrease to about $300,000. Otherwise, although demand for the company's services was somewhat seasonal, MDS's salaries and benefits were steady throughout the year. Ms. Ringer believed that this policy of regular employment for its employees enabled it to maintain a highly skilled and committed staff, which in turn contributed significantly to the company's reputation for quality service. The initial depreciation expense was forecasted to be $330,000. In addition, the company was the lessee on several long-term leases of furniture, equipment, and automobiles, with terms ranging from 3 to 5 years. The payments on these leases totaled $225,000, payable in equal installments in December and June. Because of some difficulties in making timely tax payments in the past, MDS was required by the IRS to make monthly tax payments, which were projected to be $15,000 a month. However, she expected that MDS would be in a 50 percent tax bracket, and thus, as of the end of the year, might be owed for some overpayments. Some new delivery trucks were due for delivery in December. The trucks cost $180,000 and would be paid for in four equal monthly installments, beginning on delivery. The vehicles had an economic life of four years, at the end of which their salvage value would be zero. Depreciation would begin in the month of delivery, and would be added to the above $330,000 amount. Menotomy Diaper Service September 2016 MENOTOMY DIAPER SERVICES Exhibit 2. Operating Statements Fiscal Years 2012-2014 Exhibit 3. Estimated Monthly Revenue and Month-End Accounts Receivable For FY 2015 * After adjustments for bad debts. Three years ago, MDS had borrowed $1,800,000 from a life insurance company under a 16-year note secured by the company's property and equipment. The current portion of the note, and the related interest payments, were made in equal installments in March and September of each year. In preparing her financial forecasts for 2015 , Ms. Ringer planned to show separately the two principal payments, totaling $112,500, and the two interest payments, totaling $139,220. In FY 2015, MDS would need to repay George Wilson, one of its board members, \$290,700 for an interest-free loan that he had made to the company a few yeas ago. The payments would be in equal installments in December and March. The only other cash outflow Ms. Ringer anticipated was $140,860 due to an equipment manufacturer. The sum payable was non-interest-bearing and due in equal installments in June and September. She did not expect to incur a liability of this sort during FY 2015. Inventory, prepaid expenses, other assets, and contributed capital were expected to remain essentially unchanged during FY 2015. Given the company's growth plans, Ms. Ringer did not anticipate making any dividend payments for 2015. Menotomy Diaper Service September 2016 2 of 5 Although Mr. Jansen had not hesitated to grant MDS a line of credit, he had stressed the importance of the bank's credit regulations. For a line of credit of $2,000,000 or less, the bank required the borrower to maintain a compensating cash balance of $200,000 at all times. Also, the entire line of credit, including the $625,400 currently owed by MDS, was to be completely liquidated for at least one month during the year. Using the worksheet in Exhibit 4, Ms. Ringer began to prepare a monthly cash flow forecast for FY 2015 that, she hoped, would show how much money the company would need on a monthly basis. Assignment 1. Prepare the cash flow worksheet contained in Exhibit 4. What does this tell you about the operations of MDS? 2. Prepare pro forma financial statements for FY 2015 (including a statement of cash flows). What do these tell you about the operations of MDS? How can you reconcile the information in the cash flow worksheet with that in the financial statements? 3. Calculate those ratios that might be important to the bank for each year in the 4-year period. What do these ratios tell you about MDS? 4. What changes in financing policies took place in the most recent year as compared to previous years? 5. What recommendations would you make to Ms. Ringer? MENOTOMY DIAPER SERVICES Exhibit 4. Cash Flow Worksheet * Note: Total financing (decrease in cash plus increase in line of credit) must equal net outflow. Any net inflow first decreases the line of credit and then, if line of credit reaches zero, increases cash. In November 2014, Ms. Carolyn Ringer, Treasurer of Menotomy Diaper Services (MDS), was preparing some forecasts in conjunction with a loan request to the Norten Municipal Bank. Less than 8 months earlier, MDS had expanded its staff by 25 percent. At that time, the company had been in a secure financial position, and Ms. Ringer, anticipating no financial problems, had spoken to her board of directors in favor of the increase in services. However, in July, she realized that although MDS had begun training and paying the new staff in June, the company would not receive the additional revenue they generated until later in the year. With the expansion in both full and part-time staff, she realized that the company might not have the required amount of cash on hand. Faced with this situation, Ms. Ringer had gone to the bank to apply for a short-term line of credit to cover the additional costs. Mr. Jansen, the bank officer, had granted MDS a line of credit, which had reached over $625,000 by September 30,2014 . Although he had allowed the company to continue using its line of credit into its next fiscal year (which ran from October 1 to September 30 ) he had raised some important considerations. He explained that the bank was willing to continue a line of credit for the company but he was concerned that Ms. Ringer had not adequately anticipated the company's cash needs. He asked Ms. Ringer to present the bank at the outset with a detailed monthly statement of MDS's projected cash needs for fiscal year 2015. Consequently, Ms. Ringer began to review the company's financial statements (contained in Exhibits 1 and 2) and collect data that would help her plan for MDS's future cash requirements. BACKGROUND Menotomy Diaper Services had been founded by four retired nurses. Each founder had between 10 and 35 years of experience working with infants in Norten's hospitals. Realizing that parents increasingly were using cloth diapers, the nurses saw a need for a diaper service, and started their own company. At first, MDS was small and operated out of one person's home. The company then employed the four founders, a part-time laundry worker, and three drivers. Within a few years, the organization had outgrown its "office space" as well as its organizational structure. Moreover, demand for the company's services had risen at an average rate of 10 percent per year, and forecasts at that time indicated a steady increase at the 10 percent level. As a result, MDS underwent a gradual expansion. They purchased a small building in downtown Norten for management offices, as well as laundry facilities with ample parking for the company's delivery trucks. They also bought some of the vehicles and equipment they had previously rented. In the subsequent 10 years, the staff doubled. A few years later, in conjunction with increased use of cloth diapers by environmentally concerned parents, MDS was again faced with an increasing demand for its services. A poll taken at Norten's three hospitals in March 2014 indicated that there would be a 20 percent increase in the use of cloth diapers. MDS management estimated that net revenue would reach $8,100,000 in FY 2015, an increase of 16 percent over the 2014 level. Further growth of between $750,000 and $1,000,000 a year was expected during the next three years. Consequently, MDS was forced to decide whether to hold staff and services steady and take a risk that other diaper services would fill in the gaps or to launch an expansion program aimed at providing more services to a greater number of families in the Norten area. After examining MDS's financial position and talking to Norten's staff and customers about the company's services, the board voted overwhelmingly to expand. DATA Demand for MDS's services, like that for many other cloth diaper agencies, was seasonal. Over two thirds of the company's annual sales were made during the late fall, winter, and spring months. During summer, when people were on vacation, they shifted from cloth to disposable diapers. Exhibit 3 contains the forecasted monthly revenue for FY 2015. In making these projections, Ms. Ringer took into account the volume of activity during FY 2014, and the historic bad debt experience with MDS's customers. In terms of expenses, disbursements related to overhead and administration were $150,000 a month throughout FY 2015. Included in that figure was Ms. Ringer's estimate of the monthly interest on the Norten Municipal Bank line of credit. Contract service expenses were forecast at $9,000 a month, and were paid out each month. By contrast, supply purchases were projected at $34,200 per month; the company's policy was to charge these items and pay for each month's purchases in the following month. Employees were paid on the first of each month for earnings from the previous month. Starting in October, salaries and wages were expected to be $412,500 a month, except for June, when many employees would be on vacation and some part-time wages would be eliminated; payments in July would thus decrease to about $300,000. Otherwise, although demand for the company's services was somewhat seasonal, MDS's salaries and benefits were steady throughout the year. Ms. Ringer believed that this policy of regular employment for its employees enabled it to maintain a highly skilled and committed staff, which in turn contributed significantly to the company's reputation for quality service. The initial depreciation expense was forecasted to be $330,000. In addition, the company was the lessee on several long-term leases of furniture, equipment, and automobiles, with terms ranging from 3 to 5 years. The payments on these leases totaled $225,000, payable in equal installments in December and June. Because of some difficulties in making timely tax payments in the past, MDS was required by the IRS to make monthly tax payments, which were projected to be $15,000 a month. However, she expected that MDS would be in a 50 percent tax bracket, and thus, as of the end of the year, might be owed for some overpayments. Some new delivery trucks were due for delivery in December. The trucks cost $180,000 and would be paid for in four equal monthly installments, beginning on delivery. The vehicles had an economic life of four years, at the end of which their salvage value would be zero. Depreciation would begin in the month of delivery, and would be added to the above $330,000 amount